Simultaneous-Use problem

[Milan Holub]

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
--------------------------------------