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, tnt@kalik.co.yu <tnt@kalik.co.yu>:
Did you change the type for this NAS to "other"?
Ivan Kalik Kalik Informatika ISP
Dana 17/5/2007, "Trio Yulistianto" <trioy99@gmail.com> 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='dara@idola'; +----+-----------------+---------------------------+----+--------------+ | id | UserName | Attribute | op | Value | +----+-----------------+----------------------------+----+-------------+ | 55 | dara@idola | Password | == | denpasar | | 65 | dara@idola | Simultaneous-Use | := | 1 | +----+-----------------+---------------------------+----+--------------+ 2 rows in set (0.00 sec) mysql> select username,acctstoptime from radacct where username='dara@idola' and acctstoptime=0; +----------------+-------------------------------+ | username | acctstoptime | +----------------+--------------------------------+ | dara@idola | 0000-00-00 00:00:00 | +-----------------+-------------------------------+ 1 row in set (0.00 sec)
with that config and data rows, user dara@idola can login for second session :( any help expected
thanks trio
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html