Simultaneous-Use problem
PD
paul at ranahminang.net
Thu Apr 12 09:14:48 CEST 2007
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)
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
More information about the Freeradius-Users
mailing list