[RADIATOR] AcctInsertQuery for Authby RADIUS

[Jeffrey Lee]

I tried adding <AuthBy SQL> after <AuthBy RADIUS> but as soon as
<AuthBy RADIUS> is executed, <AuthBy SQL> will not be executed.

Can you actually place <AuthBy SQL> within a <AuthBy RADIUS>?

What I'm trying to achieve is to log the RADIUS accounting records
locally (start, stop & alive) for realms that need to be authenticated
by another RADIUS server. How can I achieve that?


On Wed, Feb 16, 2011 at 11:26 AM, Michael <ringo at vianet.ca> wrote:
> AcctInsertQuery is for the <AuthBy SQL> section.  it sounds like your trying
> to use it inside or around an <AuthBy RADIUS>.  It doesn't work that way.
> You need to setup an <AuthBy SQL> section where the AcctInsertQuery will be
> inside your <AuthBy RADIUS> or i prefer configuring it outside and calling
> it inside via AuthBy (Identifier).
>
> Without a config sample though, ...can only speculate.
>
> Michael
>
>
> On 11-02-15 07:35 PM, Jeffrey Lee wrote:
>>
>> How do I log all accounting records locally (to a SQL DB) before
>> proxy-forwarding to the respective RADIUS server?
>> I know that I can log the accounting records locally but what I want
>> is to insert the accounting record into a SQL database.
>>
>> I've tried adding AcctInsertQuery between<Authby RADIUS>  tags, but
>> I'm getting this error when I started radiusd.
>> "Wed Feb 16 10:24:07 2011: ERR: Unknown keyword 'AcctInsertQuery' in
>> C:\Program Files\Radiator\radius.cfg line 268"
>>
>> Really need help with this! Thanks
>> _______________________________________________
>> radiator mailing list
>> radiator at open.com.au
>> http://www.open.com.au/mailman/listinfo/radiator
>>
>>
>