(RADIATOR) MySQL server has gone away

Bobbejaan van Elst bobby at the-mask.net
Thu Oct 2 03:23:10 CDT 2003


If I run it by hand there is no problem:

mysql> update RADPOOL set STATE=0 where STATE!=0 and EXPIRY < 1065068995
    -> ;
Query OK, 0 rows affected (0.03 sec)
Rows matched: 0  Changed: 0  Warnings: 0


I see this in the mysql log:

031002  9:32:34  Aborted connection 531 to db: 'radiusaccess' user:
'radiator' host: `localhost' (Got timeout reading communication packets)
031002  9:38:32  Aborted connection 532 to db: 'radiusaccess' user:
'radiator' host: `localhost' (Got timeout reading communication packets)
031002  9:42:34  Aborted connection 533 to db: 'radiusaccess' user:
'radiator' host: `localhost' (Got timeout reading communication packets)
031002  9:55:40  Aborted connection 534 to db: 'radiusaccess' user:
'radiator' host: `localhost' (Got timeout reading communication packets)
031002 10:02:34  Aborted connection 535 to db: 'radiusaccess' user:
'radiator' host: `localhost' (Got timeout reading communication packets)
031002 10:12:35  Aborted connection 536 to db: 'radiusaccess' user:
'radiator' host: `localhost' (Got timeout reading communication packets)


Met vriendelijke groet,
 
Bobbejaan van Elst
Planet Technologies

-----Original Message-----
From: Hugh Irvine [mailto:hugh at open.com.au] 
Sent: donderdag 2 oktober 2003 9:38
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.


More information about the radiator mailing list