From f28f40f7a62b9a6fe939c05b10366b0d66c9ec1e Mon Sep 17 00:00:00 2001 From: tbrehm <t.brehm@ispconfig.org> Date: Fri, 27 Feb 2009 12:50:34 -0500 Subject: [PATCH] Fixed amavisd socket path. --- install/update.php | 252 +++++++++++++++++++++++++++++++++++++------------- 1 files changed, 185 insertions(+), 67 deletions(-) diff --git a/install/update.php b/install/update.php index 3c8c936..496f16f 100644 --- a/install/update.php +++ b/install/update.php @@ -28,8 +28,12 @@ EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. */ +/* + ISPConfig 3 updater. +*/ -//** ISPConfig 3 installer. +error_reporting(E_ALL|E_STRICT); + //** The banner on the command line echo "\n\n".str_repeat('-',80)."\n"; echo " _____ ___________ _____ __ _ @@ -43,15 +47,15 @@ echo "\n".str_repeat('-',80)."\n"; echo "\n\n>> Update \n\n"; - //** Include the library with the basic installer functions require_once('lib/install.lib.php'); //** Include the base class of the installer class require_once('lib/installer_base.lib.php'); -//** Installer/updater logfile +//** Install logfile define('ISPC_LOG_FILE', '/var/log/ispconfig_install.log'); +define('ISPC_INSTALL_ROOT', realpath(dirname(__FILE__).'/../')); //** Check for ISPConfig 2.x versions if(is_dir('/root/ispconfig') || is_dir('/home/admispconfig')) { @@ -59,23 +63,48 @@ } //** Get distribution identifier -$distname = get_distname(); +$dist = get_distname(); include_once("/usr/local/ispconfig/server/lib/config.inc.php"); $conf_old = $conf; unset($conf); +if($dist['id'] == '') die('Linux Dustribution or Version not recognized.'); + //** Include the distribution specific installer class library and configuration -include_once('dist/lib/'.$distname.'.lib.php'); -include_once('dist/conf/'.$distname.'.conf.php'); +if(is_file('dist/lib/'.$dist['baseid'].'.lib.php')) include_once('dist/lib/'.$dist['baseid'].'.lib.php'); +include_once('dist/lib/'.$dist['id'].'.lib.php'); +include_once('dist/conf/'.$dist['id'].'.conf.php'); + +//** Get hostname +exec('hostname -f', $tmp_out); +$conf['hostname'] = $tmp_out[0]; +unset($tmp_out); + //** Set the mysql login information $conf["mysql"]["host"] = $conf_old["db_host"]; $conf["mysql"]["database"] = $conf_old["db_database"]; +$conf['mysql']['charset'] = 'utf8'; $conf["mysql"]["ispconfig_user"] = $conf_old["db_user"]; $conf["mysql"]["ispconfig_password"] = $conf_old["db_password"]; +if(isset($conf_old["dbmaster_host"])) $conf["mysql"]["master_host"] = $conf_old["dbmaster_host"]; +if(isset($conf_old["dbmaster_database"])) $conf["mysql"]["master_database"] = $conf_old["dbmaster_database"]; +if(isset($conf_old["dbmaster_user"])) $conf["mysql"]["master_ispconfig_user"] = $conf_old["dbmaster_user"]; +if(isset($conf_old["dbmaster_password"])) $conf["mysql"]["master_ispconfig_password"] = $conf_old["dbmaster_password"]; + +// Resolve the IP address of the mysql hostname. +if(!$conf['mysql']['ip'] = gethostbyname($conf['mysql']['host'])) die('Unable to resolve hostname'.$conf['mysql']['host']); + +$conf['server_id'] = intval($conf_old["server_id"]); +$conf['ispconfig_log_priority'] = $conf_old["log_priority"]; + $inst = new installer(); +$inst->is_update = true; + +//** Detect the installed applications +$inst->find_installed_apps(); echo "This application will update ISPConfig 3 on your server.\n"; @@ -100,9 +129,23 @@ system("mysqldump -h ".$conf['mysql']['host']." -u ".$conf['mysql']['admin_user']." -c -t --add-drop-table --all --quick ".$conf['mysql']['database']." > existing_db.sql"); } -//** Delete the old database + +//* initialize the database $inst->db = new db(); +//* Update $conf array with values from the server.ini that shall be preserved +$tmp = $inst->db->queryOneRecord("SELECT * FROM ".$conf["mysql"]["database"].".server WHERE server_id = ".$conf['server_id']); +$ini_array = ini_to_array(stripslashes($tmp['config'])); + +$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['postfix']['vmail_mailbox_base'] = $ini_array['mail']['homedir_path']; + +//** Delete the old database if( !$inst->db->query('DROP DATABASE IF EXISTS '.$conf['mysql']['database']) ) { $inst->error('Unable to drop MySQL database: '.$conf['mysql']['database'].'.'); @@ -122,75 +165,144 @@ //** load old data back into database if( !empty($conf["mysql"]["admin_password"]) ) { - system("mysql -h ".$conf['mysql']['host']." -u ".$conf['mysql']['admin_user']." -p".$conf['mysql']['admin_password']." ".$conf['mysql']['database']." < existing_db.sql"); + system("mysql --default-character-set=".$conf['mysql']['charset']." -h ".$conf['mysql']['host']." -u ".$conf['mysql']['admin_user']." -p".$conf['mysql']['admin_password']." ".$conf['mysql']['database']." < existing_db.sql"); } else { - system("mysql -h ".$conf['mysql']['host']." -u ".$conf['mysql']['admin_user']." ".$conf['mysql']['database']." < existing_db.sql"); + system("mysql --default-character-set=".$conf['mysql']['charset']." -h ".$conf['mysql']['host']." -u ".$conf['mysql']['admin_user']." ".$conf['mysql']['database']." < existing_db.sql"); } + +// create a backup copy of the ispconfig database in the root folder +$backup_db_name = '/root/ispconfig_db_backup_'.@date('Y-m-d_h-i').'.sql'; +copy('existing_db.sql',$backup_db_name); +exec("chmod 700 $backup_db_name"); +exec("chown root:root $backup_db_name"); + + +//** Update server ini +$tmp_server_rec = $inst->db->queryOneRecord("SELECT config FROM server WHERE server_id = ".$conf['server_id']); +$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')); + +// 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); +$inst->db->query("UPDATE server SET config = '".mysql_real_escape_string($new_ini)."' WHERE server_id = ".$conf['server_id']); +unset($old_ini_array); +unset($tpl_ini_array); +unset($new_ini); + + +//** Update system ini +$tmp_server_rec = $inst->db->queryOneRecord("SELECT config FROM sys_ini WHERE sysini_id = 1"); +$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); +$tmp = $inst->db->queryOneRecord('SELECT count(sysini_id) as number FROM sys_ini WHERE 1'); +if($tmp['number'] == 0) { + $inst->db->query("INSERT INTO sys_ini (sysini_id, config) VALUES (1,'".mysql_real_escape_string($new_ini)."')"); +} else { + $inst->db->query("UPDATE sys_ini SET config = '".mysql_real_escape_string($new_ini)."' WHERE sysini_id = 1"); +} +unset($old_ini_array); +unset($tpl_ini_array); +unset($new_ini); + //** Shall the services be reconfigured during update $reconfigure_services_answer = $inst->simple_query('Reconfigure Services?', array('yes','no'),'yes'); if($reconfigure_services_answer == 'yes') { - //** Configure postfix - $inst->configure_postfix('dont-create-certs'); - - //** Configure saslauthd - swriteln('Configuring SASL'); - $inst->configure_saslauthd(); - //** Configure PAM - swriteln('Configuring PAM'); - $inst->configure_pam(); + if($conf['services']['mail']) { + //** Configure postfix + swriteln('Configuring Postfix'); + $inst->configure_postfix('dont-create-certs'); + + //* Configure Jailkit + swriteln('Configuring Jailkit'); + $inst->configure_jailkit(); + + //** Configure saslauthd + swriteln('Configuring SASL'); + $inst->configure_saslauthd(); + + //** Configure PAM + swriteln('Configuring PAM'); + $inst->configure_pam(); - //** Configure courier - swriteln('Configuring Courier'); - $inst->configure_courier(); + //** Configure courier + swriteln('Configuring Courier'); + $inst->configure_courier(); - //** Configure Spamasassin - swriteln('Configuring Spamassassin'); - $inst->configure_spamassassin(); + //** Configure Spamasassin + swriteln('Configuring Spamassassin'); + $inst->configure_spamassassin(); - //** Configure Amavis - swriteln('Configuring Amavisd'); - $inst->configure_amavis(); + //** Configure Amavis + swriteln('Configuring Amavisd'); + $inst->configure_amavis(); - //** Configure Getmail - swriteln('Configuring Getmail'); - $inst->configure_getmail(); + //** Configure Getmail + swriteln('Configuring Getmail'); + $inst->configure_getmail(); + } + + if($conf['services']['web']) { + //** Configure Pureftpd + swriteln('Configuring Pureftpd'); + $inst->configure_pureftpd(); + } + + if($conf['services']['dns']) { + //** Configure MyDNS + swriteln('Configuring MyDNS'); + $inst->configure_mydns(); + } + + if($conf['services']['web']) { + //** Configure Apache + swriteln('Configuring Apache'); + $inst->configure_apache(); + } + - //** Configure Pureftpd - swriteln('Configuring Pureftpd'); - $inst->configure_pureftpd(); + //* Configure DBServer + swriteln('Configuring Database'); + $inst->configure_dbserver(); - //** Configure MyDNS - swriteln('Configuring MyDNS'); - $inst->configure_mydns(); - - //** Configure Apache - swriteln('Configuring Apache'); - $inst->configure_apache(); + + //if(@is_dir('/etc/Bastille')) { + //* Configure Firewall + swriteln('Configuring Firewall'); + $inst->configure_firewall(); + //} } //** Configure ISPConfig swriteln('Updating ISPConfig'); -//** We want to check if the server is a module or cgi based php enabled server -//** TODO: Don't always ask for this somehow ? -$fast_cgi = $inst->simple_query('CGI PHP Enabled Server?', array('yes','no'),'no'); - -if($fast_cgi == 'yes') { - $alias = $inst->free_query('Script Alias', '/php/'); - $path = $inst->free_query('Script Alias Path', '/path/to/cgi/bin'); - $inst->conf['apache']['vhost_cgi_alias'] = sprintf('ScriptAlias %s %s', $alias, $path); -} else { - $inst->conf['apache']['vhost_cgi_alias'] = ""; -} - - //** Customise the port ISPConfig runs on -$inst->conf['apache']['vhost_port'] = $inst->free_query('ISPConfig Port', '8080'); +$conf['apache']['vhost_port'] = $inst->free_query('ISPConfig Port', '8080'); $inst->install_ispconfig(); @@ -204,19 +316,25 @@ //** Restart services: if($reconfigure_services_answer == 'yes') { swriteln('Restarting services ...'); - system("/etc/init.d/mysql restart"); - system("/etc/init.d/postfix restart"); - system("/etc/init.d/saslauthd restart"); - system("/etc/init.d/amavis restart"); - system("/etc/init.d/clamav-daemon restart"); - system("/etc/init.d/courier-authdaemon restart"); - system("/etc/init.d/courier-imap restart"); - system("/etc/init.d/courier-imap-ssl restart"); - system("/etc/init.d/courier-pop restart"); - system("/etc/init.d/courier-pop-ssl restart"); - system("/etc/init.d/apache2 restart"); - system("/etc/init.d/pure-ftpd-mysql restart"); - system("/etc/init.d/mydns restart"); + if($conf['mysql']['init_script'] != '' && is_file($conf['init_scripts'].'/'.$conf['mysql']['init_script'])) system($conf['init_scripts'].'/'.$conf['mysql']['init_script'].' restart'); + if($conf['services']['mail']) { + if($conf['postfix']['init_script'] != '' && is_file($conf['init_scripts'].'/'.$conf['postfix']['init_script'])) system($conf['init_scripts'].'/'.$conf['postfix']['init_script'].' restart'); + if($conf['saslauthd']['init_script'] != '' && is_file($conf['init_scripts'].'/'.$conf['saslauthd']['init_script'])) system($conf['init_scripts'].'/'.$conf['saslauthd']['init_script'].' restart'); + if($conf['amavis']['init_script'] != '' && is_file($conf['init_scripts'].'/'.$conf['amavis']['init_script'])) system($conf['init_scripts'].'/'.$conf['amavis']['init_script'].' restart'); + if($conf['clamav']['init_script'] != '' && is_file($conf['init_scripts'].'/'.$conf['clamav']['init_script'])) system($conf['init_scripts'].'/'.$conf['clamav']['init_script'].' restart'); + if($conf['courier']['courier-authdaemon'] != '' && is_file($conf['init_scripts'].'/'.$conf['courier']['courier-authdaemon'])) system($conf['init_scripts'].'/'.$conf['courier']['courier-authdaemon'].' restart'); + if($conf['courier']['courier-imap'] != '' && is_file($conf['init_scripts'].'/'.$conf['courier']['courier-imap'])) system($conf['init_scripts'].'/'.$conf['courier']['courier-imap'].' restart'); + if($conf['courier']['courier-imap-ssl'] != '' && is_file($conf['init_scripts'].'/'.$conf['courier']['courier-imap-ssl'])) system($conf['init_scripts'].'/'.$conf['courier']['courier-imap-ssl'].' restart'); + if($conf['courier']['courier-pop'] != '' && is_file($conf['init_scripts'].'/'.$conf['courier']['courier-pop'])) system($conf['init_scripts'].'/'.$conf['courier']['courier-pop'].' restart'); + if($conf['courier']['courier-pop-ssl'] != '' && is_file($conf['init_scripts'].'/'.$conf['courier']['courier-pop-ssl'])) system($conf['init_scripts'].'/'.$conf['courier']['courier-pop-ssl'].' restart'); + } + if($conf['services']['web']) { + if($conf['apache']['init_script'] != '' && is_file($conf['init_scripts'].'/'.$conf['apache']['init_script'])) system($conf['init_scripts'].'/'.$conf['apache']['init_script'].' restart'); + if($conf['pureftpd']['init_script'] != '' && is_file($conf['init_scripts'].'/'.$conf['pureftpd']['init_script'])) system($conf['init_scripts'].'/'.$conf['pureftpd']['init_script'].' restart'); + } + if($conf['services']['dns']) { + if($conf['mydns']['init_script'] != '' && is_file($conf['init_scripts'].'/'.$conf['mydns']['init_script'])) system($conf['init_scripts'].'/'.$conf['mydns']['init_script'].' restart &> /dev/null'); + } } echo "Update finished.\n"; -- Gitblit v1.9.1