[RADIATOR] SessionDB::RADONLINE::Deletion Failing

[ronald higgins]

Hi User List,

I need a bit of an assist. I'm having an issue with sessions being deleted
from RADONLINE when a stop record comes in.

This is the pertinent bit in the conf:

##################################################################
<SessionDatabase SQL>

        Identifier SessionDB

                DBSource    dbi:mysql:radius:XXX.XXX.XXX.XXX:3306
                DBUsername  radius
                DBAuth      DB_PASSWORD

                Timeout         5

</SessionDatabase>

Pretty basic and standard now.

##################################################################

This is the Trace 4 in the log file for the Start and the Stop:

##################################################################
Start:

Tue Nov 13 18:51:25 2012: DEBUG: do query is: 'delete from RADONLINE where
NASIDENTIFIER='196.X.X.X' and NASPORT=01929707729':
Tue Nov 13 18:51:25 2012: DEBUG: do query is: 'insert into RADONLINE
(USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('ADSL_USERNAME',
'196.X.X.X', 1929707729, '7/0/3/5.209_16FBD22C', 1352825485, 'ADSL_IP',
'Virtual', 'Framed-User')':

It's quite happily inserting the record.

##################################################################
Stop:

Tue Nov 13 20:46:27 2012: DEBUG: do query to 'DB_CONNECTION_STRING':
'delete from RADONLINE where NASIDENTIFIER='196.X.X.X' and
NASPORT=01929707729':
Tue Nov 13 20:46:27 2012: ERR: do failed for 'delete from RADONLINE where
NASIDENTIFIER='196.X.X.X' and NASPORT=01929707729': MySQL server has gone
away

Not so happy on the Stop record, Stops always seem to produce the "MySQL
server has gone away".

##################################################################


If i log into mysql and delete the query as it's posted in the logs it
deletes just fine...

mysql> delete from RADONLINE where NASIDENTIFIER='196.X.X.X' and
NASPORT=01929707729;
Query OK, 1 row affected (0.00 sec)


It's Radiator 4.10, running on Centos 5.3 and Perl version 5.8.8



Any thoughts?

Regards

Ronald
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20121113/61d1a696/attachment.html