Hi, On Thu, Apr 12, 2007 at 07:14:48AM +0000, PD wrote:
Dear all,
We has the problem regarding the above subject... mysql> select * from radgroupcheck; +----+-----------+------------------+----+-------+ | id | GroupName | Attribute | op | Value | +----+-----------+------------------+----+-------+ | 1 | POSTPAID | Simultaneous-Use | == | 1 | | 2 | PREPAID | Simultaneous-Use | == | 1 | +----+-----------+------------------+----+-------+ 2 rows in set (0.01 sec) mysql> select * from usergroup; +----------+-----------+----------+ | UserName | GroupName | priority | +----------+-----------+----------+ | thomas | POSPAID | 1 | | christie | POSPAID | 1 | +----------+-----------+----------+ 2 rows in set (0.01 sec)
==> I believe you have a typo in the tables: radgroupcheck: groupname=POSTPAID usergroup: groupname=POSPAID which means that the Simultaneous-Use check is not performed because the user does not match the requested group...
and at sql.conf.. .. # Uncomment simul_count_query to enable simultaneous use checking # simul_counT_query = "SELECT COUNT(*) FROM ${acct_table1} WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0" simul_count_query = "SELECT COUNT(*) FROM ${acct_table1} WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0" simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingSta tionId, FramedProtocol FROM ${acct_table1} WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0" ..
But.. the same user id still able to login at the same time on different terminal / pc
I already try to change the op on radcheck from '==' become ':=' or '=' but the same problem still persist
What could be wrong ?
TIA
PD
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Milan Holub holub (at) thenet (dot) ch -------------------------------------- TheNet-Internet Services AG, im Bernertechnopark, Morgenstr. 129 CH-3018, Bern, Switzerland 031 998 4333, Fax 031 998 4330 http://www.thenet.ch http://wlan.thenet.ch --------------------------------------