On Jul 4, 6:35pm, Jason Godsey wrote:
> Subject: Re: (RADIATOR) Run perl code to generate more accounting fields
>
> Shouldn't you look for account delay time? I've never seen it be other
> than 0 but I'm sure it's there for something :)
Timestamp already includes Acct-Delay-Time.
Cheers.
>
> - Jason
>
> On Mon, 5 Jul 1999, Mike McCauley wrote:
>
> > Hi John,
> >
> > On Jul 2, 1:56pm, John Coy wrote:
> > > Subject: (RADIATOR) Run perl code to generate more accounting fields
> > > I'd like to calculate two fields (login_time and logout_time)
> > > from the "Timestamp" and the "Acct-Session-Time" accounting
> > > STOP records for insert into an SQL database. I'd like
> > > to define:
> > >
> > > LOGIN_TIME = (Timestamp - Acct-Session-Time)
> > > LOGOUT_TIME = Timestamp
> > >
> > > Is there an easy way to have Radiator calculate the LOGIN_TIME
> > > field prior to insertion into the Radius database? If there
> > > was a way to add a fake accounting field by running arbitrary
> > > perl code, that would be helpful. I thought I read in the
> > > docs you can add arbitrary authentication replies to an
> > > auth record, but nothing that I read talked about the
> > > authentication record.
> > >
> > > Ideas would be appreciated.
> >
> > Best way to do this is to construct an AcctSQLStatement that does the
> > arithmentic you want:
> >
> > AcctSQLStatement insert into accounting
> > LOGIN_TIME=%{Timestamp}-%{Acct-Session-Time},
LOGOUT_TIME=%{Acct-Session-Time}
> > .....
> >
> > Hope that helps.
> >
> > 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.
> >
>
>
>-- End of excerpt from Jason Godsey
--
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.
