Re: Cleanup Stale Sessions - needed?

2011-08-08 Thread Alexander Clouter
Paolo Di Francesco wrote: > > we searched before asking, but we did not find any reference. If you > have references of previous conversations, please send me the pointers > privately. > http://lmgtfy.com/?q=site%3Ahttp%3A%2F%2Flists.cistron.nl%2Fpipermail%2Ffreeradius-users%2F+sql+session+clean

Re: Cleanup Stale Sessions - needed?

2011-08-08 Thread Paolo Di Francesco
therefore I moved some NASes >>> from one server to another. >>> >>> When I did this change, obviously I did it without worrying what could >>> happen to the radiusd. So I simply moved the NASes on new IPs/servers >>> and restarted the radiusd. >>

Re: Cleanup Stale Sessions - needed?

2011-08-08 Thread Marinko Tarlać
k but they look "online" to radiusd on the old NASes. In few words the connection is refused because radiusd thinks that the user is ALREADY online on the "old NAS" (not true) and it does not permit the user to get into the network. So I have this teasing menu option in daloradius w

Re: Cleanup Stale Sessions - needed?

2011-08-08 Thread Paolo Di Francesco
nline" to radiusd on the old NASes. In few words the connection is > refused because radiusd thinks that the user is ALREADY online on the > "old NAS" (not true) and it does not permit the user to get into the > network. > > So I have this teasing menu option in dalor

Re: Cleanup Stale Sessions - needed?

2011-06-21 Thread Paolo Di Francesco
Hi Alan and all I am writing you to let you know that I solved this problem Yes, the auth was done with sql (sorry for not being more precise before) I surfed the tables and delete the NULL field in the right places (customers not being authenticated) It worked and I could feeel much more confo

Re: Cleanup Stale Sessions - needed?

2011-06-21 Thread Alan Buxey
Hi, > Hi Alan, > > hum... any freeradius script/comand that I could use instead of the > teasing red button with the "don't press this button" written on it? :) i'm guessing your system uses SQL (eg MySQL) in the backend for accounting..so its an sql command you'll be wanting rather than a freera

Re: Cleanup Stale Sessions - needed?

2011-06-20 Thread Fajar A. Nugraha
On Tue, Jun 21, 2011 at 6:17 AM, Paolo Di Francesco wrote: > Hi Gary > > I did the same in many other situations, and not always I got the > expected result. > > In some circumstances it was working, in others it was like the "press > here to collapse the world" just with the stickers "press me ho

Re: Cleanup Stale Sessions - needed?

2011-06-20 Thread Paolo Di Francesco
Hi Gary I did the same in many other situations, and not always I got the expected result. In some circumstances it was working, in others it was like the "press here to collapse the world" just with the stickers "press me honey" on top of it. Just wondering if somebody can point me to the right

RE: Cleanup Stale Sessions - needed?

2011-06-20 Thread Gary Gatten
Snip "much like a big red button that says 'dont press' ;-)" Ah, I did that once just to see what would happen. I STRONGLY recommend against it. No I really didn't, but it is REALLY tempting some days! "This email is intended to be reviewed by only the intended recipient and

Re: Cleanup Stale Sessions - needed?

2011-06-20 Thread Paolo Di Francesco
option in daloradius which is called >> "Cleanup Stale Sessions". I think it does exactly what I need but: >> >> 1) I do not want to break the radiusd >> 2) I do not want to loose my radius logs ("who had that IP that day..") >> 3) I do not know if thi

Re: Cleanup Stale Sessions - needed?

2011-06-20 Thread Alan Buxey
Hi, > So I have this teasing menu option in daloradius which is called > "Cleanup Stale Sessions". I think it does exactly what I need but: > > 1) I do not want to break the radiusd > 2) I do not want to loose my radius logs ("who had that IP that day..") >

Cleanup Stale Sessions - needed?

2011-06-20 Thread Paolo Di Francesco
ine on the "old NAS" (not true) and it does not permit the user to get into the network. So I have this teasing menu option in daloradius which is called "Cleanup Stale Sessions". I think it does exactly what I need but: 1) I do not want to break the radiusd 2) I do not want to

RE: Stale Sessions

2008-04-12 Thread Ivan Kalik
>Thanks for the reply. However, these are Internet customers coming from >DSL or Dial up. I assume the Cisco and portmasters are sending unique >session IDs. > Don't assume. Use debug to see what's happening with accounting packets. Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscr

RE: Stale Sessions

2008-04-11 Thread Shane McKinley
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 11, 2008 12:40 PM To: FreeRadius users mailing list Subject: Re: Stale Sessions Hi, > No one has any ideas or suggestions? If I can solve this issue I will > have a 'perfect' freeradius installation. An

Re: Stale Sessions

2008-04-11 Thread A . L . M . Buxey
Hi, > No one has any ideas or suggestions? If I can solve this issue I will > have a 'perfect' freeradius installation. And FYI I upgraded my server > to a dual core 2BG of RAM and still the same issue resides. radutmp issueS? what are you using to make sessions unique? perhaps they are not unique

Re: Stale Sessions

2008-04-10 Thread Phil Mayers
Shane McKinley wrote: No one has any ideas or suggestions? If I can solve this issue I will have a 'perfect' freeradius installation. And FYI I upgraded my server to a dual core 2BG of RAM and still the same issue resides. If the radius server doesn't receive the packets, it doesn't matter how

