<?php

/**
 * This file is part of the Froxlor project.
 * Copyright (c) 2010 the Froxlor Team (see authors).
 *
 * For the full copyright and license information, please view the COPYING
 * file that was distributed with this source code. You can also view the
 * COPYING file online at http://files.froxlor.org/misc/COPYING.txt
 *
 * @copyright  (c) the authors
 * @author     Froxlor team <*****@*****.**> (2010-)
 * @license    GPLv2 http://files.froxlor.org/misc/COPYING.txt
 * @package    Install
 *
 */
if (!defined('AREA') || defined('AREA') && AREA != 'admin' || !isset($userinfo['loginname']) || isset($userinfo['loginname']) && $userinfo['loginname'] == '') {
    header('Location: ../../../index.php');
    exit;
}
$updateto = '0.9-r0';
$frontend = 'froxlor';
showUpdateStep("Upgrading SysCP " . Settings::Get('panel.version') . " to Froxlor " . $updateto, false);
updateToVersion($updateto);
// add field frontend
Database::query("INSERT INTO `" . TABLE_PANEL_SETTINGS . "` SET\n\t`settinggroup` = 'panel',\n\t`varname` = 'frontend',\n\t`value` = 'froxlor'");
Settings::Set('panel.frontend', $frontend);
Beispiel #2
0
    Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAIN_SSL_SETTINGS . "` MODIFY `ssl_ca_file` mediumtext NOT NULL");
    Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAIN_SSL_SETTINGS . "` MODIFY `ssl_cert_chainfile` mediumtext NOT NULL");
    lastStepStatus(0);
    updateToVersion('0.9.34-dev2');
}
if (isFroxlorVersion('0.9.34-dev2')) {
    showUpdateStep("Updating from 0.9.34-dev2 to 0.9.34-dev3", false);
    $do_update = true;
    showUpdateStep("Checking for required PHP mbstring-extension");
    if (!extension_loaded('mbstring')) {
        $do_update = false;
        lastStepStatus(2, 'not installed');
    } else {
        lastStepStatus(0);
    }
    if ($do_update) {
        updateToVersion('0.9.34-dev3');
    }
}
if (isFroxlorVersion('0.9.34-dev3')) {
    showUpdateStep("Updating from 0.9.34-dev3 to 0.9.34-dev4", false);
    showUpdateStep("Adding field umask to phpconfig table");
    Database::query("ALTER TABLE `" . TABLE_PANEL_PHPCONFIGS . "` ADD `mod_fcgid_umask` varchar(15) NOT NULL DEFAULT '022' AFTER `mod_fcgid_maxrequests`");
    lastStepStatus(0);
    updateToVersion('0.9.34-dev4');
}
if (isFroxlorVersion('0.9.34-dev4')) {
    showUpdateStep("Updating from 0.9.34-dev4 to 0.9.34 final");
    lastStepStatus(0);
    updateToVersion('0.9.34');
}
Beispiel #3
0
        $db->query("INSERT INTO `panel_settings` (`settinggroup`, `varname`, `value`) VALUES ('system', 'mod_fcgid_idle_timeout', '30');");
    }
    // Get FastCGI timeout setting if available
    $handle = $db->query("SELECT `value` FROM `panel_settings` WHERE `settinggroup` = 'phpfpm' AND `varname` = 'idle_timeout';");
    // If timeout is set then skip
    if ($db->num_rows($handle) < 1) {
        $db->query("INSERT INTO `panel_settings` (`settinggroup`, `varname`, `value`) VALUES ('phpfpm', 'idle_timeout', '30');");
    }
    updateToVersion('0.9.27-svn2');
}
if (isFroxlorVersion('0.9.27-svn2')) {
    showUpdateStep("Updating from 0.9.27-svn2 to 0.9.27-rc1");
    lastStepStatus(0);
    updateToVersion('0.9.27-rc1');
}
if (isFroxlorVersion('0.9.27-rc1')) {
    showUpdateStep("Updating from 0.9.27-rc1 to 0.9.27");
    lastStepStatus(0);
    updateToVersion('0.9.27');
}
if (isFroxlorVersion('0.9.27')) {
    showUpdateStep("Updating from 0.9.27 to 0.9.28-svn1");
    lastStepStatus(0);
    // Get AliasconfigDir setting if available
    $handle = $db->query("SELECT `value` FROM `panel_settings` WHERE `settinggroup` = 'phpfpm' AND `varname` = 'aliasconfigdir';");
    // If AliasconfigDir is set then skip
    if ($db->num_rows($handle) < 1) {
        $db->query("INSERT INTO `panel_settings` (`settinggroup`, `varname`, `value`) VALUES ('phpfpm', 'aliasconfigdir', '/var/www/php-fpm/');");
    }
    updateToVersion('0.9.28-svn1');
}
Beispiel #4
0
    standard_error('exception', $e->getMessage());
}
/*
 * since froxlor, we have to check if there's still someone
 * out there using syscp and needs to upgrade
 */
