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