>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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
