Insert accounting data in different tables based on realm
Hello, I am trying to insert accounting data from different realms into different tables in MySQL. I would rather not have this run on the database server as a stored procedure, or spin up another pair of radius servers for every realm if possible. For instance I would like to: insert accounting data for user@example.org into radiusdb.radacct insert accounting data for user@example.com into radiusdb.radaccttemp Could someone point me in the right direction if this is even possible in FreeRADIUS before I call support? It seems to me like this has probably been done somewhere and I would not have to re-invent the wheel. I have been searching quite a bit the last few days and can't find an example. Regards, //F Francisco Amaral Senior Wi-Fi Networks Engineer Phone: (866) 848-5848 x 318 Fax: (866) 762-2250 Mobile: (401) 862-0526 Website: http://www.towerstream.com towerstream
On Mar 4, 2015, at 8:07 AM, Francisco Amaral <famaral@towerstream.com> wrote:
For instance I would like to:
insert accounting data for user@example.org into radiusdb.radacct
insert accounting data for user@example.com into radiusdb.radaccttemp
That’s possible. Look at the dialup.conf files. They will have something like: UPDATE ${acct_table1} \ Just change that to: UPDATE %{Towerstream-Acct-Table} \ everywhere. Then, add that attribute to raddb/dictionary as type “string”. Then update the attribute with whatever value you need, prior to calling the SQL module. Alan DeKok.
Fantastic I will have my guys give that a shot. Much appreciated, //F ________________________________________ From: Freeradius-Users <freeradius-users-bounces+famaral=towerstream.com@lists.freeradius.org> on behalf of Alan DeKok <aland@deployingradius.com> Sent: Wednesday, March 4, 2015 9:58 AM To: FreeRadius users mailing list Subject: Re: Insert accounting data in different tables based on realm On Mar 4, 2015, at 8:07 AM, Francisco Amaral <famaral@towerstream.com> wrote:
For instance I would like to:
insert accounting data for user@example.org into radiusdb.radacct
insert accounting data for user@example.com into radiusdb.radaccttemp
That’s possible. Look at the dialup.conf files. They will have something like: UPDATE ${acct_table1} \ Just change that to: UPDATE %{Towerstream-Acct-Table} \ everywhere. Then, add that attribute to raddb/dictionary as type “string”. Then update the attribute with whatever value you need, prior to calling the SQL module. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (2)
-
Alan DeKok -
Francisco Amaral