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 }
???