Volume Counter Problem with Gigawords
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
participants (1)
-
Akash