Hello Antonio -
There have been some changes in the SQL code since 2.15, so I suggest you
upgrade to 2.16.3 to see if there is any improvement. At the very least you
will get better error reporting to see what the exact problem is.
Please let me know how you get on.
regards
Hugh
On Tue, 03 Oct 2000, Antonio Coloma wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> Hi All!
>
> I am having so many problems with Radiator and Mysql by now.
>
> I have in one machine Radiator 2.15 and Mysql.
> Mysql stores SessionDataBase, and sometimes Mysql not respond to
> Radiator, and in radiator logs appears the next:
>
> Sat Sep 30 11:18:07 2000: ERR: do failed for 'delete from RADONLINE
> where NASIDENTIFIER='62.36.196.21' and NASPORT=1132': SQL Timeout
>
> Sat Sep 30 11:18:07 2000: ERR: do failed for 'delete from RADONLINE
> where NASIDENTIFIER='62.36.196.21' and NASPORT=1132': SQL Timeout
>
> CPU is perfect, and Mysql is running, but mysql log tells me:
>
> 000930 11:22:09 Aborted connection 28578 to db: 'radius' user:
> 'radius'
> 000930 11:22:09 Aborted connection 28577 to db: 'radius' user:
> 'radius'
> 000930 11:22:09 Aborted connection 29432 to db: 'radius' user:
> 'radius'
> 000930 11:22:09 Aborted connection 29433 to db: 'radius' user:
> 'radius'
> 000930 11:22:09 Aborted connection 29434 to db: 'radius' user:
> 'radius'
> 000930 11:22:09 Aborted connection 29437 to db: 'radius' user:
> 'radius'
> 000930 11:22:09 Aborted connection 29440 to db: 'radius' user:
> 'radius'
> 000930 11:22:09 Aborted connection 29441 to db: 'radius' user:
> 'radius'
> 000930 11:22:09 Aborted connection 29435 to db: 'radius' user:
> 'radius'
>
> Is it due to a file descriptor limit?
>
> Thanx in advance!
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>
>
> iQA/AwUBOdm/pvmFtUnPAF8XEQLhZACfcSgIoTgwLqd0XkNOs+A/M3tMdjgAoMVb
> vJHN+i8ZWoq4fxw0PffRYK+g
> =ajBj
> -----END PGP SIGNATURE-----
>
>
> ===
> Archive at http://www.starport.net/~radiator/
> Announcements on [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.