On Sep 3, 6:32pm, Hugh Irvine wrote:
> Subject: Re: (RADIATOR) Accounting
>
> Hello Chris -
>
> On Fri, 03 Sep 1999, Chris Knight wrote:
> > Howdy,
> > A client of ours is running Radiator, and I need to get the Accounting
data
> > into a SQL server for billing purposes. Because of management and
> > responsibility requirements, I have to get the data from the accounting log
> > file, play with it in Perl, and put it into the SQL Server. I'm not able to
> > use the SQL logging features of Radiator.
>
> I would be tempted to set up a Radiator proxy running SQL accounting, and
> configure the client Radiator to proxy only the accounting packets to it.
That
> way you retain your management and responsibility requirements, and you can
use
> all of the Radiator features to log to an SQL database. You might inform your
> client that this is how all roaming systems work, for example.
>
> > I've got a couple of questions relating to the implementation I need to
do.
> > First, is the Acct-Session-Id truly unique for each session? Secondly, if
> > multiple Radiator servers are running - both servicing the same set of
> > NASes - will the Acct-Session-Id still be unique, or do I need to catenate
> > the Acct-Session-Id with the Radiator server IP address, for instance?
> > Thirdly, out of curiosity, how is the last set of six digits for the
> > Acct-Session-Id generated? I managed to figure out the first two sets all
by
> > myself :-)
>
> The Acct-Session-Id is generated by the NAS. However I would have thought
that
> you would want to make sure that your User-Name's are unique and use those
for
> your accounting.
Acct-Session-Id cannot be regarded as unique. Most NASs will usually start
Acct-Session-Id again from 0 when it reboots. It is more usual to use a unique
key composed of something like Acct-Session-Id, username and time.
Cheers.
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
