>I have sql declared in accounting module. I have followed<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
> examples from <a href="http://wiki.freeradius.org/Rlm_sqlcounter" target="_blank">http://wiki.freeradius.org/Rlm_sqlcounter</a>, but my counter<br>
> doesn't still increase.? What am I missing please.<br>
<br>
Do you have accounting records for that user in radacct?<br>
<br></blockquote><div><br>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?<br>
<br>mysql>  select * from radacct where username="clare" and  AcctStartTime like "%2012-02-28%";<br> <br>| 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 |<br>
+-----------+---------------+------------------+----------+-------+--------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-----------------+----------------+-----------------+----------------+---------------+<br>
|       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 | <br>
<br><br></div><div>-------<br>Pamela Pomary <br>ICT Assistant, University Of Ghana.<br>skype: ppomary<br></div><br></div><br>