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;
-- --------------------------------------------------------
