From 7b26eae1b657e81aefe2a50e1c15518f0f6ee935 Mon Sep 17 00:00:00 2001 From: Marius Cramer <m.cramer@pixcept.de> Date: Thu, 27 Aug 2015 02:45:37 -0400 Subject: [PATCH] Merge branch 'master' into 'master' --- install/tpl/master_cf_amavis10025.master | 1 interface/web/vm/templates/openvz_vm_additional_ip_edit.htm | 19 +++++++++ install/sql/ispconfig3.sql | 1 install/sql/incremental/upd_dev_collection.sql | 2 + interface/web/vm/openvz_vm_edit.php | 13 ++++++ install/tpl/master_cf_amavis10027.master | 1 interface/lib/plugins/vm_openvz_plugin.inc.php | 31 ++++++++++++++- interface/web/vm/form/openvz_vm.tform.php | 6 +++ 8 files changed, 72 insertions(+), 2 deletions(-) diff --git a/install/sql/incremental/upd_dev_collection.sql b/install/sql/incremental/upd_dev_collection.sql index 919f8d4..bbf80e6 100644 --- a/install/sql/incremental/upd_dev_collection.sql +++ b/install/sql/incremental/upd_dev_collection.sql @@ -166,3 +166,5 @@ ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; ALTER TABLE `web_domain` ADD COLUMN `rewrite_to_https` ENUM('y','n') NOT NULL DEFAULT 'n' AFTER `seo_redirect`; + +ALTER TABLE openvz_ip ADD COLUMN `additional` VARCHAR(255) NOT NULL DEFAULT 'n'; diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql index 1ed6e5e..6089f3f 100644 --- a/install/sql/ispconfig3.sql +++ b/install/sql/ispconfig3.sql @@ -1004,6 +1004,7 @@ `ip_address` varchar(39) DEFAULT NULL, `vm_id` int(11) NOT NULL DEFAULT '0', `reserved` varchar(255) NOT NULL DEFAULT 'n', + `additional` varchar(255) NOT NULL DEFAULT 'n', PRIMARY KEY (`ip_address_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; diff --git a/install/tpl/master_cf_amavis10025.master b/install/tpl/master_cf_amavis10025.master index fb0481b..43f362d 100644 --- a/install/tpl/master_cf_amavis10025.master +++ b/install/tpl/master_cf_amavis10025.master @@ -12,4 +12,5 @@ -o strict_rfc821_envelopes=yes -o receive_override_options=no_unknown_recipient_checks,no_header_body_checks -o smtp_send_xforward_command=yes + -o disable_dns_lookups=yes diff --git a/install/tpl/master_cf_amavis10027.master b/install/tpl/master_cf_amavis10027.master index 44126e2..f9fdf1c 100644 --- a/install/tpl/master_cf_amavis10027.master +++ b/install/tpl/master_cf_amavis10027.master @@ -14,4 +14,5 @@ -o smtp_send_xforward_command=yes -o milter_default_action=accept -o milter_macro_daemon_name=ORIGINATING + -o disable_dns_lookups=yes diff --git a/interface/lib/plugins/vm_openvz_plugin.inc.php b/interface/lib/plugins/vm_openvz_plugin.inc.php index 7cbf843..305118d 100644 --- a/interface/lib/plugins/vm_openvz_plugin.inc.php +++ b/interface/lib/plugins/vm_openvz_plugin.inc.php @@ -60,6 +60,14 @@ // Set the IP address $app->db->query("UPDATE openvz_ip SET vm_id = ? WHERE ip_address = ?", $this->id, $this->dataRecord['ip_address']); + // Set additional IPs + if (isset($this->dataRecord['additional_ip'])) { + $app->db->query("UPDATE openvz_ip SET vm_id = 0, additional = 'n' WHERE vm_id = ? AND additional='y'", $this->id); + foreach ($this->dataRecord['additional_ip'] as $idx => $rec) { + $app->db->query("UPDATE openvz_ip SET vm_id = ?, additional = 'y' WHERE ip_address = ?", $this->id, $rec); + } + } + // Create the OpenVZ config file and store it in config field $this->makeOpenVZConfig(); @@ -95,8 +103,16 @@ // Set the IP address if(isset($this->dataRecord['ip_address'])) { - $app->db->query("UPDATE openvz_ip SET vm_id = 0 WHERE vm_id = ?", $this->id); - $app->db->query("UPDATE openvz_ip SET vm_id = ? WHERE ip_address = ?", $this->id, $this->dataRecord['ip_address']); + $app->db->query("UPDATE openvz_ip SET vm_id = 0 WHERE vm_id = ? AND additional='n'", $this->id); + $app->db->query("UPDATE openvz_ip SET vm_id = ?, additional = 'n' WHERE ip_address = ?", $this->id, $this->dataRecord['ip_address']); + } + + // Set additional IPs + if (isset($this->dataRecord['additional_ip'])) { + $app->db->query("UPDATE openvz_ip SET vm_id = 0, additional = 'n' WHERE (vm_id = ? AND additional='y')", $this->id); + foreach ($this->dataRecord['additional_ip'] as $idx => $rec) { + $app->db->query("UPDATE openvz_ip SET vm_id = ?, additional = 'y' WHERE ip_address = ?", $this->id, $rec); + } } // Create the OpenVZ config file and store it in config field @@ -195,6 +211,17 @@ $hostname = str_replace('{VEID}', $vm['veid'], $vm['hostname']); $tpl->setVar('hostname', $hostname); + + $additional_ips = $app->db->queryAllRecords("SELECT * FROM openvz_ip WHERE vm_id = ?",$this->id); + if (isset($additional_ips)) { + $vm['ip_address']=''; + foreach ($additional_ips as $ip) { + $vm['ip_address'] .= " ".$ip['ip_address']; + } + $vm['ip_address'] = substr($vm['ip_address'],1); + } + $tpl->setVar('ip_address', $vm['ip_address']); + $tpl->setVar('ip_address', $vm['ip_address']); $tpl->setVar('nameserver', $vm['nameserver']); $tpl->setVar('capability', $vm['capability']); diff --git a/interface/web/vm/form/openvz_vm.tform.php b/interface/web/vm/form/openvz_vm.tform.php index 666d06c..d6911cc 100644 --- a/interface/web/vm/form/openvz_vm.tform.php +++ b/interface/web/vm/form/openvz_vm.tform.php @@ -327,6 +327,12 @@ //################################# ) ); + + $form["tabs"]['additional_ip'] = array ( + 'title' => "Additional IP", + 'width' => 100, + 'template' => "templates/openvz_vm_additional_ip_edit.htm", + ); } diff --git a/interface/web/vm/openvz_vm_edit.php b/interface/web/vm/openvz_vm_edit.php index 07f6aaa..0db2053 100644 --- a/interface/web/vm/openvz_vm_edit.php +++ b/interface/web/vm/openvz_vm_edit.php @@ -178,6 +178,19 @@ $app->tpl->setVar("ip_address", $ip_select); unset($tmp); unset($ips); + + //* Additional IPs + $sql="SELECT * FROM openvz_ip WHERE reserved = 'n' AND ((vm_id = ? AND additional='y') OR vm_id = 0) AND server_id = ?"; + $additional_ips = $app->db->queryAllRecords($sql, $this->id, $vm_server_id); + foreach ($additional_ips as $idx => $rec) { + $temp .= "<input type='hidden' id='id".$idx."' name='additional_ip[".$idx."]' name='additional_ip[".$idx."]' value='0'>"; + $used = @($rec['additional']=='y')?'CHECKED':''; + $temp .= "<input type='checkbox' value='".$rec['ip_address']."' id='id".$idx."' name='additional_ip[".$idx."]' ".$used."> ".$rec['ip_address']."<br>"; + } + $app->tpl->setVar("additional_ip", $temp); + unset($used); + unset($temp); + unset($additional_ips); if($this->id > 0) { //* we are editing a existing record diff --git a/interface/web/vm/templates/openvz_vm_additional_ip_edit.htm b/interface/web/vm/templates/openvz_vm_additional_ip_edit.htm new file mode 100644 index 0000000..f19eb6c --- /dev/null +++ b/interface/web/vm/templates/openvz_vm_additional_ip_edit.htm @@ -0,0 +1,19 @@ +<div class='page-header'></div> +<p><tmpl_var name="list_desc_txt"></p> + +<legend>Additional IPs</legend> + +<div class="form-group"> + <div class="col-sm-3"> + {tmpl_var name='additional_ip'} + </div> +</div> + +<input type="hidden" name="id" value="{tmpl_var name='id'}"> + +<div class="clear"><div class="right"> + <button class="btn btn-default formbutton-success" type="button" value="{tmpl_var name='btn_save_txt'}" data-submit-form="pageForm" data-form-action="vm/openvz_vm_edit.php">{tmpl_var name='btn_save_txt'}</button> + <button class="btn btn-default formbutton-default" type="button" value="{tmpl_var name='btn_cancel_txt'}" data-load-content="vm/openvz_vm_list.php">{tmpl_var name='btn_cancel_txt'}</button> +</div></div> + + -- Gitblit v1.9.1