Re: using SQL, where is Session-Timeout updated?

2009-09-18 Thread Ivan Kalik
You need sqlcounter (counter.conf) for that. Found. but no UPDATE query in it. Oddly enough, counter doesn't update anything - it COUNTS. It counts how much time has been used in current period (on previous logins) and deducts that from the limit. You can choose the reset period (daily counter

Re: using SQL, where is Session-Timeout updated?

2009-09-18 Thread Rakotomandimby Mihamina
09/18/2009 12:51 PM, Ivan Kalik:: You need sqlcounter (counter.conf) for that. Found. but no UPDATE query in it. Oddly enough, counter doesn't update anything - it COUNTS. OK, Attached is my 'default' file, and the 'freeradius -X' output. the counter (in counter.conf) is: sqlcounter

Re: using SQL, where is Session-Timeout updated?

2009-09-18 Thread Ivan Kalik
sqlcounter dailycounter { counter-name = Daily-Session-Time check-name = Max-Daily-Session reply-name = Session-Timeout sqlmod-inst = sql key = User-Name reset = daily query = SELECT SUM(AcctSessionTime - \ GREATER((%b -

Re: using SQL, where is Session-Timeout updated?

2009-09-18 Thread Rakotomandimby Mihamina
09/18/2009 05:41 PM, Ivan Kalik:: sqlcounter dailycounter { counter-name = Daily-Session-Time check-name = Max-Daily-Session reply-name = Session-Timeout sqlmod-inst = sql key = User-Name reset = daily query = SELECT SUM(AcctSessionTime - \

Re: using SQL, where is Session-Timeout updated?

2009-09-18 Thread Ivan Kalik
09/18/2009 05:41 PM, Ivan Kalik:: sqlcounter dailycounter { counter-name = Daily-Session-Time check-name = Max-Daily-Session reply-name = Session-Timeout sqlmod-inst = sql key = User-Name reset = daily query = SELECT SUM(AcctSessionTime - \