mysql accounting

[Sean Taylor]

I actually did search the archives quite a bit, just not for the right 
thing apparently.  I usually won't post to a list until I've exhausted 
all other options.  Anyways,  has someone actually turned this giberish 
into working SQL code they are willing to share?

Thanks

Seferovic Edvin wrote:
> Hello,
>
> I do NOT want to be rude, but sometimes searching the archives helps A LOT !
> BELIEVE ME ! But for the lazy developers among you people - here is the part
> that describes the needed feature. Thanks to Jamal ( of course ). This is
> copy paste - so do NOT blame me ;)
>
> ---- START ----
> Create a table in the radius schema (called "fails_log") to include three
> columns: trial_date, username, password. 
> Create a function in the database (called "fails"). The main statements
> which you should write are 
> "
>
>  fails ( username1 in out char, password1 in char) return char is
>
> v_user char:='';
>
> v_password:='';
>
> begin
>
> select username , value into v_user from radcheck  where
> attribute='password' and username= username1 and password=password1;
>
> if v_user = '' then insert into fails_log values
> (sysdate,username1,password1);
>
> else return v_user;
>
> end if;
>
> end; 
>
>  
>
> "   
>
> Update authorize_ceck_query module in sql.conf  file to be as follows: 
> authorize_check_query = "SELECT id,Username,Attribute,Value,op FROM
> ${authcheck_table} WHERE Username =(select
> fails('%{SQL-User-Name}','%{User-Password}') from dual) ORDER BY id"
>
>  
>
> That is all. Then you can find all failed logs inside the new created table
> fails_log.
>
> ---- END ----
>
> Regards,
>
> Edvin Seferovic
>
> -----Original Message-----
> From: freeradius-users-bounces+edvin.seferovic=kolp.at at lists.freeradius.org
> [mailto:freeradius-users-bounces+edvin.seferovic=kolp.at at lists.freeradius.or
> g] On Behalf Of Sean Taylor
> Sent: Donnerstag, 15. Juni 2006 07:13
> To: freeradius-users at lists.freeradius.org
> Subject: mysql accounting
>
> I have a quick question on the mysql accounting.  I am working on my own
> interface for managing the freeradius+mysql setup.  Everything is
> working great, I can view all my users, see who's connected, add new
> users, manage static vs. dynamic IP's, etc..The problem is it doesnt
> seem to log authentication failures into the radacct table.  It logs all
> the successes just fine, but it would be very beneficial to have it log
> the failures too.  I have the sql module turned on in the accounting
> section of the config and have uncommented all of the accounting
> queries.  Any help appreciated.
>
> Thanks
> Sean Taylor
> Systems Administrator
> Valutel Communications
>
> - 
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>