Write additional accounting fields to sql

[Matthew McTague]

Hi,

I have two additional fields that I receive in Accounting-Request packets from my NAS, and I want to write these to radacct, or if that is not possible, to another table.

The fields are:

ADSL-Agent-Circuit-Id
ADSL-Agent-Remote-Id

Is it correct alter the table, then amend column_list within the accounting section of mods-config/sql/main/mysql/queries.conf?

Warm Regards,


Matthew McTague
Head of Infrastructure, Reliance Networks
d. +64 3 222 6013
t. 0800 483 882 (+64 3 683 9090)
Website |  
Service Desk
 |  
Internet Services
Reliance Networks Ltd accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image566467.png
Type: image/png
Size: 22286 bytes
Desc: image566467.png
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20190626/4515109d/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image672321.png
Type: image/png
Size: 462 bytes
Desc: image672321.png
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20190626/4515109d/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image725302.png
Type: image/png
Size: 556 bytes
Desc: image725302.png
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20190626/4515109d/attachment-0005.png>