Accounting on 2 tables

Ahmed Munir ahmedmunir007 at
Tue Feb 28 16:43:01 CET 2017


BTW, is there a way to distinguish instances in Radius server for
accounting i.e. for asterisk use instance1 and opensips use instance2?

Currently using NAS table for radius client setup.

id nasname shortname type ports secret server community description
1 Company other 5060 hatuiks \N \N RADIUS Client
2 TestSIP04 other 5060 hatuiks04 \N \N RADIUS Client

Please advise and share any supported document related to above case as I'm
newbie in Freeradius.

Date: Fri, 24 Feb 2017 09:54:53 -0500
> From: Alan DeKok <aland at>
> To: FreeRadius users mailing list
>         <freeradius-users at>
> Subject: Re: Accounting on 2 tables
> Message-ID: <3653CA7E-31CF-4044-98AD-68E8DC0205CF at>
> Content-Type: text/plain; charset=us-ascii
> On Feb 24, 2017, at 9:44 AM, Ahmed Munir <ahmedmunir007 at> wrote:
> >
> > I would like to know is it possible to setup more than 1 tables for
> > accounting? As by default radacct table is used.
>   Yes.
>   You will need to set up two instances of the SQL module, and then edit
> the queries as necessary.
> > The reason I'm asking as need to setup accounting on different tables for
> > Asterisk and OpenSIPs.
> >
> > Please advise and share the supported document.
>   I would suggest taking the time to look at the wiki.  This is documented
> (see rlm_sql in the wiki).  All it takes is for you to look.
>   Alan DeKok.


Ahmed Munir Chohan

More information about the Freeradius-Users mailing list