Re: simultaneous-use and stateless sessions in sql
"Seferovic Edvin" <[EMAIL PROTECTED]> wrote: > but what if I "only" have session data in SQL? Write a shell script that runs SQL queries and builds the packets to send to radclient. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: simultaneous-use and stateless sessions in sql
Hi, but what if I "only" have session data in SQL? Running radzap manually for each user is not a good idea by 200 users. And I haven't found any entries how deletestatlesssessions ( in sql.conf ) work :( sorry - I probably missed something. Any hints please :( Regards, Edvin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan DeKok "Seferovic Edvin" <[EMAIL PROTECTED]> wrote: > But how to use radzap when only using SQL for session tracking... In 1.0.5 and following, radzap is just a shell script wrapper around radwho && radclient. You can use radclient to create a fake "stop" packet, and send that to the server. > Is it kind of OK to have session tracking in sql and radutmp? yes. > How should I start radzap ( or is it run automatically by > deletestatlesssession ) ? Read the "man" page? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: simultaneous-use and stateless sessions in sql
"Seferovic Edvin" <[EMAIL PROTECTED]> wrote: > But how to use radzap when only using SQL for session tracking... In 1.0.5 and following, radzap is just a shell script wrapper around radwho && radclient. You can use radclient to create a fake "stop" packet, and send that to the server. > Is it kind of OK to have session tracking in sql and radutmp? yes. > How should I start radzap ( or is it run automatically by > deletestatlesssession ) ? Read the "man" page? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: simultaneous-use and stateless sessions in sql
But how to use radzap when only using SQL for session tracking... I've tried it but it said it cannot find radutmp ( because Ive commented it in radiusd.conf - I do not need it.. or do I ?? ). Is it kind of OK to have session tracking in sql and radutmp? How should I start radzap ( or is it run automatically by deletestatlesssession ) ? TIA Regards, Edvin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan DeKok Sent: Donnerstag, 26. Jänner 2006 23:51 To: [EMAIL PROTECTED]; FreeRadius users mailing list Subject: Re: simultaneous-use and stateless sessions in sql "Seferovic Edvin" <[EMAIL PROTECTED]> wrote: > Are there any workarounds for this scenario? I've found > deletestatlesssessions in sql.conf file, but I have no idea how does this > work ( it is set to "yes" but no use ). Since my NAS is POPTOP server, type > is set to "other" and checkrad cannot check ( or won't check ). radzap? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: simultaneous-use and stateless sessions in sql
"Seferovic Edvin" <[EMAIL PROTECTED]> wrote: > Are there any workarounds for this scenario? I've found > deletestatlesssessions in sql.conf file, but I have no idea how does this > work ( it is set to "yes" but no use ). Since my NAS is POPTOP server, type > is set to "other" and checkrad cannot check ( or won't check ). radzap? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
simultaneous-use and stateless sessions in sql
Hi, I have set up my new test environment with freeradius-1.1.0 ( with ldap and mysql ) and I just hit the wall as my VPN server ( poptop - MS PPTP ) crashed. I have a session left in my mysql db with "Acct-Stop = 0" which permits user to login again ( after the crash ) because simultaneous-use is set to 1. Are there any workarounds for this scenario? I've found deletestatlesssessions in sql.conf file, but I have no idea how does this work ( it is set to "yes" but no use ). Since my NAS is POPTOP server, type is set to "other" and checkrad cannot check ( or won't check ). At the end of the Simultaneous-Use doc it is mentioned that Idle-Timeout could be used, but this works for specific NASes and not for such VPN server that looses all info about users when crashed. Only way I figured out would be to check for open session before simultaneous-use-query. Since Ive configured my "NAS" to send accounting data every 2 minutes, it would be easy to say "delete all session data where traffic_data = 0 and time difference between now and session_start > 2 Minutes".. but where could I put such query. Does anyone have any suggestions on this topic? I know it is rather complex topic, but I would appreciate any opinions. TIA Regards, Edvin Seferovic PS: sorry for my HTML eMail today ! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
