RE: How to log Access-Accept reply attributes/values in radpostauth sql
Thanks for the replies. I can use %{pairs:reply:} and it provides: "Acct-Interim-Interval =3D 120=2C Session-Timeout =3D 86400" But this doesn't look nice in the DB as it gets inserted exactly like that. Is there a way to unescape the quoted printable text to that =3D is actually = for example? I tried %{unescape:%{pairs:reply:}} but I didn't change it. Thanks James
On Aug 26, 2017, at 5:55 PM, James Wood <james.wood@purplewifi.com> wrote:
Thanks for the replies. I can use %{pairs:reply:} and it provides:
"Acct-Interim-Interval =3D 120=2C Session-Timeout =3D 86400"
But this doesn't look nice in the DB as it gets inserted exactly like that. Is there a way to unescape the quoted printable text to that =3D is actually = for example?
Not right now, because it's hard for the server to know what's inside of an SQL string and shouldn't be escaped, versus what's outside of an SQL string, and should be escaped. Knowing that would require writing an SQL parser...
I tried %{unescape:%{pairs:reply:}} but I didn't change it.
Because the escaping is done by the SQL module *after* the expansion is created. We'll take a look at fixing this for v4, but it's likely hard to do right in v3. Alan DeKok.
Just put in a call to trivial perl module to put what you want into the DB alan On 27 Aug 2017 2:32 pm, "Alan DeKok" <aland@deployingradius.com> wrote:
On Aug 26, 2017, at 5:55 PM, James Wood <james.wood@purplewifi.com> wrote:
Thanks for the replies. I can use %{pairs:reply:} and it provides:
"Acct-Interim-Interval =3D 120=2C Session-Timeout =3D 86400"
But this doesn't look nice in the DB as it gets inserted exactly like
that.
Is there a way to unescape the quoted printable text to that =3D is actually = for example?
Not right now, because it's hard for the server to know what's inside of an SQL string and shouldn't be escaped, versus what's outside of an SQL string, and should be escaped.
Knowing that would require writing an SQL parser...
I tried %{unescape:%{pairs:reply:}} but I didn't change it.
Because the escaping is done by the SQL module *after* the expansion is created.
We'll take a look at fixing this for v4, but it's likely hard to do right in v3.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
participants (3)
-
Alan Buxey -
Alan DeKok -
James Wood