RE: [m0n0wall] RE: access for 24 hours after first login? need help

2005-10-12 Thread maruna
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

RE: RE: access for 24 hours after first login?

2005-10-07 Thread Jonathan De Graeve
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

Re: access for 24 hours after first login?

2005-10-06 Thread Markus Krause
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

RE: access for 24 hours after first login?

2005-10-06 Thread Jonathan De Graeve
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

RE: [m0n0wall] RE: access for 24 hours after first login?

2005-10-06 Thread Jonathan De Graeve
] 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

RE: [m0n0wall] RE: access for 24 hours after first login?

2005-10-06 Thread maruna
: 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

RE: RE: access for 24 hours after first login?

2005-10-06 Thread Jonathan De Graeve
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

RE: [m0n0wall] RE: access for 24 hours after first login?

2005-10-06 Thread Markus Krause
:[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

Re: access for 24 hours after first login?

2005-10-05 Thread Alan DeKok
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)