[RADIATOR] Radmin and Database

Hugh Irvine hugh at open.com.au
Wed May 22 02:35:35 CDT 2013


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 <hvn at open.com.au> wrote:

> 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.
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator


--

Hugh Irvine
hugh 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.



More information about the radiator mailing list