[RADIATOR] SessionDB::RADONLINE::Deletion Failing

[Michael]

I don't think that delete statement you are seeing is actually a delete 
statement to delete the session from your sql table.  It is a delete 
statement to help make sure duplicates don't happen in the table.  So, 
you should probably specify the proper delete statement as per the 
manual section 5.10.4


On 13/11/12 02:34 PM, Michael wrote:
> 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
>
>
> _______________________________________________
> 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/1991bf76/attachment.html