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