if (!isFroxlor()) {
    /**
     * Upgrading SysCP to Froxlor-0.9
     */
    include_once makeCorrectFile(dirname(__FILE__) . '/updates/froxlor/upgrade_syscp.inc.php');
}
if (isFroxlor()) {
    include_once makeCorrectFile(dirname(__FILE__) . '/updates/froxlor/0.9/update_0.9.inc.php');
    // Check Froxlor - database integrity (only happens after all updates are done, so we know the db-layout is okay)
    showUpdateStep("Checking database integrity");
    $integrity = new IntegrityCheck();
    if (!$integrity->checkAll()) {
        lastStepStatus(2, 'Monkeys ate the integrity');
        showUpdateStep("Trying to remove monkeys, feeding bananas");
        if (!$integrity->fixAll()) {
            lastStepStatus(2, 'Some monkeys just would not move');
        } else {
            lastStepStatus(0);
        }
    } else {
        lastStepStatus(0);
    }
    $filelog->logAction(ADM_ACTION, LOG_WARNING, '--------------- END LOG ---------------');
    unset($filelog);
}
Beispiel #5
0
    Settings::AddNew("system.mail_smtp_port", $smtp_port);
    Settings::AddNew("system.mail_smtp_usetls", $smtp_usetls);
    Settings::AddNew("system.mail_smtp_auth", $smtp_useauth);
    Settings::AddNew("system.mail_smtp_user", $smtp_user);
    Settings::AddNew("system.mail_smtp_passwd", $smtp_passwd);
    lastStepStatus(0);
    updateToDbVersion('201609200');
}
if (isDatabaseVersion('201609200')) {
    showUpdateStep("Changing tables to be more mysql strict-mode compatible");
    Database::query("ALTER TABLE `" . TABLE_MAIL_VIRTUAL . "` CHANGE `destination` `destination` TEXT NOT NULL DEFAULT '';");
    Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAINS . "` CHANGE `registration_date` `registration_date` DATE NULL DEFAULT NULL;");
    Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAINS . "` CHANGE `termination_date` `termination_date` DATE NULL DEFAULT NULL;");
    lastStepStatus(0);
    updateToDbVersion('201609240');
}
if (isDatabaseVersion('201609240')) {
    showUpdateStep("Add HSTS settings for froxlor-vhost");
    Settings::AddNew("system.hsts_maxage", 0);
    Settings::AddNew("system.hsts_incsub", 0);
    Settings::AddNew("system.hsts_preload", 0);
    lastStepStatus(0);
    showUpdateStep("Settings HSTS default values for all domains (deactivated)");
    Database::query("UPDATE `" . TABLE_PANEL_DOMAINS . "` SET `hsts_sub` = '0', `hsts_preload` = '0';");
    lastStepStatus(0);
    updateToDbVersion('201610070');
}
if (isFroxlorVersion('0.9.37')) {
    showUpdateStep("Updating from 0.9.37 to 0.9.38-rc1", false);
    updateToVersion('0.9.38-rc1');
}
Beispiel #6
0
    updateToVersion('0.9.32');
}
if (isFroxlorVersion('0.9.32')) {
    showUpdateStep("Updating from 0.9.32 to 0.9.33-dev1", false);
    showUpdateStep("Adding settings for custom newsfeed on customer-dashboard");
    Settings::AddNew("customer.show_news_feed", isset($_POST['customer_show_news_feed']) ? (int) $_POST['customer_show_news_feed'] : '0');
    Settings::AddNew("customer.news_feed_url", isset($_POST['customer_news_feed_url']) ? $_POST['customer_news_feed_url'] : '');
    lastStepStatus(0);
    updateToVersion('0.9.33-dev1');
}
if (isFroxlorVersion('0.9.33-dev1')) {
    showUpdateStep("Updating from 0.9.33-dev1 to 0.9.33-dev2", false);
    showUpdateStep("Adding settings for hostname-dns-entry");
    Settings::AddNew("system.dns_createhostnameentry", isset($_POST['dns_createhostnameentry']) ? (int) $_POST['dns_createhostnameentry'] : '0');
    lastStepStatus(0);
    updateToVersion('0.9.33-dev2');
}
if (isFroxlorVersion('0.9.33-dev2')) {
    showUpdateStep("Updating from 0.9.33-dev2 to 0.9.33-dev3", false);
    showUpdateStep("Adding settings for password-generation options");
    Settings::AddNew("panel.password_alpha_lower", '1');
    Settings::AddNew("panel.password_alpha_upper", '1');
    Settings::AddNew("panel.password_numeric", '0');
    Settings::AddNew("panel.password_special_char_required", '0');
    Settings::AddNew("panel.password_special_char", '!?<>§$%&+#=@');
    lastStepStatus(0);
    showUpdateStep("Adding settings for fpm-apache2.4-mod_proxy integration");
    Settings::AddNew("phpfpm.use_mod_proxy", '0');
    lastStepStatus(0);
    updateToVersion('0.9.33-dev3');
}
Beispiel #7
0
    showUpdateStep("Updating from 0.9.34.2 to 0.9.35-dev1");
    lastStepStatus(0);
    showUpdateStep("Adding Let's Encrypt - certificate fields");
    Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAIN_SSL_SETTINGS . "` ADD `expirationdate` DATETIME NULL AFTER `ssl_cert_chainfile`;");
    Database::query("ALTER TABLE `" . TABLE_PANEL_CUSTOMERS . "` ADD `lepublickey` MEDIUMTEXT DEFAULT NULL AFTER `custom_notes_show`");
    Database::query("ALTER TABLE `" . TABLE_PANEL_CUSTOMERS . "` ADD `leprivatekey` MEDIUMTEXT DEFAULT NULL AFTER `lepublickey`;");
    Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAINS . "` ADD `letsencrypt` TINYINT(1) NOT NULL DEFAULT '0' AFTER `ismainbutsubto`;");
    Settings::AddNew("system.leprivatekey", 'unset');
    Settings::AddNew("system.lepublickey", 'unset');
    showUpdateStep("Adding new cron-module for Let's encrypt");
    $stmt = Database::prepare("\n        INSERT INTO `" . TABLE_PANEL_CRONRUNS . "` SET\n        `module` = 'froxlor/letsencrypt',\n        `cronfile` = 'letsencrypt',\n        `interval` = '5 MINUTE',\n        `desc_lng_key` = 'cron_letsencrypt',\n        `lastrun` = NOW(),\n        `isactive` = 1");
    Database::pexecute($stmt);
    lastStepStatus(0);
    updateToVersion('0.9.35-dev1');
}
if (isFroxlorVersion('0.9.35-dev1')) {
    showUpdateStep("Updating from 0.9.35-dev1 to 0.9.35-dev2");
    lastStepStatus(0);
    showUpdateStep("Adding Let's Encrypt - settings");
    Settings::AddNew("system.letsencryptca", 'testing');
    Settings::AddNew("system.letsencryptcountrycode", 'DE');
    Settings::AddNew("system.letsencryptstate", 'Germany');
    lastStepStatus(0);
    updateToVersion('0.9.35-dev2');
}
if (isFroxlorVersion('0.9.35-dev2')) {
    showUpdateStep("Updating from 0.9.35-dev2 to 0.9.35-dev3");
    Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAINS . "` ADD `termination_date` date NOT NULL AFTER `registration_date`");
    lastStepStatus(0);
    updateToVersion('0.9.35-dev3');
}
Beispiel #8
0
    lastStepStatus(0);
    // Get FastCGI timeout setting if available
    $handle = $db->query("SELECT `value` FROM `panel_settings` WHERE `settinggroup` = 'system' AND `varname` = 'mod_fcgid_idle_timeout';");
    // If timeout is set then skip
    if ($db->num_rows($handle) < 1) {
        $db->query("INSERT INTO `panel_settings` (`settinggroup`, `varname`, `value`) VALUES ('system', 'mod_fcgid_idle_timeout', '30');");
    }
    // Get FastCGI timeout setting if available
    $handle = $db->query("SELECT `value` FROM `panel_settings` WHERE `settinggroup` = 'phpfpm' AND `varname` = 'idle_timeout';");
    // If timeout is set then skip
    if ($db->num_rows($handle) < 1) {
        $db->query("INSERT INTO `panel_settings` (`settinggroup`, `varname`, `value`) VALUES ('phpfpm', 'idle_timeout', '30');");
    }
    updateToVersion('0.9.27-svn2');
}
if (isFroxlorVersion('0.9.27-svn2')) {
    showUpdateStep("Updating from 0.9.27-svn2 to 0.9.27-rc1");
    lastStepStatus(0);
    updateToVersion('0.9.27-rc1');
}
if (isFroxlorVersion('0.9.27-rc1')) {
    showUpdateStep("Updating from 0.9.27-rc1 to 0.9.27");
    lastStepStatus(0);
    // Add the external access column (see ticket #814);
    $db->query('ALTER TABLE froxlor.panel_databases ADD allow_external_access INT(1) DEFAULT 0');
    $db->query('ALTER TABLE froxlor.panel_domains ADD special_phpsettings TEXT DEFAULT ""');
    // Add php versions
    $db->query('ALTER TABLE froxlor.panel_domains ADD php_version VARCHAR(100) DEFAULT "5.3.22"');
    $db->query('ALTER TABLE froxlor.panel_customers ADD nitrado_service_type VARCHAR(50) DEFAULT "beginner"');
    updateToVersion('0.9.27');
}
Beispiel #9
0
    Settings::AddNew("system.apacheitksupport", '0');
    lastStepStatus(0);
    showUpdateStep("Increase text-field size of domain-ssl table");
    Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAIN_SSL_SETTINGS . "` MODIFY `ssl_cert_file` mediumtext NOT NULL");
    Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAIN_SSL_SETTINGS . "` MODIFY `ssl_key_file` mediumtext NOT NULL");
    Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAIN_SSL_SETTINGS . "` MODIFY `ssl_ca_file` mediumtext NOT NULL");
    Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAIN_SSL_SETTINGS . "` MODIFY `ssl_cert_chainfile` mediumtext NOT NULL");
    lastStepStatus(0);
    updateToVersion('0.9.34-dev2');
}
if (isFroxlorVersion('0.9.34-dev2')) {
    showUpdateStep("Updating from 0.9.34-dev2 to 0.9.34-dev3", false);
    $do_update = true;
    showUpdateStep("Checking for required PHP mbstring-extension");
    if (!extension_loaded('mbstring')) {
        $do_update = false;
        lastStepStatus(2, 'not installed');
    } else {
        lastStepStatus(0);
    }
    if ($do_update) {
        updateToVersion('0.9.34-dev3');
    }
}
if (isFroxlorVersion('0.9.34-dev3')) {
    showUpdateStep("Updating from 0.9.34-dev3 to 0.9.34-dev4", false);
    showUpdateStep("Adding field umask to phpconfig table");
    Database::query("ALTER TABLE `" . TABLE_PANEL_PHPCONFIGS . "` ADD `mod_fcgid_umask` varchar(15) NOT NULL DEFAULT '022' AFTER `mod_fcgid_maxrequests`");
    lastStepStatus(0);
    updateToVersion('0.9.34-dev4');
}
Beispiel #10
0
}
if (isDatabaseVersion('201605090')) {
    showUpdateStep("Adjusting SPF record setting");
    $current_spf = Settings::Get('spf.spf_entry');
    // @	IN	TXT	"v=spf1 a mx -all"
    $new_spf = substr($current_spf, strpos($current_spf, '"'));
    Settings::Set('spf.spf_entry', $new_spf, true);
    lastStepStatus(0);
    updateToDbVersion('201605120');
}
if (isDatabaseVersion('201605120')) {
    showUpdateStep("Adding new dns-server setting");
    $new_dns_daemon = isset($_POST['new_dns_daemon']) ? $_POST['new_dns_daemon'] : "bind";
    Settings::AddNew("system.dns_server", $new_dns_daemon);
    lastStepStatus(0);
    updateToDbVersion('201605170');
}
if (isDatabaseVersion('201605170')) {
    showUpdateStep("Adding new dns-editor setting for customers");
    Database::query("ALTER TABLE `" . TABLE_PANEL_CUSTOMERS . "` ADD `dnsenabled` tinyint(1) NOT NULL default '0' AFTER `perlenabled`;");
    lastStepStatus(0);
    updateToDbVersion('201605180');
}
if (isDatabaseVersion('201605180')) {
    showUpdateStep("Changing tables to be more mysql strict-mode compatible");
    Database::query("ALTER TABLE `" . TABLE_FTP_USERS . "` CHANGE `last_login` `last_login` DATETIME NULL DEFAULT NULL;");
    Database::query("ALTER TABLE `" . TABLE_PANEL_IPSANDPORTS . "` CHANGE `specialsettings` `specialsettings` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;");
    Database::query("ALTER TABLE `" . TABLE_PANEL_TASKS . "` CHANGE `data` `data` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;");
    lastStepStatus(0);
    updateToDbVersion('201606190');
}
Beispiel #11
0
    Database::query("ALTER TABLE `panel_traffic`\n    \tDROP KEY `customerid`,\n    \tADD FOREIGN KEY `fk_customer` (customerid)\n        \tREFERENCES panel_customers(customerid)\n        \tON UPDATE CASCADE ON DELETE CASCADE;");
    Database::query("ALTER TABLE `panel_traffic_admins`\n    \tDROP KEY `adminid`,\n    \t\tADD FOREIGN KEY `fk_admin` (adminid)\n        \tREFERENCES panel_admins(adminid)\n        \tON UPDATE CASCADE ON DELETE CASCADE;");
    // it seems there are occasions where diskspace info
    // for deleted customers is still in the database.
    // remove that, just in case
    Database::query("DELETE FROM `panel_diskspace` WHERE customerid NOT IN (SELECT customerid FROM `panel_customers`)");
    Database::query("ALTER TABLE `panel_diskspace`\n    \tDROP KEY `customerid`,\n    \tADD FOREIGN KEY `fk_customer` (customerid)\n        \tREFERENCES panel_customers(customerid)\n        \tON UPDATE CASCADE ON DELETE CASCADE;");
    Database::query("ALTER TABLE `panel_diskspace_admins`\n    \tDROP KEY `adminid`,\n    \tADD FOREIGN KEY `fk_admin` (adminid)\n        \tREFERENCES panel_admins(adminid)\n        \tON UPDATE CASCADE ON DELETE CASCADE;");
    Database::query("ALTER TABLE `panel_tickets`\n    \tMODIFY COLUMN `adminid` INT(11) UNSIGNED NOT NULL,\n    \tMODIFY COLUMN `customerid` INT(11) UNSIGNED DEFAULT NULL");
    Database::query("UPDATE `panel_tickets` set customerid=NULL where customerid='0'");
    Database::query("ALTER TABLE `panel_tickets`\n\t\tDROP KEY `customerid`,\n    \t  ADD FOREIGN KEY `fk_admin` (adminid)\n\t        REFERENCES panel_admins(adminid)\n    \t    ON UPDATE CASCADE ON DELETE CASCADE,\n    \tADD FOREIGN KEY `fk_customer` (customerid)\n        \tREFERENCES panel_customers(customerid)\n        \tON UPDATE CASCADE ON DELETE CASCADE;");
    Database::query("ALTER TABLE `panel_ticket_categories`\n    \tMODIFY COLUMN `adminid` INT(11) UNSIGNED DEFAULT NULL,\n    \tADD FOREIGN KEY `fk_admin` (adminid)\n        \tREFERENCES panel_admins(adminid)\n        \tON UPDATE CASCADE ON DELETE CASCADE;");
    // it seems there can be redirect codes for deleted
    // domains. Delete those, too
    Database::query("DELETE from `domain_redirect_codes` where did not in (select id from `panel_domains`)");
    Database::query("ALTER TABLE `domain_redirect_codes`\n    \tADD PRIMARY KEY `pk` (`rid`,`did`),\n    \tADD FOREIGN KEY `fk_redirect` (`rid`)\n\t        REFERENCES redirect_codes(id)\n    \t    ON UPDATE CASCADE ON DELETE CASCADE,\n    \tADD FOREIGN KEY `fk_domain` (did)\n        \tREFERENCES panel_domains(id)\n        \tON UPDATE CASCADE ON DELETE CASCADE;");
    Database::query("ALTER TABLE `domain_ssl_settings`\n    \tMODIFY COLUMN `domainid` INT(11) UNSIGNED NOT NULL,\n    \tADD FOREIGN KEY `fk_domain` (domainid)\n        \tREFERENCES panel_domains(id)\n        \tON UPDATE CASCADE ON DELETE CASCADE;");
    Database::query("ALTER TABLE `panel_domaintoip`\n    \tADD FOREIGN KEY `fk_domain` (id_domain)\n        \tREFERENCES panel_domains(id)\n        \tON UPDATE CASCADE ON DELETE CASCADE,\n    \tADD FOREIGN KEY `fk_ipandport` (id_ipandports)\n        \tREFERENCES panel_ipsandports(id)\n        \tON UPDATE CASCADE ON DELETE CASCADE;");
    Database::query("ALTER TABLE `ftp_quotalimits`\n\t\tADD PRIMARY KEY `pk` (`name`, `quota_type`);");
    Database::query("ALTER TABLE `ftp_quotatallies`\n\t\tADD PRIMARY KEY `pk` (`name`, `quota_type`);");
    // add setting for webserver group
    Settings::AddNew('system.customerdir_group_webserver', '0');
    // add multinode version
    Settings::AddNew('multinode.version', '0.0.1.0');
}
if (MN_getVersion() == array(0, 0, 1, 0)) {
    showUpdateStep("Updating to multinode 0.0.2.0", false);
    Database::query("CREATE TABLE `panel_nodes` (\n  \t\t`id` int(11) unsigned NOT NULL AUTO_INCREMENT,\n  \t\t`name` varchar(64) NOT NULL,\n  \t\t`image_name` varchar(128) NOT NULL,\n  \t\t`image_tag` varchar(128) DEFAULT 'latest' NOT NULL,\n  \t\t`is_default` tinyint(1) DEFAULT '0',\n  \t\tPRIMARY KEY (`id`)\n\t\t) ENGINE=InnoDB CHARSET=utf8 COLLATE=utf8_general_ci;");
    Database::query("CREATE TABLE `panel_nodetodomain` (\n  \t\t`id_node` int(11) unsigned NOT NULL,\n  \t\t`id_domain` int(11) unsigned NOT NULL,\n  \t\tPRIMARY KEY (`id_node`,`id_domain`),\n  \t\tFOREIGN KEY `fk_node` (id_node)\n  \t\t\tREFERENCES panel_nodes(id)\n    \t\tON UPDATE CASCADE ON DELETE CASCADE,\n  \t\tFOREIGN KEY `fk_domain` (id_domain)\n  \t\t\tREFERENCES panel_domains(id)\n    \t\tON UPDATE CASCADE ON DELETE CASCADE\n\t\t) ENGINE=InnoDB CHARSET=utf8 COLLATE=utf8_general_ci;");
    Settings::Set('multinode.version', '0.0.2.0');
}
Beispiel #12
0
        $do_update = false;
        lastStepStatus(2, 'not installed');
    } else {
        lastStepStatus(0);
    }
    if ($do_update) {
        updateToVersion('0.9.34-dev3');
    }
}
if (isFroxlorVersion('0.9.34-dev3')) {
    showUpdateStep("Updating from 0.9.34-dev3 to 0.9.34-dev4", false);
    showUpdateStep("Adding field umask to phpconfig table");
    Database::query("ALTER TABLE `" . TABLE_PANEL_PHPCONFIGS . "` ADD `mod_fcgid_umask` varchar(15) NOT NULL DEFAULT '022' AFTER `mod_fcgid_maxrequests`");
    lastStepStatus(0);
    updateToVersion('0.9.34-dev4');
}
if (isFroxlorVersion('0.9.34-dev4')) {
    showUpdateStep("Updating from 0.9.34-dev4 to 0.9.34 final");
    lastStepStatus(0);
    updateToVersion('0.9.34');
}
if (isFroxlorVersion('0.9.34')) {
    showUpdateStep("Updating from 0.9.34 to 0.9.34.1");
    lastStepStatus(0);
    updateToVersion('0.9.34.1');
}
if (isFroxlorVersion('0.9.34.1')) {
    showUpdateStep("Updating from 0.9.34.1 to 0.9.34.2");
    lastStepStatus(0);
    updateToVersion('0.9.34.2');
}
Beispiel #13
0
}
if (isDatabaseVersion('201609050')) {
    showUpdateStep("Adding new settings for acme.conf (Let's Encrypt)");
    // get user-chosen value
    $websrv_default = "/etc/apache2/conf-enabled/acme.conf";
    if (Settings::Get('system.webserver') == 'nginx') {
        $websrv_default = "/etc/nginx/acme.conf";
    }
    $acmeconffile = isset($_POST['acmeconffile']) ? $_POST['acmeconffile'] : $websrv_default;
    $acmeconffile = makeCorrectFile($acmeconffile);
    Settings::AddNew("system.letsencryptacmeconf", $acmeconffile);
    lastStepStatus(0);
    updateToDbVersion('201609120');
}
if (isDatabaseVersion('201609120')) {
    showUpdateStep("Adding new SMTP settings for emails sent by froxlor");
    // get user-chosen value
    $smtp_enable = isset($_POST['smtp_enable']) ? (int) $_POST['smtp_enable'] : 0;
    $smtp_host = isset($_POST['smtp_host']) ? $_POST['smtp_host'] : "localhost";
    $smtp_port = isset($_POST['smtp_port']) ? (int) $_POST['smtp_port'] : 25;
    $smtp_usetls = isset($_POST['smtp_usetls']) ? (int) $_POST['smtp_usetls'] : 1;
    $smtp_useauth = isset($_POST['smtp_auth']) ? (int) $_POST['smtp_auth'] : 1;
    $smtp_user = isset($_POST['smtp_user']) ? $_POST['smtp_user'] : "";
    $smtp_passwd = isset($_POST['smtp_passwd']) ? $_POST['smtp_passwd'] : "";
    Settings::AddNew("system.mail_use_smtp", $smtp_enable);
    Settings::AddNew("system.mail_smtp_host", $smtp_host);
    Settings::AddNew("system.mail_smtp_port", $smtp_port);
    Settings::AddNew("system.mail_smtp_usetls", $smtp_usetls);
    Settings::AddNew("system.mail_smtp_auth", $smtp_useauth);
    Settings::AddNew("system.mail_smtp_user", $smtp_user);
    Settings::AddNew("system.mail_smtp_passwd", $smtp_passwd);
Beispiel #14
0
<?php

/**
 * This file is part of the Froxlor project.
 * Copyright (c) 2010 the Froxlor Team (see authors).
 *
 * For the full copyright and license information, please view the COPYING
 * file that was distributed with this source code. You can also view the
 * COPYING file online at http://files.froxlor.org/misc/COPYING.txt
 *
 * @copyright  (c) the authors
 * @author     Froxlor team <*****@*****.**> (2010-)
 * @license    GPLv2 http://files.froxlor.org/misc/COPYING.txt
 * @package    Install
 *
 */
$updateto = '0.9-r0';
$frontend = 'froxlor';
showUpdateStep("Upgrading SysCP " . $settings['panel']['version'] . " to Froxlor " . $updateto, false);
updateToVersion($updateto);
// add field frontend
$db->query("INSERT INTO `" . TABLE_PANEL_SETTINGS . "` (`settinggroup`, `varname`, `value`) VALUES ('panel','frontend','" . $frontend . "')");
$settings['panel']['frontend'] = $frontend;
Beispiel #15
0
    Database::pexecute($upd_stmt, array('lang' => 'Svenska', 'iso' => 'sv'), false);
    lastStepStatus(0);
    updateToVersion('0.9.34-dev1');
}
if (isFroxlorVersion('0.9.34-dev1')) {
    showUpdateStep("Updating from 0.9.34-dev1 to 0.9.34-dev2", false);
    showUpdateStep("Adding new settings for apache-itk-mpm");
    Settings::AddNew("system.apacheitksupport", '0');
    lastStepStatus(0);
    showUpdateStep("Increase text-field size of domain-ssl table");
    Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAIN_SSL_SETTINGS . "` MODIFY `ssl_cert_file` mediumtext NOT NULL");
    Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAIN_SSL_SETTINGS . "` MODIFY `ssl_key_file` mediumtext NOT NULL");
    Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAIN_SSL_SETTINGS . "` MODIFY `ssl_ca_file` mediumtext NOT NULL");
    Database::query("ALTER TABLE `" . TABLE_PANEL_DOMAIN_SSL_SETTINGS . "` MODIFY `ssl_cert_chainfile` mediumtext NOT NULL");
    lastStepStatus(0);
    updateToVersion('0.9.34-dev2');
}
if (isFroxlorVersion('0.9.34-dev2')) {
    showUpdateStep("Updating from 0.9.34-dev2 to 0.9.34-dev3", false);
    $do_update = true;
    showUpdateStep("Checking for required PHP mbstring-extension");
    if (!extension_loaded('mbstring')) {
        $do_update = false;
        lastStepStatus(2, 'not installed');
    } else {
        lastStepStatus(0);
    }
    if ($do_update) {
        updateToVersion('0.9.34-dev3');
    }
}