run multiple sql queries

Kristofer Hallin kristofer at sunet.se
Mon Mar 15 12:27:06 CET 2021


On 15 Mar 2021, 12:09 +0100, Imdad Hasan <imdadalikadiwala0 at gmail.com>, wrote:
> can i use unlang for run another queries in accounting section?

Why don’t you just try? That must be quicker than waiting for answers from the mailing list.
>
> like this
>
>
>
>
>
>
>
>
> *switch "%{Acct-Status-Type}" { case 'Stop' { update
> control { Tmp-String-0 := "%{sql:UPDATE `usage` SET
> acctinputoctets = acctinputoctets + '%{Acct-Input-Octets}',
> acctoutputoctets = acctoutputoctets + '%{Acct-Output-Octets}', lastupdated
> = now() WHERE username = '%{User-Name}'}" } } }*
>
> On Sat, Mar 13, 2021 at 2:41 AM Imdad Hasan <imdadalikadiwala0 at gmail.com>
> wrote:
>
> > Hii all,
> >
> > Can i run multiple sql queries at a time in freeradius sql module.?
> > specifically for accounting. for manage accounting data in different
> > different tables.
> >
> > Thanks
> >
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


More information about the Freeradius-Users mailing list