add mail-backup

Florian Schaal

2014-01-04 f17718f87dd8604e0b6ead593861bc9643ce2f05

 server/plugins-available/backup_plugin.inc.php

@@ -51,17 +51,18 @@
      global $app;

      //* Register for actions
      $app->plugins->registerAction('backup_download',$this->plugin_name,'backup_action');
      $app->plugins->registerAction('backup_restore',$this->plugin_name,'backup_action');
      $app->plugins->registerAction('backup_download', $this->plugin_name, 'backup_action');
      $app->plugins->registerAction('backup_restore', $this->plugin_name, 'backup_action');

   }

   //* Do a backup action
   public function backup_action($action_name,$data) {
      global $app,$conf;
   public function backup_action($action_name, $data) {
      global $app, $conf;

      $backup_id = intval($data);
      $backup = $app->dbmaster->queryOneRecord("SELECT * FROM web_backup WHERE backup_id = $backup_id");
      $mail_backup = $app->dbmaster->queryOneRecord("SELECT * FROM mail_backup WHERE backup_id = $backup_id");

      if(is_array($backup)) {

@@ -74,10 +75,10 @@
         //* Make backup available for download
         if($action_name == 'backup_download') {
            //* Copy the backup file to the backup folder of the website
            if(file_exists($backup_dir.'/'.$backup['filename']) && !stristr($backup_dir.'/'.$backup['filename'],'..') && !stristr($backup_dir.'/'.$backup['filename'],'etc')) {
               copy($backup_dir.'/'.$backup['filename'],$web['document_root'].'/backup/'.$backup['filename']);
               chgrp($web['document_root'].'/backup/'.$backup['filename'],$web['system_group']);
               $app->log('cp '.$backup_dir.'/'.$backup['filename'].' '.$web['document_root'].'/backup/'.$backup['filename'],LOGLEVEL_DEBUG);
            if(file_exists($backup_dir.'/'.$backup['filename']) && !stristr($backup_dir.'/'.$backup['filename'], '..') && !stristr($backup_dir.'/'.$backup['filename'], 'etc')) {
               copy($backup_dir.'/'.$backup['filename'], $web['document_root'].'/backup/'.$backup['filename']);
               chgrp($web['document_root'].'/backup/'.$backup['filename'], $web['system_group']);
               $app->log('cp '.$backup_dir.'/'.$backup['filename'].' '.$web['document_root'].'/backup/'.$backup['filename'], LOGLEVEL_DEBUG);
            }
         }

@@ -104,13 +105,13 @@
            unset($clientdb_host);
            unset($clientdb_user);
            unset($clientdb_password);
            $app->log('Restored MongoDB backup '.$backup_dir.'/'.$backup['filename'],LOGLEVEL_DEBUG);
            $app->log('Restored MongoDB backup '.$backup_dir.'/'.$backup['filename'], LOGLEVEL_DEBUG);
         }

         //* Restore a mysql backup
         if($action_name == 'backup_restore' && $backup['backup_type'] == 'mysql') {
            //* Load sql dump into db
            include('lib/mysql_clientdb.conf');
            include 'lib/mysql_clientdb.conf';

            if(file_exists($backup_dir.'/'.$backup['filename'])) {
               //$parts = explode('_',$backup['filename']);
@@ -123,33 +124,73 @@
            unset($clientdb_host);
            unset($clientdb_user);
            unset($clientdb_password);
            $app->log('Restored MySQL backup '.$backup_dir.'/'.$backup['filename'],LOGLEVEL_DEBUG);
            $app->log('Restored MySQL backup '.$backup_dir.'/'.$backup['filename'], LOGLEVEL_DEBUG);
         }

         //* Restore a web backup
         if($action_name == 'backup_restore' && $backup['backup_type'] == 'web') {
            if($backup['backup_mode'] == 'userzip') {
               if(file_exists($backup_dir.'/'.$backup['filename']) && $web['document_root'] != '' && $web['document_root'] != '/' && !stristr($backup_dir.'/'.$backup['filename'],'..') && !stristr($backup_dir.'/'.$backup['filename'],'etc')) {
                  if(file_exists($web['document_root'].'/backup/'.$backup['filename'])) rename($web['document_root'].'/backup/'.$backup['filename'],$web['document_root'].'/backup/'.$backup['filename'].'.bak');
                  copy($backup_dir.'/'.$backup['filename'],$web['document_root'].'/backup/'.$backup['filename']);
                  chgrp($web['document_root'].'/backup/'.$backup['filename'],$web['system_group']);
               if(file_exists($backup_dir.'/'.$backup['filename']) && $web['document_root'] != '' && $web['document_root'] != '/' && !stristr($backup_dir.'/'.$backup['filename'], '..') && !stristr($backup_dir.'/'.$backup['filename'], 'etc')) {
                  if(file_exists($web['document_root'].'/backup/'.$backup['filename'])) rename($web['document_root'].'/backup/'.$backup['filename'], $web['document_root'].'/backup/'.$backup['filename'].'.bak');
                  copy($backup_dir.'/'.$backup['filename'], $web['document_root'].'/backup/'.$backup['filename']);
                  chgrp($web['document_root'].'/backup/'.$backup['filename'], $web['system_group']);
                  //chown($web['document_root'].'/backup/'.$backup['filename'],$web['system_user']);
                  $command = 'sudo -u '.escapeshellarg($web['system_user']).' unzip -qq -o  '.escapeshellarg($web['document_root'].'/backup/'.$backup['filename']).' -d '.escapeshellarg($web['document_root']).' 2> /dev/null';
                  exec($command);
                  unlink($web['document_root'].'/backup/'.$backup['filename']);
                  if(file_exists($web['document_root'].'/backup/'.$backup['filename'].'.bak')) rename($web['document_root'].'/backup/'.$backup['filename'].'.bak',$web['document_root'].'/backup/'.$backup['filename']);
                  $app->log('Restored Web backup '.$backup_dir.'/'.$backup['filename'],LOGLEVEL_DEBUG);
                  if(file_exists($web['document_root'].'/backup/'.$backup['filename'].'.bak')) rename($web['document_root'].'/backup/'.$backup['filename'].'.bak', $web['document_root'].'/backup/'.$backup['filename']);
                  $app->log('Restored Web backup '.$backup_dir.'/'.$backup['filename'], LOGLEVEL_DEBUG);
               }
            }
            if($backup['backup_mode'] == 'rootgz') {
               if(file_exists($backup_dir.'/'.$backup['filename']) && $web['document_root'] != '' && $web['document_root'] != '/' && !stristr($backup_dir.'/'.$backup['filename'],'..') && !stristr($backup_dir.'/'.$backup['filename'],'etc')) {
               if(file_exists($backup_dir.'/'.$backup['filename']) && $web['document_root'] != '' && $web['document_root'] != '/' && !stristr($backup_dir.'/'.$backup['filename'], '..') && !stristr($backup_dir.'/'.$backup['filename'], 'etc')) {
                  $command = 'tar xzf '.escapeshellarg($backup_dir.'/'.$backup['filename']).' --directory '.escapeshellarg($web['document_root']);
                  exec($command);
                  $app->log('Restored Web backup '.$backup_dir.'/'.$backup['filename'],LOGLEVEL_DEBUG);
                  $app->log('Restored Web backup '.$backup_dir.'/'.$backup['filename'], LOGLEVEL_DEBUG);
               }
            }
         }
      //* Restore a mail backup - florian@schaal-24.de
      } elseif (is_array($mail_backup) && $action_name == 'backup_restore') {
         $app->uses('ini_parser,file,getconf');

         $server_config = $app->getconf->get_server_config($conf['server_id'], 'server');
         $mail_config = $app->getconf->get_server_config($conf['server_id'], 'mail');

         $domain_rec = $app->db->queryOneRecord("SELECT * FROM mail_domain WHERE domain_id = ".intval($mail_backup['parent_domain_id']));

         $backup_dir = $server_config['backup_dir'].'/mail'.$domain_rec['domain_id'];
         $mail_backup_file = $backup_dir.'/'.$mail_backup['filename'];

         $sql = "SELECT * FROM mail_user WHERE server_id = '".$conf['server_id']."' AND mailuser_id = ".intval($mail_backup['mailuser_id']);
         $record = $app->db->queryOneRecord($sql);

         //* strip mailbox from maildir
         $domain_dir=explode('/',$record['maildir']);
         $_temp=array_pop($domain_dir);unset($_temp);
         $domain_dir=implode('/',$domain_dir);
         if(file_exists($mail_backup_file) && $record['homedir'] != '' && $record['homedir'] != '/' && !stristr($mail_backup_file,'..') && !stristr($mail_backup_file,'etc') && $mail_config['homedir_path'] == $record['homedir'] && is_dir($domain_dir)) {
            if($mail_backup['backup_mode'] == 'userzip') {
               $command = 'sudo -u '.$mail_config['mailuser_name'].' unzip -qq -o  '.escapeshellarg($mail_backup_file).' -d '.escapeshellarg($domain_dir).' 2> /dev/null';
               exec($command,$tmp_output, $retval);
               if($retval == 0){
                  $app->log('Restored Mail backup '.$mail_backup_file,LOGLEVEL_DEBUG);
               } else {
                  $app->log('Unable to restore Mail backup '.$mail_backup_file.' '.$tmp_output,LOGLEVEL_ERROR);
               }
            }
            if($mail_backup['backup_mode'] == 'rootgz') {
               $command='tar xfz '.escapeshellarg($mail_backup_file).' --directory '.escapeshellarg($domain_dir);
               exec($command,$tmp_output, $retval);
               if($retval == 0){
                  $app->log('Restored Mail backup '.$mail_backup_file,LOGLEVEL_DEBUG);
               } else {
                  $app->log('Unable to restore Mail backup '.$mail_backup_file.' '.$tmp_output,LOGLEVEL_ERROR);
               }
            }
         } else {
            $app->log('Unable to restore Mail backup '.$mail_backup_file.' due to misconfiguration',LOGLEVEL_ERROR);
         }
      } else {
         $app->log('No backup with ID '.$backup_id.' found.',LOGLEVEL_DEBUG);
      }
@@ -159,4 +200,5 @@

} // end class

?>
?>