Re: radius.log on DB

[Olivier Beytrison]

On 25.03.2013 11:45, AemNet wrote:
> Thank you for the answer and for the links Olivier, but I prefer don't
> use the syslog system if it's possilbe.
> Do you think it's possible instead to use a script (perl/bash anything
> else) after the request arrive and put it in a DB?

You could make a perl script which pipe the freeradius log file and then
insert the text into a DB. But again that's beyond the scope of this
list. Freeradius doesn't offer the ability to put the log file into a DB.

Olivier B.
-- 

 Olivier Beytrison
 Network & Security Engineer, HES-SO Fribourg
 Mail: oliv...@heliosnet.org
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: radius.log on DB

[Chris Knipe]

Perl & File::Tail works very well for things like this...



On Mon, Mar 25, 2013 at 12:45 PM, AemNet  wrote:

> On 25/03/2013 11:05, Olivier Beytrison wrote:
>
>>
>> This is not possible directly from freeradius.
>>
>> What you can do, is tell FreeRadius to log to your syslog deamon (like
>> syslog-ng) and then tell syslog-ng to write the log within an INSERT
>> statement for your database. Then you can send this to your database.
>>
>> Those two links might help you :
>> http://wiki.freeradius.org/**guide/Syslog-HOWTO
>> http://vermeer.org/docs/1
>>
>> But this is beyond the scope of the freeradius list
>>
>> Olivier
>> -
>> List info/subscribe/unsubscribe? See http://www.freeradius.org/**
>> list/users.html 
>>
>>
> Thank you for the answer and for the links Olivier, but I prefer don't use
> the syslog system if it's possilbe.
> Do you think it's possible instead to use a script (perl/bash anything
> else) after the request arrive and put it in a DB?
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/**
> list/users.html 
>



-- 

Regards,
Chris Knipe
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: radius.log on DB

[A . L . M . Buxey]

Hi,

> Thank you for the answer and for the links Olivier, but I prefer
> don't use the syslog system if it's possilbe.
> Do you think it's possible instead to use a script (perl/bash
> anything else) after the request arrive and put it in a DB?

the SQL module has the psotauth table... you could always create your own
table, then use unlang to populate it with whatever you want in the
post-auth section of the server - for accept or reject packets.  that wont
log ALL that might appear in radiusd logfile (eg server messages)

alan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: radius.log on DB

[Alex Sharaz]

I the past I've "tail'd" a log file ( this was for squid and not freeradius) 
and piped that into a perl script that would then write things into a database 
but  it's a lot easier using syslog talking to an rsyslog back end database 
that writes things into a database for you.
Rgds
alex

On 25 Mar 2013, at 10:45, AemNet  wrote:

> On 25/03/2013 11:05, Olivier Beytrison wrote:
>> 
>> This is not possible directly from freeradius.
>> 
>> What you can do, is tell FreeRadius to log to your syslog deamon (like
>> syslog-ng) and then tell syslog-ng to write the log within an INSERT
>> statement for your database. Then you can send this to your database.
>> 
>> Those two links might help you :
>> http://wiki.freeradius.org/guide/Syslog-HOWTO
>> http://vermeer.org/docs/1
>> 
>> But this is beyond the scope of the freeradius list
>> 
>> Olivier
>> -
>> List info/subscribe/unsubscribe? See 
>> http://www.freeradius.org/list/users.html
>> 
> 
> Thank you for the answer and for the links Olivier, but I prefer don't use 
> the syslog system if it's possilbe.
> Do you think it's possible instead to use a script (perl/bash anything else) 
> after the request arrive and put it in a DB?
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: radius.log on DB

[AemNet]

On 25/03/2013 11:05, Olivier Beytrison wrote:


This is not possible directly from freeradius.

What you can do, is tell FreeRadius to log to your syslog deamon (like
syslog-ng) and then tell syslog-ng to write the log within an INSERT
statement for your database. Then you can send this to your database.

Those two links might help you :
http://wiki.freeradius.org/guide/Syslog-HOWTO
http://vermeer.org/docs/1

But this is beyond the scope of the freeradius list

Olivier
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html



Thank you for the answer and for the links Olivier, but I prefer don't 
use the syslog system if it's possilbe.
Do you think it's possible instead to use a script (perl/bash anything 
else) after the request arrive and put it in a DB?

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: radius.log on DB

[Olivier Beytrison]

On 25.03.2013 09:26, AemNet wrote:
> Hi everybody
> 
>  is there any way log the requests for the radius in a DB like MySQL? In
> other words is possible to put radius.log entry in a DB without use the
> local system syslog daemon?

This is not possible directly from freeradius.

What you can do, is tell FreeRadius to log to your syslog deamon (like
syslog-ng) and then tell syslog-ng to write the log within an INSERT
statement for your database. Then you can send this to your database.

Those two links might help you :
http://wiki.freeradius.org/guide/Syslog-HOWTO
http://vermeer.org/docs/1

But this is beyond the scope of the freeradius list

Olivier
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

radius.log on DB

[AemNet]

Hi everybody

 is there any way log the requests for the radius in a DB like MySQL? 
In other words is possible to put radius.log entry in a DB without use 
the local system syslog daemon?

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html