Heikki, 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).
+-----------+-----------+---------------------+--------------------+-------------------+ | 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
