Hello all!
I have problem with the Simultaneous-Use on Freeradius + Mikrotik environment. I'm using freeradius 2.1.8 on Debian lenny with mysql support. I've found a checklist in the wiki (http://wiki.freeradius.org/index.php/FAQ#Simultaneous-Use_doesn.27t_work). The second line of this is: "2. Run radiusd -X and see if it parses the Simultaneous-Use line." But if I run radiusd -x | grep simul I've got only these lines: simul_count_query = "SELECT COUNT(*) FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL" simul_verify_query = "SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL" I haven't got any output line which contents the "Simultaneous-Use" text-pattern. One of my question is: Could you describe me what can I see exactly in the output when the Simultaneous-Use function is on? I've uncommented in the /etc/freeradius/sql/mysql/dialup.conf the following lines: simul_count_query = "SELECT COUNT(*) \ FROM ${acct_table1} \ WHERE username = '%{SQL-User-Name}' \ AND acctstoptime IS NULL" and also uncommented in the /etc/freeradius/sites-enabled/default, the "sql" line in the session section. The radwho command regularly lists the online users. But if I try to login through another Mikrotik NAS client in the name of a user who is listed by the radwho, the freeradius send access-accept to the NAS client. My radius database's tables are look like this: mysql> select * from radcheck; +----+----------+---------------+----+------------+ | id | UserName | Attribute | op | Value | +----+----------+---------------+----+------------+ | 1 | hz00001 | user-password | == | Tfregep5uy | | 3 | hz00002 | user-password | == | 29riaejofu | | 4 | hz00003 | user-password | == | Razsgepiui | | 5 | hz00004 | user-password | == | 64Vifuzuxo | | 6 | hz00005 | user-password | == | 39Bygonony | | 7 | hz00006 | user-password | == | Zozyhomo25 | | 8 | hz00007 | user-password | == | awdeokihaY | | 9 | hz00008 | user-password | == | 33Vifakhde | +----+----------+---------------+----+------------+ mysql> select * from radusergroup; +----------+-----------+----------+ | username | groupname | priority | +----------+-----------+----------+ | hz00001 | HZ | 1 | | hz00002 | HZ | 1 | | hz00003 | HZ | 1 | | hz00004 | HZ | 1 | | hz00005 | HZ | 1 | | hz00006 | HZ | 1 | | hz00007 | HZ | 1 | | hz00008 | HZ | 1 | +----------+-----------+----------+ mysql> select * from radgroupreply; +----+-----------+------------------+----+-------+ | id | GroupName | Attribute | op | Value | +----+-----------+------------------+----+-------+ | 1 | HZ | Simultaneous-Use | := | 1 | +----+-----------+------------------+----+-------+ Please suggest me what causes the problem! Regards, fbi - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
