On Tue, Jun 19, 2012 at 5:17 PM, Malla reddy Sama <mallareddy.sama@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