Startdate for sessions in FreeRadius with MySql?
Hello! We're using FreeRadius 1.1.7 along with MySql on an Ubuntu server. We have a web application to create users for FreeRadius and administrators can set the expire date for when a session should expire. This is achieved with the "Expiration" attribute in the table called RadCheck in the MySql database. However, a customer would like to be able to also set a "start"-date for when the session should become valid i.e. if I set 2008-10-06 it won't be possible to log in before that date. I haven't found a way to do this in FreeRadius. Does anyone have a solution for this? I thought that it might exist an attribute for "Start" as well when there is one for "Expire" but I haven't found any. The only solution I can come up with is some kind of own customized que handling for this altough I would prefer a simple attribute. Any thoughts? Johan -- View this message in context: http://www.nabble.com/Startdate-for-sessions-in-FreeRadius-with-MySql--tp198... Sent from the FreeRadius - User mailing list archive at Nabble.com.
Yeah. That's kind of my "rescue" solution. To create a que that is processed on a daily basis. But I thought that since there is an expire attribute that it might be a start as well. It would obviously take less effort to just add that kind of attribute instead of adding a que and some kind of quehandler to our application. //Johan tnt-4 wrote:
Any thoughts?
Don't create the username before the startdate. There is absolutely no reason for it to be in the database before it. Make a script that creates the user entry when startdate is reached.
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- View this message in context: http://www.nabble.com/Startdate-for-sessions-in-FreeRadius-with-MySql--tp198... Sent from the FreeRadius - User mailing list archive at Nabble.com.
Or create all you need and add Auth Type Reject in radcheck table for that user and delete this entry on start date with cron script On Thu, Oct 9, 2008 at 8:06 AM, Bladan2000 <johan.bladh@gmail.com> wrote:
Yeah. That's kind of my "rescue" solution. To create a que that is processed on a daily basis. But I thought that since there is an expire attribute that it might be a start as well. It would obviously take less effort to just add that kind of attribute instead of adding a que and some kind of quehandler to our application.
//Johan
tnt-4 wrote:
Any thoughts?
Don't create the username before the startdate. There is absolutely no reason for it to be in the database before it. Make a script that creates the user entry when startdate is reached.
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- View this message in context: http://www.nabble.com/Startdate-for-sessions-in-FreeRadius-with-MySql--tp198... Sent from the FreeRadius - User mailing list archive at Nabble.com.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
You can always add your own. http://freeradius.org/radiusd/man/dictionary.html Ivan Kalik Kalik Informatika ISP Dana 9/10/2008, "Bladan2000" <johan.bladh@gmail.com> piše:
Yeah. That's kind of my "rescue" solution. To create a que that is processed on a daily basis. But I thought that since there is an expire attribute that it might be a start as well. It would obviously take less effort to just add that kind of attribute instead of adding a que and some kind of quehandler to our application.
//Johan
tnt-4 wrote:
Any thoughts?
Don't create the username before the startdate. There is absolutely no reason for it to be in the database before it. Make a script that creates the user entry when startdate is reached.
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- View this message in context: http://www.nabble.com/Startdate-for-sessions-in-FreeRadius-with-MySql--tp198... Sent from the FreeRadius - User mailing list archive at Nabble.com.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
Bladan2000 -
Marinko Tarlac -
tnt＠kalik.net