How to log failed auth attempts?

tnt at tnt at
Thu Dec 18 02:07:45 CET 2008

>I do see this query in sql/mysql/dialup.conf that controls the insert:
>        postauth_query = "INSERT INTO ${postauth_table} \
>                          (username, pass, reply, authdate) \
>                          VALUES ( \
>                          '%{User-Name}', \
>                          '%{%{User-Password}:-%{Chap-Password}}', \
>                          '%{reply:Packet-Type}', '%S')"
>I am guessing I need to modify this query and the DB schema to suite my


>What variable can I use to pull the reject reason, is it something like

That is a good choice.

>Am I missing anything else to accomplish this?

You just need to compose text that will go into the Reply-Message.

>Is there a list of available variables to use


Ivan Kalik
Kalik Informatika ISP

More information about the Freeradius-Users mailing list