[RADIATOR] Too much DB queries with SessionDatabase

Jan Tomasek jan at tomasek.cz
Tue Apr 14 09:07:57 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/d1767de6/attachment-0001.ksh>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: maxsession-log.bz2
Type: application/x-bzip
Size: 7824 bytes
Desc: not available
URL: <http://www.open.com.au/pipermail/radiator/attachments/20090414/d1767de6/attachment-0001.bin>


More information about the radiator mailing list