confusing about Simultaneous-Use (still)

["Trio Yulistianto" <trioy99@gmail.com>]

hi all im using Freeradius-1.1.6, with mysql database.i'm still confusing about simultaneous-use.

i want to limiting the maximum number of simultaneous logons ( just 1 session can login for every 1 user in a same time)

this is my radiusd.conf

session {
        sql
}

and this is my database :

mysql> select * from radcheck where username='dara@idola';
+----+-----------------+---------------------------+----+--------------+
| id | UserName   | Attribute               | op | Value      |
+----+-----------------+----------------------------+----+-------------+
| 55 | dara@idola | Password             | == | denpasar |
| 65 | dara@idola | Simultaneous-Use | :=  | 1            |
+----+-----------------+---------------------------+----+--------------+
2 rows in set (0.00 sec)
mysql>  select username,acctstoptime from radacct where username='dara@idola' and acctstoptime=0;
+----------------+-------------------------------+
| username   | acctstoptime             |
+----------------+--------------------------------+
| dara@idola | 0000-00-00 00:00:00  |
+-----------------+-------------------------------+
1 row in set (0.00 sec)
 

with that config and data rows, user dara@idola can login for second session :(

any help expected

 

thanks

trio