On 21 Aug 2012, at 14:46, "Franks Andy \(RLZ\) IT Systems Engineer" <Andy.Franks@sath.nhs.uk> wrote:
Ok, schoolboy error there! Thanks guys. Whilst on the subject, is it possible (in theory) to write different INSERT statements dependent on, for example, whether the post-auth section is based on having accepted or rejected the user. The sql modules named in the default virtual server file link through to a single post-auth section in dialup.conf with the insert statement, but is there any way of telling the module to link to a different insert statement? Or does all that not make any sense!? Thanks Andy
Well you can use SQL XLAT instead of the post-auth method, or see master:HEAD, and use Post-Auth-Type in the reference. For SQL xlat: update request { Tmp-Integer-0 := "%{sql:INSERT INTO blah blah blah}" } -Arran
-----Original Message----- From: freeradius-users-bounces+andy.franks=sath.nhs.uk@lists.freeradius.org [mailto:freeradius-users-bounces+andy.franks=sath.nhs.uk@lists.freeradiu s.org] On Behalf Of Matthew Newton Sent: 21 August 2012 14:21 To: FreeRadius users mailing list Subject: Re: Recording post auth sql data
On Tue, Aug 21, 2012 at 01:33:00PM +0100, Franks Andy (RLZ) IT Systems Engineer wrote:
got into yet. I'd quite like to record the attribute ClientShortname as referred to by the clients.conf file, but expansion of '%{request:Client-Short-Name}' didn't seem to work - blank string.
Looking at dictionary.freeradius.internal (and xlat.c) - try %{Client-Shortname}.
Matthew
-- Matthew Newton, Ph.D. <mcn4@le.ac.uk>
Systems Architect (UNIX and Networks), Network Services, I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom
For IT help contact helpdesk extn. 2253, <ithelp@le.ac.uk> - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html