>I have sql declared in accounting module. I have followed
> examples from http://wiki.freeradius.org/Rlm_sqlcounter, but my counter
> doesn't still increase.? What am I missing please.

Do you have accounting records for that user in radacct?


mmm. no Fajar, I have checked from mysql and do not have any record for service type= Framed-User. I only record for service type=NAS-Prompt-User. What could be the reason why accounting records are not captured in radacct for a Framed-User?

mysql>  select * from radacct where username="clare" and  AcctStartTime like "%2012-02-28%";
 
| RadAcctId | AcctSessionId | AcctUniqueId     | UserName | Realm | NASIPAddress | NASPortId | NASPortType | AcctStartTime       | AcctStopTime        | AcctSessionTime | AcctAuthentic | ConnectInfo_start | ConnectInfo_stop | AcctInputOctets | AcctOutputOctets | CalledStationId | CallingStationId | AcctTerminateCause | ServiceType     | FramedProtocol | FramedIPAddress | AcctStartDelay | AcctStopDelay |
+-----------+---------------+------------------+----------+-------+--------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-----------------+----------------+-----------------+----------------+---------------+
|       395 | 000000F0      | 5f2c6316d5e5945b | clare    |       | 10.1.5.4     | 6         | Virtual     | 2012-02-28 14:21:12 | 0000-00-00 00:00:00 |               0 | RADIUS        |                   |                  |               0 |                0 |                 | 10.1.5.12        |                    | NAS-Prompt-User |                |                 |              0 |             0 |


-------
Pamela Pomary
ICT Assistant, University Of Ghana.
skype: ppomary