Volume Counter Problem with Gigawords

[Akash]

Volume Counter not working 

(1) sql: Session-Timeout = 43200
(1) sql: Acct-Interim-Interval = 300
(1) sql: Mikrotik-Rate-Limit = '768k/1024k'
(1) sql: Mikrotik-Total-Limit-Gigawords = 5120
(1) sql: Fall-Through = Yes
rlm_sql (sql): Released connection (4)
(1) [sql] = ok
(1) expiration: Account will expire at 'Jan 22 2015 00:00:00 NPT'
(1) [expiration] = ok
(1) logintime: Checking Login-Time
(1) [logintime] = ok
WARNING: (1) volumecounter: Couldn't find check attribute,
control:Mikrotik-Total-Limit-Gigawords, doing nothing...
(1) [volumecounter] = noop
WARNING: (1) pap: Auth-Type already set. Not setting to PAP
(1) [pap] = noop
(1) } # authorize = ok
(1) Found Auth-Type = MSCHAP
(1) # Executing group from file /etc/raddb/sites-enabled/default
(1) Auth-Type MS-CHAP {
----------------------------- 

sqlcounter file 

----------------------------- 

sqlcounter volumecounter {
 sql_module_instance = sql
 dialect = ${modules.sql.dialect}

 counter_name = Mikrotik-Total-Limit-Gigawords
 check_name = Mikrotik-Total-Limit-Gigawords
 key = User-name
 reset = never

 $INCLUDE ${modconfdir}/sql/counter/${dialect}/${.:instance}.conf
}
--------------------------- 

volumecounter.conf 

--------------------------- 

query = "SELECT (SUM(acctinputoctets) +
SUM(acctoutputoctets))/(1024*1024)FROM r
adacct WHERE username='%{%k}'" 

Thanks, 

Akash 

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20141222/d9d72442/attachment.html>