run the query in
mysql, I get a value of 86400 (I know the above doesn't sum anything).
How can I get and use the value?
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Fixed-Duration-Weekly-Monthly-and-Daily-Accounts-tp4950022p4986842.html
Sent from the FreeRadius - User
On Sat, Nov 12, 2011 at 7:49 PM, JennyBlunt jennyshoeh...@me.com wrote:
Thanks for the help, that's very useful. I can get the time in there now but
have a question about getting our access-period out.
In post-auth, I've tried this query to get the access-period out:
if (!
a bit confused as the query works in sql
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Fixed-Duration-Weekly-Monthly-and-Daily-Accounts-tp4950022p4986938.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http
Got it sorted by moving the query out in to a separate update request section
and calling without control.XXX
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Fixed-Duration-Weekly-Monthly-and-Daily-Accounts-tp4950022p4986992.html
Sent from the FreeRadius - User mailing
('%{User-Name}', 'expiration', ':=',
'UNIX_TIMESTAMP+ %{control.Tmp-String-0}'}; SELECT NOW()
Thanks for your help
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Fixed-Duration-Weekly-Monthly-and-Daily-Accounts-tp4950022p4985367.html
Sent from the FreeRadius - User mailing
On Sat, Nov 12, 2011 at 2:43 AM, JennyBlunt jennyshoeh...@me.com wrote:
I'm looking at your query and am a bit lost as to what I should use for the
attributes.
Say I wanted 24 hour voucher - expires exactly 24 hours after first login. I
need to give the user some attribute in the db of 86400
For example, Mikrotik understands this syntax
id | UserName | Attribute | Value | Op
183 | someuser| Expiration | October 04 2011 00:00:00 | ==
To convert 2011-10-04 into October 04 2011 00:00:00 you should use the
next SQL syntax
SELECT DATE_FORMAT( `date` , '%M %d %Y %H:%i:%s' ) AS date
a monthly rule to allow 43200 minutes, the user will get a lot of time
online!
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Fixed-Duration-Weekly-Monthly-and-Daily-Accounts-tp4950022p4950022.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List
On Sun, Oct 30, 2011 at 7:39 PM, JennyBlunt jennyshoeh...@me.com wrote:
How do I create a group which provides access for a preset amount of time,
for instance one day, week or month. I've tried by using expiration but
don't think thats right. Will the noreset parameter do this?
In our
Expiration is actually the validity of the account. It does not calculates
the amount of time used. If you are looking to limit the session time i.e
100 hrs Monthly or anything , you need rlm_sqlcounter with attributes like
Max-Session-Time with a value.
In conjunction with Expiration, you can
.1045715.n5.nabble.com/Fixed-Duration-Weekly-Monthly-and-Daily-Accounts-tp4950022p4950078.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
.
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Fixed-Duration-Weekly-Monthly-and-Daily-Accounts-tp4950022p4950078.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list
JennyBlunt wrote:
That's the one we're using. What I don't understand is that if we set up a
group with max-all-session = 43200 the user would get in total 43200
minutes. When, in reality, we're trying to give them a continuous 43200
minutes from first login.
Then set the expiration date
Hi Alan,
I think the poster is asking for a continuous amount of time after login.
Setting Expiration will give a max valid period in which the user can login
but under no circumstances it can provide a continuous period of usage.
Poster is also not clear what will happen if the user disconnects
time and start time?
J
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Fixed-Duration-Weekly-Monthly-and-Daily-Accounts-tp4950022p4950211.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http
JennyBlunt wrote:
that's what I was trying to get to - am happy to set an expiration upon first
login - just wanted to see if I could achieve the desired with the built in
functions etc.
Yes... your question was also ambiguous.
Do you want a TOTAL of X hours after first login, summed only
On Sun, Oct 30, 2011 at 9:59 PM, JennyBlunt jennyshoeh...@me.com wrote:
that's what I was trying to get to - am happy to set an expiration upon first
login - just wanted to see if I could achieve the desired with the built in
functions etc.
You really need to make sure you know EXACTLY what
/Fixed-Duration-Weekly-Monthly-and-Daily-Accounts-tp4950022p4950392.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
login. A continuous clock ticking
from the start time.
I'm going to look at Fajar's suggestion now...
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Fixed-Duration-Weekly-Monthly-and-Daily-Accounts-tp4950022p4950392.html
Sent from the FreeRadius - User mailing
19 matches
Mail list logo