On 05/22/2013 06:58 PM, [email protected] wrote: >> You can do this more simply by only processing stop records and subtracting >> the Acct-Session-Time from the Timestamp to get the start time. >> >> This can be done directly in the SQL statement. > > Yes. I can get this accomplished using the SQL statement. I was also hoping > to make Radiator do the conversion and add the "start time" (not epoch time) > to the database. Is this at possible?
What if you create a PreProcessingHook that does the substraction and adds start time in the request. The start time would still be in seconds (epoch time) but you could use AcctColumnDef with integer-date Type to convert it to a date. See the reference manual for the above for more. Thanks, Heikki -- Heikki Vatiainen <[email protected]> Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP, DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS, NetWare etc. _______________________________________________ radiator mailing list [email protected] http://www.open.com.au/mailman/listinfo/radiator
