It's not really the same thing, since you're using whatever is on nas_table instead of the original integer value. Also, "%{sql:" doesn't really work with redundant sql modules instances.
Understood, I will avoid doing that.
Git log shows this
...
It'd probably do what you want. If you want to use that, I recommend using v2.1.x branch from git instead of 2.1.11.
Thanks for the tip- that does look like what I need. Unfortunately I'm not in a position to change the version of FreeRADIUS that's being used here so I will have to find another solution. Thanks, Jack On 17 August 2011 10:59, Fajar A. Nugraha <list@fajar.net> wrote:
On Wed, Aug 17, 2011 at 4:13 PM, Jack Patmos <jack.patmos@googlemail.com> wrote:
Guess I should have persevered for another 10 minutes.
I have found a solution to my problem, which is to change my accounting_*_query from:
[...] '%{NAS-Port-Type}', [...]
to: [...] '%{sql:SELECT shortname FROM ${nas_table} WHERE nasname = %{NAS-Port-Type}}', \ [...]
It's not really the same thing, since you're using whatever is on nas_table instead of the original integer value. Also, "%{sql:" doesn't really work with redundant sql modules instances.
However, I'm still curious if it's possible to configure the behaviour of FreeRADIUS in this regard?
Git log shows this
commit b74612c710d3d7e9fdfa4ebf8763877d25a0d3a9 Author: Alan T. DeKok <aland@freeradius.org> Date: Tue Dec 21 10:01:16 2010 +0100
Added %{integer:...}
Which takes an argument like %{integer:Event-Timestamp}, and prints it as an integer, bypassing all of the named enumeration and date/time expansion
It'd probably do what you want. If you want to use that, I recommend using v2.1.x branch from git instead of 2.1.11.
-- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html