RE: Stale Sessions

2008-04-10 Thread Shane McKinley
day, April 08, 2008 11:17 AM To: 'freeradius-users@lists.freeradius.org' Subject: Stale Sessions I have searched and searched, read the archives, etc. I feel that I may have a unique problem and just missing a piece of the puzzle. I have been running freeradius with a mysql database for

Re: Stale Sessions

2008-04-08 Thread Bill Brunton
<[EMAIL PROTECTED]> Reply-To: FreeRadius users mailing list To: freeradius-users@lists.freeradius.org Subject: Stale Sessions I have searched and searched, read the archives, etc. I feel that I may have a unique problem and just missing a piece of the puzzle. I have been running free

Stale Sessions

2008-04-08 Thread Shane McKinley
on every one of my NASes. They range from Cisco 7200, Cisco 2600, and Livingston Portmasters. They all have stale sessions in the mysql database that never recieve a stop time. I am almost certain there are no network issues because it seems that start packets are never lost or update packets either

clean stale sessions with radzap?

2006-09-23 Thread YvesDM
I use FR + mysqlI try to clean some stale sessions from NAS's with dynamic ip's.I 'm logged in on the server and use radzap this way:radius1:~# radzapUsage: radzap [options] server[:port] secretSo i try: radius1:~# radzap -u john localhost:1812 mysecretBut this doesn't seem to

Re: Stale sessions

2006-06-13 Thread Stelio Gouveia
Thank you Carlos for your reply, your post has been most helpful to reinforce my understanding of freeradius. According to your reply i am going to assume that the only field that need to be updated is the AcctStopTime field. To be honest i dont really understand the logic behind the Interrim-Inter

Re: Stale sessions

2006-06-12 Thread Alan DeKok
Stelio Gouveia <[EMAIL PROTECTED]> wrote: > I have noticed that you cant rely on the sql method, even thou there is > a simul_count_query! In my case when i encounter a stale session i set > the AcctStopTime = AcctStartTime + AcctSessionTime. Although this seems > to work most of the time, its not

Stale sessions

2006-06-12 Thread Stelio Gouveia
Im using the following configuration to handle sessions # 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

Re: Stale sessions problem

2006-02-25 Thread Alan DeKok
Georgi Alexandrov <[EMAIL PROTECTED]> wrote: > sql is listed in the session section, yes. Then it should clean up stale sessions when the user logs in the second time, if the first session doesn't exist on the NAS. IF... checkrad can talk to the NAS. If not, you have to cl

Re: Stale sessions problem

2006-02-25 Thread Georgi Alexandrov
Gerry Dalton wrote: > Kinda depends on what he is connected to. If you get a START record and > a STOP record after the authentication from the device they are > connected to you can check there. If you use sql for accounting, there > will be a record created with a unique session id for the cust

Re: Stale sessions problem

2006-02-25 Thread Georgi Alexandrov
Alan DeKok wrote: > Georgi Alexandrov <[EMAIL PROTECTED]> wrote: > >>how could one know from the database (radacct i suppose) if a user >>session i stalled or he's actually online? > > > The SQL module is supposed to do this by calling checkrad. Have you > listed "sql" in the "session" sectio

Re: Stale sessions problem

2006-02-25 Thread Alan DeKok
Georgi Alexandrov <[EMAIL PROTECTED]> wrote: > how could one know from the database (radacct i suppose) if a user > session i stalled or he's actually online? The SQL module is supposed to do this by calling checkrad. Have you listed "sql" in the "session" section? Alan DeKok. - List info/

Re: Stale sessions problem

2006-02-25 Thread Gerry Dalton
Kinda depends on what he is connected to. If you get a START record and a STOP record after the authentication from the device they are connected to you can check there. If you use sql for accounting, there will be a record created with a unique session id for the customer, and it will have a

Re: Stale sessions problem

2006-02-25 Thread Georgi Alexandrov
Alan DeKok wrote: > Georgi Alexandrov <[EMAIL PROTECTED]> wrote: > >>If a user that somehow failed network connectivity and failed to tell >>the server "account stop" tries to reconnect back it won't let him >>because his previous session is stalled. I need a mechanism that will do >>a check upon

Re: Stale sessions problem

2006-02-21 Thread Alan DeKok
Georgi Alexandrov <[EMAIL PROTECTED]> wrote: > If a user that somehow failed network connectivity and failed to tell > the server "account stop" tries to reconnect back it won't let him > because his previous session is stalled. I need a mechanism that will do > a check upon connection if the sessi

Re: Stale sessions problem

2006-02-20 Thread Georgi Alexandrov
On 2/17/06, Georgi Alexandrov <[EMAIL PROTECTED]> wrote: Hello,I'm running freeradius 1.1.0 + mysql + dialupadmin on a linux 2.6 boxwith a pppoe-server runing on the same machine as nas.It works great ;-)But i have a problem with stalled sessions.I have set simultaneous use :=1. I have set "sql" in

Stale sessions problem

2006-02-17 Thread Georgi Alexandrov
Hello, I'm running freeradius 1.1.0 + mysql + dialupadmin on a linux 2.6 box with a pppoe-server runing on the same machine as nas. It works great ;-) But i have a problem with stalled sessions. I have set simultaneous use :=1. I have set "sql" in the session section in radiusd.conf. If a user t