One of the queries should be enabled by default
authorpnixon <pnixon>
Wed, 12 Sep 2007 13:58:48 +0000 (13:58 +0000)
committerpnixon <pnixon>
Wed, 12 Sep 2007 13:58:48 +0000 (13:58 +0000)
raddb/sql/postgresql/counter.conf

index 43c2e1c..9a814ca 100644 (file)
@@ -56,10 +56,10 @@ sqlcounter dailycounter {
        # previous reset period into the current period but
        # involves more work for the SQL server than those
        # below
-#      query = "SELECT SUM(AcctSessionTime - \
-#                GREATER((%b - AcctStartTime::ABSTIME::INT4), 0)) \
-#                FROM radacct WHERE UserName='%{%k}' AND \
-#                AcctStartTime::ABSTIME::INT4 + AcctSessionTime > '%b'"
+       query = "SELECT SUM(AcctSessionTime - \
+                GREATER((%b - AcctStartTime::ABSTIME::INT4), 0)) \
+                FROM radacct WHERE UserName='%{%k}' AND \
+                AcctStartTime::ABSTIME::INT4 + AcctSessionTime > '%b'"
 
        # This query ignores calls that started in a previous
        # reset period and continue into into this one. But it