Doron Shmaryahu wrote:
> After much trying I have finally got freeradius on Freebsd with mysql
> all working. The dialup admin interface is working. The only thing is
> that it does not log failed login's. Can anyone give me a idea ??
With the CVS version you can add a post-auth query in your config.
In your case, add in your sql.conf:
sql {
[lots of things...]
postauth_table = "radpostauth"
postauth_query = "INSERT into ${postauth_table} (id, user, pass, reply, date)
values ('', '%{User-Name}', '%{User-Password}', '%{reply:Packet-Type}', NOW())"
}
And in radiusd.conf:
post-auth {
Post-Auth-Type REJECT {
sql
}
}
The table structure for table 'radpostauth' is in
src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql
--
Nicolas Baradakis
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
