Inline comments below. On Wed, 22 May 2013 17:35:35 +1000 Hugh Irvine <[email protected]> wrote: > >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.
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? > >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? Correct. >> >> 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. And what implication would this (start/stop records in one session) have on the setup of RADMIN? >> 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. > Rohan Henry Server Administrator Cable And Wireless Jamaica Phone (876) 936-4819 Mobile (876) 997-0729 _______________________________________________ radiator mailing list [email protected] http://www.open.com.au/mailman/listinfo/radiator
