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