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@lists.freeradius.org [mailto:freeradius-users-bounces+edvin.seferovic=kolp.at@lists.freeradius.or g] On Behalf Of Sean Taylor Sent: Donnerstag, 15. Juni 2006 07:13 To: freeradius-users@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