SQL logging options
Hi, I currently have freeradius 1.04 working with mysql. It logs successful connections to the 'radpostauth' table, and accouting information to the 'radacct' table. Is it possible to configure freeradius to log more data to the mysql database, such as unsuccessful connections with bad passwords/certificates etc? I would basically like to configure it to log *everything* to a mysql database. Thanks in advance, Ben Dowling __________________________________________________________________ 1Mb Tiscali Broadband for £14.99. Offer ends 30th June 2005 http://www.tiscali.co.uk/products/broadband
bendowling@lineone.net wrote:
I currently have freeradius 1.04 working with mysql. It logs successful connections to the 'radpostauth' table, and accouting information to the 'radacct' table. Is it possible to configure freeradius to log more data to the mysql database, such as unsuccessful connections with bad passwords/certificates etc?
You can run a SQL query for a failed connection by adding the module "sql" in the stanza "Post-Auth-Type REJECT". See http://freeradius.org/radiusd/doc/Post-Auth-Type -- Nicolas Baradakis
That's exactly what I was after, Thanks alot. Ben
-- Original Message -- Date: Sat, 3 Sep 2005 20:18:19 +0200 From: Nicolas Baradakis <nbk@sitadelle.com> To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: Re: SQL logging options Reply-To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org>
bendowling@lineone.net wrote:
I currently have freeradius 1.04 working with mysql. It logs successful connections to the 'radpostauth' table, and accouting information to the 'radacct' table. Is it possible to configure freeradius to log more data to the mysql database, such as unsuccessful connections with bad passwords/certificates etc?
You can run a SQL query for a failed connection by adding the module "sql" in the stanza "Post-Auth-Type REJECT".
See http://freeradius.org/radiusd/doc/Post-Auth-Type
-- Nicolas Baradakis
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
__________________________________________________________________ 1Mb Tiscali Broadband for £14.99. Offer ends 30th June 2005 http://www.tiscali.co.uk/products/broadband
participants (2)
-
bendowling＠lineone.net -
Nicolas Baradakis