update.lib.php 22.2 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
<?php
/*
Copyright (c) 2007-2010, Till Brehm, projektfarm Gmbh
All rights reserved.

Redistribution and use in source and binary forms, with or without modification,
are permitted provided that the following conditions are met:

    * Redistributions of source code must retain the above copyright notice,
      this list of conditions and the following disclaimer.
    * Redistributions in binary form must reproduce the above copyright notice,
      this list of conditions and the following disclaimer in the documentation
      and/or other materials provided with the distribution.
    * Neither the name of ISPConfig nor the names of its contributors
      may be used to endorse or promote products derived from this software without
      specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/

30 31
//* Installer patch stub class
class installer_patch_update {
32
	public function onBeforeSQL() {
33 34
	}

35
	public function onAfterSQL() {
36 37
	}

38 39 40
}

//* DB dump function
41 42 43 44 45 46
function prepareDBDump() {
	global $conf;

	//** load the pre update sql script do perform modifications on the database before the database is dumped
	if(is_file(ISPC_INSTALL_ROOT."/install/sql/pre_update.sql")) {
		if($conf['mysql']['admin_password'] == '') {
47
			caselog("mysql --default-character-set=".escapeshellarg($conf['mysql']['charset'])." -h ".escapeshellarg($conf['mysql']['host'])." -u ".escapeshellarg($conf['mysql']['admin_user'])." ".escapeshellarg($conf['mysql']['database'])." < '".ISPC_INSTALL_ROOT."/install/sql/pre_update.sql' &> /dev/null", __FILE__, __LINE__, 'read in pre_update.sql', 'could not read in pre_update.sql');
48
		} else {
49
			caselog("mysql --default-character-set=".escapeshellarg($conf['mysql']['charset'])." -h ".escapeshellarg($conf['mysql']['host'])." -u ".escapeshellarg($conf['mysql']['admin_user'])." -p".escapeshellarg($conf['mysql']['admin_password'])." ".escapeshellarg($conf['mysql']['database'])." < '".ISPC_INSTALL_ROOT."/install/sql/pre_update.sql' &> /dev/null", __FILE__, __LINE__, 'read in pre_update.sql', 'could not read in pre_update.sql');
50 51 52 53 54 55
		}
	}

	//** export the current database data
	if( !empty($conf["mysql"]["admin_password"]) ) {

56
		system("mysqldump -h ".escapeshellarg($conf['mysql']['host'])." -u ".escapeshellarg($conf['mysql']['admin_user'])." -p".escapeshellarg($conf['mysql']['admin_password'])." -c -t --add-drop-table --create-options --quick --result-file=existing_db.sql ".$conf['mysql']['database']);
57 58 59
	}
	else {

60
		system("mysqldump -h ".escapeshellarg($conf['mysql']['host'])." -u ".escapeshellarg($conf['mysql']['admin_user'])." -c -t --add-drop-table --create-options --quick --result-file=existing_db.sql ".$conf['mysql']['database']);
61 62 63 64 65 66 67 68 69
	}

	/*
	 * If we have a server with nothing in it except VE's then the database of thie server is empty.
	 * so the following line will no longer work!
	 */
	//if(filesize('existing_db.sql') < 30000) die('Possible problem with dumping the database. We will stop here. Please check the file existing_db.sql');

	// create a backup copy of the ispconfig database in the root folder
70 71 72 73 74
	if(isset($conf['backup_path'])) {
		$backup_db_name = $conf['backup_path'].'/ispconfig_db_backup.sql';
	} else {
		$backup_db_name = '/root/ispconfig_db_backup_'.@date('Y-m-d_H-i').'.sql';
	}
75
	copy('existing_db.sql', $backup_db_name);
