postauth sql logging

[Jeff Crowe]

Hi all,

I have just recently migrated from 1.1.7 to 2.0.5.  In 1.1.7 I had the
postauth sql logging turned on to log successful and failed auth attempts.
I not able to find where I would add it in 2.0.5 to enable this feature.  I
see the sql statement in the dialup.conf config file but I am unsure on how
to invoke the sql query.

Any pointers would be great.

Thanks,
Jeff.



-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

PostAUth SQL logging

[Cory Robson]

I have freeradius logging failed login attempts to the postauth table, what
in the sql syntax do I need to change to log the reason for the
access-reject (ie password invalid, account expired, or session limit
reached)?

Cory

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: postauth sql logging

[Alan DeKok]

Jeff Crowe wrote:
> I have just recently migrated from 1.1.7 to 2.0.5.  In 1.1.7 I had the
> postauth sql logging turned on to log successful and failed auth attempts.
> I not able to find where I would add it in 2.0.5 to enable this feature.

  Read radiusd.conf, especially the last few lines.  It explains where
the configuration has moved to.  See raddb/sites-available/default.

>  I
> see the sql statement in the dialup.conf config file but I am unsure on how
> to invoke the sql query.

  This is documented...

  Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html