noresetcounter

2013-06-06 Thread Bill Schoolfield
login (auth) when the time goes to zero. sqlcounter noresetcounter { counter-name = Max-All-Session-Time check-name = Max-All-Session sqlmod-inst = sql key = User-Name reset = never query = SELECT IFNULL(SUM

Re: noresetcounter

2013-06-06 Thread Bill Schoolfield
Never mind. I did not have noresetcounter in the authorize section. This in turn caused me to use the wrong check variable (Max-All-Session-Time instead of Max-All-Session) as the right one wasn't known (because the noresetcounter wasn't known to 'authorize'. Anyway. My apologies for the false

noresetcounter

2013-04-01 Thread Muhammad Nuzaihan Kamal Luddin
Hi, My objective to configure freeradius is that the user automatically gets logged out during the accounting process by noresetcounter statement. But currently, the user that is logged in keeps being connected even when the time is up. Here's my counter.conf: --- sqlcounter noresetcounter

Re: noresetcounter

2013-04-01 Thread Russell Mike
-Timeout 3600 Idle-Timeout 60 Thanks RM -- On Mon, Apr 1, 2013 at 1:35 PM, Muhammad Nuzaihan Kamal Luddin muham...@taqisystems.com wrote: Hi, My objective to configure freeradius is that the user automatically gets logged out during the accounting process by noresetcounter statement

noresetcounter + NULL radacct records (First Connection)

2009-09-08 Thread Neville
UserName='%{User-Name}'' [noresetcounter]expand: SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{User-Name}' - SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='6cmy75HS' sqlcounter_expand: '%{sql:SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='6cmy75HS

Re: noresetcounter + NULL radacct records (First Connection)

2009-09-08 Thread Ivan Kalik
On occasions sqlcounter does not seem to work correctly, especially for NEW User that have no radacct details. After doing some digging, I've identified the issue only to happen on the first ever connect of the user in a new account. As you will see from the sql below, if no integer is

MySQL noresetcounter / No reply-name or count attribute?

2008-05-22 Thread Tuc at T-B-O-H.NET
Hi, I've noticed on the default FR 2.0.4 MySQL counter.conf file, for the sqlcounter noresetcounter , there isn't a count-attribute of Acct-Session-Time or a reply-name of something like Session-Timeout. The dailycounter and monthlycounter both have a reply-name . Is this for a reason

Re: rlm_sqlcounter noresetcounter

2005-08-09 Thread N White
Anyone have advice/input? N White wrote: I'm having trouble setting up the noresetcounter(Max-All-Session). I'm running freeradius 1.0.4(Debian). I have compiled and added the rlm_sqlcounter.so files to the proper folder in Debian, and freeradius -X shows the module starting up(I have

rlm_sqlcounter noresetcounter

2005-08-07 Thread N White
I'm having trouble setting up the noresetcounter(Max-All-Session). I'm running freeradius 1.0.4(Debian). I have compiled and added the rlm_sqlcounter.so files to the proper folder in Debian, and freeradius -X shows the module starting up(I have renamed it hotspotcounter). If you would like

noresetcounter problem

2005-03-01 Thread Lists
** Here my configuration on sqlcounter.conf ** sqlcounter noresetcounter { counter-name = Max-All-Session-Time check-name = Max-All-Session sqlmod-inst = sql key = User-Name reset = never query