log to mysql?

Dennis Skinner dskinner at bluefrog.com
Tue Feb 20 15:17:02 CET 2007


Phil Mayers wrote:

>> The logs are about everything concern freeradius and not only about
>> auth/acct on a mysql server. Is it realy possible?
> 
> I'm sure there are a million ways of sending the non-accounting logs to 
> SQL, but why would you want to - in normal (non-debugging) mode, the 
> FreeRadius logs are basically useless.

They can be useful to CS staff.  All you need is a perl script that uses
the File::Tail module.  It basically tails the log file and grabs out
some info and does mysql inserts.  I modified ours from a popb4smtp
script I found on the net.

-- 
Dennis Skinner
Systems Administrator
BlueFrog Internet
http://www.bluefrog.com



More information about the Freeradius-Users mailing list