Re: How to log Access-Accept reply attributes/values in radpostauth sql

25 Aug 2017

      On Aug 24, 2017, at 5:19 PM, James Wood <james.wood@purplewifi.com> wrote:
...
FR 3.0.13. Everything working perfectly, including SQL (mysql) for auth/acct
logging.
It would be good to upgrade to 3.0.15, but that's fine..
...
When a user authenticates, I would like to log any Access-Accept reply
attributes we've set to sql (radpostauth).
There really aren't provisions for that, unfortunately.
...
Is that possible? I tried using something like the below in the queries
file:
post-auth {
       query = "\
               INSERT INTO ${..postauth_table} \
                       (username, pass, reply, authdate, callingstationid,
calledstationid, attributes) \
               VALUES ( \
                       '%{SQL-User-Name}', \
                       '%{%{User-Password}:-%{Chap-Password}}', \
                       '%{reply:Packet-Type}', \
                       '%S', \
                       '%{Calling-Station-Id}', \
                       '%{Called-Station-Id}', \
                       '%{reply:[*]}')"
But doesn't appar I can use %{reply[*]} in that way.
Nope.  I'm surprised that didn't give you parse errors.

  Alan DeKok.