Re[2]: daily limit

Monday, May 9, 2005, 9:34:05 PM, you wrote:

SE> Hm... maybe you should set the SQL statements in your sqlcounter.conf file
SE> that can be usually found in /etc/raddb or
SE> /usr/local/etc/raddb depending on
SE> distribution...

SE> You can define the different counters for your vouchers that will count time
SE> or traffic by defining them in the file I mentioned...

SE> I dont know, but maybe you should take a look at
SE> /usr/share/doc/packages/freeradius/rlm_sqlcounter if you already didnt do
SE> that...

hello, i still cant solve the problem about 1 day limit. now im thinking to put in
sqlcounter.conf :

sqlcounter hourcounter {
counter-name = Max-Hour-Session-Time
check-name = Max-Hour-Session
sqlmod-inst = sql
key = User-Name
reset = never
query = "SELECT SUM(AcctSessionTime - GREATEST((%b -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}' AND
UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
}

and i set 86400 in radgroupcheck, and input :

INSERT INTO radgroupcheck (id,GroupName,Attribute,Value,op)
-> VALUES
('','plan_name','Password-Expire','86400',':=');

is it will work regard to my case ? the point is, customer cant login
after next day, the login voucher will valid for twenty four hours
from the first time login. please advice. thanks


--
Best regards,
avudz


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html