Your message dated Tue, 24 Nov 2009 03:00:43 +0100 with message-id <[email protected]> and subject line fixed in freeradius 2.1.7+dfsg-1 has caused the Debian Bug report #518828, regarding wrong sql query for simultaneous use checking to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 518828: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=518828 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---Package: freeradius-mysql Version: 2.0.4+dfsg-6 Severity: important In /etc/freeradius/sql/mysql/dialup.conf ther is a wrong mysql query. Becasue of this "Simultaneous Use Checking" is not working correctly. ################################################################ # Simultaneous Use Checking Queries ####################################################################### # simul_count_query - query for the number of current connections # - If this is not defined, no simultaneouls use checking # - will be performed by this module instance # simul_verify_query - query to return details of current connections for verification # - Leave blank or commented out to disable verification step # - Note that the returned field order should not be changed. ####################################################################### # Uncomment simul_count_query to enable simultaneous use checking simul_count_query = "SELECT COUNT(*) \ FROM ${acct_table1} \ WHERE username = '%{SQL-User-Name}' \ AND acctstoptime = NULL" simul_verify_query = "SELECT radacctid, acctsessionid, username, \ nasipaddress, nasportid, framedipaddress, \ callingstationid, framedprotocol \ FROM ${acct_table1} \ WHERE username = '%{SQL-User-Name}' \ AND acctstoptime = NULL" Should be "is NULL" not "= Null"
--- End Message ---
--- Begin Message ---Version: 2.1.7+dfsg-1 Hi, The simul_count_query and simul_verify_query in FreeRADIUS 2.1.7 have been fixed, and the package of that has just been uploaded. Thanks for reporting. -- 2. That which causes joy or happiness.
--- End Message ---
