redray

2008-10-25 56dfe60128f99d4199154f7df443723b07c13480

 install/update.php

@@ -28,128 +28,233 @@
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/

/*
   ISPConfig 3 installer.
*/

// Include the library with the basic installer functions
//** ISPConfig 3 installer.
//** The banner on the command line
echo "\n\n".str_repeat('-',80)."\n";
echo " _____ ___________   _____              __ _       
|_   _/  ___| ___ \ /  __ \            / _(_)      
  | | \ `--.| |_/ / | /  \/ ___  _ __ | |_ _  __ _ 
  | |  `--. \  __/  | |    / _ \| '_ \|  _| |/ _` |
 _| |_/\__/ / |     | \__/\ (_) | | | | | | | (_| |
 \___/\____/\_|      \____/\___/|_| |_|_| |_|\__, |
                                              __/ |
                                             |___/ ";
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
//** Include the base class of the installer class
require_once('lib/installer_base.lib.php');

$distname = get_distname();
//** Installer/updater logfile
define('ISPC_LOG_FILE', '/var/log/ispconfig_install.log');

//** Check for ISPConfig 2.x versions
if(is_dir('/root/ispconfig') || is_dir('/home/admispconfig')) {
   die('This software can not be installed on a server wich runs ISPConfig 2.x.');
}

//** Get distribution identifier
$dist = get_distname();

include_once("/usr/local/ispconfig/server/lib/config.inc.php");
$conf_old = $conf;
unset $conf;
unset($conf);

// Include the distribution specific installer class library
// and configuration
include_once('dist/lib/'.$distname.'.lib.php');
include_once('dist/conf/'.$distname.'.conf.php');
if($dist['id'] == '') die('Linux Dustribution or Version not recognized.');

// Set the mysql login information
$conf["mysql_server_host"] = $conf_old["db_host"];
$conf["mysql_server_database"] = $conf_old["db_database"];
$conf["mysql_server_ispconfig_user"] = $conf_old["db_user"];
$conf["mysql_server_ispconfig_password"] = $conf_old["db_password"];
//** Include the distribution specific installer class library and configuration
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"]["ispconfig_user"] = $conf_old["db_user"];
$conf["mysql"]["ispconfig_password"] = $conf_old["db_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'] = $conf_old["server_id"];
$conf['ispconfig_log_priority'] = $conf_old["log_priority"];

$inst = new installer();


echo "This application will update ISPConfig 3 on your server.\n";

// $conf["language"] = $inst->request_language();

// TODO: all other queries, for testing I will setup everything in $conf

// Initialize the MySQL server connection
//** Initialize the MySQL server connection
include_once('lib/mysql.lib.php');

//** Database update is a bit brute force and should be rebuild later ;)

//** Ask user for mysql admin_password if empty
if( empty($conf["mysql"]["admin_password"]) ) {

   $conf["mysql"]["admin_password"] = $inst->free_query('MySQL root password', $conf['mysql']['admin_password']);
}

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

   system("mysqldump -h ".$conf['mysql']['host']." -u ".$conf['mysql']['admin_user']." -p".$conf['mysql']['admin_password']." -c -t --add-drop-table --all --quick ".$conf['mysql']['database']." > existing_db.sql");
}
else {

   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
$inst->db = new db();

// Database update is a bit brute force and should be rebuild later ;)
if( !$inst->db->query('DROP DATABASE IF EXISTS '.$conf['mysql']['database']) ) {

// export the current database data
exec("mysqldump -h $conf[mysql_server_host] -u $conf[mysql_server_ispconfig_user] -p$conf[mysql_server_ispconfig_password] -c -t --add-drop-table --add-locks --all --quick --lock-tables $conf[mysql_server_database] > existing_db.sql  &> /dev/null");
   $inst->error('Unable to drop MySQL database: '.$conf['mysql']['database'].'.');
}

// Delete the old database
exec("/etc/init.d/mysql stop");
exec("rm -rf /var/lib/mysql/".$conf["db_database"]);
exec("/etc/init.d/mysql start");

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

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

foreach($db_tables as $table) {

   $inst->db->query("TRUNCATE $table");
}

// load old data back into database
exec("mysql -h $conf[mysql_server_host] -u $conf[mysql_server_ispconfig_user] -p$conf[mysql_server_ispconfig_password] $conf[mysql_server_database] < existing_db.sql  &> /dev/null");
//** load old data back into database
if( !empty($conf["mysql"]["admin_password"]) ) {

// Configure postfix
$inst->configure_postfix('dont-create-certs');
   system("mysql -h ".$conf['mysql']['host']." -u ".$conf['mysql']['admin_user']." -p".$conf['mysql']['admin_password']." ".$conf['mysql']['database']." < existing_db.sql");
} else {

// Configure saslauthd
swriteln('Configuring SASL');
$inst->configure_saslauthd();
   system("mysql -h ".$conf['mysql']['host']." -u ".$conf['mysql']['admin_user']." ".$conf['mysql']['database']." < existing_db.sql");
}

//** 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
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);


// Configure PAM
swriteln('Configuring PAM');
$inst->configure_pam();
//** Shall the services be reconfigured during update
$reconfigure_services_answer = $inst->simple_query('Reconfigure Services?', array('yes','no'),'yes');

// Configure courier
swriteln('Configuring Courier');
$inst->configure_courier();
if($reconfigure_services_answer == 'yes') {
   //** Configure postfix
   $inst->configure_postfix('dont-create-certs');
	
   //* Configure postfix
   swriteln('Configuring Jailkit');
   $inst->configure_jailkit();
	
   //** Configure saslauthd
   swriteln('Configuring SASL');
   $inst->configure_saslauthd();
	
   //** Configure PAM
   swriteln('Configuring PAM');
   $inst->configure_pam();

// Configure Spamasassin
swriteln('Configuring Spamassassin');
$inst->configure_spamassassin();
   //** Configure courier
   swriteln('Configuring Courier');
   $inst->configure_courier();

// Configure Amavis
swriteln('Configuring Amavisd');
$inst->configure_amavis();
   //** Configure Spamasassin
   swriteln('Configuring Spamassassin');
   $inst->configure_spamassassin();

// Configure Getmail
swriteln('Configuring Getmail');
$inst->configure_getmail();
   //** Configure Amavis
   swriteln('Configuring Amavisd');
   $inst->configure_amavis();

// Configure Getmail
swriteln('Configuring Pureftpd');
$inst->configure_pureftpd();
   //** Configure Getmail
   swriteln('Configuring Getmail');
   $inst->configure_getmail();

// Configure ISPConfig
swriteln('Installing ISPConfig');
   //** Configure Pureftpd
   swriteln('Configuring Pureftpd');
   $inst->configure_pureftpd();

   //** Configure MyDNS
   swriteln('Configuring MyDNS');
   $inst->configure_mydns();

   //** Configure Apache
   swriteln('Configuring Apache');
   $inst->configure_apache();
	
   //* Configure DBServer
   swriteln('Configuring DBServer');
   $inst->configure_dbserver();
	
   //if(@is_dir('/etc/Bastille')) {
      //* Configure Firewall
      swriteln('Configuring Firewall');
      $inst->configure_firewall();
   //}
}

//** Configure ISPConfig
swriteln('Updating ISPConfig');


//** Customise the port ISPConfig runs on
$conf['apache']['vhost_port'] = $inst->free_query('ISPConfig Port', '8080');

$inst->install_ispconfig();

// Configure ISPConfig
swriteln('Installing Crontab');
$inst->install_crontab();
//** Configure Crontab
$update_crontab_answer = $inst->simple_query('Reconfigure Crontab?', array('yes','no'),'yes');
if($update_crontab_answer == 'yes') {
   swriteln('Updating Crontab');
   $inst->install_crontab();
}


/*
Restart services:
*/

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");
//** Restart services:
if($reconfigure_services_answer == 'yes') {
   swriteln('Restarting services ...');
   system($conf['init_scripts'].'/'.$conf['mysql']['init_script'].' restart');
   system($conf['init_scripts'].'/'.$conf['postfix']['init_script'].' restart');
   system($conf['init_scripts'].'/'.$conf['saslauthd']['init_script'].' restart');
   system($conf['init_scripts'].'/'.$conf['amavis']['init_script'].' restart');
   system($conf['init_scripts'].'/'.$conf['clamav']['init_script'].' restart');
   system($conf['init_scripts'].'/'.$conf['courier']['courier-authdaemon'].' restart');
   system($conf['init_scripts'].'/'.$conf['courier']['courier-imap'].' restart');
   system($conf['init_scripts'].'/'.$conf['courier']['courier-imap-ssl'].' restart');
   system($conf['init_scripts'].'/'.$conf['courier']['courier-pop'].' restart');
   system($conf['init_scripts'].'/'.$conf['courier']['courier-pop-ssl'].' restart');
   system($conf['init_scripts'].'/'.$conf['apache']['init_script'].' restart');
   system($conf['init_scripts'].'/'.$conf['pureftpd']['init_script'].' restart');
   system($conf['init_scripts'].'/'.$conf['mydns']['init_script'].' restart &> /dev/null');
}

echo "Update finished.\n";


?>
?>