76 77 78 79 80 81
	chmod($backup_db_name, 0700);
	chown($backup_db_name, 'root');
	chgrp($backup_db_name, 'root');

	if ($conf['powerdns']['installed']) {
		//** export the current PowerDNS database data
82 83 84 85 86
		if( !empty($conf["mysql"]["admin_password"]) ) {
			system("mysqldump -h ".escapeshellarg($conf['mysql']['host'])." -u ".escapeshellarg($conf['mysql']['admin_user'])." -p".escapeshellarg($conf['mysql']['admin_password'])." -c -t --add-drop-table --create-options --quick --result-file=existing_powerdns_db.sql ".$conf['powerdns']['database']);
		} else {
			system("mysqldump -h ".escapeshellarg($conf['mysql']['host'])." -u ".escapeshellarg($conf['mysql']['admin_user'])." -c -t --add-drop-table --create-options --quick --result-file=existing_powerdns_db.sql ".$conf['powerdns']['database']);
		}
87 88 89

		// create a backup copy of the PowerDNS database in the root folder
		$backup_db_name = '/root/ispconfig_powerdns_db_backup_'.@date('Y-m-d_h-i').'.sql';
90
		copy('existing_powerdns_db.sql', $backup_db_name);
91
		chmod($backup_db_name, 0700);
92 93
		chown($backup_db_name, 'root');
		chgrp($backup_db_name, 'root');
94 95 96 97 98 99 100 101 102 103
	}
}

function checkDbHealth() {
	global $conf;

	//* Array containing non OK tables (can be repaired, crashed, corrupt)
	$notok = array();

	echo "Checking ISPConfig database .. ";
104
	exec("mysqlcheck -h ".escapeshellarg($conf['mysql']['host'])." -u ".escapeshellarg($conf['mysql']['admin_user'])." -p".escapeshellarg($conf['mysql']['admin_password'])." -r ".escapeshellarg($conf["mysql"]["database"]), $result);
105 106 107 108 109 110 111 112 113 114 115 116 117 118 119
	for( $i=0; $i<sizeof($result);$i++) {
		if ( substr($result[$i], -2) != "OK" ) {
			$notok[] = $result[$i];
		}
	}

	if ( sizeof($notok) > 0 ) {
		echo "\nSome tables where not 'OK'. Please check the list below.\n\n";
		foreach ($notok as $key => $value) {
			echo "$value\n";
		}
		echo "\nPress enter to continue or CTRL-C to cancel the installation ..";
		sread();
	}
	else
120
		echo "OK\n";
121 122 123 124 125
}

