You could proabably use the Class attribute for this in your AUTH reply. The NAS should send the Class attribute back in any accounting requests.
Frank Danielson [Infrastructure Architect] wireless: 407.467.7832 wireline: 407.515.8633 Data On Air 301 E. Pine St. Suite 450 Orlando, Fl 32801 http://www.dataonair.com -----Original Message----- From: Justin Scott [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:52 PM To: [EMAIL PROTECTED] Subject: (RADIATOR) SQL Accounting able to pick up a var from SQL subscribers table? 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
