Access-Reject message to SQL

[Steven Walters]

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