>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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html