You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@vcl.apache.org by jf...@apache.org on 2014/09/30 20:10:27 UTC
svn commit: r1628508 - /vcl/trunk/mysql/update-vcl.sql
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;
-- --------------------------------------------------------