Merge branch 'master' into 'master'
Master
See merge request !138
| | |
| | | echo "<privatekey>".$private_key."</privatekey>\n"; |
| | | echo "<publickey>".$public_key."</publickey>\n"; |
| | | if ( validate_domain($_POST['domain']) ) { |
| | | echo '<dns_record>'.$selector.'_domainkey.'.$_POST['domain'].'. 3600 TXT "v=DKIM1; t=s; p='.$dns_record.'"</dns_record>'; |
| | | echo '<dns_record>'.$selector.'._domainkey.'.$_POST['domain'].'. 3600 TXT "v=DKIM1; t=s; p='.$dns_record.'"</dns_record>'; |
| | | } |
| | | echo "</formatname>\n"; |
| | | ?> |
| | |
| | | } else { |
| | | chmod(escapeshellcmd($backup_dir), $backup_dir_permissions); |
| | | } |
| | | |
| | | //* mount backup directory, if necessary |
| | | $run_backups = true; |
| | | $server_config['backup_dir_mount_cmd'] = trim($server_config['backup_dir_mount_cmd']); |
| | | if($server_config['backup_dir_is_mount'] == 'y' && $server_config['backup_dir_mount_cmd'] != ''){ |
| | | if(!$app->system->is_mounted($backup_dir)){ |
| | | exec(escapeshellcmd($server_config['backup_dir_mount_cmd'])); |
| | | sleep(1); |
| | | if(!$app->system->is_mounted($backup_dir)) $run_backups = false; |
| | | } |
| | | } |
| | | |
| | | //* mount backup directory, if necessary |
| | | if( $server_config['backup_dir_is_mount'] == 'y' && !$app->system->mount_backup_dir($backup_dir) ) $run_backups = false; |
| | | if($run_backups){ |
| | | //* backup only active domains |
| | | $sql = "SELECT * FROM web_domain WHERE server_id = '".$conf['server_id']."' AND (type = 'vhost' OR type = 'vhostsubdomain' OR type = 'vhostalias') AND active = 'y'"; |
| | | $records = $app->db->queryAllRecords($sql); |
| | | $sql = "SELECT * FROM web_domain WHERE server_id = ? AND (type = 'vhost' OR type = 'vhostsubdomain' OR type = 'vhostalias') AND active = 'y'"; |
| | | $records = $app->db->queryAllRecords($sql, $conf['server_id']); |
| | | if(is_array($records)) { |
| | | foreach($records as $rec) { |
| | | |
| | |
| | | //* Insert web backup record in database |
| | | //$insert_data = "(server_id,parent_domain_id,backup_type,backup_mode,tstamp,filename) VALUES (".$conf['server_id'].",".$web_id.",'web','".$backup_mode."',".time().",'".$app->db->quote($web_backup_file)."')"; |
| | | //$app->dbmaster->datalogInsert('web_backup', $insert_data, 'backup_id'); |
| | | $sql = "INSERT INTO web_backup (server_id,parent_domain_id,backup_type,backup_mode,tstamp,filename) VALUES (".$conf['server_id'].",".$web_id.",'web','".$backup_mode."',".time().",'".$app->db->quote($web_backup_file)."')"; |
| | | $app->db->query($sql); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql); |
| | | $filesize = $app->functions->formatBytes(filesize($web_backup_dir.'/'.$web_backup_file)); |
| | | $sql = "INSERT INTO web_backup (server_id, parent_domain_id, backup_type, backup_mode, tstamp, filename, filesize) VALUES (?, ?, ?, ?, ?, ?, ?)"; |
| | | $app->db->query($sql, $conf['server_id'], $web_id, 'web', $backup_mode, time(), $web_backup_file, $filesize); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) |
| | | $app->dbmaster->query($sql, $conf['server_id'], $web_id, 'web', $backup_mode, time(), $web_backup_file, $filesize); |
| | | unset($filesize); |
| | | } |
| | | } else { |
| | | if(is_file($web_backup_dir.'/'.$web_backup_file)) unlink($web_backup_dir.'/'.$web_backup_file); |
| | |
| | | //$tmp = $app->dbmaster->queryOneRecord($sql); |
| | | //$app->dbmaster->datalogDelete('web_backup', 'backup_id', $tmp['backup_id']); |
| | | //$sql = "DELETE FROM web_backup WHERE backup_id = ".intval($tmp['backup_id']); |
| | | $sql = "DELETE FROM web_backup WHERE server_id = ".$conf['server_id']." AND parent_domain_id = $web_id AND filename = '".$app->db->quote($files[$n])."'"; |
| | | $app->db->query($sql); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql); |
| | | $sql = "DELETE FROM web_backup WHERE server_id = ? AND parent_domain_id = ? AND filename = ?"; |
| | | $app->db->query($sql, $conf['server_id'], $web_id, $files[$n]); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql, $conf['server_id'], $web_id, $files[$n]); |
| | | } |
| | | } |
| | | |
| | |
| | | $web_backup_dir = realpath($backup_dir.'/web'.$web_id); |
| | | if(is_dir($web_backup_dir)) { |
| | | exec('sudo -u '.escapeshellarg($web_user).' rm -f '.escapeshellarg($web_backup_dir.'/*')); |
| | | $sql = "DELETE FROM web_backup WHERE server_id = ".intval($conf['server_id'])." AND parent_domain_id = ".intval($web_id); |
| | | $app->db->query($sql); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql); |
| | | $sql = "DELETE FROM web_backup WHERE server_id = ? AND parent_domain_id = ?"; |
| | | $app->db->query($sql, $conf['server_id'], $web_id); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql, $conf['server_id'], $web_id); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | $sql = "SELECT * FROM web_database WHERE server_id = ".$conf['server_id']." AND backup_interval != 'none' AND backup_interval != ''"; |
| | | $records = $app->db->queryAllRecords($sql); |
| | | $records = $app->db->queryAllRecords("SELECT * FROM web_database WHERE server_id = ? AND backup_interval != 'none' AND backup_interval != ''", $conf['server_id']); |
| | | if(is_array($records)) { |
| | | |
| | | include 'lib/mysql_clientdb.conf'; |
| | |
| | | //* Insert web backup record in database |
| | | //$insert_data = "(server_id,parent_domain_id,backup_type,backup_mode,tstamp,filename) VALUES (".$conf['server_id'].",$web_id,'mysql','sqlgz',".time().",'".$app->db->quote($db_backup_file).".gz')"; |
| | | //$app->dbmaster->datalogInsert('web_backup', $insert_data, 'backup_id'); |
| | | $sql = "INSERT INTO web_backup (server_id,parent_domain_id,backup_type,backup_mode,tstamp,filename) VALUES (".$conf['server_id'].",$web_id,'mysql','sqlgz',".time().",'".$app->db->quote($db_backup_file).".gz')"; |
| | | $app->db->query($sql); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql); |
| | | $filesize = $app->functions->formatBytes(filesize($db_backup_dir.'/'.$db_backup_file.'.gz')); |
| | | $sql = "INSERT INTO web_backup (server_id, parent_domain_id, backup_type, backup_mode, tstamp, filename, filesize) VALUES (?, ?, ?, ?, ?, ?, ?)"; |
| | | $app->db->query($sql, $conf['server_id'], $web_id, 'mysql', 'sqlgz', time(), $db_backup_file.'.gz', $filesize); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) |
| | | $app->dbmaster->query($sql, $conf['server_id'], $web_id, 'mysql', 'sqlgz', time(), $db_backup_file.'.gz', $filesize); |
| | | unset($filesize); |
| | | } |
| | | } else { |
| | | if(is_file($db_backup_dir.'/'.$db_backup_file.'.gz')) unlink($db_backup_dir.'/'.$db_backup_file.'.gz'); |
| | |
| | | //$sql = "SELECT backup_id FROM web_backup WHERE server_id = ".$conf['server_id']." AND parent_domain_id = $web_id AND filename = '".$app->db->quote($filelist[$n])."'"; |
| | | //$tmp = $app->dbmaster->queryOneRecord($sql); |
| | | //$sql = "DELETE FROM web_backup WHERE backup_id = ".intval($tmp['backup_id']); |
| | | $sql = "DELETE FROM web_backup WHERE server_id = ".$conf['server_id']." AND parent_domain_id = $web_id AND filename = '".$app->db->quote($filelist[$n])."'"; |
| | | $app->db->query($sql); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql); |
| | | $sql = "DELETE FROM web_backup WHERE server_id = ? AND parent_domain_id = ? AND filename = ?"; |
| | | $app->db->query($sql, $conf['server_id'], $web_id, $filelist[$n]); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql, $conf['server_id'], $web_id, $filelist[$n]); |
| | | } |
| | | } |
| | | } |
| | |
| | | } |
| | | |
| | | // remove non-existing backups from database |
| | | $backups = $app->db->queryAllRecords("SELECT * FROM web_backup WHERE server_id = ".$conf['server_id']); |
| | | $backups = $app->db->queryAllRecords("SELECT * FROM web_backup WHERE server_id = ?", $conf['server_id']); |
| | | if(is_array($backups) && !empty($backups)){ |
| | | foreach($backups as $backup){ |
| | | $backup_file = $backup_dir.'/web'.$backup['parent_domain_id'].'/'.$backup['filename']; |
| | | if(!is_file($backup_file)){ |
| | | $sql = "DELETE FROM web_backup WHERE server_id = ".$conf['server_id']." AND parent_domain_id = ".$backup['parent_domain_id']." AND filename = '".$backup['filename']."'"; |
| | | $app->db->query($sql); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql); |
| | | $sql = "DELETE FROM web_backup WHERE server_id = ? AND parent_domain_id = ? AND filename = ?"; |
| | | $app->db->query($sql, $conf['server_id'], $backup['parent_domain_id'], $backup['filename']); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql, $conf['server_id'], $backup['parent_domain_id'], $backup['filename']); |
| | | } |
| | | } |
| | | } |
| | |
| | | if($backup_mode == '') $backup_mode = 'userzip'; |
| | | |
| | | if($backup_dir != '') { |
| | | //* mount backup directory, if necessary |
| | | $run_backups = true; |
| | | $server_config['backup_dir_mount_cmd'] = trim($server_config['backup_dir_mount_cmd']); |
| | | if($server_config['backup_dir_is_mount'] == 'y' && $server_config['backup_dir_mount_cmd'] != ''){ |
| | | if(!$app->system->is_mounted($backup_dir)){ |
| | | exec(escapeshellcmd($server_config['backup_dir_mount_cmd'])); |
| | | sleep(1); |
| | | if(!$app->system->is_mounted($backup_dir)) $run_backups = false; |
| | | } |
| | | } |
| | | //* mount backup directory, if necessary |
| | | if( $server_config['backup_dir_is_mount'] == 'y' && !$app->system->mount_backup_dir($backup_dir) ) $run_backups = false; |
| | | |
| | | $sql = "SELECT * FROM mail_user WHERE server_id = '".intval($conf['server_id'])."' AND maildir <> ''"; |
| | | $records = $app->db->queryAllRecords($sql); |
| | | $records = $app->db->queryAllRecords("SELECT * FROM mail_user WHERE server_id = ? AND maildir <> ''", intval($conf['server_id'])); |
| | | |
| | | if(is_array($records) && $run_backups) { |
| | | if(!is_dir($backup_dir)) { |
| | |
| | | foreach($records as $rec) { |
| | | //* Do the mailbox backup |
| | | if($rec['backup_interval'] == 'daily' or ($rec['backup_interval'] == 'weekly' && date('w') == 0) or ($rec['backup_interval'] == 'monthly' && date('d') == '01')) { |
| | | $email = $rec['email'][1]; |
| | | $sql="SELECT * FROM mail_domain WHERE domain = ?" . $app->db->quote(explode("@",$email))."'"; |
| | | $email = $rec['email']; |
| | | $email=explode("@",$email)[1]; |
| | | $domain_rec=$app->db->queryOneRecord("SELECT * FROM mail_domain WHERE domain = ?", $email); |
| | | unset($email); |
| | | $domain_rec=$app->db->queryOneRecord($sql); |
| | | |
| | | $mail_backup_dir = $backup_dir.'/mail'.$domain_rec['domain_id']; |
| | | if(!is_dir($mail_backup_dir)) mkdir($mail_backup_dir, 0750); |
| | |
| | | chgrp($mail_backup_dir.'/'.$mail_backup_file, 'root'); |
| | | chmod($mail_backup_dir.'/'.$mail_backup_file, 0640); |
| | | /* Insert mail backup record in database */ |
| | | $sql = "INSERT INTO mail_backup (server_id,parent_domain_id,mailuser_id,backup_mode,tstamp,filename,filesize) VALUES (".$conf['server_id'].",".$domain_rec['domain_id'].",".$rec['mailuser_id'].",'".$backup_mode."',".time().",'".$app->db->quote($mail_backup_file)."','".$app->functions->formatBytes(filesize($mail_backup_dir.'/'.$mail_backup_file))."')"; |
| | | $app->db->query($sql); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql); |
| | | $sql = "INSERT INTO mail_backup (server_id, parent_domain_id, mailuser_id, backup_mode, tstamp, filename, filesize) VALUES (?, ?, ?, ?, ?, ?, ?)"; |
| | | $app->db->query($sql, $conf['server_id'], $domain_rec['domain_id'], $rec['mailuser_id'], $backup_mode, time(), $mail_backup_file, $app->functions->formatBytes(filesize($mail_backup_dir.'/'.$mail_backup_file))); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql, $conf['server_id'], $domain_rec['domain_id'], $rec['mailuser_id'], $backup_mode, time(), $mail_backup_file, $app->functions->formatBytes(filesize($mail_backup_dir.'/'.$mail_backup_file))); |
| | | } else { |
| | | /* Backup failed - remove archive */ |
| | | if(is_file($mail_backup_dir.'/'.$mail_backup_file)) unlink($mail_backup_dir.'/'.$mail_backup_file); |
| | |
| | | for ($n = $backup_copies; $n <= 10; $n++) { |
| | | if(isset($files[$n]) && is_file($mail_backup_dir.'/'.$files[$n])) { |
| | | unlink($mail_backup_dir.'/'.$files[$n]); |
| | | $sql = "DELETE FROM mail_backup WHERE server_id = ".$conf['server_id']." AND parent_domain_id = ".$domain_rec['domain_id']." AND filename = '".$app->db->quote($files[$n])."'"; |
| | | $app->db->query($sql); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql); |
| | | $sql = "DELETE FROM mail_backup WHERE server_id = ? AND parent_domain_id = ? AND filename = ?"; |
| | | $app->db->query($sql, $conf['server_id'], $domain_rec['domain_id'], $files[$n]); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql, $conf['server_id'], $domain_rec['domain_id'], $files[$n]); |
| | | } |
| | | } |
| | | unset($files); |
| | |
| | | /* Remove inactive backups */ |
| | | if($rec['backup_interval'] == 'none') { |
| | | /* remove backups from db */ |
| | | $sql = "DELETE FROM mail_backup WHERE server_id = ".$conf['server_id']." AND parent_domain_id = ".$domain_rec['domain_id']." AND mailuser_id = ".$rec['mailuser_id']; |
| | | $app->db->query($sql); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql); |
| | | $sql = "DELETE FROM mail_backup WHERE server_id = ? AND parent_domain_id = ? AND mailuser_id = ?"; |
| | | $app->db->query($sql, $conf['server_id'], $domain_rec['domain_id'], $rec['mailuser_id']); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql, $conf['server_id'], $domain_rec['domain_id'], $rec['mailuser_id']); |
| | | /* remove archives */ |
| | | $mail_backup_dir = $backup_dir.'/mail'.$rec['domain_id']; |
| | | $mail_backup_file = 'mail'.$rec['mailuser_id'].'_*'; |
| | |
| | | return $return_var == 0 ? true : false; |
| | | } |
| | | |
| | | function mount_backup_dir($backup_dir, $mount_cmd = '/usr/local/ispconfig/server/scripts/backup_dir_mount.sh'){ |
| | | $mounted = true; |
| | | if ( is_file($mount_cmd) && |
| | | is_executable($mount_cmd) && |
| | | fileowner($mount_cmd) === 0 |
| | | ) { |
| | | if (!$this->is_mounted($backup_dir)){ |
| | | exec($backup_dir_mount_cmd); |
| | | sleep(1); |
| | | if (!$this->is_mounted($backup_dir)) $mounted = false; |
| | | } |
| | | } else $mounted = false; |
| | | |
| | | return $mounted; |
| | | } |
| | | |
| | | function getinitcommand($servicename, $action, $init_script_directory = ''){ |
| | | global $conf; |
| | | // upstart |
| | |
| | | if($data['old']['type'] == 'vhost') { |
| | | $server_config = $app->getconf->get_server_config($conf['server_id'], 'server'); |
| | | $backup_dir = $server_config['backup_dir']; |
| | | //* mount backup directory, if necessary |
| | | $mount_backup = true; |
| | | $server_config['backup_dir_mount_cmd'] = trim($server_config['backup_dir_mount_cmd']); |
| | | if($server_config['backup_dir'] != '' && $server_config['backup_delete'] == 'y') { |
| | | if($server_config['backup_dir_is_mount'] == 'y' && $server_config['backup_dir_mount_cmd'] != ''){ |
| | | if(!$app->system->is_mounted($backup_dir)){ |
| | | exec(escapeshellcmd($server_config['backup_dir_mount_cmd'])); |
| | | sleep(1); |
| | | if(!$app->system->is_mounted($backup_dir)) $mount_backup = false; |
| | | } |
| | | } |
| | | //* mount backup directory, if necessary |
| | | if( $server_config['backup_dir_is_mount'] == 'y' && !$app->system->mount_backup_dir($backup_dir) ) $mount_backup = false; |
| | | |
| | | if($mount_backup){ |
| | | $web_backup_dir = $backup_dir.'/web'.$data_old['domain_id']; |
| | | //** do not use rm -rf $web_backup_dir because database(s) may exits |
| | | exec(escapeshellcmd('rm -f '.$web_backup_dir.'/web'.$data_old['domain_id'].'_').'*'); |
| | | //* cleanup database |
| | | $sql = "DELETE FROM web_backup WHERE server_id = ".$conf['server_id']." AND parent_domain_id = ".$data_old['domain_id']." AND filename LIKE 'web".$data_old['domain_id']."_%'"; |
| | | $app->db->query($sql); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql); |
| | | $sql = "DELETE FROM web_backup WHERE server_id = ? AND parent_domain_id = ? AND filename LIKE ?"; |
| | | $app->db->query($sql, $conf['server_id'], $data_old['domain_id'], "web".$data_old['domain_id']."_%"); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql, $conf['server_id'], $data_old['domain_id'], "web".$data_old['domain_id']."_%"); |
| | | |
| | | $app->log('Deleted the web backup files', LOGLEVEL_DEBUG); |
| | | } |
| | |
| | | $server_config = $app->getconf->get_server_config($conf['server_id'], 'server'); |
| | | $backup_dir = $server_config['backup_dir'].'/web'.$web['domain_id']; |
| | | |
| | | $backup_dir_is_ready = true; |
| | | //* mount backup directory, if necessary |
| | | /* |
| | | $backup_dir_is_ready = true; |
| | | $server_config['backup_dir_mount_cmd'] = trim($server_config['backup_dir_mount_cmd']); |
| | | if($server_config['backup_dir_is_mount'] == 'y' && $server_config['backup_dir_mount_cmd'] != ''){ |
| | | if(!$app->system->is_mounted($server_config['backup_dir'])){ |
| | | exec(escapeshellcmd($server_config['backup_dir_mount_cmd'])); |
| | | sleep(1); |
| | | if(!$app->system->is_mounted($server_config['backup_dir'])) $backup_dir_is_ready = false; |
| | | } |
| | | }*/ |
| | | $backup_dir_is_ready = true; |
| | | $backup_dir_mount_cmd = '/usr/local/ispconfig/server/scripts/backup_dir_mount.sh'; |
| | | if( $server_config['backup_dir_is_mount'] == 'y' && |
| | | is_file($backup_dir_mount_cmd) && |
| | | is_executable($backup_dir_mount_cmd) && |
| | | fileowner($backup_dir_mount_cmd) === 0 |
| | | ){ |
| | | if(!$app->system->is_mounted($backup_dir)){ |
| | | exec($backup_dir_mount_cmd); |
| | | sleep(1); |
| | | if(!$app->system->is_mounted($server_config['backup_dir'])) $backup_dir_is_ready = false; |
| | | } |
| | | } |
| | | if( $server_config['backup_dir_is_mount'] == 'y' && !$app->system->mount_backup_dir($backup_dir) ) $backup_dir_is_ready = false; |
| | | |
| | | if($backup_dir_is_ready){ |
| | | //* Make backup available for download |
| | |
| | | $server_config = $app->getconf->get_server_config($conf['server_id'], 'server'); |
| | | $backup_dir = $server_config['backup_dir']; |
| | | |
| | | //* mount backup directory, if necessary |
| | | $backup_dir_is_ready = true; |
| | | $server_config['backup_dir_mount_cmd'] = trim($server_config['backup_dir_mount_cmd']); |
| | | if($server_config['backup_dir_is_mount'] == 'y' && $server_config['backup_dir_mount_cmd'] != ''){ |
| | | if(!$app->system->is_mounted($backup_dir)){ |
| | | exec(escapeshellcmd($server_config['backup_dir_mount_cmd'])); |
| | | sleep(1); |
| | | if(!$app->system->is_mounted($backup_dir)) $backup_dir_is_ready = false; |
| | | } |
| | | } |
| | | //* mount backup directory, if necessary |
| | | if( $server_config['backup_dir_is_mount'] == 'y' && !$app->system->mount_backup_dir($backup_dir) ) $backup_dir_is_ready = false; |
| | | |
| | | if($backup_dir_is_ready){ |
| | | $mail_config = $app->getconf->get_server_config($conf['server_id'], 'mail'); |
| | |
| | | //* Delete the mail-backups |
| | | $server_config = $app->getconf->get_server_config($conf['server_id'], 'server'); |
| | | $backup_dir = $server_config['backup_dir']; |
| | | //* mount backup directory, if necessary |
| | | $mount_backup = true; |
| | | $server_config['backup_dir_mount_cmd'] = trim($server_config['backup_dir_mount_cmd']); |
| | | if($server_config['backup_dir'] != '' && $maildir_path_deleted && $server_config['backup_delete'] == 'y') { |
| | | if($server_config['backup_dir_is_mount'] == 'y' && $server_config['backup_dir_mount_cmd'] != ''){ |
| | | if(!$app->system->is_mounted($backup_dir)){ |
| | | exec(escapeshellcmd($server_config['backup_dir_mount_cmd'])); |
| | | sleep(1); |
| | | if(!$app->system->is_mounted($backup_dir)) $mount_backup = false; |
| | | } |
| | | } |
| | | //* mount backup directory, if necessary |
| | | if( $server_config['backup_dir_is_mount'] == 'y' && !$app->system->mount_backup_dir($backup_dir) ) $mount_backup = false; |
| | | if($mount_backup){ |
| | | $sql = "SELECT * FROM mail_domain WHERE domain = '".explode("@",$data['old']['email'])[1]."'"; |
| | | $domain_rec = $app->db->queryOneRecord($sql); |
| | |
| | | $mail_backup_files = 'mail'.$data['old']['mailuser_id']; |
| | | exec(escapeshellcmd('rm -f '.$mail_backup_dir.'/'.$mail_backup_files).'*'); |
| | | //* cleanup database |
| | | $sql = "DELETE FROM mail_backup WHERE server_id = ".$conf['server_id']." AND parent_domain_id = ".$domain_rec['domain_id']." AND mailuser_id = ".$data['old']['mailuser_id']; |
| | | $app->db->query($sql); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql); |
| | | $sql = "DELETE FROM mail_backup WHERE server_id = ? AND parent_domain_id = ? AND mailuser_id = ?"; |
| | | $app->db->query($sql, $conf['server_id'], $domain_rec['domain_id'], $data['old']['mailuser_id']); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql, $conf['server_id'], $domain_rec['domain_id'], $data['old']['mailuser_id']); |
| | | |
| | | $app->log('Deleted the mail backups for: '.$data['old']['email'], LOGLEVEL_DEBUG); |
| | | |
| | | |
| | | } |
| | | } |
| | | } |
| | |
| | | //* Delete the mail-backups |
| | | $server_config = $app->getconf->get_server_config($conf['server_id'], 'server'); |
| | | $backup_dir = $server_config['backup_dir']; |
| | | //* mount backup directory, if necessary |
| | | $mount_backup = true; |
| | | $server_config['backup_dir_mount_cmd'] = trim($server_config['backup_dir_mount_cmd']); |
| | | if($server_config['backup_dir'] != '' && $maildomain_path_deleted && $server_config['backup_delete'] == 'y'){ |
| | | if($server_config['backup_dir_is_mount'] == 'y' && $server_config['backup_dir_mount_cmd'] != ''){ |
| | | if(!$app->system->is_mounted($backup_dir)){ |
| | | exec(escapeshellcmd($server_config['backup_dir_mount_cmd'])); |
| | | sleep(1); |
| | | if(!$app->system->is_mounted($backup_dir)) $mount_backup = false; |
| | | } |
| | | } |
| | | //* mount backup directory, if necessary |
| | | if( $server_config['backup_dir_is_mount'] == 'y' && !$app->system->mount_backup_dir($backup_dir) ) $mount_backup = false; |
| | | if($mount_backup){ |
| | | $mail_backup_dir = $backup_dir.'/mail'.$data['old']['domain_id']; |
| | | exec(escapeshellcmd('rm -rf '.$mail_backup_dir)); |
| | | //* cleanup database |
| | | $sql = "DELETE FROM mail_backup WHERE server_id = ".$conf['server_id']." AND parent_domain_id = ".$data['old']['domain_id']; |
| | | $app->db->query($sql); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql); |
| | | $sql = "DELETE FROM mail_backup WHERE server_id = ? AND parent_domain_id = ? AND mailuser_id = ?"; |
| | | $app->db->query($sql, $conf['server_id'], $domain_rec['domain_id'], $data['old']['mailuser_id']); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql, $conf['server_id'], $domain_rec['domain_id'], $data['old']['mailuser_id']); |
| | | |
| | | $app->log('Deleted the mail backup directory: '.$mail_backup_dir, LOGLEVEL_DEBUG); |
| | | } |
| | |
| | | $this->awstats_delete($data, $web_config); |
| | | } |
| | | |
| | | //* Delete the web-backups |
| | | if($data['old']['type'] == 'vhost') { |
| | | $server_config = $app->getconf->get_server_config($conf['server_id'], 'server'); |
| | | $backup_dir = $server_config['backup_dir']; |
| | | $mount_backup = true; |
| | | if($server_config['backup_dir'] != '' && $server_config['backup_delete'] == 'y') { |
| | | //* mount backup directory, if necessary |
| | | if( $server_config['backup_dir_is_mount'] == 'y' && !$app->system->mount_backup_dir($backup_dir) ) $mount_backup = false; |
| | | if($mount_backup){ |
| | | $web_backup_dir = $backup_dir.'/web'.$data_old['domain_id']; |
| | | //** do not use rm -rf $web_backup_dir because database(s) may exits |
| | | exec(escapeshellcmd('rm -f '.$web_backup_dir.'/web'.$data_old['domain_id'].'_').'*'); |
| | | //* cleanup database |
| | | $sql = "DELETE FROM web_backup WHERE server_id = ? AND parent_domain_id = ? AND filename LIKE ?"; |
| | | $app->db->query($sql, $conf['server_id'], $data_old['domain_id'], "web".$data_old['domain_id']."_%"); |
| | | if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql, $conf['server_id'], $data_old['domain_id'], "web".$data_old['domain_id']."_%"); |
| | | |
| | | $app->log('Deleted the web backup files', LOGLEVEL_DEBUG); |
| | | } |
| | | } |
| | | } |
| | | |
| | | $app->services->restartServiceDelayed('httpd', 'reload'); |
| | | |
| | | } |