(RADIATOR) SQL Accounting able to pick up a var from SQL subscribers table?

[Justin Scott]

Hi guys,

I have another thing I'm trying to wrap my brain around here, that I can't seem to figure out.

My client's reason for choosing Radiator is so that they can seamlessly integrate it into their custom billing/accounting package (which is going great!)

However, the billing system needs to have a CID (customer ID) associated with everything for ease of report generation.

In my SUBSCRIBERS table, I have that CID listed with each individual user.  In the ACCOUNTING table, we also have one there.

However, since the Accounting table is generated by radius accounting, I can't figure out a way to get that user's CID to propagate to each of their records in the accounting table.

I first wondered if maybe I could send this information back to the NAS upon replying to the AUTH request, and maybe the NAS could store and forward back to the radius auth on radiator when accounting packets are handled.  I don't think this will work, will it?

The other that I thought of was maybe to do an AcctSQLStatement before the defs for the insert query, but how could I get the returned column for a simple statement like:

select CID from SUBSCRIBERS where USERNAME = '%n'

Or similar into a variable that could then be passed back thru the AcctColumnDefs into the accounting table?

Thanks for your help! :) 

Radiator is truly the most flexible package I have worked with in years.  The possibilities seem to be endless!  Keep up the great work!

cheers,
j
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.