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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html