What is the generated error through function creating?? -----Original Message----- From: freeradius-users-bounces+jamal.taweel=paltel.net@lists.freeradius.org [mailto:freeradius-users-bounces+jamal.taweel=paltel.net@lists.freeradiu s.org] On Behalf Of Jeremy ohara Sent: Wednesday, May 17, 2006 4:51 PM To: FreeRadius users mailing list Subject: RE: getting Freeradius to recorde login failure, etc i have tried the sql functin you have me and it didnt work. failed to create jeremy -----Original Message----- From: "Jeremy ohara" <Admin@jemisp.com> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Date: Thu, 18 May 2006 00:20:31 +1000 Subject: RE: getting Freeradius to recorde login failure, etc thats easy do it do it in the sql state ment or on the database ro what? just want caller id and nas ip 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 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.freeradiu s.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.freeradiu s.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.freeradiu s.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 <mailto:Admin@jemisp.com> To: FreeRadius users mailing list <mailto:freeradius-users@lists.freeradius.org> 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 <mailto: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 <mailto:Admin@jemisp.com> To: FreeRadius users mailing list <mailto:freeradius-users@lists.freeradius.org> 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. ------------------------------------------------------------------------ ---- ------------------------------------------------------------------------ ---- 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. ------------------------------------------------------------------------ ----