RE: getting Freeradius to recorde login failure, etc

2006-05-20 Thread Jamal Taweel
ius users mailing list" 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 PROTECTE

Re: getting Freeradius to recorde login failure, etc

2006-05-20 Thread Nicolas Baradakis
Christopher Carver wrote: > If someone can point me to the right direction, I would be very > appreciative. Perhaps I could even explore it to its fullest and > submit some documentation to the developers to include with the > software to make things a bit more clear. What exactly is unclear in

Re: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Alan DeKok
"Jeremy ohara" <[EMAIL PROTECTED]> wrote: > it seems to be ok now. just having trouble getting Acct-Terminate-Cause to > work > > its no showing any result when login or pass , etc is wrong Again, the FAQ & documentation clearly describe this. They *don't* mention Acct-Terminate-Cause specif

Re: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Alan DeKok
"Duane Cox" <[EMAIL PROTECTED]> wrote: > Alan, Is there any way to have a conditional statement in the post-auth > section, something like: if NASIPAddress == '1.1.1.1' then don't process > postauth? Not really, no. That would be very useful, but probably hard to do in the current architecture

Re: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Jeremy ohara
:12:33 -0500Subject: Re: getting Freeradius to recorde login failure, etc Jeremy,You need to make sure mysql (and mysql development headers/libraries) installed on the server and then configure --with-mysql.  When you compile you should see the rlm_sql files in the lib dir of freeradius.  Wat

Re: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Duane Cox
'1.1.1.1' then don't process postauth? - Original Message - From: "Christopher Carver" <[EMAIL PROTECTED]> To: "FreeRadius users mailing list" Sent: Wednesday, May 17, 2006 11:51 AM Subject: Re: getting Freeradius to recorde login failure,

Re: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Alan DeKok
Christopher Carver <[EMAIL PROTECTED]> wrote: > So, I too am interested in > hearing the specifics on how this can be done. If someone can point me > to the right direction, I would be very appreciative. Perhaps I could > even explore it to its fullest and submit some documentation to the > d

Re: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Christopher Carver
ROTECTED]> To: FreeRadius users mailing list Date: Wed, 17 May 2006 16:44:55 +0200 Subject: Re: getting Freeradius to recorde login failure, etc Jeremy ohara wrote: > is there a way to get Freeradius 1.0.5 with Mysql to record login-failure, > incorrect pass

Re: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Christopher Carver
emy -Original Message- From: "Alan DeKok" <[EMAIL PROTECTED]> To: FreeRadius users mailing list Date: Wed, 17 May 2006 10:33:43 -0400 Subject: Re: getting Freeradius to recorde login failure, etc "Jeremy ohara" <[EMAIL PROTECTED]>

Re: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Alan DeKok
"Jeremy ohara" <[EMAIL PROTECTED]> wrote: > there is no sign of any of this in the documentation if you can show me > where it "shows" what and how to do it and code, by all means show me! The documentation does not describe how to configure the server for your particular location, for your loc

Re: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Jeremy ohara
the whole thing is arleady in the sql.conf.   all it logs is the accepted passwords not failed passwords   Jeremy  -Original Message-From: Nicolas Baradakis <[EMAIL PROTECTED]>To: FreeRadius users mailing list Date: Wed, 17 May 2006 16:44:55 +0200Subject: Re: getting Freerad

Re: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Jeremy ohara
the version of freeradius doesnt not have the rim_sql files   Freeradius 1.0.5 -Original Message-From: Nicolas Baradakis <[EMAIL PROTECTED]>To: FreeRadius users mailing list Date: Wed, 17 May 2006 16:44:55 +0200Subject: Re: getting Freeradius to recorde login failure, etc

Re: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Jeremy ohara
Wed, 17 May 2006 10:33:43 -0400Subject: Re: getting Freeradius to recorde login failure, etc "Jeremy ohara" <[EMAIL PROTECTED]> wrote:> i dont want to sound rude, etc but your not really answering my question. > you only  answered half of it  At some point you *do* have to r

RE: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Jeremy ohara
i have tried the sql functin you have me and it didnt work. failed to create   jeremy  -Original Message-From: "Jeremy ohara" <[EMAIL PROTECTED]>To: "FreeRadius users mailing list" Date: Thu, 18 May 2006 00:20:31 +1000Subject: RE: getting Freeradius to r

Re: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Nicolas Baradakis
Jeremy ohara wrote: > 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? Please read the FAQ, and look for: "How do I log failed login attempts in a SQL database?" http://wiki.freeradius.org/index.php/Free

Re: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Alan DeKok
"Jeremy ohara" <[EMAIL PROTECTED]> wrote: > i dont want to sound rude, etc but your not really answering my question. > you only answered half of it At some point you *do* have to read the documentation. While people may be kind enough to answer your questions on the list, most of those answe

RE: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Jeremy ohara
ate: Thu, 18 May 2006 00:20:31 +1000Subject: 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" <[EMAIL PROTECTED]>

RE: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Jeremy ohara
Jamal Taweel" <[EMAIL PROTECTED]>To: "FreeRadius users mailing list" Date: Wed, 17 May 2006 13:36:59 +0200Subject: 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,   ---

RE: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Jamal Taweel
AIL PROTECTED]> To: "FreeRadius users mailing list" 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 Mess

RE: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Jeremy ohara
uld write are   how do i do this?   Jeremy    -Original Message-From: "Jamal Taweel" <[EMAIL PROTECTED]>To: "FreeRadius users mailing list" Date: Wed, 17 May 2006 12:40:43 +0200Subject: RE: getting Freeradius to recorde login failure, etc Hi Jeremy,

RE: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Jeremy ohara
if i wante extra frields do i add them in the function or the sql.conf?   Jeremy  -Original Message-From: "Jamal Taweel" <[EMAIL PROTECTED]>To: "FreeRadius users mailing list" Date: Wed, 17 May 2006 13:36:59 +0200Subject: RE: getting Freeradius to record

RE: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Jamal Taweel
: 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     -Ori

RE: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Jeremy ohara
g list" Date: Wed, 17 May 2006 12:40:43 +0200Subject: 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, pass

RE: getting Freeradius to recorde login failure, etc

2006-05-17 Thread Jamal Taweel
emy 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 f

Re: getting Freeradius to recorde login failure, etc

2006-05-16 Thread Jeremy ohara
Date: Tue, 16 May 2006 22:28:12 -0500Subject: 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, abo

Re: getting Freeradius to recorde login failure, etc

2006-05-16 Thread Jeremy ohara
Date: Tue, 16 May 2006 22:28:12 -0500Subject: 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, abo

Re: getting Freeradius to recorde login failure, etc

2006-05-16 Thread Duane Cox
  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 Messag

Re: getting Freeradius to recorde login failure, etc

2006-05-16 Thread Jeremy ohara
where and how do i do it and what do i write???   jeremy  -Original Message-From: "Duane Cox" <[EMAIL PROTECTED]>To: "FreeRadius users mailing list" Date: Tue, 16 May 2006 18:17:26 -0500Subject: Re: getting Freeradius to recorde login failure, etc yes, t

Re: getting Freeradius to recorde login failure, etc

2006-05-16 Thread Duane Cox
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