"WHERE acctstoptime = NULL" does NOT do what you think it does!

diff --git a/raddb/sql/mysql/dialup.conf b/raddb/sql/mysql/dialup.conf
index 5e370e7..6020196 100644 (file)
--- a/raddb/sql/mysql/dialup.conf
+++ b/raddb/sql/mysql/dialup.conf
@@ -144,7 +144,7 @@
                                    unix_timestamp(acctstarttime), \
              acctterminatecause =  '%{Acct-Terminate-Cause}', \
              acctstopdelay      =  %{%{Acct-Delay-Time}:-0} \
-          WHERE acctstoptime      =  NULL \
+          WHERE acctstoptime IS NULL \
           AND nasipaddress      =  '%{NAS-IP-Address}' \
           AND acctstarttime     <= '%S'"
 
@@ -278,14 +278,14 @@
        #simul_count_query = "SELECT COUNT(*) \
                              #FROM ${acct_table1} \
                              #WHERE username = '%{SQL-User-Name}' \
-                             #AND acctstoptime = NULL"
+                             #AND acctstoptime IS NULL"
 
        simul_verify_query  = "SELECT radacctid, acctsessionid, username, \
                                nasipaddress, nasportid, framedipaddress, \
                                callingstationid, framedprotocol \
                                FROM ${acct_table1} \
                                WHERE username = '%{SQL-User-Name}' \
-                               AND acctstoptime = NULL"
+                               AND acctstoptime IS NULL"
 
        #######################################################################
        # Authentication Logging Queries