I have a user that has Session-Timeout set to 2 hours (7200sec). I want
that user to have time for using its connection one day after first login.
So, if after one day after he logged in first time, he didn't use his full
amount of time, his account will be expired. Is there an attribute that can
an hour, day, week, etc with an else for a
non-match.
On Aug 8, 2012, at 6:50 AM, Andrei Petru Mura mapand...@gmail.com wrote:
I have a user that has Session-Timeout set to 2 hours (7200sec). I want that
user to have time for using its connection one day after first login. So, if
after one day
can u help me how can CAN I DO THIS in freeradius
its like i want a certain user to be expired after x minutes since his first
login
thanks-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
All,
forgive me if this is a nubie question... It seems many have already
done something similar. I want prepaid radius accounts for 1 day,
that begins the first time they are used. For example, someone buys
2- 1 day accounts, and uses them next Monday and Friday.
Is there a simple way to do
06, 2005 7:50 PM
To: 'FreeRadius users mailing list'
Subject: RE: [m0n0wall] RE: access for 24 hours after first login?
It doesn't work on postgresql v7.4.6 that I tried it on.. however, I used
SELECT now() - AcctStartTime FROM radacct WHERE UserName = '%{%k}'
LIMIT 1;
And its ok
Thank you
how is the actual comparision of the calculated value in query done,
does it
mean, that the value returned by query has to be smaller than the one
referred to by check-name (in your example Max-Secs-Passed)?
It works quite simple
If ( (Max-Secs-Passed - All-Secs-Passed 0) = allow access
what
want to enhance the functionality about the following feature:
setting up several predefined (guest) accounts with a generated username
and
password. this account should be valid from the first time it is used
(first
login) for 24 hours (or even better until 23:59 that day).
rlm_counter
Krause
Verzonden: donderdag 6 oktober 2005 12:57
Aan: freeradius-users@lists.freeradius.org
Onderwerp: Re: access for 24 hours after first login?
Zitat von Alan DeKok [EMAIL PROTECTED]:
Markus Krause [EMAIL PROTECTED] wrote:
i set up freeradius succesfully for authentification against pam
]
Verzonden: donderdag 6 oktober 2005 15:51
Aan: FreeRadius users mailing list
CC: [EMAIL PROTECTED]
Onderwerp: [m0n0wall] RE: access for 24 hours after first login?
This is how I do this
Use SQLcounter module
Put this in sqlcounter.conf (expecting that sqlcounter is already
configged
: Thursday, October 06, 2005 3:09 PM
To: Jonathan De Graeve; FreeRadius users mailing list
Cc: [EMAIL PROTECTED]
Subject: RE: [m0n0wall] RE: access for 24 hours after first login?
And here the query in case you don't like seconds ;)
SELECT HOUR(SEC_TO_TIME(UNIX_TIMESTAMP() -
UNIX_TIMESTAMP
It doesn't work on postgresql v7.4.6 that I tried it on.. howver, I
used
SELECT now() - AcctStartTime FROM radacct WHERE UserName = '%{%k}'
LIMIT 1;
Be carefull with this!
SELECT now() - AcctStartTime Secs
FROM radacct
WHERE UserName = '%{k}' LIMIT 1;
Gives for example with username
:[EMAIL PROTECTED]
Verzonden: donderdag 6 oktober 2005 15:51
Aan: FreeRadius users mailing list
CC: [EMAIL PROTECTED]
Onderwerp: [m0n0wall] RE: access for 24 hours after first login?
This is how I do this
Use SQLcounter module
Put this in sqlcounter.conf (expecting that sqlcounter is already
time it is used (first
login) for 24 hours (or even better until 23:59 that day). this is intended
for our daily visitors and guests or for conference members, the idea is to
give them a username/password pair to be used just that day without much
administration effort. (just generate a list
) accounts with a generated username and
password. this account should be valid from the first time it is used (first
login) for 24 hours (or even better until 23:59 that day).
rlm_counter. Set it for 24 hours of access, and reset=never.
Alan DeKok.
-
List info/subscribe/unsubscribe? See
Isn't there any way to change mysql sentence so it checks if there is no
'Expired' attribute, thus adding expired date?
I tried this query (in raddb/sql.conf):
postauth_query = INSERT into ${authcheck_table} (id, UserName, Attribute, op,
Value) values (0, '%{User-Name}', 'Expired',
Hello,
We have set up a radius server to manage user access from a hotel. Users are
connected via PLC or WiFi. By now, we are using freeradius 1.0.1 running on a
Debian 3.0 r3, and rlm_mysql module.
I'd like to know if there is some way to clean a user from the database one
day after his first
On Tue, 22 Feb 2005, Antonio J. Soler wrote:
Hello,
We have set up a radius server to manage user access from a hotel. Users are
connected via PLC or WiFi. By now, we are using freeradius 1.0.1 running on a
Debian 3.0 r3, and rlm_mysql module.
I'd like to know if there is some way to clean a user
17 matches
Mail list logo
