(RADIATOR) help with ipass accouting

[Ayotunde Itayemi]

Hi All, Hi Hugh,

I haven't been active on the list for some time since Radiator has simple been radiant!

I want to get radiator to log the following values into an oracle table called IPASSTABLE.
The time the ipass user disconnected ( as contained in %o) into both a VARCHAR2 and DATE field.
The time the user logged on ( calculated by subtracting the %{Acct-Session-Time} from the disconnect time) - 
       this value would also be stored in aVARCHAR2 and DATE field.

I already have the first, but the second seems a little tricky. I though of subtracting %{Acct-Session-Time} from %b,
but the problem is how to convert the resulting timestamp (in seconds) back to a DATE value (and a CHAR value too)

Currently I have the following AcctSqlStatement in my radius config file.

AcctSQLStatement insert into ipasstable values ( \
 '%{User-Name}', '%{Acct-Status-Type}', \
 '%{NAS-Identifier}', '%{Framed-IP-Address}', \
 %{Acct-Session-Time}, \
 '%o', \
 to_date('%o', 'DY MON DD HH24:MI:SS YYYY'), \
 '%o', \
 to_date('%o', 'DY MON DD HH24:MI:SS YYYY') )

The first "to_date (..." is supposed to contain the calculated login time (some variation of "%b - %{Acct-Session-Time}" ?)
while the first %o is supposed to hold the login time in char format ( to_char(whatever_i_get_from_the_calculation above) ?).
Please see the LOGIN_START_DATE_DATE and LOGIN_START_DATE_CHAR in the table def below.

HELP!!!!

Regards,
Tunde I.


================ IPASSTABLE table def ================================
 Name                                              Null?        Type
 -----------------------------------------             --------     ------------------
 USERNAME                                               VARCHAR2(50)
 ACCTSTATUSTYPE                                    VARCHAR2(10)
 NASIDENTIFIER                                         VARCHAR2(20)
 FRAMEDIPADDRESS                                 VARCHAR2(20)
 SESSIONTIME                                           NUMBER(38)
 LOGIN_START_DATE_CHAR                      VARCHAR2(25)
 LOGIN_START_DATE_DATE                       DATE
 LOGIN_STOP_DATE_CHAR                        VARCHAR2(25)
 LOGIN_STOP_DATE_DATE                        DATE

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20030304/f5ae846e/attachment.html>