Multiple logins Freeradius/Mysql

[Aaron Paetznick]

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