From 03153f790f1bc8988067f1554d1326ae40e8667e Mon Sep 17 00:00:00 2001
From: "Alan T. DeKok" <aland@freeradius.org>
Date: Wed, 28 Jan 2009 14:59:42 +0100
Subject: [PATCH] Corrected MySQL syntax to = NULL

---
 raddb/sql/mysql/ippool.conf | 14 +++++++-------
 1 file changed, 7 insertions(+), 7 deletions(-)

diff --git a/raddb/sql/mysql/ippool.conf b/raddb/sql/mysql/ippool.conf
index 0cf082a..0799f90 100644
--- a/raddb/sql/mysql/ippool.conf
+++ b/raddb/sql/mysql/ippool.conf
@@ -8,7 +8,7 @@
 # allocate-clear = "UPDATE ${ippool_table} \
 #  SET nasipaddress = '', pool_key = 0, \
 #  callingstationid = '', username = '', \
-#  expiry_time IS NULL \
+#  expiry_time = NULL \
 #  WHERE pool_key = '${pool-key}'"
 
 ## This series of queries allocates an IP address
@@ -19,7 +19,7 @@
  allocate-clear = "UPDATE ${ippool_table} \
   SET nasipaddress = '', pool_key = 0, \
   callingstationid = '', username = '', \
-  expiry_time IS NULL \
+  expiry_time = NULL \
   WHERE expiry_time <= NOW() - INTERVAL 1 SECOND
   AND nasipaddress = '%{Nas-IP-Address}'"
 
@@ -39,7 +39,7 @@ allocate-find = "SELECT framedipaddress FROM ${ippool_table} \
 # ## use this query instead
 # allocate-find = "SELECT framedipaddress FROM ${ippool_table} \
 #  WHERE pool_name = '%{control:Pool-Name}' \
-#  AND expiry_time IS NULL \
+#  AND expiry_time =s NULL \
 #  ORDER BY RAND() \
 #  LIMIT 1 \
 #  FOR UPDATE"
@@ -59,7 +59,7 @@ allocate-update = "UPDATE ${ippool_table} \
  SET nasipaddress = '%{NAS-IP-Address}', pool_key = '${pool-key}', \
  callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}', \
  expiry_time = NOW() + INTERVAL ${lease-duration} SECOND \
- WHERE framedipaddress = '%I' AND expiry_time IS NULL"
+ WHERE framedipaddress = '%I' AND expiry_time = NULL"
 
 
 
@@ -73,7 +73,7 @@ start-update = "UPDATE ${ippool_table} \
 ## STOP record arrives
 stop-clear = "UPDATE ${ippool_table} \
  SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', \
- expiry_time IS NULL \
+ expiry_time = NULL \
  WHERE nasipaddress = '%{Nas-IP-Address}' AND pool_key = '${pool-key}' \
  AND username = '%{User-Name}' \
  AND callingstationid = '%{Calling-Station-Id}' \
@@ -96,13 +96,13 @@ alive-update = "UPDATE ${ippool_table} \
 ## NAS when an accounting ON record arrives
 on-clear = "UPDATE ${ippool_table} \
  SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', \
- expiry_time IS NULL \
+ expiry_time = NULL \
  WHERE nasipaddress = '%{Nas-IP-Address}'"
 
 ## This series of queries frees the IP numbers allocate to a
 ## NAS when an accounting OFF record arrives
 off-clear = "UPDATE ${ippool_table} \
  SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', \
- expiry_time IS NULL \
+ expiry_time = NULL \
  WHERE nasipaddress = '%{Nas-IP-Address}'"
 
-- 
2.1.4