Hello Rohan - 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. regards Hugh On 22 May 2013, at 17:11, Heikki Vatiainen <[email protected]> wrote: > On 05/22/2013 12:30 AM, [email protected] 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 <[email protected]> wrote: >>> On 05/21/2013 11:02 PM, [email protected] 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 <[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 >> >> Rohan >> _______________________________________________ >> radiator mailing list >> [email protected] >> http://www.open.com.au/mailman/listinfo/radiator >> > > > -- > 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 -- Hugh Irvine [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
