Re: patch for sqlcounter, please test!

2005-12-23 Thread Damjan
query = SELECT TO_DAYS(NOW()) - MIN(TO_DAYS(AcctStartTime)) FROM radacct WHERE UserName = '%{%k}' LIMIT 1; this actually works very well, a user logs in and is allowed to access to the network until the date changes e.g. the second time if he is allowed access for two days. but as i am

Re: patch for sqlcounter, please test!

2005-12-23 Thread Markus Krause
Zitat von Damjan [EMAIL PROTECTED]: query = SELECT TO_DAYS(NOW()) - MIN(TO_DAYS(AcctStartTime)) FROM radacct WHERE UserName = '%{%k}' LIMIT 1; this actually works very well, a user logs in and is allowed to access to the network until the date changes e.g. the second time if he is

Re: [FREERADIUS] Re: patch for sqlcounter, please test!

2005-12-23 Thread Damjan
Hello. I'm also interested in this. What Expire attribute? The attribute name is actually Expiration. You set it in rad(group)check to something like Expiration == 24 Dec 2005 14:00:00, and if the user connects in 13:48, he'll get a 12 minutes of Session-Timeout. Can't find any reference of

patch for sqlcounter, please test!

2005-12-22 Thread Markus Krause
hi list! part of a radius-related project is to allow access to our guests and visitors at our institute to parts of our network, of course only with username and password, and do some logging. the idea is that guests get an account and a password which they can use for a period of one to seven