solved, thanks...
i just comment in this part :
#simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName,
NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol
FROM ${acct_table1} WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0"
and now everything work well
thanks for any reply
2007/5/18, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
Did you change the type for this NAS to "other"?
Ivan Kalik
Kalik Informatika ISP
Dana 17/5/2007, "Trio Yulistianto" <[EMAIL PROTECTED]> piše:
>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='[EMAIL PROTECTED]';
>+----+-----------------+---------------------------+----+--------------+
>| id | UserName | Attribute | op | Value |
>+----+-----------------+----------------------------+----+-------------+
>| 55 | [EMAIL PROTECTED] | Password | == | denpasar |
>| 65 | [EMAIL PROTECTED] | Simultaneous-Use | := | 1 |
>+----+-----------------+---------------------------+----+--------------+
>2 rows in set (0.00 sec)
>mysql> select username,acctstoptime from radacct where
>username='[EMAIL PROTECTED]' and acctstoptime=0;
>+----------------+-------------------------------+
>| username | acctstoptime |
>+----------------+--------------------------------+
>| [EMAIL PROTECTED] | 0000-00-00 00:00:00 |
>+-----------------+-------------------------------+
>1 row in set (0.00 sec)
>
>with that config and data rows, user [EMAIL PROTECTED] can login for second
session
>:(
>any help expected
>
>thanks
>trio
>
>
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
