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 :)

- 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.
> 


===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to