Hello Bobby -
It looks like the MySQL server does not like certain requests.
You should try to run the same requests by hand to see what happens and you should check the MySQL log files to see what is happening with the database.
regards
Hugh
On Thursday, Oct 2, 2003, at 16:36 Australia/Melbourne, Bobbejaan van Elst wrote:
Hi,
I see verry often the following errors:
Thu Oct 2 06:29:55 2003: ERR: do failed for 'update RADPOOL set STATE=0
where STATE!=0 and EXPIRY < 1065068995': MySQL server has gone away
Thu Oct 2 06:59:55 2003: ERR: do failed for 'update RADPOOL set STATE=0
where STATE!=0 and EXPIRY < 1065070795': MySQL server has gone away
Thu Oct 2 07:29:55 2003: ERR: do failed for 'update RADPOOL set STATE=0
where STATE!=0 and EXPIRY < 1065072595': MySQL server has gone away
Thu Oct 2 07:59:55 2003: ERR: do failed for 'update RADPOOL set STATE=0
where STATE!=0 and EXPIRY < 1065074395': MySQL server has gone away
And here also an error:
Code: Access-Request Identifier: 108 Authentic: 1234567890123456 Attributes: User-Name = "[EMAIL PROTECTED]" NAS-Port = 2030108795 User-Password = "<200><185>l<173><175>\<4><246><188>8<9><160><216>}x<153>" NAS-Identifier = "nl-gv-dc2-fsip-gr05-3" Timestamp = 1064997007
Wed Oct 1 10:30:07 2003: DEBUG: Handling request with Handler 'Realm=adsl, Request-Type=Access-Request' Wed Oct 1 10:30:07 2003: DEBUG: mySessionDB Deleting session for [EMAIL PROTECTED], 195.190.240.82, 2030108795 Wed Oct 1 10:30:07 2003: DEBUG: do query is: 'delete from RADONLINE where ACCTSESSIONID=''':
Wed Oct 1 10:30:07 2003: ERR: do failed for 'delete from RADONLINE where ACCTSESSIONID=''': MySQL server has gone away Wed Oct 1 10:30:07 2003: DEBUG: Handling with AuthINTERNAL: DefaultAccept Wed Oct 1 10:30:07 2003: DEBUG: Handling with Radius::AuthDYNADDRESS Wed Oct 1 10:30:07 2003: DEBUG: Query is: 'select TIME_STAMP, YIADDR, SUBNETMASK, DNSSERVER from RADPOOL where POOL='nl-gv-dc2-fsip-gr05-3' and STATE=0 order by TIME_STAMP limit 1':
Wed Oct 1 10:30:07 2003: DEBUG: do query is: 'update RADPOOL set STATE=1, TIME_STAMP=1064997007, EXPIRY=1065083407, USERNAME='[EMAIL PROTECTED]' where YIADDR='172.16.178.124' and TIME_STAMP =1064929204':
Wed Oct 1 10:30:07 2003: DEBUG: Access accepted for [EMAIL PROTECTED]
I am using the following versions:
DBD-mysql-2.9002 DBI-1.38 Digest-MD5-2.27 mysql-4.0.14 Radiator-3.6
Has someone an idea?
Met vriendelijke groet,
Bobbejaan van Elst
=== Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
NB: have you included a copy of your configuration file (no secrets), together with a trace 4 debug showing what is happening?
-- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence.
=== Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.