[RADIATOR] SessionDB::RADONLINE::Deletion Failing

[Michael]

5.10.4
DeleteQuery
This SQL statement is executed whenever a user session finishes (i.e. 
when an Account-
ing-Request Stop message is received). It is expected to remove the 
details of the ses-
sion from the SQL database. Special formatting characters may be used. 
%0 is replaced
by the quoted user name to be deleted, %1 by the NAS IP address, %2 by 
the NAS-Port,
%3 by the SQL quoted Acct-Session-Id. If DeleteQuery is defined as an 
empty string,
then the query will not be executed.


On 13/11/12 02:15 PM, ronald higgins wrote:
>
> 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
>
>
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20121113/0e49408e/attachment.html