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: 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