Multiple logins Freeradius/Mysql
We've set up Simultaneous-Use := 1 - and this seems fine. However, I have my first user - who is really off the net and 'radzap' seems to do nothing.... (radwho still gives the user as being there). What is the code... in sql.conf... simul_count_query = "SELECT COUNT(*) FROM ${acct_table1} WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0" ...for???? In our previous Radius - we used to simply provide a valid AcctStopTime time - and the user could then login again. What do I need to do to change freeradius to do Simultaneous-Use control using mysql and not using radwho?? I've read doc/Simultaneous-Use - which doesn't use/mention [my]sql. I'm guessing (looking at where radutmp is mentioned)... radiusd.conf has... session { radutmp } Should this be changed to... session { sql } ??? -- . . ___. .__ Posix Systems - Sth Africa. e.164 VOIP ready /| /| / /__ mje@posix.co.za - Mark J Elkins, Cisco CCIE / |/ |ARK \_/ /__ LKINS Tel: +27 12 807 0590 Cell: +27 82 601 0496
I'm having a similar problem. I'm using sql accounting. I've uncommented the simul_count_query query line. I've entered the Simultaneous-Use attribute in the radgroupcheck table with the ":=" op. It's still trying to use checkrad (in the log) no matter what I do. I've read the doc file. Help? --Aaron Mark Elkins wrote:
We've set up Simultaneous-Use := 1 - and this seems fine. However, I have my first user - who is really off the net and 'radzap' seems to do nothing.... (radwho still gives the user as being there).
What is the code... in sql.conf... simul_count_query = "SELECT COUNT(*) FROM ${acct_table1} WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0" ...for????
In our previous Radius - we used to simply provide a valid AcctStopTime time - and the user could then login again.
What do I need to do to change freeradius to do Simultaneous-Use control using mysql and not using radwho??
I've read doc/Simultaneous-Use - which doesn't use/mention [my]sql.
I'm guessing (looking at where radutmp is mentioned)... radiusd.conf has...
session { radutmp }
Should this be changed to... session { sql }
???
On Mon, 2005-06-13 at 17:27 +0200, Mark Elkins wrote:
We've set up Simultaneous-Use := 1 - and this seems fine. However, I have my first user - who is really off the net and 'radzap' seems to do nothing.... (radwho still gives the user as being there).
What is the code... in sql.conf... simul_count_query = "SELECT COUNT(*) FROM ${acct_table1} WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0" ...for????
In our previous Radius - we used to simply provide a valid AcctStopTime time - and the user could then login again.
What do I need to do to change freeradius to do Simultaneous-Use control using mysql and not using radwho??
I've read doc/Simultaneous-Use - which doesn't use/mention [my]sql.
I think this Document should be updated to tell people who are using an SQL to change the 'session' bit in radiusd.conf ????
I'm guessing (looking at where radutmp is mentioned)... radiusd.conf has...
session { radutmp }
Should this be changed to... session { sql }
The above seems to work - grepping through old email also seems to suggest that now checkrad won't work...unless we use radutmp... or does checkrad run with the sql... simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol FROM ${acct_table1} WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0" ??? Anyway - testing the above seemed to block simultaneous use - like things worked with radutmp - except now it does seem to be using the SQL code.. -- . . ___. .__ Posix Systems - Sth Africa. e.164 VOIP ready /| /| / /__ mje@posix.co.za - Mark J Elkins, Cisco CCIE / |/ |ARK \_/ /__ LKINS Tel: +27 12 807 0590 Cell: +27 82 601 0496
participants (2)
-
Aaron Paetznick -
Mark Elkins