Reg: Volume or time base limit.

[Fajar A. Nugraha]

On Tue, Jun 19, 2012 at 5:17 PM, Malla reddy Sama
<mallareddy.sama at yahoo.com> wrote:
> Dear Fajar,
>
> Thank you very much for the help.
>
> I did as rlm_counter process for limiting for use data.
>
> I give 1800 sec to user 'test2', then I run the user test2 with another
> machine. After 1800 sec I got packet to Freeradius server but the connection
> not disconnected.
>
> Please help me in this regards,
>
> I attached a copy debug output...

Please keep cc to the list. More people reading means more people are
likely to help you.

As for your problem, well, read the debug log you sent. For example,
the relevant section is


rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
++[noresetcounter] returns noop
rlm_sqlcounter: Entering module authorize code
sqlcounter_expand:  'SELECT SUM(AcctSessionTime - GREATEST((1340056800
- UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE
UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) +
AcctSessionTime > '1340056800''
[dailycounter]  expand: SELECT SUM(AcctSessionTime -
GREATEST((1340056800 - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM
radacct WHERE UserName='%{User-Name}' AND
UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1340056800' ->
SELECT SUM(AcctSessionTime - GREATEST((1340056800 -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE
UserName='test2' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime >
'1340056800'
sqlcounter_expand:  '%{sqlcca3:SELECT SUM(AcctSessionTime -
GREATEST((1340056800 - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM
radacct WHERE UserName='test2' AND UNIX_TIMESTAMP(AcctStartTime) +
AcctSessionTime > '1340056800'}'
[dailycounter] WARNING: Unknown module "sqlcca3" in string expansion "%"
rlm_sqlcounter: No integer found in string ""
++[dailycounter] returns noop
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
++[monthlycounter] returns noop




The "Could not find Check item value pair" and "Unknown module
"sqlcca3"' in particular looks suspicious, so double-check you follow
the wiki correctly, and that you're using the correct instance of sql
module.

-- 
Fajar