Re: Cleanup Stale Sessions - needed?

2011-08-08 Thread Paolo Di Francesco
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 loose my radius logs (who had that IP that day..) 3) I do

Re: Cleanup Stale Sessions - needed?

2011-08-08 Thread Marinko Tarlać
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 which is called Cleanup Stale Sessions. I think it does exactly what I need but: 1) I do not want

Re: Cleanup Stale Sessions - needed?

2011-08-08 Thread Paolo Di Francesco
) 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 loose my radius logs (who had that IP that day..) 3

Re: Cleanup Stale Sessions - needed?

2011-08-08 Thread Alexander Clouter
Paolo Di Francesco paolo.difrance...@level7.it 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.

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 freeradius

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

Cleanup Stale Sessions - needed?

2011-06-20 Thread Paolo Di Francesco
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 loose my radius logs (who had that IP

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..) 3) I do not know if this is the right button

Re: Cleanup Stale Sessions - needed?

2011-06-20 Thread Paolo Di Francesco
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? :) Afterall I only want to flush the sessions older than 1 day Hi, So I have this teasing menu option in daloradius which is called Cleanup Stale

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! font size=1 div style='border:none;border-bottom:double windowtext

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 Fajar A. Nugraha
On Tue, Jun 21, 2011 at 6:17 AM, Paolo Di Francesco paolo.difrance...@level7.it 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

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

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-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. And FYI I upgraded

RE: Stale Sessions

2008-04-10 Thread Shane McKinley
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 over a year now

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

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

Re: Stale Sessions

2008-04-08 Thread Bill Brunton
[EMAIL PROTECTED] Reply-To: FreeRadius users mailing list freeradius-users@lists.freeradius.org 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

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 be the right way?tnx

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

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

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 fool

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 connection if

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

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

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 section? Alan

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

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 clean them up by hand

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 session is

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