function updateDbAndIni() {
	global $inst, $conf;

126 127
	//* check sql-mode
	$check_sql_mode = $inst->db->queryOneRecord("SELECT @@sql_mode");
128 129 130
	if ($check_sql_mode['@@sql_mode'] != '' && $check_sql_mode['@@sql_mode'] != 'NO_ENGINE_SUBSTITUTION') {
		echo "Wrong SQL-mode. You should use NO_ENGINE_SUBSTITUTION. Add\n\n";
		echo "    sql-mode=\"NO_ENGINE_SUBSTITUTION\"\n\n";
131
		echo"to the mysqld-section in your mysql-config on this server and restart mysqld afterwards\n";
132 133
		die();
	}
134

135
	$unwanted_sql_plugins = array('validate_password');
136
	$sql_plugins = $inst->db->queryAllRecords("SELECT plugin_name FROM information_schema.plugins WHERE plugin_status='ACTIVE' AND plugin_name IN ?", $unwanted_sql_plugins);
137 138 139 140 141
	if(is_array($sql_plugins) && !empty($sql_plugins)) {
		foreach ($sql_plugins as $plugin) echo "Login in to MySQL and disable $plugin[plugin_name] with:\n\n    UNINSTALL PLUGIN $plugin[plugin_name];";
		die();
	}

142
	//* Update $conf array with values from the server.ini that shall be preserved
143
	$tmp = $inst->db->queryOneRecord("SELECT * FROM ?? WHERE server_id = ?", $conf["mysql"]["database"] . '.server', $conf['server_id']);
144 145 146
	$ini_array = ini_to_array(stripslashes($tmp['config']));
	$current_db_version = (isset($tmp['dbversion']))?intval($tmp['dbversion']):0;

147
	if(!is_array($ini_array) or count($ini_array) == 0) die('Unable to read server configuration from database.');
148 149 150 151 152 153 154 155 156

	$conf['services']['mail'] = ($tmp['mail_server'] == 1)?true:false;
	$conf['services']['web'] = ($tmp['web_server'] == 1)?true:false;
	$conf['services']['dns'] = ($tmp['dns_server'] == 1)?true:false;
	$conf['services']['file'] = ($tmp['file_server'] == 1)?true:false;
	$conf['services']['db'] = ($tmp['db_server'] == 1)?true:false;
	$conf['services']['vserver'] = ($tmp['vserver_server'] == 1)?true:false;
	$conf['services']['proxy'] = (isset($tmp['proxy_server']) && $tmp['proxy_server'] == 1)?true:false;
	$conf['services']['firewall'] = (isset($tmp['firewall_server']) && $tmp['firewall_server'] == 1)?true:false;
157

158
	$conf['postfix']['vmail_mailbox_base'] = $ini_array['mail']['homedir_path'];
159

tbrehm's avatar
tbrehm committed
160
	if(isset($ini_array['web']['server_type']) && $ini_array['web']['server_type'] != ''){
161 162 163 164 165 166 167 168 169 170
		$conf['webserver']['server_type'] = $ini_array['web']['server_type'];
		if($conf['webserver']['server_type'] == 'nginx'){
			$conf['apache']['installed'] = false;
		} else {
			$conf['nginx']['installed'] = false;
		}
	} else {
		$conf['webserver']['server_type'] = 'apache';
		$conf['nginx']['installed'] = false;
	}
171

Marius Cramer's avatar
Marius Cramer committed
172 173
	//* Do incremental DB updates only on installed ISPConfig versions >= 3.0.3
	if(version_compare('3.0.3', ISPC_APP_VERSION, '<=')) {
174

175
		swriteln($inst->lng('Starting incremental database update.'));
176 177

		//* get the version of the db schema from the server table
178
		$found = true;
179
		$dev_patch = false;
180
		while($found == true) {
181 182
			if($dev_patch == true) $next_db_version = 'dev_collection';
			else $next_db_version = intval($current_db_version + 1);
183 184
			$sql_patch_filename = realpath(dirname(__FILE__).'/../').'/sql/incremental/upd_'.str_pad($next_db_version, 4, '0', STR_PAD_LEFT).'.sql';
			$php_patch_filename = realpath(dirname(__FILE__).'/../').'/patches/upd_'.str_pad($next_db_version, 4, '0', STR_PAD_LEFT).'.php';
185 186
			
			// comma separated list of version numbers were a update has to be done silently
187
			$silent_update_versions = 'dev_collection,75';
188

189
			if(is_file($sql_patch_filename)) {
190

191 192 193
				//* Load php patch file and instantiate object
				if(is_file($php_patch_filename)) {
					$php_patch_class_name = 'upd_'.str_pad($next_db_version, 4, '0', STR_PAD_LEFT);
194
					include_once $php_patch_filename;
195 196 197 198 199 200
					if(class_exists($php_patch_class_name)) {
						$php_patch = new $php_patch_class_name;
					} else {
						swriteln($inst->lng('WARNING: PHP patch file').': '.$php_patch_filename.' '.$inst->lng('contains errors.'));
					}
				}
201

202
				//* Exec onBeforeSQL function
203
				if(isset($php_patch) && is_object($php_patch) && method_exists($php_patch, 'onBeforeSQL')) {
204 205 206
					$php_patch->onBeforeSQL();
					swriteln($inst->lng('Executing PHP patch file').': '.$php_patch_filename);
				}
207

208 209
				//* Load patch file into database
				if( !empty($conf["mysql"]["admin_password"]) ) {
210
					$cmd = "mysql --default-character-set=".escapeshellarg($conf['mysql']['charset'])." --force -h ".escapeshellarg($conf['mysql']['host'])." -u ".escapeshellarg($conf['mysql']['admin_user'])." -p".escapeshellarg($conf['mysql']['admin_password'])." ".escapeshellarg($conf['mysql']['database'])." < ".$sql_patch_filename;
211
				} else {
212
					$cmd = "mysql --default-character-set=".escapeshellarg($conf['mysql']['charset'])." --force -h ".escapeshellarg($conf['mysql']['host'])." -u ".escapeshellarg($conf['mysql']['admin_user'])." ".escapeshellarg($conf['mysql']['database'])." < ".$sql_patch_filename;
213
				}
214
				
215 216 217
				if(in_array($next_db_version,explode(',',$silent_update_versions))) {
					$cmd .= ' > /dev/null 2> /dev/null';
				} else {
218
					$cmd .= ' >> /var/log/ispconfig_install.log 2>> /var/log/ispconfig_install.log';
219
				}
220 221
				system($cmd);
				
222
				swriteln($inst->lng('Loading SQL patch file').': '.$sql_patch_filename);
223

224
				//* Exec onAfterSQL function
225
				if(isset($php_patch) && is_object($php_patch) && method_exists($php_patch, 'onAfterSQL')) {
226
					$php_patch->onAfterSQL();
227
				}
228

229 230 231
				if($dev_patch == false) $current_db_version = $next_db_version;
				else $found = false;
				
232
				if(isset($php_patch)) unset($php_patch);
233 234
			} elseif($dev_patch == false) {
				$dev_patch = true;
235 236 237 238
			} else {
				$found = false;
			}
		}
239

240
		//* update the database version in server table
241 242
		$inst->db->query("UPDATE ?? SET dbversion = ? WHERE server_id = ?", $conf["mysql"]["database"] . ".server", $current_db_version, $conf['server_id']);
		if($inst->db->dbHost != $inst->dbmaster->dbHost) $inst->dbmaster->query("UPDATE ?? SET dbversion = ? WHERE server_id = ?", $conf["mysql"]["master_database"] . ".server", $current_db_version, $conf['server_id']);
243 244 245


		//* If ISPConfig Version < 3.0.3, we will do a full db update
246
	} else {
247

248
		swriteln($inst->lng('Starting full database update.'));
249

250
		//** Delete the old database
251
		if( !$inst->db->query('DROP DATABASE IF EXISTS ??', $conf['mysql']['database']) ) {
252
			$inst->error('Unable to drop MySQL database: '.$conf['mysql']['database'].'.');
253 254 255 256 257 258 259 260 261
		}

		//** Create the mysql database
		$inst->configure_database();

		//** empty all databases
		$db_tables = $inst->db->getTables();

		foreach($db_tables as $table) {
262
			$inst->db->query("TRUNCATE ??", $table);
263 264 265 266
		}

		//** load old data back into database
		if( !empty($conf["mysql"]["admin_password"]) ) {
267
			system("mysql --default-character-set=".escapeshellarg($conf['mysql']['charset'])." --force -h ".escapeshellarg($conf['mysql']['host'])." -u ".escapeshellarg($conf['mysql']['admin_user'])." -p".escapeshellarg($conf['mysql']['admin_password'])." ".escapeshellarg($conf['mysql']['database'])." < existing_db.sql");
268
		} else {
269
			system("mysql --default-character-set=".escapeshellarg($conf['mysql']['charset'])." --force -h ".escapeshellarg($conf['mysql']['host'])." -u ".escapeshellarg($conf['mysql']['admin_user'])." ".escapeshellarg($conf['mysql']['database'])." < existing_db.sql");
270
		}
271

272 273 274 275 276 277 278 279 280 281 282
		//** Get the database version number based on the patchfile
		$found = true;
		while($found == true) {
			$next_db_version = intval($current_db_version + 1);
			$patch_filename = realpath(dirname(__FILE__).'/../').'/sql/incremental/upd_'.str_pad($next_db_version, 4, '0', STR_PAD_LEFT).'.sql';
			if(is_file($patch_filename)) {
				$current_db_version = $next_db_version;
			} else {
				$found = false;
			}
		}
283

284
		//* update the database version in server table
285 286
		$inst->db->query("UPDATE ?? SET dbversion = ? WHERE server_id = ?", $conf["mysql"]["database"] . ".server", $current_db_version, $conf['server_id']);
		if($inst->db->dbHost != $inst->dbmaster->dbHost) $inst->dbmaster->query("UPDATE ?? SET dbversion = ? WHERE server_id = ?", $conf["mysql"]["master_database"] . ".server", $current_db_version, $conf['server_id']);
287 288

		if ($conf['powerdns']['installed']) {
289

290 291
			swriteln($inst->lng('Starting full PowerDNS database update.'));

292
			//** Delete the old PowerDNS database
293
			if( !$inst->db->query('DROP DATABASE IF EXISTS ??', $conf['powerdns']['database']) ) {
294
				$inst->error('Unable to drop MySQL database: '.$conf['powerdns']['database'].'.');
295
			}
296

297 298
			//** Create the mysql database
			$inst->configure_powerdns();
299

300 301 302 303 304 305
			//** load old data back into the PowerDNS database
			if( !empty($conf["mysql"]["admin_password"]) ) {
				system("mysql --default-character-set=".escapeshellarg($conf['mysql']['charset'])." --force -h ".escapeshellarg($conf['mysql']['host'])." -u ".escapeshellarg($conf['mysql']['admin_user'])." -p".escapeshellarg($conf['mysql']['admin_password'])." ".escapeshellarg($conf['powerdns']['database'])." < existing_powerdns_db.sql");
			} else {
				system("mysql --default-character-set=".escapeshellarg($conf['mysql']['charset'])." --force -h ".escapeshellarg($conf['mysql']['host'])." -u ".escapeshellarg($conf['mysql']['admin_user'])." ".escapeshellarg($conf['powerdns']['database'])." < existing_powerdns_db.sql");
			}
306 307 308 309 310
		}
	}


	//** Update server ini
311
	$tmp_server_rec = $inst->db->queryOneRecord("SELECT config FROM ?? WHERE server_id = ?", $conf["mysql"]["database"] . ".server", $conf['server_id']);
312 313 314
	$old_ini_array = ini_to_array(stripslashes($tmp_server_rec['config']));
	unset($tmp_server_rec);
	$tpl_ini_array = ini_to_array(rf('tpl/server.ini.master'));
315

316 317 318 319 320
	//* Update further distribution specific parameters for server config here
	//* HINT: Every line added here has to be added in installer_base.lib.php too!!
	$tpl_ini_array['jailkit']['jailkit_chroot_app_programs'] = $conf['jailkit']['jailkit_chroot_app_programs'];
	$tpl_ini_array['fastcgi']['fastcgi_phpini_path'] = $conf['fastcgi']['fastcgi_phpini_path'];
	$tpl_ini_array['fastcgi']['fastcgi_starter_path'] = $conf['fastcgi']['fastcgi_starter_path'];
321
	$tpl_ini_array['fastcgi']['fastcgi_bin'] = $conf['fastcgi']['fastcgi_bin'];
322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339
	$tpl_ini_array['server']['hostname'] = $conf['hostname'];
	$tpl_ini_array['server']['ip_address'] = @gethostbyname($conf['hostname']);
	$tpl_ini_array['web']['website_basedir'] = $conf['web']['website_basedir'];
	$tpl_ini_array['web']['website_path'] = $conf['web']['website_path'];
	$tpl_ini_array['web']['website_symlinks'] = $conf['web']['website_symlinks'];
	$tpl_ini_array['cron']['crontab_dir'] = $conf['cron']['crontab_dir'];
	$tpl_ini_array['web']['security_level'] = 20;
	$tpl_ini_array['web']['user'] = $conf['apache']['user'];
	$tpl_ini_array['web']['group'] = $conf['apache']['group'];
	$tpl_ini_array['web']['php_ini_path_apache'] = $conf['apache']['php_ini_path_apache'];
	$tpl_ini_array['web']['php_ini_path_cgi'] = $conf['apache']['php_ini_path_cgi'];
	$tpl_ini_array['mail']['pop3_imap_daemon'] = ($conf['dovecot']['installed'] == true)?'dovecot':'courier';
	$tpl_ini_array['mail']['mail_filter_syntax'] = ($conf['dovecot']['installed'] == true)?'sieve':'maildrop';
	$tpl_ini_array['dns']['bind_user'] = $conf['bind']['bind_user'];
	$tpl_ini_array['dns']['bind_group'] = $conf['bind']['bind_group'];
	$tpl_ini_array['dns']['bind_zonefiles_dir'] = $conf['bind']['bind_zonefiles_dir'];
	$tpl_ini_array['dns']['named_conf_path'] = $conf['bind']['named_conf_path'];
	$tpl_ini_array['dns']['named_conf_local_path'] = $conf['bind']['named_conf_local_path'];
340

341 342 343 344 345 346 347 348 349 350
	$tpl_ini_array['web']['nginx_vhost_conf_dir'] = $conf['nginx']['vhost_conf_dir'];
	$tpl_ini_array['web']['nginx_vhost_conf_enabled_dir'] = $conf['nginx']['vhost_conf_enabled_dir'];
	$tpl_ini_array['web']['nginx_user'] = $conf['nginx']['user'];
	$tpl_ini_array['web']['nginx_group'] = $conf['nginx']['group'];
	$tpl_ini_array['web']['nginx_cgi_socket'] = $conf['nginx']['cgi_socket'];
	$tpl_ini_array['web']['php_fpm_init_script'] = $conf['nginx']['php_fpm_init_script'];
	$tpl_ini_array['web']['php_fpm_ini_path'] = $conf['nginx']['php_fpm_ini_path'];
	$tpl_ini_array['web']['php_fpm_pool_dir'] = $conf['nginx']['php_fpm_pool_dir'];
	$tpl_ini_array['web']['php_fpm_start_port'] = $conf['nginx']['php_fpm_start_port'];
	$tpl_ini_array['web']['php_fpm_socket_dir'] = $conf['nginx']['php_fpm_socket_dir'];
351

352 353 354 355
	if ($conf['nginx']['installed'] == true) {
		$tpl_ini_array['web']['server_type'] = 'nginx';
		$tpl_ini_array['global']['webserver'] = 'nginx';
	}
356

357
	//* update the new template with the old values
358 359 360 361 362 363 364 365 366
	if(is_array($old_ini_array)) {
		foreach($old_ini_array as $tmp_section_name => $tmp_section_content) {
			foreach($tmp_section_content as $tmp_var_name => $tmp_var_content) {
				$tpl_ini_array[$tmp_section_name][$tmp_var_name] = $tmp_var_content;
			}
		}
	}

	$new_ini = array_to_ini($tpl_ini_array);
367 368
	$sql = "UPDATE ?? SET config = ? WHERE server_id = ?";
	$inst->db->query($sql, $conf["mysql"]["database"] . ".server", $new_ini, $conf['server_id']);
369

370
	if($inst->db->dbHost != $inst->dbmaster->dbHost) {
371 372
		$sql = "UPDATE ?? SET config = ? WHERE server_id = ?";
		$inst->dbmaster->query($sql, $conf["mysql"]["master_database"].".server", $new_ini, $conf['server_id']);
373
	}
374 375 376 377 378 379
	unset($old_ini_array);
	unset($tpl_ini_array);
	unset($new_ini);


	//** Update system ini
380
	$tmp_server_rec = $inst->db->queryOneRecord("SELECT config FROM ?? WHERE sysini_id = 1", $conf["mysql"]["database"] . ".sys_ini");
381 382 383 384 385 386 387 388 389 390 391 392 393 394
	$old_ini_array = ini_to_array(stripslashes($tmp_server_rec['config']));
	unset($tmp_server_rec);
	$tpl_ini_array = ini_to_array(rf('tpl/system.ini.master'));

	// update the new template with the old values
	if(is_array($old_ini_array)) {
		foreach($old_ini_array as $tmp_section_name => $tmp_section_content) {
			foreach($tmp_section_content as $tmp_var_name => $tmp_var_content) {
				$tpl_ini_array[$tmp_section_name][$tmp_var_name] = $tmp_var_content;
			}
		}
	}

	$new_ini = array_to_ini($tpl_ini_array);
395
	$tmp = $inst->db->queryOneRecord('SELECT count(sysini_id) as number FROM ?? WHERE 1', $conf["mysql"]["database"] . '.sys_ini');
396
	if($tmp['number'] == 0) {
397
		$inst->db->query("INSERT INTO ?? (sysini_id, config) VALUES (1,?)", $conf["mysql"]["database"] . ".sys_ini", $new_ini);
398
	} else {
399
		$inst->db->query("UPDATE ?? SET config = ? WHERE sysini_id = 1", $conf["mysql"]["database"] . ".sys_ini", $new_ini);
400 401 402 403
	}
	unset($old_ini_array);
	unset($tpl_ini_array);
	unset($new_ini);
404 405

	// Truncate sys_session
406
	$inst->db->query('TRUNCATE ??', $conf['mysql']['database'].'sys_session');
407 408
}

