Hi, i need little help with this. I have MySQL setup with freeradis, that is working. Now for Simultaneous-Use checking there are no querys to uncomment inside sql.conf by default (installed freeradius over apt-get ). Now i added to sql.conf simul_count_query = "SELECT COUNT(*) FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0" simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0" Group checking is disabled. What else i have to do to get this checking started? Thx! -- View this message in context: http://freeradius.1045715.n5.nabble.com/Simultaneous-Use-checking-tp5514541p... Sent from the FreeRadius - User mailing list archive at Nabble.com.
On Sat, Feb 25, 2012 at 11:51 AM, opti2k4 <dreic@email.t-com.hr> wrote:
Hi,
i need little help with this. I have MySQL setup with freeradis, that is working. Now for Simultaneous-Use checking there are no querys to uncomment inside sql.conf by default (installed freeradius over apt-get ).
It should be there. See https://github.com/alandekok/freeradius-server/blob/v2.1.x/raddb/sql/mysql/d...
What else i have to do to get this checking started?
- make sure you have acct stored in mysql as well (look at your radacct tables) - make sure the user has Simultaneous-Use attribute (in radcheck/radgroupcheck/whatever) -- Fajar
participants (2)
-
Fajar A. Nugraha -
opti2k4