(RADIATOR) MySQL server has gone away

[Chris Patterson]

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:hugh at open.com.au]
> Sent: Thursday, 2 October 2003 5:38 PM
> To: Bobbejaan van Elst
> Cc: radiator at open.com.au
> 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 = "opssp at adsl"
> >         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
> > opssp at adsl, 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='opssp at adsltest' where YIADDR='172.16.178.124' and 
> TIME_STAMP
> > =1064929204':
> >
> > Wed Oct  1 10:30:07 2003: DEBUG: Access accepted for opssp at adsl
> >
> >
> > 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 radiator-announce at open.com.au
> > To unsubscribe, email 'majordomo at open.com.au' 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 radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
> 
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.