Author: jfthomps
Date: Tue Sep 30 18:10:27 2014
New Revision: 1628508
URL: http://svn.apache.org/r1628508
Log:
VCL-174 - NAT - support for sites that have small IP address ranges
update-vcl.sql: added conditional to WHERE for INSERT IGNORE INTO nathost to
skip management nodes with stateid = 1
Modified:
vcl/trunk/mysql/update-vcl.sql
Modified: vcl/trunk/mysql/update-vcl.sql
URL:
http://svn.apache.org/viewvc/vcl/trunk/mysql/update-vcl.sql?rev=1628508&r1=1628507&r2=1628508&view=diff
==============================================================================
--- vcl/trunk/mysql/update-vcl.sql (original)
+++ vcl/trunk/mysql/update-vcl.sql Tue Sep 30 18:10:27 2014
@@ -1375,7 +1375,7 @@ INSERT IGNORE INTO `module` (`name`, `pr
-- Inserts for table `nathost`
--
-INSERT IGNORE INTO nathost (resourceid, natIP) SELECT resource.id,
managementnode.IPaddress FROM resource, managementnode WHERE
resource.resourcetypeid = 16 AND resource.subid = managementnode.id;
+INSERT IGNORE INTO nathost (resourceid, natIP) SELECT resource.id,
managementnode.IPaddress FROM resource, managementnode WHERE
resource.resourcetypeid = 16 AND resource.subid = managementnode.id AND
managementnode.stateid != 1;
-- --------------------------------------------------------
