<div>hi all im using Freeradius-1.1.6, with mysql database.i'm still confusing about simultaneous-use.</div>
<div>i want to limiting the maximum number of simultaneous logons ( just 1 session can login for every 1 user in a same time)</div>
<div>this is my radiusd.conf</div>
<div>
<p>session {<br> sql<br>}<br></p></div>
<div>and this is my database :</div>
<div>mysql> select * from radcheck where <a href="mailto:username='dara@idola'">username='dara@idola'</a>;<br>+----+-----------------+---------------------------+----+--------------+<br>| id | UserName | Attribute | op | Value |
<br>+----+-----------------+----------------------------+----+-------------+<br>| 55 | <a href="mailto:dara@idola">dara@idola</a> | Password | == | denpasar |<br>| 65 | <a href="mailto:dara@idola">dara@idola</a>
| Simultaneous-Use | := | 1 |<br>+----+-----------------+---------------------------+----+--------------+<br>2 rows in set (0.00 sec)<br>mysql> select username,acctstoptime from radacct where <a href="mailto:username='dara@idola'">
username='dara@idola'</a> and acctstoptime=0;<br>+----------------+-------------------------------+<br>| username | acctstoptime |<br>+----------------+--------------------------------+<br>| <a href="mailto:dara@idola">
dara@idola</a> | 0000-00-00 00:00:00 |<br>+-----------------+-------------------------------+<br>1 row in set (0.00 sec)<br> </div>
<div>with that config and data rows, user <a href="mailto:dara@idola">dara@idola</a> can login for second session :(</div>
<div>any help expected </div>
<div> </div>
<div>thanks</div>
<div>trio</div>