Automatically Generating "Expiration" - Freeradius 2.1.9 / mysql 5.1 / dialup admin
What I'm trying to do is enable a non-technical person to create temporary, "guest like" accounts using the dialup admin interface. The accounts will be created as needed, they need to expire within a predetermined time frame(s) and I'm trying to avoid asking the person creating the accounts to be entering "Expiration". So how would I approach having the "Expiration" field auto populated based on the account creation date/time and a predetermined account lifetime? For instance, creation date/time + 12-hours, or date + 1-day. Thanks in advance for any guidance. -- View this message in context: http://freeradius.1045715.n5.nabble.com/Automatically-Generating-Expiration-... Sent from the FreeRadius - User mailing list archive at Nabble.com.
I don't know of a way to do that in dialup_admin, but you could potentially look at using a trigger on insert in MySQL. That might be problematic however if you have some users that you don't want to automatically assign this Expiration to. Otherwise if the services assigned are simple it might be easier to create a pared down account creation script either as an extension of dialup_admin or as a standalone app. Ben
-----Original Message----- From: freeradius-users- bounces+wiechman.lists=gmail.com@lists.freeradius.org [mailto:freeradius-users- bounces+wiechman.lists=gmail.com@lists.freeradius.org] On Behalf Of mikal Sent: Wednesday, November 24, 2010 12:51 AM To: freeradius-users@lists.freeradius.org Subject: Automatically Generating "Expiration" - Freeradius 2.1.9 / mysql 5.1 / dialup admin
What I'm trying to do is enable a non-technical person to create temporary, "guest like" accounts using the dialup admin interface. The accounts will be created as needed, they need to expire within a predetermined time frame(s) and I'm trying to avoid asking the person creating the accounts to be entering "Expiration".
So how would I approach having the "Expiration" field auto populated based on the account creation date/time and a predetermined account lifetime? For instance, creation date/time + 12-hours, or date + 1-day.
Thanks in advance for any guidance. -- View this message in context: http://freeradius.1045715.n5.nabble.com/Automatically-Generating- Expiration-Freeradius-2-1-9-mysql-5-1-dialup-admin- tp3277961p3277961.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Wed, Nov 24, 2010 at 7:50 AM, mikal <mpm@atceast.com> wrote:
What I'm trying to do is enable a non-technical person to create temporary, "guest like" accounts using the dialup admin interface. The accounts will be created as needed, they need to expire within a predetermined time frame(s) and I'm trying to avoid asking the person creating the accounts to be entering "Expiration".
So how would I approach having the "Expiration" field auto populated based on the account creation date/time and a predetermined account lifetime? For instance, creation date/time + 12-hours, or date + 1-day.
Thanks in advance for any guidance.
Why don't you simply write some kind of small webif in php to do this? It's easy to predefine values and just add them to the database when a non-technical person presses a button or something like it. (you could even add multiple timeframes in a dropdownbox or so) With a little coding you could even integrate such a page in the existing dialup admin if this is desired. I would not use expiration also, but some no-resetting sql counter. You will also need to find a way to auto-delete expired accounts. Just my 2cents.
participants (3)
-
Ben Wiechman -
mikal -
YvesDM