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.