confusing about Simultaneous-Use (still)

[Trio Yulistianto]

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 at kalik.co.yu <tnt at 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 at 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 at idola';
> >+----+-----------------+---------------------------+----+--------------+
> >| id | UserName   | Attribute               | op | Value      |
> >+----+-----------------+----------------------------+----+-------------+
> >| 55 | dara at idola | Password             | == | denpasar |
> >| 65 | dara at idola | Simultaneous-Use | :=  | 1            |
> >+----+-----------------+---------------------------+----+--------------+
> >2 rows in set (0.00 sec)
> >mysql>  select username,acctstoptime from radacct where
> >username='dara at idola' and acctstoptime=0;
> >+----------------+-------------------------------+
> >| username   | acctstoptime             |
> >+----------------+--------------------------------+
> >| dara at idola | 0000-00-00 00:00:00  |
> >+-----------------+-------------------------------+
> >1 row in set (0.00 sec)
> >
> >with that config and data rows, user dara at idola can login for second
> session
> >:(
> >any help expected
> >
> >thanks
> >trio
> >
> >
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070518/3b793777/attachment.html>