about simultaneous when using mysql and freeradius

[Spacelee]

sorry, does the radcheck.pl included in freeradius now? does you mean
/usr/sbin/checkrad ?


and i search the keywords "Simultaneous mysql radius down" , but found no
results i need.

2010/6/1 Anton <warm at stack.ru>

> It should be done by NAS. For example PPPoE and PPTP have lcp packets, If
> no response for some time from
> client to NAS then NAS decides that session is down and sends acct-stop
> packet to radius server. Radius
> server sets the corresponding record to SQL session table.
>
> Or there is another method: depending on NAS type radiusd can connect to
> NAS and check activity of user
> session directly on NAS - this is more reliable source of information. See
> radcheck.pl.
>
>
> On Tue, 1 Jun 2010 16:24:54 +0700
> Spacelee <fjctlzy at gmail.com> wrote:
>
> >
> > i want to limit user's behavior, such as a username can login only once
> at the same time...
> >
> > 1、modifiy default and inner-tunnel in
> >
> > #  Session database, used for checking Simultaneous-Use. Either the
> radutmp
> > #  or rlm_sql module can handle this.
> > #  The rlm_sql module is *much* faster
> > session {
> >         #radutmp
> >
> >         #  See "Simultaneous Use Checking Querie" in sql.conf
> >         sql
> >
> > }
> > 2、modify dialup.conf in etc/raddb/sql/mysql
> >
> > # Uncomment simul_count_query to enable simultaneous use checking
> >
> > simul_count_query = "SELECT COUNT(*) \
> >                             FROM ${acct_table1} \
> >                             WHERE username = '%{SQL-User-Name}' \
> >                              AND acctstoptime IS NULL"
> >
> > 3、add a entry to the table radgorucheck
> > INSERT INTO `radgroupcheck` ( `id` , `GroupName` , `Attribute` , `op` ,
> `Value` )
> > VALUES (
> > NULL , ’user’, ’Simultaneous-Use’, ’:=’, ’1’
> > );
> >
> > 4. update the user "test"  to the group "user"
> >
> >
> > i finally tried successfully, but if , i say if the radius server was
> down suddenly or the user logout
> > improperly(such as he poweroff the computer directly). then the record
> will still be record in the table as
> > he was still online ...so we need to modify the record, but how to ? can
> freeradius judge it by itself, or
> > how to judge the user if offline ?
> >
> > --
> > Spacelee
> >
> >
> >
> > --
> > Spacelee
>
>
> --
> Anton [WARM-RIPE]
> Stack ltd division head
> tel. 8 (3822) 555-797
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>



-- 
Spacelee
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20100601/479ba7dc/attachment.html>