Question About rlm_sql_log (it was Re: Time connected)

[Sergio Belkin-2]

2009/10/29 Ivan Kalik <tnt@...>:

> Sergio Belkin wrote:
>>
>> 2009/10/29 Ivan Kalik <tnt@...>:
>>
>>>
>>> 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

[tnt-5]

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

[Sergio Belkin-2]

2009/11/3 Ivan Kalik <tnt@...>:

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