Robert,
I know that this question is from awhile back and may be a non-issue
now, however it may still be of help to someone. If you're using mysql (or
most decent DBMS) you can use case statements in your insert query. This is
what I'm doing. I
The query looks something like...
AcctSQLStatement EXEC sp_RadiusAcctInsert '0', '%{Acct-Session-Id}',
CASE '%{Acct-Status-Type}' WHEN 'Start' THEN 1 WHEN 'Stop' THEN 2 ELSE NULL
END,
'%{User-Name}','%{Called-Station-Id}','%{Calling-Station-Id}','%c
','%{NAS-Port}','%{NAS-Port-Type}','%{Service-Type}','%{Framed-Protocol}','%
{Framed-IP-Address}',
'%{Connect-Info}','%{Acct-Terminate-Cause}','%{Acct-Input-Octets}','%{Acct-O
utput-Octets}','%{Acct-Session-Time}'
Ross Kusler
Senior Database Administrator
InReach Internet LLC
[EMAIL PROTECTED]
> ----- Original Message -----
> From: "Robert Blayzor" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Friday, January 04, 2002 4:57 AM
> Subject: RE: (RADIATOR) SQL Accounting / Radius Attribute Values only
>
>
> > Correct... If you are using the standard accounting "INSERT ...". But
> > how would you do it if you need to use:
> >
> > AcctSQLStatement EXEC sp_RadiusAcctInsert
> > '0','%{Acct-Session-Id}','%{Acct-Status-
> > Type}','%{User-Name}','%{Called-Station-Id}','%{Calling-Station-Id}','%c
> > ','%{NAS-Port}','%{NAS-Po
> > rt-Type}','%{Service-Type}','%{Framed-Protocol}','%{Framed-IP-Address}',
> > '%{Connect-Info}','%{Acct
> > -Terminate-Cause}','%{Acct-Input-Octets}','%{Acct-Output-Octets}','%{Acc
> > t-Session-Time}'
> >
> >
> > A more advanced SQL statement?
> >
> > --
> > Robert Blayzor, BOFH
> > INOC, LLC
> > [EMAIL PROTECTED]
> >
> >
> > > -----Original Message-----
> > > From: Hugh Irvine [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, January 03, 2002 11:38 PM
> > > To: [EMAIL PROTECTED]; Robert Blayzor
> > > Cc: [EMAIL PROTECTED]
> > > Subject: Re: (RADIATOR) SQL Accounting / Radius Attribute Values only
> > >
> > >
> > >
> > > Hello Robert -
> > >
> > > You can do this with AcctColumnDef's:
> > >
> > > AcctColumnDef NASPORT,NAS-Port,integer
> > >
> > > Have a look at section 6.28.13 in the Radiator 2.19 reference manual.
> > >
> >
> > ===
> > 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.
