Hi I have enabled SQL under post-auth to send access reject records to a db. Below is the query in queries.conf. Currently it only indicates the packet type but I would like to add the same message written to the radius.log file e.g "Login incorrect (pap: MD5 digest does not match "known good" digest)" to the database. query = "\ INSERT INTO ${..postauth_table} \ (username, reply, authdate) \ VALUES(\ '%{User-Name}', \ '%{reply:Packet-Type}', \ NOW())" Regards Steven
On Dec 13, 2022, at 2:12 AM, Steven Walters <steven.walters1@gmail.com> wrote:
I have enabled SQL under post-auth to send access reject records to a db. Below is the query in queries.conf.
Currently it only indicates the packet type but I would like to add the same message written to the radius.log file e.g "Login incorrect (pap: MD5 digest does not match "known good" digest)" to the database.
Unfortunately, no. The "Login incorrect" message is produced after all of the modules have finished running. Alan DeKok.
participants (2)
-
Alan DeKok -
Steven Walters