(RADIATOR) MySQL server has gone away

[Hugh Irvine]

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.