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

[Alan DeKok]

On Aug 24, 2017, at 5:19 PM, James Wood <james.wood at 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.