rlm_sqlcounter doesn't increase counter

[pamela pomary]

   >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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20120228/2b6b57a8/attachment.html>