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@open.com.au
http://www.open.com.au/mailman/listinfo/radiator
_______________________________________________
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator
_______________________________________________
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator
