[RADIATOR] Radmin and Database

[rohan.henry at cwjamaica.com]

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 <hvn at open.com.au> wrote:
>On 05/21/2013 11:02 PM, rohan.henry at 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 <hvn at 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 at open.com.au
>http://www.open.com.au/mailman/listinfo/radiator

Rohan