-----Original Message-----
From: "Jamal Taweel" <jamal.taweel@paltel.net>
To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org>
Date: Wed, 17 May 2006 15:13:50 +0200
Subject: RE: getting Freeradius to recorde login failure, etc

Yes it is possible. But you should define a proper data type for the field.

 

 

-----Original Message-----
From: freeradius-users-bounces+jamal.taweel=paltel.net@lists.freeradius.org [mailto:freeradius-users-bounces+jamal.taweel=paltel.net@lists.freeradius.org] On Behalf Of Jeremy ohara
Sent: Wednesday, May 17, 2006 1:09 PM
To: FreeRadius users mailing list
Subject: RE: getting Freeradius to recorde login failure, etc
Importance: High

 

i wanted 2 other fields which are nasip and callerid

 

does that sound possible? sorry i'm not very strong in the sql coding area

 

Jeremy
 

 

-----Original Message-----
From: "Jamal Taweel" <jamal.taweel@paltel.net>
To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org>
Date: Wed, 17 May 2006 13:36:59 +0200
Subject: RE: getting Freeradius to recorde login failure, etc

You should write in PL/SQL the following:

CREATE FUNCTION + the statements which they were sent.

BR,

 

-----Original Message-----
From: freeradius-users-bounces+jamal.taweel=paltel.net@lists.freeradius.org [mailto:freeradius-users-bounces+jamal.taweel=paltel.net@lists.freeradius.org] On Behalf Of Jeremy ohara
Sent: Wednesday, May 17, 2006 12:17 PM
To: FreeRadius users mailing list
Subject: RE: getting Freeradius to recorde login failure, etc
Importance: High

 

i done all but i'm lost where you have

 

·  Create a function in the database (called “fails”). The main statements which you should write are

 

how do i do this?

 

Jeremy
 

 

-----Original Message-----
From: "Jamal Taweel" <jamal.taweel@paltel.net>
To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org>
Date: Wed, 17 May 2006 12:40:43 +0200
Subject: RE: getting Freeradius to recorde login failure, etc

Hi Jeremy,

 

In order to apply what wants, you should do the following:

·   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}','%{Use

r-Password}’) from dual) ORDER BY id"

 

That is all. Then you can find all failed logs inside the new created table fails_log.

 

Best Regards,

 

Jamal

 

 

-----Original Message-----
From: freeradius-users-bounces+jamal.taweel=paltel.net@lists.freeradius.org [mailto:freeradius-users-bounces+jamal.taweel=paltel.net@lists.freeradius.org] On Behalf Of Jeremy ohara
Sent: Wednesday, May 17, 2006 6:32 AM
To: FreeRadius users mailing list
Subject: Re: getting Freeradius to recorde login failure, etc

 

Hi there

i dont want to sound rude, etc but your not really answering my question. you only  answered half of it

 

what do i wite for the sql statement, etc

 

Jeremy 

 

-----Original Message-----
From: "Duane Cox" <duanec@mail.illicom.net>
To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org>
Date: Tue, 16 May 2006 22:28:12 -0500
Subject: Re: getting Freeradius to recorde login failure, etc

post-auth {
        #
        #  If you want to have a log of authentication replies,
        #  un-comment the following line, and the 'detail reply_log'
        #  section, above.
#       reply_log

 

        sql

 

        Post-Auth-Type REJECT {
                sql
        }
}

----- Original Message -----

From: Jeremy ohara

To: FreeRadius users mailing list

Sent: Tuesday, May 16, 2006 9:13 PM

Subject: Re: getting Freeradius to recorde login failure, etc

 

where and how do i do it and what do i write???

 

jeremy
 

 

-----Original Message-----
From: "Duane Cox" <duanec@mail.illicom.net>
To: "FreeRadius users mailing list" < freeradius-users@lists.freeradius.org>
Date: Tue, 16 May 2006 18:17:26 -0500
Subject: Re: getting Freeradius to recorde login failure, etc

yes, there is a subsection under the post_auth section for such a thing...

 

 

----- Original Message -----

From: Jeremy ohara

To: FreeRadius users mailing list

Sent: Tuesday, May 16, 2006 3:24 PM

Subject: getting Freeradius to recorde login failure, etc

 

 hi there

 

is there a way to get Freeradius 1.0.5 with Mysql  to record login-failure, incorrect password or incorrect username into the mysql table?

 

i can see its possbile. but when you login with wrong details it doesnt get to record the login failure, etc. and i dont knwo what code to use and how to make freeradius to record it

 

 

Jeremy

----------------------------------------------------------------------------
This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon.
Updated daily to keep up-to-date with all new and old viruses.
----------------------------------------------------------------------------

---

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

----------------------------------------------------------------------------
This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon.
Updated daily to keep up-to-date with all new and old viruses.
----------------------------------------------------------------------------

---

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

----------------------------------------------------------------------------
This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon.
Updated daily to keep up-to-date with all new and old viruses.
----------------------------------------------------------------------------

----------------------------------------------------------------------------
This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon.
Updated daily to keep up-to-date with all new and old viruses.
----------------------------------------------------------------------------

----------------------------------------------------------------------------
This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon.
Updated daily to keep up-to-date with all new and old viruses.
----------------------------------------------------------------------------