How to log failed auth attempts?

tnt at kalik.net tnt at kalik.net
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
>needs.

Yes.

>What variable can I use to pull the reject reason, is it something like
>%{reply:Reply-Message}

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

doc/variables.txt

Ivan Kalik
Kalik Informatika ISP




More information about the Freeradius-Users mailing list