[RADIATOR] Radmin and Database

[Heikki Vatiainen]

On 05/22/2013 12:30 AM, rohan.henry at 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 <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
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator
> 


-- 
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.