<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN">
<html><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Volume Counter not working</p>
<p>(1) sql: Session-Timeout = 43200<br />(1) sql: Acct-Interim-Interval = 300<br />(1) sql: Mikrotik-Rate-Limit = '768k/1024k'<br />(1) sql: Mikrotik-Total-Limit-Gigawords = 5120<br />(1) sql: Fall-Through = Yes<br />rlm_sql (sql): Released connection (4)<br />(1) [sql] = ok<br />(1) expiration: Account will expire at 'Jan 22 2015 00:00:00 NPT'<br />(1) [expiration] = ok<br />(1) logintime: Checking Login-Time<br />(1) [logintime] = ok<br />WARNING: (1) volumecounter: Couldn't find check attribute, control:Mikrotik-Total-Limit-Gigawords, doing nothing...<br />(1) [volumecounter] = noop<br />WARNING: (1) pap: Auth-Type already set. Not setting to PAP<br />(1) [pap] = noop<br />(1) } # authorize = ok<br />(1) Found Auth-Type = MSCHAP<br />(1) # Executing group from file /etc/raddb/sites-enabled/default<br />(1) Auth-Type MS-CHAP {<br />-----------------------------</p>
<p>sqlcounter file</p>
<p>-----------------------------</p>
<p>sqlcounter volumecounter {<br /> sql_module_instance = sql<br /> dialect = ${modules.sql.dialect}<br /><br /> counter_name = Mikrotik-Total-Limit-Gigawords<br /> check_name = Mikrotik-Total-Limit-Gigawords<br /> key = User-name<br /> reset = never<br /><br /> $INCLUDE ${modconfdir}/sql/counter/${dialect}/${.:instance}.conf<br />}<br />---------------------------</p>
<p>volumecounter.conf</p>
<p>---------------------------</p>
<p>query = "SELECT (SUM(acctinputoctets) + SUM(acctoutputoctets))/(1024*1024)FROM r<br />adacct WHERE username='%{%k}'"</p>
<p> </p>
<p>Thanks,</p>
<p>Akash</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<div> </div>
</body></html>