Question About rlm_sql_log (it was Re: Time connected)
2009/10/29 Ivan Kalik t...@kalik.net: Sergio Belkin wrote: 2009/10/29 Ivan Kalik t...@kalik.net: Sergio Belkin wrote: Hi, Sorry for the stupid question, but I'd want to get how many time every user is connected, please could you provide some kind of guideliness? Using Version 2.1.1. SELECT Count(*) FROM radacct WHERE UserName='some_username' Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html I guess that you're using database module, aren't you? You should too. Much simpler than parsing detail file. Ivan Kalik Kalik Informatika ISP - Hi, I was reading about rlm_sql_log. I mean I don't want to rely on sql for authorization and authentication. Can I use that module only for easiest log handling *only* ? Thanks in advance! -- -- Open Kairos http://www.openkairos.com Watch More TV http://sebelk.blogspot.com Sergio Belkin - - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Question About rlm_sql_log (it was Re: Time connected)
Sorry for the stupid question, but I'd want to get how many time every user is connected, please could you provide some kind of guideliness? Using Version 2.1.1. SELECT Count(*) FROM radacct WHERE UserName='some_username' I guess that you're using database module, aren't you? You should too. Much simpler than parsing detail file. I was reading about rlm_sql_log. Why? That has nothing to do with anything you would want. I mean I don't want to rely on sql for authorization and authentication. So don't. Use it just for accounting. Can I use that module only for easiest log handling *only* ? What does that mean? Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Question About rlm_sql_log (it was Re: Time connected)
2009/11/3 Ivan Kalik t...@kalik.net: Sorry for the stupid question, but I'd want to get how many time every user is connected, please could you provide some kind of guideliness? Using Version 2.1.1. SELECT Count(*) FROM radacct WHERE UserName='some_username' I guess that you're using database module, aren't you? You should too. Much simpler than parsing detail file. I was reading about rlm_sql_log. Why? That has nothing to do with anything you would want. I mean I don't want to rely on sql for authorization and authentication. So don't. Use it just for accounting. Can I use that module only for easiest log handling *only* ? What does that mean? Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html I want to find some way to analyze logs, and so can get eg: last user status or how long a time that a user has been connected. Thanks in advance! -- -- Open Kairos http://www.openkairos.com Watch More TV http://sebelk.blogspot.com Sergio Belkin - - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Time connected
Sergio Belkin wrote: Hi, Sorry for the stupid question, but I'd want to get how many time every user is connected, please could you provide some kind of guideliness? Using Version 2.1.1. SELECT Count(*) FROM radacct WHERE UserName='some_username' Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Time connected
2009/10/29 Ivan Kalik t...@kalik.net: Sergio Belkin wrote: Hi, Sorry for the stupid question, but I'd want to get how many time every user is connected, please could you provide some kind of guideliness? Using Version 2.1.1. SELECT Count(*) FROM radacct WHERE UserName='some_username' Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html I guess that you're using database module, aren't you? -- -- Open Kairos http://www.openkairos.com Watch More TV http://sebelk.blogspot.com Sergio Belkin - - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Time connected
Sergio Belkin wrote: 2009/10/29 Ivan Kalik t...@kalik.net: Sergio Belkin wrote: Hi, Sorry for the stupid question, but I'd want to get how many time every user is connected, please could you provide some kind of guideliness? Using Version 2.1.1. SELECT Count(*) FROM radacct WHERE UserName='some_username' Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html I guess that you're using database module, aren't you? You should too. Much simpler than parsing detail file. Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Time connected
I use the following: SELECT SUM(AcctOutputOctets/1024) AS data, SUM(AcctSessionTime/60) AS minutes, DATE_FORMAT(AcctStartTime,'%M %Y') AS month, CalledStationId, UserName INTO OUTFILE /tmp/feb-09-result.txt FROM radacct GROUP BY month, CalledStationId, UserName HAVING month LIKE 'February 2009'; Scott -Original Message- From: freeradius-users-bounces+srmiller=interbel@lists.freeradius.org [mailto:freeradius-users-bounces+srmiller=interbel@lists.freeradius.org] On Behalf Of Sergio Belkin Sent: Thursday, October 29, 2009 5:11 AM To: FreeRadius users mailing list Subject: Time connected Hi, Sorry for the stupid question, but I'd want to get how many time every user is connected, please could you provide some kind of guideliness? Using Version 2.1.1. Thanks in advance! -- -- Open Kairos http://www.openkairos.com Watch More TV http://sebelk.blogspot.com Sergio Belkin - - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html