Recording post auth sql data

[Arran Cudbard-Bell]

On 21 Aug 2012, at 14:46, "Franks Andy \(RLZ\) IT Systems Engineer" <Andy.Franks at 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 at lists.freeradius.org
> [mailto:freeradius-users-bounces+andy.franks=sath.nhs.uk at 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 at 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 at 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