[RADIATOR] Too much DB queries with SessionDatabase
Jan Tomasek
jan at tomasek.cz
Tue Apr 14 08:14:50 CDT 2009
Hi,
I'm setting up a Radiator server which should allow only one login per
user. It is working, but Radiator execute delete query per each
access-request. It does something like:
Tue Apr 14 14:33:17 2009: DEBUG: do query is: 'DELETE FROM RadOnline
WHERE NASIdentifier="195.113.150.2" AND
lower(UserName)=lower("semik at tomasek.cz") AND AcctSession
ID="NULL"':
I'm worried about load this can put on SQL server. How should I
configure Radiator to execute delete query only for stop accounting
requests?
Trace4 log file and configuration I'm using is attached.
Thank you for help.
--
-----------------------
Jan Tomasek aka Semik
http://www.tomasek.cz/
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: radius.cfg-radsec-tomasek-cz
URL: <http://www.open.com.au/pipermail/radiator/attachments/20090414/2a4f4366/attachment-0002.ksh>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: maxsession-log
URL: <http://www.open.com.au/pipermail/radiator/attachments/20090414/2a4f4366/attachment-0003.ksh>
More information about the radiator
mailing list