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
Zitat von Alan DeKok [EMAIL PROTECTED]:
Markus Krause [EMAIL PROTECTED] wrote:
i set up freeradius succesfully for authentification against pam and users
file
:-)
Please don't use authentification. It's authentication.
sorry for my poor english, it's not my mother-tongue ...
now i
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
Markus Krause [EMAIL PROTECTED] wrote:
i set up freeradius succesfully for authentification against pam and users
file
:-)
Please don't use authentification. It's authentication.
now i want to enhance the functionality about the following feature:
setting up several predefined (guest)
9 matches
Mail list logo