RE: Recording post auth sql data
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 -----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
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
participants (2)
-
Arran Cudbard-Bell -
Franks Andy (RLZ) IT Systems Engineer