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
