Session-Timeout Monitoring from db.daily
Hello guys, I am using counter module as follows: counter daily { filename = ${raddbdir}/db.daily key = User-Name count-attribute = Acct-Session-Time reset = daily counter-name = Daily-Session-Time check-name = Max-Daily-Session reply-name = Session-Timeout cache-size = 5000 } All the information of the users that connect and dc, is stored in the db.daily file I suppose. But I can not open the file with notepad and see which user had how many seconds of active sessions. I configured a user to use 1 hour per day. The user used 20 min of his 1 hour limit. Now where can I see that users remaining time to spent during that day?? I am not using regular accounting tables of the FR. I suppose that information is located that db.daily file but I can not see inside of it. Can you help me? Thank you very much -- View this message in context: http://freeradius.1045715.n5.nabble.com/Session-Timeout-Monitoring-from-db-d... Sent from the FreeRadius - User mailing list archive at Nabble.com.
yagizozen wrote:
All the information of the users that connect and dc, is stored in the db.daily file I suppose. But I can not open the file with notepad and see which user had how many seconds of active sessions.
That's not how computers work. Do you open MP3s in Notepad to play them?
I configured a user to use 1 hour per day. The user used 20 min of his 1 hour limit. Now where can I see that users remaining time to spent during that day?? I am not using regular accounting tables of the FR. I suppose that information is located that db.daily file but I can not see inside of it. Can you help me?
See the "rad_counter.pl" file which is distributed with the server. Alan DeKok.
Thank you Alan, I couldnt find that perl file in my machine. Is there any way to see the content of db.daily with the use of any program in the windows environment so that I can copy the file to my windows and use that tool to look inside. -- View this message in context: http://freeradius.1045715.n5.nabble.com/Session-Timeout-Monitoring-from-db-d... Sent from the FreeRadius - User mailing list archive at Nabble.com.
On Wed, May 9, 2012 at 3:54 PM, yagizozen <yagizozen@yahoo.com> wrote:
Thank you Alan,
I couldnt find that perl file in my machine. Is there any way to see the content of db.daily with the use of any program in the windows environment so that I can copy the file to my windows and use that tool to look inside.
Short version: No. Long version: did you look at rad_counter.pl, as Alan mentioned? If you did, you'd notice that it's a perl script, which uses GDBM_File module. Both should be available on windows (active perl, cygwin, etc). Or you could use some other program which supports gdbm (e.g. php). But since you didn't even bother looking at that file, my guess is you won't be able to find the applications required to look at it's content. So no, you won't be able to do so. -- Fajar
On Wed, May 9, 2012 at 3:54 PM, yagizozen <yagizozen@yahoo.com> wrote:
Thank you Alan,
I couldnt find that perl file in my machine.
It's available on FR source code, as mentioned already by Alan: http://freeradius.org/download.html Or read the latest development version directly from github: https://github.com/alandekok/freeradius-server/blob/v2.1.x/src/modules/rlm_c... -- Fajar
yagizozen wrote:
I couldnt find that perl file in my machine.
That's not a good response. The file is distributed with FreeRADIUS. Go look in the FreeRADIUS distribution archive for it.
Is there any way to see the content of db.daily with the use of any program in the windows environment so that I can copy the file to my windows and use that tool to look inside.
I have no idea. I don't use Windows. The tools distributed with FreeRADIUS work. Use them. Alan DeKok.
You are right Sir, I could not find it in my server because it didnt installed I guess when I install FR with "yum install freeradius2 freeradius2-utils" -- View this message in context: http://freeradius.1045715.n5.nabble.com/Session-Timeout-Monitoring-from-db-d... Sent from the FreeRadius - User mailing list archive at Nabble.com.
I do not have the "modules" folder under /usr/src. How can I install the modules folder to my machine but do not change any other file contents under /etc or /var/log/radius -- View this message in context: http://freeradius.1045715.n5.nabble.com/Session-Timeout-Monitoring-from-db-d... Sent from the FreeRadius - User mailing list archive at Nabble.com.
yagizozen wrote:
I do not have the "modules" folder under /usr/src. How can I install the modules folder to my machine but do not change any other file contents under /etc or /var/log/radius
Download the "tar" file from our FTP site. See http://www.freeradius.org/ Or, read the link that Fajar sent out. Alan DeKok.
On 05/09/2012 07:17 AM, yagizozen wrote:
You are right Sir,
I could not find it in my server because it didnt installed I guess when I install FR with "yum install freeradius2 freeradius2-utils"
The reason the rad_counter.pl is only in a source distribution is because it's not installed via the install target in the Makefile. If rad_counter.pl is meant to be a user utility it should be installed as part of "make install". -- John Dennis <jdennis@redhat.com> Looking to carve out IT costs? www.redhat.com/carveoutcosts/
John Dennis wrote:
The reason the rad_counter.pl is only in a source distribution is because it's not installed via the install target in the Makefile. If rad_counter.pl is meant to be a user utility it should be installed as part of "make install".
That's probably a good idea. I'll go add that. Alan DeKok.
helloo everyone, I manage to do it finally :) THANK YOU Very much -- View this message in context: http://freeradius.1045715.n5.nabble.com/Session-Timeout-Monitoring-from-db-d... Sent from the FreeRadius - User mailing list archive at Nabble.com.
participants (4)
-
Alan DeKok -
Fajar A. Nugraha -
John Dennis -
yagizozen