Multiple logins Freeradius/Mysql

Mark Elkins mje at posix.co.za
Mon Jun 13 17:27:56 CEST 2005


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 at posix.co.za  -  Mark J Elkins, Cisco CCIE
/ |/ |ARK \_/ /__ LKINS  Tel: +27 12 807 0590  Cell: +27 82 601 0496




More information about the Freeradius-Users mailing list