<HTML>
<FONT style="FONT-SIZE: 8pt; FONT-FAMILY: arial, helvetica, sans-serif">
<DIV>i have tried the sql functin you have me and it didnt work. failed
to create</DIV>
<DIV> </DIV>
<DIV>jeremy<BR> </DIV></FONT><BR>
<BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">-----Original
Message-----<BR>From: "Jeremy ohara" <Admin@jemisp.com><BR>To:
"FreeRadius users mailing list"
<freeradius-users@lists.freeradius.org><BR>Date: Thu, 18 May 2006
00:20:31 +1000<BR>Subject: RE: getting Freeradius to recorde login failure,
etc<BR><BR><FONT style="FONT-SIZE: 8pt; FONT-FAMILY: arial, helvetica,
sans-serif">
<DIV>thats easy do it do it in the sql state ment or on the database ro
what?</DIV>
<DIV> </DIV>
<DIV>just want caller id and nas ip</DIV>
<DIV> </DIV>
<DIV>Jeremy<BR> </DIV></FONT><BR>
<BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">-----Original
Message-----<BR>From: "Jamal Taweel" <jamal.taweel@paltel.net><BR>To:
"FreeRadius users mailing list"
<freeradius-users@lists.freeradius.org><BR>Date: Wed, 17 May 2006
15:13:50 +0200<BR>Subject: RE: getting Freeradius to recorde login failure,
etc<BR><BR>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Yes it is possible.
But you should define a proper data type for the field.</SPAN></FONT></DIV>
</DIV>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </SPAN></FONT>
<DIV></DIV>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </SPAN></FONT>
<DIV></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original Message-----<BR>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B>
freeradius-users-bounces+jamal.taweel=paltel.net@lists.freeradius.org
[mailto:freeradius-users-bounces+jamal.taweel=paltel.net@lists.freeradius.org]
<B><SPAN style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Jeremy ohara<BR>
<B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, May 17, 2006
1:09 PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> FreeRadius
users mailing list<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B>
RE: getting Freeradius to recorde login failure, etc<BR><B><SPAN
style="FONT-WEIGHT: bold">Importance:</SPAN></B> High</SPAN></FONT>
<DIV></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">i wanted 2 other fields
which are nasip and callerid</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">does that sound possible? sorry
i'm not very strong in the sql coding area</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Jeremy<BR> </SPAN></FONT>
</DIV></DIV>
<DIV></DIV>
<BLOCKQUOTE style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm;
BORDER-TOP: medium none; PADDING-LEFT: 4pt; PADDING-BOTTOM: 0cm; MARGIN: 5pt
0cm 5pt 3.75pt; BORDER-LEFT: black 1.5pt solid; PADDING-TOP: 0cm;
BORDER-BOTTOM: medium none">
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT>
<DIV></DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 36pt;
MARGIN-RIGHT: 0cm"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">-----Original Message-----<BR>From: "Jamal Taweel"
<jamal.taweel@paltel.net><BR>To: "FreeRadius users mailing list"
<freeradius-users@lists.freeradius.org><BR>Date: Wed, 17 May 2006
13:36:59 +0200<BR>Subject: RE: getting Freeradius to recorde login failure,
etc</SPAN></FONT>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">You
should write in PL/SQL the following:</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">CREATE
FUNCTION + the statements which they were sent.</SPAN></FONT>
<DIV></DIV></BLOCKQUOTE>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
BR,</SPAN></FONT>
<DIV></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
</SPAN></FONT>
<DIV></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original Message-----<BR>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B>
freeradius-users-bounces+jamal.taweel=paltel.net@lists.freeradius.org
[mailto:freeradius-users-bounces+jamal.taweel=paltel.net@lists.freeradius.org]
<B><SPAN style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Jeremy ohara<BR>
<B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, May 17, 2006
12:17 PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> FreeRadius
users mailing list<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B>
RE: getting Freeradius to recorde login failure, etc<BR><B><SPAN
style="FONT-WEIGHT: bold">Importance:</SPAN></B> High</SPAN></FONT>
<DIV></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">i done all but i'm lost where you
have</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Symbol size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Symbol">·</SPAN></FONT><FONT face=Arial
size=1><SPAN style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"> </SPAN></FONT>
<FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR:
navy; FONT-FAMILY: Arial">Create a function in the database (called
“fails”). The main statements which you should write are </SPAN></FONT>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">how do i do this?</SPAN>
</FONT><FONT face=Arial size=1><SPAN style="FONT-SIZE: 7.5pt; FONT-FAMILY:
Arial"></SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Jeremy<BR> </SPAN></FONT>
</DIV></DIV>
<DIV></DIV>
<BLOCKQUOTE style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm;
BORDER-TOP: medium none; PADDING-LEFT: 4pt; PADDING-BOTTOM: 0cm; MARGIN: 5pt
0cm 5pt 3.75pt; BORDER-LEFT: black 1.5pt solid; PADDING-TOP: 0cm;
BORDER-BOTTOM: medium none">
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT>
<DIV></DIV></BLOCKQUOTE>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 72pt"><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">-----Original
Message-----<BR>From: "Jamal Taweel" <jamal.taweel@paltel.net><BR>To:
"FreeRadius users mailing list"
<freeradius-users@lists.freeradius.org><BR>Date: Wed, 17 May 2006
12:40:43 +0200<BR>Subject: RE: getting Freeradius to recorde login failure,
etc</SPAN></FONT>
<DIV></DIV>
<DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Hi
Jeremy,</SPAN></FONT></DIV></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">In
order to apply what wants, you should do the following:</SPAN></FONT></DIV>
</DIV>
<DIV></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 108pt; TEXT-INDENT: -18pt"><FONT
face=Symbol color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy;
FONT-FAMILY: Symbol">·</SPAN></FONT><FONT color=navy size=1><SPAN
style="FONT-SIZE: 7pt; COLOR: navy"> </SPAN></FONT><FONT
face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy;
FONT-FAMILY: Arial">Create a table in the radius schema (called
“fails_log”) to include three columns: trial_date, username,
password.</SPAN></FONT><FONT color=navy><SPAN style="COLOR: navy"> </SPAN>
</FONT>
<DIV></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 108pt; TEXT-INDENT: -18pt"><FONT
face=Symbol color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy;
FONT-FAMILY: Symbol">·</SPAN></FONT><FONT color=navy size=1><SPAN
style="FONT-SIZE: 7pt; COLOR: navy"> </SPAN></FONT><FONT
face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy;
FONT-FAMILY: Arial">Create a function in the database (called “fails”).
The main statements which you should write are </SPAN></FONT>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt; TEXT-INDENT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
“</SPAN></FONT>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt; TEXT-INDENT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
fails ( username1 in out char, password1 in char) return char is
</SPAN></FONT>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt; TEXT-INDENT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">v_user
char:=’’;</SPAN></FONT>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt; TEXT-INDENT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
v_password:=’’;</SPAN></FONT>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt; TEXT-INDENT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
begin</SPAN></FONT>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt; TEXT-INDENT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">select
username , value into v_user from radcheck where
attribute=’password’ and username= username1 and
password=password1;</SPAN></FONT>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt; TEXT-INDENT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">if
v_user = ‘’ then insert into fails_log values
(sysdate,username1,password1);</SPAN></FONT>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt; TEXT-INDENT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">else
return v_user;</SPAN></FONT>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt; TEXT-INDENT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">end
if;</SPAN></FONT>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt; TEXT-INDENT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">end;
</SPAN></FONT>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt; TEXT-INDENT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
</SPAN></FONT>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt; TEXT-INDENT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
“ </SPAN></FONT>
<DIV></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 108pt; TEXT-INDENT: -18pt"><FONT
face=Symbol color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy;
FONT-FAMILY: Symbol">·</SPAN></FONT><FONT color=navy size=1><SPAN
style="FONT-SIZE: 7pt; COLOR: navy">
</SPAN></FONT><FONT
face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy;
FONT-FAMILY: Arial">Update authorize_ceck_query module in sql.conf
file to be as follows:</SPAN></FONT><FONT color=navy><SPAN
style="COLOR: navy"> </SPAN></FONT>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt; TEXT-INDENT: 36pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
authorize_check_query = "SELECT id,Username,Attribute,Value,op FROM
${authcheck_table} WHERE Username =(select
fails('%{SQL-User-Name}','%{Use</SPAN></FONT>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
r-Password}’) from dual) ORDER BY id" </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">That
is all. Then you can find all failed logs inside the new created table
fails_log.</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Best
Regards,</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
Jamal</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original Message-----<BR>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B>
freeradius-users-bounces+jamal.taweel=paltel.net@lists.freeradius.org
[mailto:freeradius-users-bounces+jamal.taweel=paltel.net@lists.freeradius.org]
<B><SPAN style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Jeremy ohara<BR>
<B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, May 17, 2006
6:32 AM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> FreeRadius
users mailing list<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B>
Re: getting Freeradius to recorde login failure, etc</SPAN></FONT>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> </SPAN></FONT>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Hi there</SPAN></FONT></DIV>
</DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">i dont want to sound rude, etc
but your not really answering my question. you only answered half of
it</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">what do i wite for the sql
statement, etc</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Jeremy </SPAN></FONT></DIV>
</DIV>
<DIV></DIV>
<BLOCKQUOTE style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm;
BORDER-TOP: medium none; PADDING-LEFT: 4pt; PADDING-BOTTOM: 0cm; MARGIN: 5pt
0cm 5pt 3.75pt; BORDER-LEFT: black 1.5pt solid; PADDING-TOP: 0cm;
BORDER-BOTTOM: medium none">
<P style="MARGIN-LEFT: 108pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> </SPAN></FONT>
<DIV></DIV></BLOCKQUOTE>
<P style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 108pt; MARGIN-RIGHT: 0cm"><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">-----Original
Message-----<BR>From: "Duane Cox" <duanec@mail.illicom.net><BR>To:
"FreeRadius users mailing list"
<freeradius-users@lists.freeradius.org><BR>Date: Tue, 16 May 2006
22:28:12 -0500<BR>Subject: Re: getting Freeradius to recorde login failure,
etc</SPAN></FONT>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">post-auth {<BR>
#<BR>
# If you want to have a log
of authentication replies,<BR>
# un-comment the following line, and the 'detail reply_log'<BR>
# section, above.<BR>
# reply_log</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">
sql</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">
Post-Auth-Type REJECT {<BR>
sql<BR> }<BR>}</SPAN></FONT></DIV>
</DIV>
<DIV></DIV>
<BLOCKQUOTE style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm;
BORDER-TOP: medium none; PADDING-LEFT: 4pt; PADDING-BOTTOM: 0cm; MARGIN: 5pt
0cm 5pt 3.75pt; BORDER-LEFT: black 1.5pt solid; PADDING-TOP: 0cm;
BORDER-BOTTOM: medium none">
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">----- Original Message -----
</SPAN></FONT></DIV></DIV>
<DIV></DIV></BLOCKQUOTE>
<DIV style="font-color: black">
<P style="BACKGROUND: #e4e4e4; MARGIN-LEFT: 108pt"><B><FONT face=Arial
size=2><SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">
From:</SPAN></FONT></B><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial"> <A title=Admin@jemisp.com
href="mailto:Admin@jemisp.com">Jeremy ohara</A> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><B><FONT face=Arial size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">To: </SPAN>
</FONT></B><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial"><A title=freeradius-users@lists.freeradius.org
href="mailto:freeradius-users@lists.freeradius.org">FreeRadius users mailing
list</A> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><B><FONT face=Arial size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">Sent: </SPAN>
</FONT></B><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial">Tuesday, May 16, 2006 9:13 PM</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><B><FONT face=Arial size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">
Subject:</SPAN></FONT></B><FONT face=Arial size=2><SPAN style="FONT-SIZE:
10pt; FONT-FAMILY: Arial"> Re: getting Freeradius to recorde login failure,
etc</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">where and how do i do it and
what do i write???</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">jeremy<BR> </SPAN></FONT>
</DIV></DIV>
<DIV></DIV>
<BLOCKQUOTE style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm;
BORDER-TOP: medium none; PADDING-LEFT: 4pt; PADDING-BOTTOM: 0cm; MARGIN: 5pt
0cm 5pt 3.75pt; BORDER-LEFT: black 1.5pt solid; PADDING-TOP: 0cm;
BORDER-BOTTOM: medium none">
<P style="MARGIN-LEFT: 108pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> </SPAN></FONT>
<DIV></DIV></BLOCKQUOTE>
<P style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 108pt; MARGIN-RIGHT: 0cm"><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">-----Original
Message-----<BR>From: "Duane Cox" <<A
href="mailto:duanec@mail.illicom.net">duanec@mail.illicom.net</A>><BR>To:
"FreeRadius users mailing list" <<A
href="mailto:freeradius-users@lists.freeradius.org">
freeradius-users@lists.freeradius.org</A>><BR>Date: Tue, 16 May 2006
18:17:26 -0500<BR>Subject: Re: getting Freeradius to recorde login failure,
etc</SPAN></FONT>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">yes, there is a subsection under
the post_auth section for such a thing...</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<BLOCKQUOTE style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm;
BORDER-TOP: medium none; PADDING-LEFT: 4pt; PADDING-BOTTOM: 0cm; MARGIN: 5pt
0cm 5pt 3.75pt; BORDER-LEFT: black 1.5pt solid; PADDING-TOP: 0cm;
BORDER-BOTTOM: medium none">
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">----- Original Message -----
</SPAN></FONT></DIV></DIV>
<DIV></DIV></BLOCKQUOTE>
<DIV style="font-color: black">
<P style="BACKGROUND: #e4e4e4; MARGIN-LEFT: 108pt"><B><FONT face=Arial
size=2><SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">
From:</SPAN></FONT></B><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial"> <A title=Admin@jemisp.com
href="mailto:Admin@jemisp.com">Jeremy ohara</A> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><B><FONT face=Arial size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">To: </SPAN>
</FONT></B><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial"><A title=freeradius-users@lists.freeradius.org
href="mailto:freeradius-users@lists.freeradius.org">FreeRadius users mailing
list</A> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><B><FONT face=Arial size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">Sent: </SPAN>
</FONT></B><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt;
FONT-FAMILY: Arial">Tuesday, May 16, 2006 3:24 PM</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><B><FONT face=Arial size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">
Subject:</SPAN></FONT></B><FONT face=Arial size=2><SPAN style="FONT-SIZE:
10pt; FONT-FAMILY: Arial"> getting Freeradius to recorde login failure,
etc</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"><BR> hi there</SPAN></FONT>
</DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">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?</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">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</SPAN></FONT> </DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"> </SPAN></FONT></DIV></DIV>
<DIV></DIV>
<DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face=Arial size=1><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Arial">Jeremy</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><BR>
----------------------------------------------------------------------------<BR>
This email has been scanned for Virus by MDaemon AntiVirus part of
MDaemon.<BR>Updated daily to keep up-to-date with all new and old
viruses.<BR>
----------------------------------------------------------------------------
</SPAN></FONT>
<DIV></DIV>
<DIV>
<DIV style="MARGIN-LEFT: 36pt">
<DIV style="MARGIN-LEFT: 36pt">
<DIV class=MsoNormal style="MARGIN-LEFT: 36pt; TEXT-ALIGN: center"
align=center><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE:
12pt">
<HR align=center width="100%" SIZE=2>
</SPAN></FONT></DIV></DIV></DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">- <BR>List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><BR>
----------------------------------------------------------------------------<BR>
This email has been scanned for Virus by MDaemon AntiVirus part of
MDaemon.<BR>Updated daily to keep up-to-date with all new and old
viruses.<BR>
----------------------------------------------------------------------------
</SPAN></FONT>
<DIV></DIV>
<DIV>
<DIV style="MARGIN-LEFT: 36pt">
<DIV style="MARGIN-LEFT: 36pt">
<DIV class=MsoNormal style="MARGIN-LEFT: 36pt; TEXT-ALIGN: center"
align=center><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE:
12pt">
<HR align=center width="100%" SIZE=2>
</SPAN></FONT></DIV></DIV></DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">- <BR>List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html</SPAN></FONT></DIV></DIV>
<DIV></DIV>
<P style="MARGIN-LEFT: 108pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><BR>
----------------------------------------------------------------------------<BR>
This email has been scanned for Virus by MDaemon AntiVirus part of
MDaemon.<BR>Updated daily to keep up-to-date with all new and old
viruses.<BR>
----------------------------------------------------------------------------
</SPAN></FONT>
<DIV></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 72pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"><BR>
----------------------------------------------------------------------------<BR>
This email has been scanned for Virus by MDaemon AntiVirus part of
MDaemon.<BR>Updated daily to keep up-to-date with all new and old
viruses.<BR>
----------------------------------------------------------------------------
</SPAN></FONT>
<DIV></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 36pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"><BR>
----------------------------------------------------------------------------<BR>
This email has been scanned for Virus by MDaemon AntiVirus part of
MDaemon.<BR>Updated daily to keep up-to-date with all new and old
viruses.<BR>
----------------------------------------------------------------------------</SPAN>
</FONT>
<DIV></DIV>
<DIV></DIV></BLOCKQUOTE><BR>
----------------------------------------------------------------------------<BR>
This email has been scanned for Virus by MDaemon AntiVirus part of
MDaemon.<BR>Updated daily to keep up-to-date with all new and old
viruses.<BR>
----------------------------------------------------------------------------<BR>
<BR>
----------------------------------------------------------------------------<BR>
This email has been scanned for Virus by MDaemon AntiVirus part of
MDaemon.<BR>Updated daily to keep up-to-date with all new and old
viruses.<BR>
----------------------------------------------------------------------------<BR>
</BLOCKQUOTE>
<br>----------------------------------------------------------------------------<br>
This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon.<br>
Updated daily to keep up-to-date with all new and old viruses.<br>
----------------------------------------------------------------------------<br>
</html>