We currently have radiator storing the accounting records into the Mysql Accounting table.
Is it possible by using the radius.cfg file to insert the same accounting data into another table as well as the accounting table during authentication.
I added another 'AccountingTable tablename' together with the same AcctColumnDefs in the <AuthBy SQL>. Essentially i had two blocks for storing data into Mysql but into separate tables, however this does not seem to work as its producing errors and not logging any data.
I have also attempted to use the AcctSQLStatement syntax but this also produces errors as the number of columns do not match the number of attributes that radius picks up which seems to vary from time to time.
Is there a proper way to acheive this?
Thanks. Col.