Re: [RADIATOR] Radmin and Database
Thanks Hugh. On Tue, 28 May 2013 09:02:53 +1000 Hugh Irvine h...@open.com.au wrote: Hello Rohan - All of the Radmin code uses the current table names, so you can't really change them. Depending on your database you may be able to use some form of synonym for the table names to add whatever you want. See your database documentation for details. regards Hugh On 28 May 2013, at 06:24, rohan.he...@cwjamaica.com wrote: Hello All, Can Radmin be installed with my own database schema (e.i. my own table_names)? Or must I conform to the database schema in Radiator sample files for Radmin to work properly? Thanks. Rohan ___ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator -- Hugh Irvine h...@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@open.com.au http://www.open.com.au/mailman/listinfo/radiator
Re: [RADIATOR] Radmin and Database
Hello Rohan - All of the Radmin code uses the current table names, so you can't really change them. Depending on your database you may be able to use some form of synonym for the table names to add whatever you want. See your database documentation for details. regards Hugh On 28 May 2013, at 06:24, rohan.he...@cwjamaica.com wrote: Hello All, Can Radmin be installed with my own database schema (e.i. my own table_names)? Or must I conform to the database schema in Radiator sample files for Radmin to work properly? Thanks. Rohan ___ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator -- Hugh Irvine h...@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@open.com.au http://www.open.com.au/mailman/listinfo/radiator
Re: [RADIATOR] Radmin and Database
On 05/22/2013 06:58 PM, rohan.he...@cwjamaica.com wrote: 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? What if you create a PreProcessingHook that does the substraction and adds start time in the request. The start time would still be in seconds (epoch time) but you could use AcctColumnDef with integer-date Type to convert it to a date. See the reference manual for the above for more. Thanks, Heikki -- Heikki Vatiainen h...@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@open.com.au http://www.open.com.au/mailman/listinfo/radiator
Re: [RADIATOR] Radmin and Database
On 05/22/2013 12:30 AM, rohan.he...@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 | -00-00 00:00:00 | Mar 1, 2013 01:11 | 729805 | | elclarke | 805306450 | -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 h...@open.com.au wrote: On 05/21/2013 11:02 PM, rohan.he...@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 h...@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@open.com.au http://www.open.com.au/mailman/listinfo/radiator Rohan ___ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator -- Heikki Vatiainen h...@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@open.com.au http://www.open.com.au/mailman/listinfo/radiator
Re: [RADIATOR] Radmin and Database
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 h...@open.com.au wrote: On 05/22/2013 12:30 AM, rohan.he...@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 | -00-00 00:00:00 | Mar 1, 2013 01:11 | 729805 | | elclarke | 805306450 | -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 h...@open.com.au wrote: On 05/21/2013 11:02 PM, rohan.he...@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 h...@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@open.com.au http://www.open.com.au/mailman/listinfo/radiator Rohan ___ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator -- Heikki Vatiainen h...@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@open.com.au http://www.open.com.au/mailman/listinfo/radiator -- Hugh Irvine h...@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@open.com.au http://www.open.com.au/mailman/listinfo/radiator
Re: [RADIATOR] Radmin and Database
Inline comments below. On Wed, 22 May 2013 17:35:35 +1000 Hugh Irvine h...@open.com.au 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 h...@open.com.au wrote: On 05/22/2013 12:30 AM, rohan.he...@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? 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 | -00-00 00:00:00 | Mar 1, 2013 01:11 | 729805 | | elclarke | 805306450 | -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 h...@open.com.au wrote: On 05/21/2013 11:02 PM, rohan.he...@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 h...@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@open.com.au http://www.open.com.au/mailman/listinfo/radiator Rohan ___ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator -- Heikki Vatiainen h...@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@open.com.au http://www.open.com.au/mailman/listinfo/radiator -- Hugh Irvine h...@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. Rohan Henry Server Administrator Cable And Wireless Jamaica Phone (876) 936-4819 Mobile (876) 997-0729 ___ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator
Re: [RADIATOR] Radmin and Database
On 05/21/2013 11:02 PM, rohan.he...@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 h...@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@open.com.au http://www.open.com.au/mailman/listinfo/radiator