On 05/22/2013 12:30 AM, rohan.he...@cwjamaica.com wrote: > Sample records below include one row per session (I haven't yet been able to > do a proper conversion of epoch time to date for the START_TIME).
You are thinking of consolidating the start and stop records into one session record, did I understand correctly? If so, I recommend using an external process, a cron job, database function, etc., to do this. This process or function could select all Stops, look up the respective start with Accounting-Session-Id and then create the combined record. I think you could do this with a Radiator hook that does the consolidation when an Accounting-Request with Acct-Status-Type=stop is received. The downside here would be the need to create and debug the hook and especially the extra processing Radiator needs to do. My choice would be to consider something that runs outside Radiator and does the session consolidation. I would also consider doing this fairly infrequently, maybe daily, if possible. Thanks, Heikki > +-----------+-----------+---------------------+--------------------+-------------------+ > | USER_NAME | NAS_PORT | ACCT_START_TIME | ACCT_STOP_TIME | > ACCT_SESSION_TIME | > +-----------+-----------+---------------------+--------------------+-------------------+ > | elclarke | 805306450 | 0000-00-00 00:00:00 | Mar 1, 2013 01:11 | > 729805 | > | elclarke | 805306450 | 0000-00-00 00:00:00 | Mar 6, 2013 09:03 | > 460108 | > | elclarke | 805306450 | 1362578608 | Mar 12, 2013 03:33 | > 498607 | > | elclarke | 805306450 | 1363077402 | Mar 16, 2013 12:01 | > 375888 | > | elclarke | 805306450 | 1363467090 | Mar 21, 2013 14:53 | > 428504 | > > > > On Tue, 21 May 2013 23:40:26 +0300 > Heikki Vatiainen <h...@open.com.au> wrote: >> On 05/21/2013 11:02 PM, rohan.he...@cwjamaica.com wrote: >> >>> Can Radmin work in an environment where Radiator writes a single record >>> (containing both Start and Stop fields) to MySQL for each session as oppose >>> to two records per session? >> >> Hello Rohan, >> >> can you provide an example? This might be possible by defining suitable >> SQL queries, but it's hard to say more. >> >> Thanks, >> Heikki >> >> -- >> Heikki Vatiainen <h...@open.com.au> >> >> 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 >> radiator@open.com.au >> http://www.open.com.au/mailman/listinfo/radiator > > Rohan > _______________________________________________ > radiator mailing list > radiator@open.com.au > http://www.open.com.au/mailman/listinfo/radiator > -- Heikki Vatiainen <h...@open.com.au> 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 radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator