Question About rlm_sql_log (it was Re: Time connected)
2009/10/29 Ivan Kalik <tnt@kalik.net>:
Sergio Belkin wrote:
2009/10/29 Ivan Kalik <tnt@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 -
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
2009/11/3 Ivan Kalik <tnt@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 -
participants (2)
-
Ivan Kalik -
Sergio Belkin