Hi Dave and Hugh,
I guess it would also be possible to remove the VALUE definitions for that
attribute from the dictionary: then the numeric value will be reported.
Cheers.
On Feb 12, 2:31pm, Hugh Irvine wrote:
> Subject: Re: (RADIATOR) detail file: turning OFF dictionary lookups
>
> Hello Dave -
>
> This got lost in my inbox because of the wrong date.....(or it was stuck
> somewhere for a *long* time...).
>
> On Thu, 06 Jan 2000, Dave Kitabjian wrote:
> > Currently, a typical detail entry from Radiator looks like:
> >
> > Thu Dec 16 16:30:33 1999
> > User-Name = "dave"
> > Service-Type = Framed-User
> > NAS-IP-Address = 253.63.154.1
> > NAS-Port = 1234
> > NAS-Port-Type = Async
> > Acct-Session-Id = "00001234"
> > Acct-Status-Type = Stop
> > Acct-Delay-Time = 0
> > Acct-Session-Time = 1000
> > Acct-Input-Octets = 20000
> > Acct-Output-Octets = 30000
> > Timestamp = 945379833
> >
> > However, our current Sql Server database is set up relationally, so that in
> > the column for ServiceType, we have numerical entries rather than text
> > entries like "Framed-User". The same applies to NAS-Port-Type,
> > Acct-Status-Type, Acct-Authentic, User-Service, Login-Service,
> > Framed-Protocol, and others. The "dictionary" in our database consists of
> > Emerald-style tables, RadAttributes and RadValues, to do the appropriate
> > lookups.
> >
> > Now, we are using a custom accounting interface which will read the detail
> > text files in standard Radiator format, parse them, and INSERT them into
> > this table. I've tried several database tricks to try to coerce the detail
> > data into our table, such as INSERT with JOIN, Views, etc, to no avail.
> >
> > So.......
> >
> > I'm assuming Radiator natively receives this data in the numeric form
> > rather than the text form. So, what would fix the problem, I think, would
> > be if I could tell Radiator to stop looking up values in the dictionary,
> > and instead just log the raw numeric values in the detail file.
> >
>
> It would be better to post-process the data as it is in text form, and use
the
> Radiator dictionary definitions to do the transformations back to numeric
form.
>
> hth
>
> Hugh
>
> --
> 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.
>-- End of excerpt from Hugh Irvine
--
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.
