I was having a similar problem - appears to have been a problem with the mysql settings being too small. Adjusting these settings in /etc/my.cnf (see my-small.cnf/my-medium.cnf etc...) Certainly helped/rectified the problem.
> -----Original Message----- > From: Hugh Irvine [mailto:[EMAIL PROTECTED] > Sent: Thursday, 2 October 2003 5:38 PM > To: Bobbejaan van Elst > Cc: [EMAIL PROTECTED] > Subject: Re: (RADIATOR) MySQL server has gone away > > > > 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. > === 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.