409 410


Marius Cramer's avatar
Marius Cramer committed
411 412 413 414 415 416 417 418
function setDefaultServers(){
	global $inst, $conf;
	
	// clients
	$clients = $inst->db->queryAllRecords("SELECT * FROM ".$conf["mysql"]["database"].".client");
	if(is_array($clients) && !empty($clients)){
		foreach($clients as $client){
			// mailserver
419
			if(trim($client['mail_servers']) == '') $inst->db->query("UPDATE ?? SET mail_servers = ? WHERE client_id = ?", $conf["mysql"]["database"].".client", trim($client['default_mailserver']), $client['client_id']);
Marius Cramer's avatar
Marius Cramer committed
420
			// webserver
421
			if(trim($client['web_servers']) == '') $inst->db->query("UPDATE ?? SET web_servers = ? WHERE client_id = ?", $conf["mysql"]["database"].".client", trim($client['default_webserver']), $client['client_id']);
Marius Cramer's avatar
Marius Cramer committed
422
			// dns server
423
			if(trim($client['dns_servers']) == '') $inst->db->query("UPDATE ?? SET dns_servers = ? WHERE client_id = ?", $conf["mysql"]["database"].".client", trim($client['default_dnsserver']), $client['client_id']);
Marius Cramer's avatar
Marius Cramer committed
424
			// db server
425
			if(trim($client['db_servers']) == '') $inst->db->query("UPDATE ?? SET db_servers = ? WHERE client_id = ?", $conf["mysql"]["database"].".client", trim($client['default_dbserver']), $client['client_id']);
Marius Cramer's avatar
Marius Cramer committed
426 427 428 429 430
		}
	}
	
}

