Re: about simultaneous when using mysql and freeradius

2010-06-27 Thread Alan DeKok
Spacelee wrote: my nas client is pptp and ppp, how can i set pptp to send updates every 5 minutes? See the PPTP documentation. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: about simultaneous when using mysql and freeradius

2010-06-26 Thread Spacelee
my nas client is pptp and ppp, how can i set pptp to send updates every 5 minutes? On Tue, Jun 1, 2010 at 7:13 PM, Marinko Tarlac mangi...@gmail.com wrote: Here we go again 1. add datetime column at the end of radacct table (name it for example last_update_column) 2. edit queries in

about simultaneous when using mysql and freeradius

2010-06-01 Thread Spacelee
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 {

Re: about simultaneous when using mysql and freeradius

2010-06-01 Thread Marinko Tarlac
I already wrote about this problem on this list. Please search before asking... Spacelee 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.

Re: about simultaneous when using mysql and freeradius

2010-06-01 Thread Anton
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:

Re: about simultaneous when using mysql and freeradius

2010-06-01 Thread 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 w...@stack.ru It should be done by NAS. For example PPPoE and PPTP have lcp packets, If no

Re: about simultaneous when using mysql and freeradius

2010-06-01 Thread Anton
Yes, this is /usr/sbin/checkrad. Sorry for mistake. You should read this script ... Radiusd can be down or unrichable or packet can be loss. If You have NAS one of this type You can specify this type in clients.conf (nastype = cisco). After than radiusd should use /usr/sbin/checkrad to check

Re: about simultaneous when using mysql and freeradius

2010-06-01 Thread Marinko Tarlac
Here we go again 1. add datetime column at the end of radacct table (name it for example last_update_column) 2. edit queries in dialup.conf (for 2.x FR) or sql.conf (for 1.x FR) so every update will update this column to (for example update radacct set , last_update_column = NOW() ).