From 1377b58057012a0c2dcbefee5a05a2a45a1340ee Mon Sep 17 00:00:00 2001 From: pnixon Date: Sat, 3 May 2008 17:16:07 +0000 Subject: [PATCH] "WHERE acctstoptime = NULL" does NOT do what you think it does! --- raddb/sql/mysql/dialup.conf | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/raddb/sql/mysql/dialup.conf b/raddb/sql/mysql/dialup.conf index 5e370e7..6020196 100644 --- 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 -- 2.1.4