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?
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
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?
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 <sysadmin-aemnet@aemnet.it> 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
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
Perl & File::Tail works very well for things like this... On Mon, Mar 25, 2013 at 12:45 PM, AemNet <sysadmin-aemnet@aemnet.it> 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://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 <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 <http://www.freeradius.org/list/users.html>
-- Regards, Chris Knipe
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: olivier@heliosnet.org
participants (5)
-
A.L.M.Buxey＠lboro.ac.uk -
AemNet -
Alex Sharaz -
Chris Knipe -
Olivier Beytrison