From 0d3e95814c9b0dc5d1339d38c23cd7ab33a2e7a9 Mon Sep 17 00:00:00 2001
From: Till Brehm <tbrehm@ispconfig.org>
Date: Thu, 16 Jun 2016 08:43:08 -0400
Subject: [PATCH] Fixed Issue #3966 Error when Web-IP is '*'
---
install/sql/incremental/upd_dev_collection.sql | 147 +++---------------------------------------------
1 files changed, 10 insertions(+), 137 deletions(-)
diff --git a/install/sql/incremental/upd_dev_collection.sql b/install/sql/incremental/upd_dev_collection.sql
index 221fde9..13c895c 100644
--- a/install/sql/incremental/upd_dev_collection.sql
+++ b/install/sql/incremental/upd_dev_collection.sql
@@ -1,137 +1,10 @@
-ALTER TABLE `mail_user`
- CHANGE `uid` `uid` int(11) NOT NULL DEFAULT '5000',
- CHANGE `gid` `gid` int(11) NOT NULL DEFAULT '5000';
-
-ALTER TABLE `mail_user`
- ADD COLUMN `sender_cc` varchar(255) NOT NULL DEFAULT '' AFTER `cc`;
-
-ALTER TABLE `client_template` ADD `default_mailserver` INT(11) NOT NULL DEFAULT 1;
-ALTER TABLE `client_template` ADD `default_webserver` INT(11) NOT NULL DEFAULT 1;
-ALTER TABLE `client_template` ADD `default_dnsserver` INT(11) NOT NULL DEFAULT 1;
-ALTER TABLE `client_template` ADD `default_slave_dnsserver` INT(11) NOT NULL DEFAULT 1;
-ALTER TABLE `client_template` ADD `default_dbserver` INT(11) NOT NULL DEFAULT 1;
-ALTER TABLE `client` ADD `contact_firstname` VARCHAR( 64 ) NOT NULL DEFAULT '' AFTER `gender`;
-
-UPDATE `dns_template` SET `fields` = 'DOMAIN,IP,NS1,NS2,EMAIL,DKIM' WHERE `dns_template`.`template_id` =1;
-UPDATE `dns_template` SET `template` = '[ZONE]
-origin={DOMAIN}.
-ns={NS1}.
-mbox={EMAIL}.
-refresh=7200
-retry=540
-expire=604800
-minimum=86400
-ttl=3600
-
-[DNS_RECORDS]
-A|{DOMAIN}.|{IP}|0|3600
-A|www|{IP}|0|3600
-A|mail|{IP}|0|3600
-NS|{DOMAIN}.|{NS1}.|0|3600
-NS|{DOMAIN}.|{NS2}.|0|3600
-MX|{DOMAIN}.|mail.{DOMAIN}.|10|3600
-TXT|{DOMAIN}.|v=spf1 mx a ~all|0|3600' WHERE `dns_template`.`template_id` = 1;
-
-ALTER TABLE `mail_backup` CHANGE `filesize` `filesize` VARCHAR(20) NOT NULL DEFAULT '';
-ALTER TABLE `web_backup` CHANGE `filesize` `filesize` VARCHAR(20) NOT NULL DEFAULT '';
-
-ALTER TABLE `sys_datalog` ADD INDEX `dbtable` (`dbtable` (25), `dbidx` (25)), ADD INDEX (`action`);
-ALTER TABLE `mail_user` ADD `greylisting` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'n' AFTER `postfix`;
-ALTER TABLE `mail_user` ADD `maildir_format` varchar(255) NOT NULL default 'maildir' AFTER `maildir`;
-ALTER TABLE `mail_forwarding` ADD `greylisting` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'n' AFTER `active`;
-
-ALTER TABLE `openvz_ip` CHANGE `ip_address` `ip_address` VARCHAR(39) DEFAULT NULL;
-
--- XMPP Support
-
-ALTER TABLE `server` ADD COLUMN `xmpp_server` tinyint(1) NOT NULL default '0' AFTER `firewall_server`;
-
-ALTER TABLE `client`
- ADD COLUMN `default_xmppserver` int(11) unsigned NOT NULL DEFAULT '1',
- ADD COLUMN `xmpp_servers` blob,
- ADD COLUMN `limit_xmpp_domain` int(11) NOT NULL DEFAULT '-1',
- ADD COLUMN `limit_xmpp_user` int(11) NOT NULL DEFAULT '-1',
- ADD COLUMN `limit_xmpp_muc` ENUM( 'n', 'y' ) NOT NULL default 'n',
- ADD COLUMN `limit_xmpp_anon` ENUM( 'n', 'y' ) NOT NULL default 'n',
- ADD COLUMN `limit_xmpp_auth_options` varchar(255) NOT NULL DEFAULT 'plain,hashed,isp',
- ADD COLUMN `limit_xmpp_vjud` ENUM( 'n', 'y' ) NOT NULL default 'n',
- ADD COLUMN `limit_xmpp_proxy` ENUM( 'n', 'y' ) NOT NULL default 'n',
- ADD COLUMN `limit_xmpp_status` ENUM( 'n', 'y' ) NOT NULL default 'n',
- ADD COLUMN `limit_xmpp_pastebin` ENUM( 'n', 'y' ) NOT NULL default 'n',
- ADD COLUMN `limit_xmpp_httparchive` ENUM( 'n', 'y' ) NOT NULL default 'n';
-
-
-CREATE TABLE `xmpp_domain` (
- `domain_id` int(11) unsigned NOT NULL auto_increment,
- `sys_userid` int(11) unsigned NOT NULL default '0',
- `sys_groupid` int(11) unsigned NOT NULL default '0',
- `sys_perm_user` varchar(5) NOT NULL default '',
- `sys_perm_group` varchar(5) NOT NULL default '',
- `sys_perm_other` varchar(5) NOT NULL default '',
- `server_id` int(11) unsigned NOT NULL default '0',
- `domain` varchar(255) NOT NULL default '',
-
- `management_method` ENUM( 'normal', 'maildomain' ) NOT NULL default 'normal',
- `public_registration` ENUM( 'n', 'y' ) NOT NULL default 'n',
- `registration_url` varchar(255) NOT NULL DEFAULT '',
- `registration_message` varchar(255) NOT NULL DEFAULT '',
- `domain_admins` text,
-
- `use_pubsub` enum('n','y') NOT NULL DEFAULT 'n',
- `use_proxy` enum('n','y') NOT NULL DEFAULT 'n',
- `use_anon_host` enum('n','y') NOT NULL DEFAULT 'n',
-
- `use_vjud` enum('n','y') NOT NULL DEFAULT 'n',
- `vjud_opt_mode` enum('in', 'out') NOT NULL DEFAULT 'in',
-
- `use_muc_host` enum('n','y') NOT NULL DEFAULT 'n',
- `muc_name` varchar(30) NOT NULL DEFAULT ''
- `muc_restrict_room_creation` enum('n', 'y', 'm') NOT NULL DEFAULT 'm',
- `muc_admins` text,
- `use_pastebin` enum('n','y') NOT NULL DEFAULT 'n',
- `pastebin_expire_after` int(3) NOT NULL DEFAULT 48,
- `pastebin_trigger` varchar(10) NOT NULL DEFAULT '!paste',
- `use_http_archive` enum('n','y') NOT NULL DEFAULT 'n',
- `http_archive_show_join` enum('n', 'y') NOT NULL DEFAULT 'n',
- `http_archive_show_status` enum('n', 'y') NOT NULL DEFAULT 'n',
- `use_status_host` enum('n','y') NOT NULL DEFAULT 'n',
-
- `ssl_state` varchar(255) NULL,
- `ssl_locality` varchar(255) NULL,
- `ssl_organisation` varchar(255) NULL,
- `ssl_organisation_unit` varchar(255) NULL,
- `ssl_country` varchar(255) NULL,
- `ssl_email` varchar(255) NULL,
- `ssl_request` mediumtext NULL,
- `ssl_cert` mediumtext NULL,
- `ssl_bundle` mediumtext NULL,
- `ssl_key` mediumtext NULL,
- `ssl_action` varchar(16) NULL,
-
- `active` enum('n','y') NOT NULL DEFAULT 'n',
- PRIMARY KEY (`domain_id`),
- KEY `server_id` (`server_id`,`domain`),
- KEY `domain_active` (`domain`,`active`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-
---
--- Table structure for table `xmpp_user`
---
-
-CREATE TABLE `xmpp_user` (
- `xmppuser_id` int(11) unsigned NOT NULL auto_increment,
- `sys_userid` int(11) unsigned NOT NULL default '0',
- `sys_groupid` int(11) unsigned NOT NULL default '0',
- `sys_perm_user` varchar(5) NOT NULL default '',
- `sys_perm_group` varchar(5) NOT NULL default '',
- `sys_perm_other` varchar(5) NOT NULL default '',
- `server_id` int(11) unsigned NOT NULL default '0',
- `jid` varchar(255) NOT NULL default '',
- `password` varchar(255) NOT NULL default '',
- `active` enum('n','y') NOT NULL DEFAULT 'n',
- PRIMARY KEY (`xmppuser_id`),
- KEY `server_id` (`server_id`,`jid`),
- KEY `jid_active` (`jid`,`active`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-
--- --------------------------------------------------------
+ALTER TABLE `client` CHANGE `web_servers` `web_servers` TEXT NULL DEFAULT NULL;
+ALTER TABLE `client` CHANGE `mail_servers` `mail_servers` TEXT NULL DEFAULT NULL;
+ALTER TABLE `client` CHANGE `xmpp_servers` `xmpp_servers` TEXT NULL DEFAULT NULL;
+ALTER TABLE `client` CHANGE `db_servers` `db_servers` TEXT NULL DEFAULT NULL;
+ALTER TABLE `client` CHANGE `dns_servers` `dns_servers` TEXT NULL DEFAULT NULL;
+UPDATE client SET web_servers = default_webserver WHERE (web_servers = '' OR web_servers IS NULL);
+UPDATE client SET mail_servers = default_mailserver WHERE (mail_servers = '' OR mail_servers IS NULL);
+UPDATE client SET xmpp_servers = default_xmppserver WHERE (xmpp_servers = '' OR xmpp_servers IS NULL);
+UPDATE client SET db_servers = default_dbserver WHERE (db_servers = '' OR db_servers IS NULL);
+UPDATE client SET dns_servers = default_dnsserver WHERE (dns_servers = '' OR dns_servers IS NULL);
\ No newline at end of file
--
Gitblit v1.9.1