431 432 433 434 435 436 437


/** Checks if a detected service differs from db setup and asks the user what to do
 *	@param $servicename string the name of the Database-Field in "servers" for this service
 *	@param $detected_value boolean The result of service detection
 */
function check_service_config_state($servicename, $detected_value) {
438
	global $current_svc_config, $inst, $conf;
439
	
440 441
	if ($current_svc_config[$servicename] == 1) $current_state = 1;
	else $current_state = 0;
442 443 444

	if ($detected_value) $detected_value = 1;
	else $detected_value = 0;
445 446
	
	if ($detected_value != $current_state) {
447
		$answer = $inst->simple_query('Service \''.$servicename.'\' '.($detected_value ? 'has been' : 'has not been').' detected ('.($current_state ? 'strongly recommended, currently enabled' : 'currently disabled').') do you want to '.($detected_value ? 'enable and configure' : 'disable').' it? ', array('yes', 'no'), ($current_state ? 'yes' : 'no'), 'svc_detect_change_'.$servicename);
448 449
		if ($answer == 'yes') return $detected_value;
		else {
450
			if ($servicename == 'web_server') echo "\033[0;33mWARNING: If ISPConfig-Interface (Webfrontend) is installed on this Server we will configure the Web Server anyways but will not enable it in ISPConfig.\033[0m\n\n";
451 452
			return $current_state;
		}
453 454 455
	} else return $current_state;
}

456
?>