> 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 <l...@fajar.net> wrote: > On Wed, Aug 17, 2011 at 4:13 PM, Jack Patmos <jack.pat...@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 <al...@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 > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html