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" <[EMAIL PROTECTED]>
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:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
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
-----Original Message-----
From: "Jamal Taweel"
<[EMAIL PROTECTED]>
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:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
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
-----Original
Message-----
From: "Jamal Taweel" <[EMAIL PROTECTED]>
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
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.
-----Original Message-----
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
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
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
-----Original
Message-----
From: "Duane Cox" <[EMAIL PROTECTED]>
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
Post-Auth-Type REJECT {
sql
}
}
----- Original Message -----
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???
-----Original
Message-----
From: "Duane Cox" <[EMAIL PROTECTED]>
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 -----
Sent:
Tuesday, May 16, 2006 3:24 PM
Subject: getting Freeradius to recorde login failure,
etc
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
----------------------------------------------------------------------------
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.
----------------------------------------------------------------------------
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- RE: getting Freeradius to recorde login failure, ... Jeremy ohara
-