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

[Frank Danielson]

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:jhs at ocs-tx.com]
Sent: Wednesday, January 16, 2002 1:52 PM
To: radiator at open.com.au
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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.
===
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.