Re: more detailed sql logging

2005-03-07 Thread Nicolas Baradakis
Kris Efland wrote: > Can I enter raw sql syntax similar to those found in the sql.conf > file? (blah = "INSERT INTO ...") Granted this isnt the greatest > place to put this, but as long as the sql.conf include is before my > module def all of the sql server information should already be > in-line

Re: more detailed sql logging

2005-03-06 Thread Kris Efland
Score!  Exactly the information I needed.  Thank you.  For clarification, since I havent written a module before... For example:   If i had the following block in radiusd.conf   post-auth{    Post-Auth-Type REJECT {    log_rejected_users    } }   In the modules block in radiusd.conf...  Can I e

Re: more detailed sql logging

2005-03-06 Thread Nicolas Baradakis
Kris Efland wrote: > Packet-Type = Access-Request > Sat Mar 5 15:04:02 2005 > User-Name = "user" > User-Password = "password" > NAS-IP-Address = 1.2.3.4 > Client-IP-Address = 1.3.4.5 > Module-Failure-Message = "rlm_ldap: User not found" > > _I would like t

Re: more detailed sql logging

2005-03-06 Thread Alan DeKok
Kris Efland <[EMAIL PROTECTED]> wrote: > Clearly... As I said in my first email. There are no insert > statements that coincide to what I am looking for and thus my original > question about crafting my own sql statements. It's not just a matter of crafting your own SQL statements. The module

Re: more detailed sql logging

2005-03-05 Thread Kris Efland
Alan DeKok <[EMAIL PROTECTED]> wrote:> No... the "radcheck" table contains information that tells the> server how to check authentication for the user. Ok. > sql.conf clearly shows that the only authenticating logging query is> the post-auth one. It also clearly shows that the authcheck_table> com

Re: more detailed sql logging

2005-03-05 Thread Alan DeKok
Kris Efland <[EMAIL PROTECTED]> wrote: > I am simply trying to log who is trying to auth against the rad > server, valid or not. Right now only postauth is being logged to > sql and I'm trying to rectify that. That's fine. > I would assume that someone trying to check authentic credentials >

Re: more detailed sql logging

2005-03-04 Thread Kris Efland
Guy,   Thanks for the response.  But, according to the sql.conf...   "authcheck_table = 'radcheck' "   I am simply trying to log who is trying to auth against the rad server, valid or not.  Right now only postauth is being logged to sql and I'm trying to rectify that.  I would assume that someone t

Re: more detailed sql logging

2005-03-04 Thread Guy Fraser
On Thu, 2005-03-03 at 13:54 -0800, Kris Efland wrote: > Excuse me if this has already been discussed but I couldnt find > anything after searching... > > I have FR successfully up and running. I have it "logging" through > sql, and authenticating through ldap. How do I go about getting more > d

more detailed sql logging

2005-03-03 Thread Kris Efland
Excuse me if this has already been discussed but I couldnt find anything after searching...   I have FR successfully up and running.  I have it "logging" through sql, and authenticating through ldap.  How do I go about getting more detailed logs out of FR through sql?  Currently it is only logging