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 2015/03/13 16:17:40 UTC
svn commit: r1666476 - /vcl/trunk/mysql/update-vcl.sql
Author: jfthomps
Date: Fri Mar 13 15:17:40 2015
New Revision: 1666476
URL: http://svn.apache.org/r1666476
Log:
VCL-174 - NAT - support for sites that have small IP address ranges
update-vcl.sql: removed insert that populated nathost table with existing management nodes. This was initially added before there was a way to add nat hosts and all added management nodes would also be added as nat hosts. The code was added to be able to set any management node or computer as a nat host. So, this initial population of the nathost table with management nodes is unnecessary.
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=1666476&r1=1666475&r2=1666476&view=diff
==============================================================================
--- vcl/trunk/mysql/update-vcl.sql (original)
+++ vcl/trunk/mysql/update-vcl.sql Fri Mar 13 15:17:40 2015
@@ -1572,13 +1572,6 @@ INSERT IGNORE INTO `module` (`name`, `pr
INSERT IGNORE INTO `module` (`name`, `prettyname`, `description`, `perlpackage`) VALUES ('predictive_level_2', 'Predictive Loading Module Level 2', 'Power off computer. If a virtual machine, it will be also destroyed.', 'VCL::Module::Predictive::Level_2');
INSERT IGNORE INTO `module` (`name`, `prettyname`, `description`, `perlpackage`) VALUES ('provisioning_openstack', 'OpenStack Provisioning Module', '', 'VCL::Module::Provisioning::openstack');
INSERT IGNORE INTO `module` (`name`, `prettyname`, `description`, `perlpackage`) VALUES ('provisioning_one', 'OpenNebula Provisioning Module', '', 'VCL::Module::Provisioning::one');
--- --------------------------------------------------------
-
---
--- Inserts for table `nathost`
---
-
-INSERT IGNORE INTO nathost (resourceid, publicIPaddress) SELECT resource.id, managementnode.IPaddress FROM resource, managementnode WHERE resource.resourcetypeid = 16 AND resource.subid = managementnode.id AND managementnode.stateid != 1;
-- --------------------------------------------------------