#!/usr/bin/php
array(
'as_db' => array(
'desc' => 'Database',
'components' => array(
array(
'type' => 'bundle',
'backupdir' => 'mysqldb_asterisk',
'backupfile' => 'mysqldb_asterisk.tgz',
'components' => array(
array(
'type' => 'mysqldb',
'database' => 'asterisk',
'backupfile'=> NULL,
),
array(
'type' => 'mysqldb',
'database' => 'asteriskcdrdb',
'backupfile'=> NULL,
),
array(
'type' => 'mysqldb',
'database' => 'asteriskrealtime',
'backupfile'=> NULL,
),
),
),
array(
'type' => 'file',
'path' => array('/var/lib/asterisk/astdb.sqlite3', '/var/lib/asterisk/astdb'),
'restoreperm' => 0664,
'restoreown' => array('asterisk', 'asterisk'),
),
array(
'type' => 'dirkeep',
'parentdir' => '/var/www/html',
'dirname' => 'admin',
'backupfile' => 'var.www.html.admin.tgz'
),
array(
'type' => 'dirkeep',
'parentdir' => '/var/lib/asterisk',
'dirname' => 'agi-bin',
'backupfile' => 'var.lib.asterisk.agi-bin.tgz'
),
),
'prerestore' => 'prerestore_as_db',
'postrestore' => 'postrestore_as_db',
),
'as_config_files' => array(
'desc' => 'Configuration Files',
'components' => array(
array(
'type' => 'dir',
'parentdir' => '/etc',
'dirname' => 'asterisk',
'backupfile' => 'etc.asterisk.tgz',
),
),
'postrestore' => 'postrestore_as_config_files',
),
'as_monitor' => array(
'desc' => 'Monitors',
'components' => array(
array(
'type' => 'dir',
'parentdir' => '/var/spool/asterisk',
'dirname' => 'monitor',
'backupfile' => 'var.spool.asterisk.monitor.tgz',
),
),
),
'as_voicemail' => array(
'desc' => 'Voicemails',
'components' => array(
array(
'type' => 'dir',
'parentdir' => '/var/spool/asterisk',
'dirname' => 'voicemail',
'backupfile' => 'var.spool.asterisk.voicemail.tgz',
),
),
),
'as_sounds' => array(
'desc' => 'Sounds',
'components' => array(
array(
'type' => 'dir',
'parentdir' => '/var/lib/asterisk/sounds',
'dirname' => 'custom',
'backupfile' => 'var.lib.asterisk.sounds.custom.tgz',
),
),
),
'as_mohmp3' => array(
'desc' => 'MOH',
'components' => array(
array(
'type' => 'dir',
'parentdir' => '/var/lib/asterisk',
'dirname' => 'mohmp3',
'backupfile' => 'var.lib.asterisk.mohmp3.tgz',
'mustExist' => 'no',
),
array(
'type' => 'dir',
'parentdir' => '/var/lib/asterisk',
'dirname' => 'moh',
'backupfile' => 'var.lib.asterisk.moh.tgz',
),
),
),
'as_dahdi' => array(
'desc' => 'DAHDI Configuration',
'components' => array(
array(
'type' => 'dir',
'parentdir' => '/etc',
'dirname' => 'dahdi',
'backupfile' => 'etc.dahdi.tgz',
/* Previous backup implementation changed ownership to
* asterisk:asterisk before backup and this change got
* embedded into the tarball. */
'restoreown' => array('root', 'root'),
),
),
),
),
'fax' => array(
'fx_db' => array(
'desc' => 'Database',
'components' => array(
array(
'type' => 'sqlitedb',
'path' => '/var/www/db/fax.db',
/* This particular file is updated by hylafax under user
* uucp, therefore needs to be world writable. */
'restoreperm' => 0666,
'restoreown' => array('asterisk', 'asterisk'),
),
),
'postrestore' => 'postrestore_fx_db',
),
'fx_pdf' => array(
'desc' => 'PDF',
'components' => array(
array(
'type' => 'dir',
'parentdir' => '/var/www',
'dirname' => 'faxes',
'backupfile' => 'var.www.faxes.tgz',
),
),
),
),
'email' => array(
'em_db' => array(
'desc' => 'Database',
'components' => array(
array(
'type' => 'mysqldb',
'database' => 'roundcubedb',
'backupfile'=> 'roundcubedb_mysql.tgz',
),
array(
'type' => 'sqlitedb',
'path' => '/var/www/db/email.db',
'restoreperm' => 0644,
'restoreown' => array('asterisk', 'asterisk'),
),
),
'prerestore' => 'prerestore_em_db',
'postrestore' => 'postrestore_em_db',
),
'em_mailbox' => array(
'desc' => 'Mailbox',
'components' => array(
array(
'type' => 'dir',
'parentdir' => '/var/spool',
'dirname' => 'imap',
'backupfile' => 'var.spool.imap.tgz',
/* Previous backup implementation changed ownership to
* asterisk:asterisk before backup and this change got
* embedded into the tarball. */
'restoreown' => array('cyrus', 'mail'),
),
array(
'type' => 'dir',
'parentdir' => '/var/lib/imap',
'dirname' => 'domain',
'backupfile' => 'var.lib.imap.tgz',
/* Campo mustExist determina si mandar una alerta de error en caso
* de que al momento de realizar el backup o el restore no se encuentre
* el directorio listado.*/
'mustExist' => 'no',
/* Previous backup implementation changed ownership to
* asterisk:asterisk before backup and this change got
* embedded into the tarball. */
'restoreown' => array('cyrus', 'mail'),
),
),
'postrestore' => 'postrestore_em_mailbox',
),
),
'endpoint' => array(
'ep_db' => array(
'desc' => 'Database',
'components' => array(
// The database endpoint.db is now obsolete
/*
array(
'type' => 'sqlitedb',
'path' => '/var/www/db/endpoint.db',
),
*/
array(
'type' => 'mysqldb',
'database' => 'endpointconfig',
'backupfile'=> 'endpointconfig_mysql.tgz',
),
),
),
'ep_config_files' => array(
'desc' => 'Configuration Files',
'components' => array(
array(
'type' => 'dir',
'parentdir' => '/',
'dirname' => 'tftpboot',
'backupfile' => 'tftpboot.tgz',
/* Previous backup implementation changed ownership to
* asterisk:asterisk before backup and this change got
* embedded into the tarball. */
'restoreown' => array('root', 'root'),
),
),
),
),
'otros' => array(
'callcenter_db' => array(
'desc' => 'Call Center CE Database',
'components' => array(
array(
'type' => 'mysqldbsync',
'database' => 'call_center',
'backupfile'=> 'callcenter_mysql.tgz',
),
),
'prerestore' => 'prerestore_callcenter_db',
'postrestore' => 'postrestore_callcenter_db',
),
'asternic_db' => array(
'desc' => 'Asternic Call Center Stats Database',
'components' => array(
array(
'type' => 'mysqldb',
'database' => 'qstats',
'backupfile'=> 'qstats_mysql.tgz',
),
),
),
'FOP2_settings_db' => array(
'desc' => 'FOP2 User Settings',
'components' => array(
array(
'type' => 'sqlitedb',
'path' => '/usr/local/fop2/fop2settings.db',
'restoreperm' => 0644,
'restoreown' => array('asterisk', 'asterisk'),
),
),
),
'sugar_db' => array(
'desc' => 'SugarCRM Database',
'components' => array(
array(
'type' => 'mysqldb',
'database' => 'sugarcrm',
'backupfile'=> 'sugarcrm_mysql.tgz',
),
),
),
'vtiger_db' => array(
'desc' => 'VtigerCRM Database',
'components' => array(
array(
'type' => 'mysqldb',
'database' => 'vtigercrm510',
'backupfile'=> 'vtigercrm510_mysql.tgz',
),
),
),
'a2billing_db' => array(
'desc' => 'A2billing Database',
'components' => array(
array(
'type' => 'mysqldb',
'database' => 'mya2billing',
'backupfile'=> 'mya2billing_mysql.tgz',
),
),
'prerestore' => 'prerestore_a2billing_db',
'postrestore' => 'postrestore_a2billing_db',
),
'mysql_db' => array(
'desc' => 'Mysql Database',
'components' => array(
array(
'type' => 'mysqldb',
'database' => 'mysql',
'backupfile'=> 'mysql_mysql.tgz',
),
),
'prerestore' => 'prerestore_mysql_db',
'postrestore' => 'postrestore_mysql_db',
),
'menus_permissions' => array(
'desc' => 'Menus and Permissions',
'components' => array(
array(
'type' => 'sqlitedb',
'path' => '/var/www/db/menu.db',
'restoreperm' => 0644,
'restoreown' => array('asterisk', 'asterisk'),
),
array(
'type' => 'sqlitedb',
'path' => '/var/www/db/acl.db',
'restoreperm' => 0644,
'restoreown' => array('asterisk', 'asterisk'),
),
),
'postrestore' => 'postrestore_menu_permissions',
),
'fop_config' => array(
'desc' => 'Flash Operator Panel Config Files',
'components' => array(
array(
'type' => 'dir',
/*
'parentdir' => '/var/www/html/',
'pathlist' => array(
'panel/*.cfg',
'panel/*.txt',
),
'backupfile' => 'var.www.html.panel.tgz',
*/
'parentdir' => '/var/www/html/admin/modules/',
'pathlist' => array(
'fw_fop/*.cfg',
'fw_fop/*.txt',
),
'backupfile' => 'fw_fop.tgz',
),
/* The previous implementation attempted to backup and restore
* /var/lib/asterisk/bin/retrieve_op_conf_from_mysql.pl when
* the issabelPBX package version is not greater than 2.6.x . This
* backup is now assumed to be obsolete. */
),
),
),
'otros_new' => array(
'calendar_db' => array(
'desc' => 'Calendar Database',
'components' => array(
array(
'type' => 'sqlitedb',
'path' => '/var/www/db/calendar.db',
'restoreperm' => 0644,
'restoreown' => array('asterisk', 'asterisk'),
),
),
),
'address_db' => array(
'desc' => 'Address Book Database',
'components' => array(
array(
'type' => 'sqlitedb',
'path' => '/var/www/db/address_book.db',
'restoreperm' => 0644,
'restoreown' => array('asterisk', 'asterisk'),
),
),
),
'conference_db' => array(
'desc' => 'Conference Database',
'components' => array(
array(
'type' => 'mysqldb',
'database' => 'meetme',
'backupfile'=> 'meetme_mysql.tgz',
),
),
),
'eop_db' => array(
'desc' => 'EOP',
'components' => array(
array(
'type' => 'sqlitedb',
'path' => '/var/www/db/control_panel_design.db',
'restoreperm' => 0644,
'restoreown' => array('asterisk', 'asterisk'),
),
),
),
),
);
$CYRUS = NULL;
define('SASL_DOMAIN', 'example.com');
// Ugly - should not depend on anything under /var/www/html
ini_set('include_path', '/var/www/html:'.ini_get('include_path'));
load_default_timezone();
// Some scripts require programs in /sbin but sudo resets env
putenv('PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin');
// Parse command-line options
$opt = Console_Getopt::getopt($argv, '', array(
'backup', // Run a backup operation
'restore', // Run a restore operation
'autobackup=', // Manage automatic backup via crontab
'tmpdir=', // Use this temporary directory for backup/restore operation
'backupfile=', // Backup file to generate (backup) or use (restore)
'components=', // Comma-separated list of backup options to backup/restore
));
if (PEAR::isError($opt)) error_exit($opt->getMessage()."\n");
validateOptions($opt);
foreach ($opt[0] as $option) switch ($option[0]) {
case '--backup':
exit(action_runBackup($opt) ? 0 : 1);
case '--restore':
exit(action_runRestore($opt) ? 0 : 1);
case '--autobackup':
exit(action_runAutoBackupAdmin($opt) ? 0 : 1);
}
error_exit("No action specified (--backup or --restore)\n");
function error_exit($sMsg, $errorcode = 1)
{
fwrite(STDERR, $sMsg);
exit($errorcode);
}
function load_default_timezone()
{
$sDefaultTimezone = @date_default_timezone_get();
if ($sDefaultTimezone == 'UTC') {
$sDefaultTimezone = 'America/New_York';
$regs = NULL;
if (is_link("/etc/localtime") && preg_match("|/usr/share/zoneinfo/(.+)|", readlink("/etc/localtime"), $regs)) {
$sDefaultTimezone = $regs[1];
} elseif (file_exists('/etc/sysconfig/clock')) {
foreach (file('/etc/sysconfig/clock') as $s) {
$regs = NULL;
if (preg_match('/^ZONE\s*=\s*"(.+)"/', $s, $regs)) {
$sDefaultTimezone = $regs[1];
}
}
}
}
date_default_timezone_set($sDefaultTimezone);
}
function isPostfixToIssabel2()
{
foreach (file('/etc/imapd.conf') as $s) {
if (strpos(trim($s), 'virtdomains: yes') === 0) return TRUE;
}
return FALSE;
}
function loadCyrusPassword()
{
global $CYRUS;
if (is_null($CYRUS)) {
$CYRUS = array(
'HOST' => 'localhost',
'PORT' => 143,
'ADMIN' => 'cyrus',
'PASS' => 'palosanto',
);
/*
foreach (file(PASSWD_PATH) as $s) {
$regs = NULL;
if (preg_match('/^cyrususerpwd\s*=\s*(.+)/', trim($s), $regs)) {
$CYRUS['PASS'] = $regs[1];
}
}*/
$passwords = load_keys();
if (isset($passwords['cyrususerpwd'])) $CYRUS['PASS'] = $passwords['cyrususerpwd'];
}
}
// Need custom function to load conf file, odd characters choke parse_ini_file()
function load_keys()
{
$keys = array();
if (file_exists(PASSWD_PATH)) foreach (file(PASSWD_PATH) as $s) {
$s = rtrim($s, "\r\n");
$regs = NULL;
if (preg_match('/^(\w+)=(.*)$/', $s, $regs))
$keys[$regs[1]] = $regs[2];
}
return $keys;
}
// Parse and validate known command-line options
function validateOptions($opt)
{
foreach ($opt[0] as $option) switch ($option[0]) {
case '--backup':
case '--restore':
case '--autobackup':
break;
case '--tmpdir':
if (!is_dir($option[1]))
error_exit('Option '.$option[0].': Invalid backup directory: '.$option[1]."\n");
if (strpos($option[1], '/') !== 0)
error_exit('Option '.$option[0].': Backup directory requires absolute path: '.$option[1]."\n");
break;
case '--backupfile':
$s = basename($option[1]);
if ($s != $option[1])
error_exit('Option '.$option[0].': No directory names accepted: '.$option[1]."\n");
break;
case '--components':
list($knownComponents, $unknownComponents) = expandBackupComponents($option[1]);
if (count($unknownComponents) > 0)
error_exit('Option '.$option[0].': unimplemented components: '.implode(',', $unknownComponents)."\n");
break;
}
}
function action_runAutoBackupAdmin($opt)
{
$sFrequency = NULL;
// Admin-specific validation of options
foreach ($opt[0] as $option) switch ($option[0]) {
case '--autobackup':
$sFrequency = $option[1];
break;
}
if (is_null($sFrequency) || !in_array($sFrequency, array('off', 'daily', 'weekly', 'monthly'))) {
error_exit('Option '.$option[0].": expected one of [off daily weekly monthly]\n");
}
switch ($sFrequency) {
case 'daily':
$s = "59 23 * * * root /usr/bin/php -q /var/www/backup/automatic_backup.php daily\n";
break;
case 'monthly':
$s = "59 23 30 * * root /usr/bin/php -q /var/www/backup/automatic_backup.php monthly\n";
break;
case 'weekly':
$s = "59 23 * * 7 root /usr/bin/php -q /var/www/backup/automatic_backup.php weekly\n";
break;
case 'off':
default:
$s = "";
break;
}
return (file_put_contents('/etc/cron.d/automatic_backup.cron', $s) !== FALSE);
}
/**
* Expand and validate backup components. Returns a list of known selected
* components, and a list of unknown components.
*
* @param string $comp Comma-separated list of backup components to process
*
* @return mixed array of two elements (known-selections,unknown-selections)
*/
function expandBackupComponents($comp)
{
global $BACKUP_PLAN;
// Expand 'all' into a list of first-level keys
$selection = array_unique(explode(',', $comp));
$newSelection = array();
$firstLevelKeys = array_keys($BACKUP_PLAN);
foreach ($selection as $c) {
if ($c == 'all') {
$newSelection = array_merge($newSelection, $firstLevelKeys);
} else {
$newSelection[] = $c;
}
}
$selection = array_unique($newSelection);
// Expand each instance of a first-level key into a list of second-level keys
$newSelection = array();
foreach ($selection as $c) {
if (isset($BACKUP_PLAN[$c])) {
$newSelection = array_merge($newSelection, array_keys($BACKUP_PLAN[$c]));
} else {
$newSelection[] = $c;
}
}
$selection = array_unique($newSelection);
$knownKeys = array();
foreach ($BACKUP_PLAN as $firstLevel) {
$knownKeys = array_merge($knownKeys, array_keys($firstLevel));
}
$knownSelection = array_intersect($knownKeys, $selection);
$unknownSelection = array_diff($selection, $knownKeys);
return array($knownSelection, $unknownSelection);
}
function action_runBackup($opt)
{
global $BACKUP_PLAN;
$sBackupFile = NULL;
$sTempDir = DEFAULT_BACKUP_DIR;
$sComponentString = 'all';
$selectedComponents = array();
// Backup-specific validation of options
foreach ($opt[0] as $option) switch ($option[0]) {
case '--tmpdir':
$sTempDir = $option[1];
break;
case '--backupfile':
$sBackupFile = $option[1];
break;
case '--components':
$sComponentString = $option[1];
break;
}
$regs = NULL;
if (preg_match('|^(.+)/$|', $sTempDir, $regs)) {
$sTempDir = $regs[1];
}
if (!is_null($sBackupFile) && file_exists($sTempDir.'/'.$sBackupFile)) {
error_exit("Option --backupfile: File already exists!\n");
}
list($selectedComponents, $unknownComponents) = expandBackupComponents($sComponentString);
if (count($selectedComponents) <= 0) {
error_exit("Option --components: Must specify a nonempty component list.\n");
}
// Create temporary directory on backup directory, clean if required
$sWorkingDir = $sTempDir.'/backup';
if (file_exists($sWorkingDir)) {
$output = $retval = NULL;
exec('rm -rf '.escapeshellarg($sWorkingDir), $output, $retval);
if ($output != 0 && file_exists($sWorkingDir)) {
error_exit("FATAL: failed to remove existing working directory $sWorkingDir\n");
}
}
mkdir($sWorkingDir, 0755);
// Write manifests
writeSelectedComponentManifest($selectedComponents, $sWorkingDir.'/a_options.xml');
writeInstalledPackagesManifest($sWorkingDir.'/versions.xml');
/* Process each backup component. In keeping with backward compatibility,
* the backup process will continue even if some of the components fail to
* backup. */
$bGlobalSuccess = TRUE;
foreach ($BACKUP_PLAN as $firstLevelKey => $firstLevelGroup) {
foreach ($firstLevelGroup as $secondLevelKey => $backupComponent) {
if (in_array($secondLevelKey, $selectedComponents)) {
$bResult = backupComponent($firstLevelKey.'/'.$secondLevelKey, $backupComponent, $sWorkingDir);
if (!$bResult) $bGlobalSuccess = FALSE;
}
}
}
if (!is_null($sBackupFile)) {
// Create tarball with final result
$output = $retval = NULL;
$sBackupPath = $sTempDir.'/'.$sBackupFile;
exec('tar -C '.escapeshellarg($sTempDir).' -cf '.escapeshellarg($sBackupPath).' backup', $output, $retval);
if ($retval != 0) {
error_exit("FATAL: failed to pack final tarball on $sWorkingDir\n");
}
// Remove working directory
$output = $retval = NULL;
exec('rm -rf '.escapeshellarg($sWorkingDir), $output, $retval);
// Switch tarball file permission to asterisk:asterisk
chown($sBackupPath, 'asterisk');
chgrp($sBackupPath, 'asterisk');
}
return $bGlobalSuccess;
}
// Write manifest of selected options
function writeSelectedComponentManifest(&$selectedComponents, $sOutputPath)
{
global $BACKUP_PLAN;
$xml_manifest = new SimpleXMLElement('');
foreach (array_keys($BACKUP_PLAN) as $firstLevelKey) {
$xml_optiongroup = $xml_manifest->addChild('options');
$xml_optiongroup->addAttribute('id', $firstLevelKey);
foreach (array_keys($BACKUP_PLAN[$firstLevelKey]) as $secondLevelKey) {
if (in_array($secondLevelKey, $selectedComponents)) {
$xml_optiongroup->addChild('option', $secondLevelKey);
}
}
}
if (!$xml_manifest->asXML($sOutputPath)) {
error_exit("FATAL: failed to write selected options manifest!\n");
}
}
// Write manifest of installed packages
function writeInstalledPackagesManifest($sOutputPath)
{
$packageList = array('asterisk', 'dahdi', 'wanpipe-util', 'issabelPBX',
'issabel', 'issabel-pbx', 'issabel-email_admin', 'issabel-agenda',
'issabel-fax', 'issabel-vtigercrm', 'issabel-a2billing',
'issabel-sugarcrm-addon');
$output = $retval = NULL;
exec("rpm -q --queryformat '%{name} %{version} %{release}\\n' ".implode(' ', $packageList),
$output, $retval);
// Add all existing packages to XML tree
$xml_manifest = new SimpleXMLElement('');
foreach ($output as $s) {
$fields = explode(' ', trim($s));
if (count($fields) == 3 && in_array($fields[0], $packageList)) {
// This is needed for compatibility with previous backup implementation
$sPackageName = $fields[0];
if ($sPackageName == 'issabelPBX') $sPackageName = 'issabelpbx';
$xml_program = $xml_manifest->addChild('program');
$xml_program->addAttribute('id', $sPackageName);
$xml_program->addAttribute('ver', $fields[1]);
$xml_program->addAttribute('rel', $fields[2]);
$k = array_search($fields[0], $packageList);
unset($packageList[$k]);
}
}
/* Any remaining values in $packageList are missing packages. The missing
* package is marked with 'Package not installed' as attribute value for
* compatibility with the previous backup implementation. */
foreach ($packageList as $sPackage) {
$xml_program = $xml_manifest->addChild('program');
$xml_program->addAttribute('id', $sPackage);
$xml_program->addAttribute('ver', 'Package not installed');
$xml_program->addAttribute('rel', 'Package not installed');
}
if (!$xml_manifest->asXML($sOutputPath)) {
error_exit("FATAL: failed to write package manifest!\n");
}
}
/**
* Select between each of the backup types and perform the backup.
*
* @param string $sLevelTag Informative tag for backup component name
* @param mixed $backupComponent Information on backup parameters
* @param string $sWorkingDir Working directory for backup operation
*/
function backupComponent($sLevelTag, &$backupComponent, $sWorkingDir)
{
$bGlobalSuccess = TRUE;
print "INFO: backing up component $sLevelTag...\n";
foreach ($backupComponent['components'] as $component) {
$sProcName = 'backupComponent_'.$component['type'];
if (function_exists($sProcName)) {
$bResult = $sProcName($sLevelTag, $component, $sWorkingDir);
if (!$bResult) $bGlobalSuccess = FALSE;
} else {
error_exit('FATAL: unimplemented backup component type '.$component['type']."\n");
}
}
return $bGlobalSuccess;
}
function backupComponent_sqlitedb($sLevelTag, &$backupComponent, $sWorkingDir)
{
return backupComponent_file($sLevelTag, $backupComponent, $sWorkingDir);
}
function backupComponent_file($sLevelTag, &$backupComponent, $sWorkingDir)
{
$bResult = TRUE;
// If an array, backup the first one found
$backuppath = NULL;
if (is_array($backupComponent['path'])) {
foreach ($backupComponent['path'] as $bp) {
$backuppath = $bp;
if (file_exists($backuppath)) break;
}
} else {
$backuppath = $backupComponent['path'];
}
if(!is_file($backuppath)) {
fprintf(STDERR, "WARN: $sLevelTag: file ".$backuppath." not found\n");
return TRUE;
}
$sDestination = $sWorkingDir.'/'.basename($backuppath);
if (!copy($backuppath, $sDestination)) {
fwrite(STDERR, "ERR: $sLevelTag: failed to copy ".$backuppath." to destination $sWorkingDir\n");
$bResult = FALSE;
}
return $bResult;
}
function backupComponent_dirkeep($sLevelTag, &$backupComponent, $sWorkingDir)
{
return backupComponent_dir($sLevelTag, $backupComponent, $sWorkingDir);
}
function backupComponent_dir($sLevelTag, &$backupComponent, $sWorkingDir)
{
if (isset($backupComponent['dirname']) &&
is_dir($backupComponent['parentdir']."/".$backupComponent['dirname']) === false) {
if(isset($backupComponent['mustExist'])){
if($backupComponent['mustExist']=="no"){
return TRUE;
}
}
fwrite(STDERR, "ERR: $sLevelTag: failed to create tarball ".$backupComponent['backupfile']." on destination $sWorkingDir\n");
return FALSE;
}
/* Directory change cannot be done with tar -C for all cases, because
* pathlist might need shell expansion relative to target directory. */
$sCommand = 'cd '.escapeshellarg($backupComponent['parentdir']).
'&& tar -czf '.escapeshellarg($sWorkingDir.'/'.$backupComponent['backupfile']).' '.
(isset($backupComponent['pathlist'])
? implode(' ', $backupComponent['pathlist'])
: $backupComponent['dirname']);
$output = $retval = NULL;
exec($sCommand, $output, $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to create tarball ".$backupComponent['backupfile']." on destination $sWorkingDir\n");
return FALSE;
}
return TRUE;
}
$sMysqlRootPass = NULL;
$mysqlSchemata = array();
function prepareMysqlData($sLevelTag)
{
// Read mysql credentials if running for the first time
global $sMysqlRootPass;
global $mysqlSchemata;
if (is_null($sMysqlRootPass)) {
if (!file_exists(PASSWD_PATH)) {
$sMysqlRootPass = 'iSsAbEl.2o17';
} else {
foreach (file(PASSWD_PATH) as $s) {
$regs = NULL;
if (preg_match('/^mysqlrootpwd\s*=\s*(.+)$/', trim($s), $regs)) {
$sMysqlRootPass = $regs[1];
break;
}
}
if (is_null($sMysqlRootPass)) {
error_exit("FATAL: $sLevelTag: failed to find MySQL root password in /etc/issabel.conf\n");
}
}
// Read list of all schemata from database
try {
$conn = new PDO('mysql:host=localhost;dbname=information_schema', 'root', $sMysqlRootPass);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sth = $conn->query('SELECT SCHEMA_NAME FROM SCHEMATA');
$mysqlSchemata = $sth->fetchAll(PDO::FETCH_COLUMN);
$sth = NULL;
$conn = NULL;
} catch (PDOException $e) {
error_exit("FATAL: $sLevelTag: failed to read list of MySQL schemata: ".$e->getMessage()."\n");
}
}
}
function backupComponent_mysqldb($sLevelTag, &$backupComponent, $sWorkingDir)
{
global $sMysqlRootPass;
global $mysqlSchemata;
// Load mysql password if required
prepareMysqlData($sLevelTag);
// Check whether selected database exists
if (!in_array($backupComponent['database'], $mysqlSchemata)) {
fprintf(STDERR, "WARN: $sLevelTag: database ".$backupComponent['database']." not found\n");
return TRUE;
}
/* Due to memory constraints, the database schema will be cached in memory
* but the data itself will be written to a temporary file. */
// Schema
$output = $retval = NULL;
exec('mysqldump -h localhost -u root '.escapeshellarg('-p'.$sMysqlRootPass).
' '.escapeshellarg($backupComponent['database']).' --no-data ',
$output, $retval);
if ($retval != 0) {
fprintf(STDERR, "ERR: $sLevelTag: failed to dump schema for database ".$backupComponent['database']."\n");
return FALSE;
}
$schema = trim(str_replace('CREATE TABLE', 'CREATE TABLE IF NOT EXISTS', implode("\n", $output)));
if (strlen($schema) <= 0) {
fprintf(STDERR, "WARN: $sLevelTag: database ".$backupComponent['database']." has no schema\n");
return TRUE;
}
// Data
$output = $retval = NULL;
$sDataPath = $sWorkingDir.'/'.$backupComponent['database'].'2.sql';
exec('mysqldump -h localhost -u root '.escapeshellarg('-p'.$sMysqlRootPass).
' '.escapeshellarg($backupComponent['database']).' -t -c --skip-triggers -r '.
escapeshellarg($sDataPath),
$output, $retval);
if ($retval != 0) {
fprintf(STDERR, "ERR: $sLevelTag: failed to dump data for database ".$backupComponent['database']."\n");
return FALSE;
}
// Write schema, then data
$sSchemaPath = $sWorkingDir.'/'.$backupComponent['database'].'.sql';
$h = fopen($sSchemaPath, 'w+');
if (!$h) error_exit("ERR: $sLevelTag: failed to open $sSchemaPath for writing\n");
fwrite($h, $schema."\n");
$htemp = fopen($sDataPath, 'r');
if (!$htemp) error_exit("ERR: $sLevelTag: failed to open $sDataPath for reading\n");
while (!feof($htemp)) fwrite($h, fread($htemp, 4096));
fclose($htemp); fclose($h);
unlink($sDataPath);
// Create tarball if required
if (!is_null($backupComponent['backupfile'])) {
$output = $retval = NULL;
exec('tar -C '.escapeshellarg($sWorkingDir).' -czf '.
escapeshellarg($sWorkingDir.'/'.$backupComponent['backupfile']).' '.
escapeshellarg($backupComponent['database'].'.sql'),
$output, $retval);
if ($retval != 0) {
fprintf(STDERR, "ERR: $sLevelTag: failed to pack tarball for database ".$backupComponent['database']."\n");
return FALSE;
}
unlink($sSchemaPath);
}
return TRUE;
}
/* The call center database is backed up exactly as any mysqldb component;
* only its restore differs (restoreComponent_mysqldbsync). */
function backupComponent_mysqldbsync($sLevelTag, &$backupComponent, $sWorkingDir)
{
return backupComponent_mysqldb($sLevelTag, $backupComponent, $sWorkingDir);
}
function backupComponent_bundle($sLevelTag, &$backupComponent, $sWorkingDir)
{
$sWorkingSubdir = $sWorkingDir.'/'.$backupComponent['backupdir'];
if (!mkdir($sWorkingSubdir, 0755)) {
fprintf(STDERR, "ERR: $sLevelTag: failed to create directory $sWorkingSubdir\n");
return FALSE;
}
// Recursively run backup subcomponents
$bGlobalSuccess = backupComponent($sLevelTag.'/'.$backupComponent['backupdir'], $backupComponent, $sWorkingSubdir);
$bundleComponent = array(
'type' => 'dir',
'parentdir' => $sWorkingDir,
'dirname' => $backupComponent['backupdir'],
'backupfile' => $backupComponent['backupfile'],
);
if (!backupComponent_dir($sLevelTag, $bundleComponent, $sWorkingDir)) {
$bGlobalSuccess = FALSE;
}
$output = $retval = NULL;
exec('rm -rf '.escapeshellarg($sWorkingSubdir), $output, $retval);
return $bGlobalSuccess;
}
function action_runRestore($opt)
{
global $BACKUP_PLAN, $adminpwd;
$sBackupFile = NULL;
$sTempDir = DEFAULT_BACKUP_DIR;
$sComponentString = 'all';
$selectedComponents = array();
// Restore-specific validation of options
foreach ($opt[0] as $option) switch ($option[0]) {
case '--tmpdir':
$sTempDir = $option[1];
break;
case '--backupfile':
$sBackupFile = $option[1];
break;
case '--components':
$sComponentString = $option[1];
break;
}
$regs = NULL;
if (preg_match('|^(.+)/$|', $sTempDir, $regs)) {
$sTempDir = $regs[1];
}
if (is_null($sBackupFile)) {
error_exit("Option --backupfile: Must specify a backup filename.\n");
}
if (!file_exists($sTempDir.'/'.$sBackupFile)) {
error_exit("Option --backupfile: File not found!\n");
}
list($selectedComponents, $unknownComponents) = expandBackupComponents($sComponentString);
if (count($selectedComponents) <= 0) {
error_exit("Option --components: Must specify a nonempty component list.\n");
}
$adminpwd=trim(`sqlite3 /var/www/db/acl.db "select md5_password from acl_user where name='admin'"`);
// Create temporary directory on backup directory, clean if required
$sWorkingDir = $sTempDir.'/restore';
if (file_exists($sWorkingDir)) {
$output = $retval = NULL;
exec('rm -rf '.escapeshellarg($sWorkingDir), $output, $retval);
if ($output != 0 && file_exists($sWorkingDir)) {
error_exit("FATAL: failed to remove existing working directory $sWorkingDir\n");
}
}
mkdir($sWorkingDir, 0755);
// Unpack tarball with backup files. Should create 'backup' directory
$output = $retval = NULL;
$sUnpackedDir = $sWorkingDir.'/backup';
exec('tar -C '.escapeshellarg($sWorkingDir).' -xf '.escapeshellarg($sTempDir.'/'.$sBackupFile), $output, $retval);
if ($retval != 0) {
error_exit("FATAL: failed to unpack tarball on $sWorkingDir\n");
} elseif (!is_dir($sUnpackedDir)) {
error_exit("FATAL: invalid tarball on $sWorkingDir - missing backup directory\n");
}
// Load options that were specified in backup
$availableOptions = array();
if (!file_exists($sUnpackedDir.'/a_options.xml'))
error_exit("FATAL: invalid tarball on $sWorkingDir - missing a_options.xml\n");
$xml_manifest = simplexml_load_file($sUnpackedDir.'/a_options.xml');
if (!$xml_manifest)
error_exit("FATAL: invalid tarball on $sWorkingDir - invalid a_options.xml\n");
foreach ($xml_manifest->options as $xml_optionlist) {
foreach ($xml_optionlist->option as $xml_option) {
$availableOptions[] = (string)$xml_option;
}
}
/* Process each backup component. In keeping with backward compatibility,
* the restore process will continue even if some of the components fail to
* restore. */
$bGlobalSuccess = TRUE;
foreach ($BACKUP_PLAN as $firstLevelKey => $firstLevelGroup) {
foreach ($firstLevelGroup as $secondLevelKey => $backupComponent) {
if (in_array($secondLevelKey, $selectedComponents)) {
$sLevelTag = $firstLevelKey.'/'.$secondLevelKey;
if (in_array($secondLevelKey, $availableOptions)) {
$bResult = restoreComponent($sLevelTag, $backupComponent, $sUnpackedDir);
if (!$bResult) $bGlobalSuccess = FALSE;
} else {
fprintf(STDERR, "WARN: $sLevelTag: specified in restore but not available in backup\n");
}
}
}
}
// Remove working directory
$output = $retval = NULL;
exec('rm -rf '.escapeshellarg($sWorkingDir), $output, $retval);
// Reload amportal, manager.conf needs to be reloaded most of the time a restore occurs
exec('/usr/sbin/amportal reload', $output, $retval);
return $bGlobalSuccess;
}
/**
* Select between each of the backup types and perform the backup.
*
* @param string $sLevelTag Informative tag for backup component name
* @param mixed $backupComponent Information on backup parameters
* @param string $sWorkingDir Working directory for backup operation
*/
function restoreComponent($sLevelTag, &$backupComponent, $sWorkingDir)
{
$bGlobalSuccess = TRUE;
print "INFO: restoring component $sLevelTag...\n";
// Run any custom pre-restore operation
if (isset($backupComponent['prerestore'])) {
if (function_exists($backupComponent['prerestore'])) {
$bResult = $backupComponent['prerestore']($sLevelTag, $backupComponent, $sWorkingDir);
if (!$bResult) $bGlobalSuccess = FALSE;
} else {
error_exit('FATAL: unimplemented pre-restore action '.$backupComponent['prerestore']."\n");
}
}
foreach ($backupComponent['components'] as $component) {
$sProcName = 'restoreComponent_'.$component['type'];
if (function_exists($sProcName)) {
$bResult = $sProcName($sLevelTag, $component, $sWorkingDir);
if (!$bResult) $bGlobalSuccess = FALSE;
} else {
error_exit('FATAL: unimplemented restore component type '.$component['type']."\n");
}
}
// Run any custom post-restore operation
if (isset($backupComponent['postrestore'])) {
if (function_exists($backupComponent['postrestore'])) {
$bResult = $backupComponent['postrestore']($sLevelTag, $backupComponent, $sWorkingDir);
if (!$bResult) $bGlobalSuccess = FALSE;
} else {
error_exit('FATAL: unimplemented post-restore action '.$backupComponent['postrestore']."\n");
}
}
return $bGlobalSuccess;
}
function restoreComponent_sqlitedb($sLevelTag, &$backupComponent, $sWorkingDir)
{
return restoreComponent_file($sLevelTag, $backupComponent, $sWorkingDir);
}
function restoreComponent_file($sLevelTag, &$backupComponent, $sWorkingDir)
{
$bResult = TRUE;
if (is_array($backupComponent['path'])) {
foreach ($backupComponent['path'] as $bp) {
$backuppath = $bp;
if (file_exists($sWorkingDir.'/'.basename($backuppath))) break;
}
} else {
$backuppath = $backupComponent['path'];
}
$sSource = $sWorkingDir.'/'.basename($backuppath);
if(file_exists($sSource)) {
if (!copy($sSource, $backuppath)) {
fwrite(STDERR, "ERR: $sLevelTag: failed to copy ".$backuppath." from source $sWorkingDir\n");
$bResult = FALSE;
} else {
// Restore owner and permissions
if (isset($backupComponent['restoreperm'])) {
chmod($backuppath, $backupComponent['restoreperm']);
}
if (isset($backupComponent['restoreown'])) {
chown($backuppath, $backupComponent['restoreown'][0]);
chgrp($backuppath, $backupComponent['restoreown'][1]);
}
}
} else {
fprintf(STDERR, "WARN: $sLevelTag: file ".$sSource." not found\n");
}
return $bResult;
}
function restoreComponent_dirkeep($sLevelTag, &$backupComponent, $sWorkingDir)
{
return restoreComponent_dir($sLevelTag, $backupComponent, $sWorkingDir, $keep=TRUE);
}
function restoreComponent_dir($sLevelTag, &$backupComponent, $sWorkingDir, $keep=FALSE)
{
if (isset($backupComponent['dirname'])) {
$sFullDirPath = $backupComponent['parentdir'].'/'.$backupComponent['dirname'];
if (is_dir($sFullDirPath)) {
// Make a backup of the directory contents in case the restore is botched
$sCommand = 'tar -czf '.
escapeshellarg($sFullDirPath.'.tgz').' '.
escapeshellarg($sFullDirPath.'/');
$output = $retval = NULL;
exec($sCommand, $output, $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to create safety-backup\n ");
return FALSE;
}
// Remove everything inside the target directory
$sCommand = 'rm -rf '.$sFullDirPath.'/';
exec($sCommand, $output, $retval);
}
}
//comprobamos si el archivo del backup existing
//puede que no exista en caso de que tenga configurado el
//parametro mustExist = no
if(file_exists($sWorkingDir.'/'.$backupComponent['backupfile'])===false){
if(isset($backupComponent['mustExist'])){
if($backupComponent['mustExist']=="no"){
return TRUE;
}
}
fwrite(STDERR, "ERR: $sLevelTag: failed to unpack tarball ".$backupComponent['backupfile']." from source $sWorkingDir\n");
return FALSE;
}
// Restore inside parentdir
$sCommand = 'tar -C '.escapeshellarg($backupComponent['parentdir']).' -xvf '.escapeshellarg($sWorkingDir.'/'.$backupComponent['backupfile']);
$output = $retval = NULL;
exec($sCommand, $output, $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to unpack tarball ".$backupComponent['backupfile']." from source $sWorkingDir\n");
return FALSE;
} else {
if($keep === TRUE) {
$sCommand = 'tar -xzf '. escapeshellarg($sFullDirPath.'.tgz').' -C /';
exec($sCommand, $output, $retval);
unlink($sFullDirPath.'.tgz');
}
// Restore owner and permissions if restoring a full directory
if (isset($backupComponent['dirname']) && isset($backupComponent['restoreown'])) {
$output = $retval = NULL;
exec('/bin/chown -R '.implode(':', $backupComponent['restoreown']).
' '.escapeshellarg($backupComponent['parentdir'].'/'.$backupComponent['dirname']));
}
}
return TRUE;
}
function restoreComponent_mysqldb($sLevelTag, &$backupComponent, $sWorkingDir)
{
global $sMysqlRootPass;
// Load mysql password if required
prepareMysqlData($sLevelTag);
$sSchemaPath = $sWorkingDir.'/'.$backupComponent['database'].'.sql';
if (!is_null($backupComponent['backupfile'])) {
$sDbTarball = $sWorkingDir.'/'.$backupComponent['backupfile'];
if (!file_exists($sDbTarball)) {
fprintf(STDERR, "WARN: $sLevelTag: $sDbTarball not found, not restoring database...\n");
return TRUE;
}
$sCommand = 'tar -C '.escapeshellarg($sWorkingDir).' -xzf '.escapeshellarg($sDbTarball);
$output = $retval = NULL;
exec($sCommand, $output, $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to unpack database tarball $sDbTarball\n ");
return FALSE;
} elseif (!file_exists($sSchemaPath)) {
fwrite(STDERR, "ERR: $sLevelTag: unpacking of database tarball $sDbTarball failed to produce schema\n ");
return FALSE;
}
}
if (!file_exists($sSchemaPath)) {
fprintf(STDERR, "WARN: $sLevelTag: $sSchemaPath not found, not restoring database...\n");
return TRUE;
}
// BUG de mysqldump en CentOS 7: algunas tablas tienen IF NOT EXISTS dos veces
$sCommand = 'sed -ie '.escapeshellarg('s/CREATE TABLE IF NOT EXISTS IF NOT EXISTS/CREATE TABLE IF NOT EXISTS/').
' '.escapeshellarg($sSchemaPath);
$output = $retval = NULL;
exec($sCommand, $output, $retval);
$sCommand = 'mysql -h localhost -u root '.escapeshellarg('-p'.$sMysqlRootPass).
' '.escapeshellarg($backupComponent['database']).' < '.escapeshellarg($sSchemaPath);
$output = $retval = NULL;
exec($sCommand, $output, $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to restore database from schema $sSchemaPath\n ");
return FALSE;
}
return TRUE;
}
/* Restore a mysql database dump through the schema-aware copy script: the
* dump - which may come from an older version of the module, with columns
* the live schema no longer has or lacks - is loaded into a staging database
* and copied table by table through the columns both schemas share. This is
* the same method issabel_migration.sh uses for an old asterisk/CDR dump.
* Boxes without the target database (the Call Center CE module is not
* installed) are warned and skipped, not failed. */
function restoreComponent_mysqldbsync($sLevelTag, &$backupComponent, $sWorkingDir)
{
global $sMysqlRootPass;
global $mysqlSchemata;
// Load mysql password if required
prepareMysqlData($sLevelTag);
// Nothing to restore into if the module's database is absent
if (!in_array($backupComponent['database'], $mysqlSchemata)) {
fprintf(STDERR, "WARN: $sLevelTag: database ".$backupComponent['database']." not found, install the Call Center module first\n");
return TRUE;
}
$sSchemaPath = $sWorkingDir.'/'.$backupComponent['database'].'.sql';
if (!is_null($backupComponent['backupfile'])) {
$sDbTarball = $sWorkingDir.'/'.$backupComponent['backupfile'];
if (!file_exists($sDbTarball)) {
fprintf(STDERR, "WARN: $sLevelTag: $sDbTarball not found, not restoring database...\n");
return TRUE;
}
$sCommand = 'tar -C '.escapeshellarg($sWorkingDir).' -xzf '.escapeshellarg($sDbTarball);
$output = $retval = NULL;
exec($sCommand, $output, $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to unpack database tarball $sDbTarball\n ");
return FALSE;
} elseif (!file_exists($sSchemaPath)) {
fwrite(STDERR, "ERR: $sLevelTag: unpacking of database tarball $sDbTarball failed to produce schema\n ");
return FALSE;
}
}
if (!file_exists($sSchemaPath)) {
fprintf(STDERR, "WARN: $sLevelTag: $sSchemaPath not found, not restoring database...\n");
return TRUE;
}
/* The root password must not reach a command line, so it is handed to
* the copy script through a temporary option file instead. The file is
* created 0600 (umask) before any byte of the password is written, and
* the value is double-quoted with the mysql option-file escapes, so a
* password holding '#', a quote, a backslash or spaces is read exactly. */
$sDefaultsFile = $sWorkingDir.'/.cc_restore.cnf';
$iOldMask = umask(0077);
$h = fopen($sDefaultsFile, 'w');
if ($h !== FALSE) {
fwrite($h, "[client]\nuser = root\npassword = \"".
str_replace(array('\\', '"'), array('\\\\', '\\"'), $sMysqlRootPass).
"\"\nhost = localhost\n");
fclose($h);
chmod($sDefaultsFile, 0600);
}
umask($iOldMask);
if (!$h) {
fwrite(STDERR, "ERR: $sLevelTag: failed to open $sDefaultsFile for writing\n ");
return FALSE;
}
$sCommand = '/usr/sbin/issabel_migration_callcenter.sh --dump '.
escapeshellarg($sSchemaPath).' --db '.
escapeshellarg($backupComponent['database']).
' --defaults-file '.escapeshellarg($sDefaultsFile).' 2>&1';
$output = $retval = NULL;
exec($sCommand, $output, $retval);
// The copy script's progress lines are this restore's own output
foreach ($output as $sLine) {
print "$sLine\n";
}
unlink($sDefaultsFile);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: schema-aware restore of database ".$backupComponent['database']." failed\n ");
return FALSE;
}
return TRUE;
}
function restoreComponent_bundle($sLevelTag, &$backupComponent, $sWorkingDir)
{
$sWorkingSubdir = $sWorkingDir.'/'.$backupComponent['backupdir'];
// Unpack bundle tarball containing files to recursively restore
$sCommand = 'tar -C '.escapeshellarg($sWorkingDir).
' -xvf '.escapeshellarg($sWorkingDir.'/'.$backupComponent['backupfile']);
$output = $retval = NULL;
exec($sCommand, $output, $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to unpack tarball ".$backupComponent['backupfile']." from source $sWorkingDir\n");
return FALSE;
} elseif (!is_dir($sWorkingSubdir)) {
fwrite(STDERR, "ERR: $sLevelTag: unpacking of tarball ".$backupComponent['backupfile']." failed to produce $sWorkingSubdir/\n");
return FALSE;
}
// Recursively restore backup subcomponents
return restoreComponent($sLevelTag.'/'.$backupComponent['backupdir'], $backupComponent, $sWorkingSubdir);
}
// Custom processing before restoring asterisk databases
function prerestore_as_db($sLevelTag, &$backupComponent, $sWorkingDir)
{
// asterisk must be stopped in order to swap out astdb.sqlite3
exec('/sbin/service asterisk stop > /dev/null 2>&1');
return TRUE;
}
// Custom processing after restoring asterisk databases
function postrestore_as_db($sLevelTag, &$backupComponent, $sWorkingDir)
{
$keysFromFPBX = array('AMPDBHOST', 'AMPDBUSER', 'AMPDBPASS', 'PRE_RELOAD',
'AMPBIN', 'FOPRUN', 'POST_RELOAD', 'ASTETCDIR');
$keysFromAsterisk = array('astlogdir');
$fpbxConf = array();
$astConf = array();
if (file_exists('/usr/sbin/astdb2sqlite3') && file_exists($sWorkingDir.'/astdb')) {
// Backup originated from asterisk 1.8 and restored on asterisk 11
if (file_exists('/var/lib/asterisk/astdb.sqlite3'))
unlink('/var/lib/asterisk/astdb.sqlite3');
system('/usr/sbin/astdb2sqlite3 /var/lib/asterisk/astdb');
}
// remove legacy astetc files from issabelPBX that will conflict with newer versions
if(is_dir('/var/www/html/admin/modules/framework/amp_conf/')) {
system('rm -rf /var/www/html/admin/modules/framework/amp_conf/');
}
// asterisk must be restarted in order for retrieve_conf to work correctly
exec('/sbin/service asterisk start > /dev/null 2>&1');
// Read information from /etc/amportal.conf
foreach (file('/etc/amportal.conf') as $s) {
$regs = NULL;
if (preg_match('/^(\w+)\s*=\s*(.+)/', trim($s), $regs)) {
if (in_array($regs[1], $keysFromFPBX)) $fpbxConf[$regs[1]] = $regs[2];
}
}
// Read information from /etc/asterisk/asterisk.conf
foreach (file('/etc/asterisk/asterisk.conf') as $s) {
$regs = NULL;
if (preg_match('/^(\w+)\s*=>\s*(.+)/', trim($s), $regs)) {
if (in_array($regs[1], $keysFromAsterisk)) $astConf[$regs[1]] = $regs[2];
}
}
// Simulate refreshing of configuration
if (isset($fpbxConf['PRE_RELOAD'])) {
exec('su -s /bin/sh - asterisk -c '.escapeshellarg($fpbxConf['PRE_RELOAD']));
}
exec('su -s /bin/sh - asterisk -c '.escapeshellarg($fpbxConf['AMPBIN'].'/retrieve_conf'));
if (isset($fpbxConf['FOPRUN'])) {
exec('su -s /bin/sh - asterisk -c '.escapeshellarg($fpbxConf['AMPBIN'].'/bounce_op.sh &> '.$astConf['astlogdir'].'/issabelpbx-bounce_op.log'));
}
try {
// Reset the pending-changes flag
$conn = new PDO('mysql:host='.$fpbxConf['AMPDBHOST'].';dbname=asterisk',
$fpbxConf['AMPDBUSER'], $fpbxConf['AMPDBPASS']);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$conn->query("UPDATE admin SET value = 'false' WHERE variable = 'need_reload'");
// Restore the admin password from /etc/issabel.conf
$passwords = load_keys();
if (isset($passwords['amiadminpwd'])) {
$sth = $conn->prepare('UPDATE asterisk.ampusers SET password_sha1 = SHA1(?) WHERE username = ?');
$sth->execute(array($passwords['amiadminpwd'], 'admin'));
$sth = NULL;
$sth = $conn->prepare("UPDATE issabelpbx_settings SET value=? WHERE keyword IN ('ARI_ADMIN_PASSWORD','AMPMGRPASS')");
$sth->execute(array($passwords['amiadminpwd']));
$sth = NULL;
$manager_file = '/etc/asterisk/manager.conf';
$content = file($manager_file);
$bAdmin = FALSE;
for ($i = 0; $i < count($content); $i++) {
$regs = NULL;
if (preg_match('/^\[(\w+)\]/', $content[$i], $regs)) {
$bAdmin = ($regs[1] == 'admin');
} elseif ($bAdmin && preg_match('/^secret\s*=\s*/', $content[$i])) {
$content[$i] = "secret = $sNewPassword\n";
}
}
file_put_contents($manager_file,$content);
}
$conn = NULL;
} catch (PDOException $e) {
fwrite(STDERR, "WARN: $sLevelTag: failed to reset IssabelPBX update flag!\n");
}
// If we restore an old database for IssabelPBX, then migrate modules so DB gets updated and module enabled
exec("/var/lib/asterisk/bin/module_admin list | grep Pending | awk '{print $1}'",$output,$ret);
// first install priority modules if needed
$priority_modules = array ('framework','core','recordings');
foreach($priority_modules as $mm) {
if(in_array($mm,$output)) {
exec('/var/lib/asterisk/bin/module_admin install '.$mm,$ocore);
}
}
// then attempt to install all disabled pending upgrade modules
foreach($output as $module) {
if(in_array($module,$priority_modules)) { continue; }
exec('/var/lib/asterisk/bin/module_admin install '.escapeshellarg($module),$output,$ret);
}
// Finally install all local available modules that are pending also
exec('/var/lib/asterisk/bin/module_admin installlocal',$output,$ret);
if (isset($fpbxConf['POST_RELOAD'])) {
exec('su -s /bin/sh - asterisk -c '.escapeshellarg($fpbxConf['POST_RELOAD']));
}
// Finally restart everything
exec('/usr/sbin/amportal restart > /dev/null 2>&1');
return TRUE;
}
// Custom processing after restoring asterisk configuration files
function postrestore_as_config_files($sLevelTag, &$backupComponent, $sWorkingDir)
{
/* Workaround for Elastix bug #164. If backing up in 32-bit and restoring in
* 64-bit, or viceversa, the module directory will be incorrect - fix it. */
$sModulePath = '/usr/lib/asterisk/modules';
if (is_dir('/usr/lib64/asterisk/modules')) {
$sModulePath = '/usr/lib64/asterisk/modules';
}
$pathList = array("/usr/lib/asterisk/modules","/usr/lib64/asterisk/modules");
foreach (array(
'/etc/asterisk/asterisk.conf',
'/etc/asterisk/extensions_additional.conf') as $sFilePath) {
$s = file_get_contents($sFilePath);
$s = str_replace($pathList, $sModulePath, $s);
file_put_contents($sFilePath, $s);
}
// Restore password from /etc/issabel.conf into each known location.
// The following list is taken from issabel-admin-passwords.
$passwords = load_keys();
foreach (array(
array(
'/etc/asterisk/res_mysql.conf',
'^dbpass\s*=\s*',
'dbpass = '.$passwords['amiadminpwd'],
),
array(
'/etc/asterisk/res_config_mysql.conf',
'^dbpass\s*=\s*',
'dbpass = '.$passwords['amiadminpwd'],
),
array(
'/etc/asterisk/cbmysql.conf',
'^password=',
'password='.$passwords['amiadminpwd'],
),
array(
'/etc/asterisk/cdr_mysql.conf',
'^password\s*=\s*',
'password = '.$passwords['amiadminpwd'],
),
array(
'/etc/asterisk/extensions_additional.conf',
'^AMPDBPASS =',
'AMPDBPASS ='.$passwords['amiadminpwd'],
),
array(
'/etc/asterisk/manager.conf',
array(
'custom', 'change_ami_password'
),
'secret = '.$passwords['amiadminpwd'],
),
array(
'/etc/asterisk/extensions_additional.conf',
'^AMPMGRPASS =',
'AMPMGRPASS ='.$passwords['amiadminpwd'],
),
) as $fileinfo) {
if (file_exists($fileinfo[0])) {
$content = file($fileinfo[0]);
if (is_array($fileinfo[1])) {
switch ($fileinfo[1][0]) {
case 'custom':
if (function_exists($fileinfo[1][1]))
$fileinfo[1][1]($content, $passwords['amiadminpwd']);
break;
}
} else {
for ($i = 0; $i < count($content); $i++) {
if (preg_match("/".$fileinfo[1]."/", rtrim($content[$i], "\r\n"))) {
$content[$i] = $fileinfo[2]."\n";
break;
}
}
}
file_put_contents($fileinfo[0], $content);
}
}
// Verificar si voicemail.conf tiene formato nuevo con includes o viejo todo en uno
$s = file_get_contents('/etc/asterisk/voicemail.conf');
if(!preg_match("/#include vm_general.inc/",$s)) {
$lineas = preg_split("/\n/",$s);
$vm_general_content = '';
$defaultsection=0;
foreach($lineas as $linea) {
if($defaultsection==1 && substr($linea,0,1)=='[') { $defaultsection=0; }
if(preg_match("/\[default\]/",$linea)) {
$defaultsection=1;
}
if($defaultsection==0 && !preg_match("/emailbody/",$linea)) {
if(substr($linea,0,1)=='[' && !preg_match("/general/",$linea)) { $defaultsection=2; continue; }
$vm_general_content.=$linea."\n";
}
if($defaultsection==1) {
if(trim($linea)=='') { continue; }
if(substr(trim($linea),0,1)==';') { continue; }
if(preg_match("/Example/i",$linea) && substr($linea,0,4)=='1234') { continue; }
$default_content.=$linea."\n";
}
}
file_put_contents('/etc/asterisk/vm_general.inc', $vm_general_content);
$r = "[general]
#include vm_general.inc
#include vm_email.inc
";
$r.= "\n$default_content\n";
file_put_contents('/etc/asterisk/voicemail.conf',$r);
}
return TRUE;
}
function change_ami_password(&$content, $sNewPassword)
{
$bAdmin = FALSE;
for ($i = 0; $i < count($content); $i++) {
$regs = NULL;
if (preg_match('/^\[(\w+)\]/', $content[$i], $regs)) {
$bAdmin = ($regs[1] == 'admin');
} elseif ($bAdmin && preg_match('/^secret\s*=\s*/', $content[$i])) {
$content[$i] = "secret = $sNewPassword\n";
}
}
}
// Custom processing after restoring fax database
function postrestore_fx_db($sLevelTag, &$backupComponent, $sWorkingDir)
{
$output = $retval = NULL;
exec('/usr/share/issabel/privileged/faxconfig --refresh', $output, $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to refresh fax configuration after restore\n");
return FALSE;
}
return TRUE;
}
// Custom processing before restoring email database. Strictly speaking, all of
// the database updates are unnecessary, since the sqlite file will be replaced
// anyway, but all of the old accounts and domains should be deleted in cyrus
// and postfix configurations.
function prerestore_em_db($sLevelTag, &$backupComponent, $sWorkingDir)
{
$bSuccess = TRUE;
loadCyrusPassword();
require_once('libs/cyradm.php');
// Connect to IMAP before doing anything else
$cyr_conn = new cyradm;
if (!$cyr_conn->imap_login()) {
fwrite(STDERR, "ERR: $sLevelTag: failed to login to IMAP\n");
return FALSE;
}
$bPostfixIssabel2 = isPostfixToIssabel2();
// Remove all current accounts of all known domains
$removedDomains = array();
$conn = NULL;
try {
$conn = new PDO('sqlite:/var/www/db/email.db');
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sthListAccounts = $conn->prepare(
'SELECT username, password, id_domain, quota FROM accountuser '.
'WHERE id_domain = ? ORDER BY username');
$sthListAliases = $conn->prepare(
'SELECT alias FROM virtual WHERE username = ? ORDER BY alias');
$sthDeleteAccount = $conn->prepare('DELETE FROM accountuser WHERE username = ?');
$sthDeleteAccountDomain = $conn->prepare('DELETE FROM accountuser WHERE id_domain = ?');
$sthDeleteAliases = $conn->prepare('DELETE FROM virtual WHERE username = ?');
$sthDeleteDomain = $conn->prepare('DELETE FROM domain WHERE id = ?');
// Query and list all domains
$sth = $conn->query('SELECT id, domain_name FROM domain ORDER BY domain_name');
$domainList = $sth->fetchAll(PDO::FETCH_ASSOC);
foreach ($domainList as $domain) {
$sthListAccounts->execute(array($domain['id']));
$accountList = $sthListAccounts->fetchAll(PDO::FETCH_ASSOC);
$bAccountsRemoved = TRUE;
foreach ($accountList as $account) {
// Query any aliases for the account, and delete them
$sthListAliases->execute(array($account['username']));
$aliasList = $sthListAliases->fetchAll(PDO::FETCH_COLUMN);
$sthDeleteAliases->execute(array($account['username']));
// Delete account and associated mailbox
$sthDeleteAccount->execute(array($account['username']));
if (!$cyr_conn->deletemb('user/'.$account['username'])) {
fwrite(STDERR, "ERR: $sLevelTag: failed to delete mailbox for username ".
$account['username'].' - '.$cyr_conn->getMessage()."\n");
$bSuccess = FALSE;
$bAccountsRemoved = FALSE;
break;
}
// Remove sasl passwords linked to aliases
if (!$bPostfixIssabel2 && count($aliasList) <= 0)
$aliasList[] = $account['username'].'@'.SASL_DOMAIN;
foreach ($aliasList as $sAlias) {
$retval = NULL;
system('/usr/sbin/saslpasswd2 -d '.escapeshellarg($sAlias), $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to delete alias ".
$sAlias.' for username '.$account['username']."\n");
$bSuccess = FALSE;
$bAccountsRemoved = FALSE;
}
}
}
if (!$bAccountsRemoved) {
fwrite(STDERR, "ERR: $sLevelTag: could not remove all accounts from domain ".
$domain['domain_name'].", skipping remove...\n");
break;
}
$sthDeleteAccountDomain->execute(array($domain['id']));
$sthDeleteDomain->execute(array($domain['id']));
$removedDomains[] = $domain['domain_name'];
}
} catch (PDOException $e) {
fwrite(STDERR, "ERR: $sLevelTag: failed to remove old domains - ".$e->getMessage()."\n");
return FALSE;
}
// Remove domains from /etc/postfix/main.cf and reload postfix.
if (count($removedDomains) > 0) {
$sDomainKey = $bPostfixIssabel2 ? 'virtual_mailbox_domains' : 'mydomain2';
$postfixConf = file('/etc/postfix/main.cf');
if ($postfixConf === FALSE) {
fwrite(STDERR, "ERR: $sLevelTag: failed to load /etc/postfix/main.cf for domain update\n");
$bSuccess = FALSE;
} else {
$bUpdated = FALSE;
foreach (array_keys($postfixConf) as $i) {
$regs = NULL;
if (preg_match('/^(\w+)\s*=\s*(.*)/', rtrim($postfixConf[$i]), $regs)) {
if ($regs[1] == $sDomainKey) {
$oldDomainList = preg_split('/,\s*/', $regs[2]);
$newDomainList = array_diff($oldDomainList, $removedDomains);
$postfixConf[$i] = $sDomainKey.' = '.implode(',', $newDomainList)."\n";
$bUpdated = (count($oldDomainList) != count($newDomainList));
}
}
}
if ($bUpdated) {
if (FALSE === file_put_contents('/etc/postfix/main.cf', $postfixConf)) {
fwrite(STDERR, "ERR: $sLevelTag: failed to write /etc/postfix/main.cf for domain update\n");
$bSuccess = FALSE;
} else {
$retval = NULL;
system('/usr/sbin/postfix reload', $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to reload postfix after domain update ($retval)\n");
$bSuccess = FALSE;
}
}
}
}
}
$cyr_conn->imap_logout();
return $bSuccess;
}
// Custom processing after restoring email database.
function postrestore_em_db($sLevelTag, &$backupComponent, $sWorkingDir)
{
global $CYRUS;
$bSuccess = TRUE;
loadCyrusPassword();
require_once('libs/cyradm.php');
// Connect to IMAP before doing anything else
$cyr_conn = new cyradm;
if (!$cyr_conn->imap_login()) {
fwrite(STDERR, "ERR: $sLevelTag: failed to login to IMAP\n");
return FALSE;
}
$bPostfixIssabel2 = isPostfixToIssabel2();
// Load all of the required domains and accounts
$domainList = array(); $accountList = array();
try {
$conn = new PDO('sqlite:/var/www/db/email.db');
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sth = $conn->query('SELECT domain_name FROM domain ORDER BY domain_name');
$domainList = $sth->fetchAll(PDO::FETCH_COLUMN);
$sth = $conn->query(
'SELECT a.username, a.password, a.quota, d.domain_name '.
'FROM accountuser AS a, domain AS d WHERE d.id = a.id_domain');
$accountList = $sth->fetchAll(PDO::FETCH_ASSOC);
$sth = NULL; $conn = NULL;
} catch (PDOException $e) {
fwrite(STDERR, "ERR: $sLevelTag: failed to query new domains or accounts - ".$e->getMessage()."\n");
return FALSE;
}
// Create all of the new domains and reload postfix
if (count($domainList) > 0) {
$sDomainKey = $bPostfixIssabel2 ? 'virtual_mailbox_domains' : 'mydomain2';
$postfixConf = file('/etc/postfix/main.cf');
if ($postfixConf === FALSE) {
fwrite(STDERR, "ERR: $sLevelTag: failed to load /etc/postfix/main.cf for domain update\n");
$bSuccess = FALSE;
} else {
$bUpdated = FALSE;
$bKeyExists = FALSE;
foreach (array_keys($postfixConf) as $i) {
$regs = NULL;
if (preg_match('/^(\w+)\s*=\s*(.*)/', rtrim($postfixConf[$i]), $regs)) {
if ($regs[1] == $sDomainKey) {
$bKeyExists = TRUE;
$oldDomainList = preg_split('/,\s*/', $regs[2]);
$newDomainList = array_unique(array_merge($oldDomainList, $domainList));
$postfixConf[$i] = $sDomainKey.' = '.implode(',', $newDomainList)."\n";
$bUpdated = (count($oldDomainList) != count($newDomainList));
}
}
}
if (!$bKeyExists) {
$postfixConf[] = $sDomainKey.' = '.implode(',', $domainList)."\n";
$bUpdated = TRUE;
}
if ($bUpdated) {
if (FALSE === file_put_contents('/etc/postfix/main.cf', $postfixConf)) {
fwrite(STDERR, "ERR: $sLevelTag: failed to write /etc/postfix/main.cf for domain update\n");
$bSuccess = FALSE;
} else {
$retval = NULL;
system('/usr/sbin/postfix reload', $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to reload postfix after domain update ($retval)\n");
$bSuccess = FALSE;
}
}
}
}
}
// Create all the new accounts inside the domains
foreach ($accountList as $account) {
$emailFields = explode('@', $account['username']);
$sEmail = $emailFields[0].'@'.$account['domain_name'];
// Assign password for new user
$sAccountCommand = 'echo '.escapeshellarg($account['password']).' | /usr/sbin/saslpasswd2 -c '.
($bPostfixIssabel2
? escapeshellarg($sEmail)
: escapeshellarg($account['username']).' -u '.SASL_DOMAIN);
$retval = NULL;
system($sAccountCommand, $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to create account $sEmail ($retval)\n");
$bSuccess = FALSE;
} else {
// Create mailbox for user
$userpath = 'user/'.$account['username'];
if (!$cyr_conn->createmb($userpath)) {
fwrite(STDERR, "ERR: $sLevelTag: failed to create user {$account['username']}: ".$cyr_conn->getMessage()."\n");
$bSuccess = FALSE;
} elseif (!$cyr_conn->setacl($userpath, $CYRUS['ADMIN'], 'lrswipcda')) {
fwrite(STDERR, "ERR: $sLevelTag: failed to set ACL on user {$account['username']}: ".$cyr_conn->getMessage()."\n");
$bSuccess = FALSE;
} elseif (!$cyr_conn->setmbquota($userpath, $account['quota'])) {
fwrite(STDERR, "ERR: $sLevelTag: failed to set quota on user {$account['username']}: ".$cyr_conn->getMessage()."\n");
$bSuccess = FALSE;
}
}
}
$cyr_conn->imap_logout();
return $bSuccess;
}
// Custom processing after restoring email mailboxes
function postrestore_em_mailbox($sLevelTag, &$backupComponent, $sWorkingDir)
{
$bSuccess = TRUE;
// Query all users of all domains and reconstruct mailboxes
try {
$conn = new PDO('sqlite:/var/www/db/email.db');
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach ($conn->query('SELECT a.username, d.domain_name FROM accountuser AS a, domain AS d WHERE d.id = a.id_domain') as $row) {
$fields = explode('@', $row['username']);
if (count($fields) > 1) {
$username = $fields[0].'@'.$row['domain_name'];
$sMailboxPath = escapeshellarg("user/$username");
$sCmdReconstruct = escapeshellarg("/usr/lib/cyrus-imapd/reconstruct -r -f $sMailboxPath");
$sCmdSu = "su -s /bin/sh - cyrus -c $sCmdReconstruct";
//print "$sCmdSu\n";
$output = $retval = NULL;
exec($sCmdSu, $output, $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to reconstruct mailbox for user $username\n");
$bSuccess = FALSE;
}
}
}
$conn = NULL;
} catch (PDOException $e) {
fwrite(STDERR, "WARN: $sLevelTag: failed to query list of usernames and domains\n");
return FALSE;
}
// Fix quota usage for all the mailboxes
$retval = NULL;
system('su -s /bin/sh - cyrus -c '.escapeshellarg('/usr/lib/cyrus-imapd/quota -f'), $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to repair quotas for mailboxes\n");
$bSuccess = FALSE;
}
exec("/sbin/service cyrus-imapd restart", $output, $ret);
return $bSuccess;
}
/* Need to shut down a2b_callback_daemon if found running, then restart it. This
prevents database restore hanging due to "Waiting for table metadata lock".
*/
$a2b_callback_running = FALSE;
function prerestore_a2billing_db($sLevelTag, &$backupComponent, $sWorkingDir)
{
global $a2b_callback_running;
$output = $retval = NULL;
exec("/sbin/service a2b-callback-daemon status", $output, $retval);
if ($retval == 0) {
$a2b_callback_running = TRUE;
exec("/sbin/service a2b-callback-daemon stop", $output, $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to stop a2b-callback-daemon prior to restore, schema restore might hang!\n");
return FALSE;
}
}
return TRUE;
}
function postrestore_a2billing_db($sLevelTag, &$backupComponent, $sWorkingDir)
{
global $a2b_callback_running;
if ($a2b_callback_running) {
$output = $retval = NULL;
exec("/sbin/service a2b-callback-daemon start", $output, $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to restart a2b-callback-daemon after restore!\n");
return FALSE;
}
}
return TRUE;
}
/* The Call Center CE dialer (issabeldialer) writes to the call_center
* database while it runs, so it is stopped for the duration of a
* callcenter_db restore - the tables it is writing to are being replaced -
* and started again afterwards, only if this code stopped it. Boxes without
* the module have no unit file in any of the usual places and nothing to
* do. The three unit paths are the dashboard's own _existService
* convention. */
$callcenter_dialer_running = FALSE;
function prerestore_callcenter_db($sLevelTag, &$backupComponent, $sWorkingDir)
{
global $callcenter_dialer_running;
$bUnitFound = FALSE;
foreach (array(
'/etc/systemd/system/issabeldialer.service',
'/usr/lib/systemd/system/issabeldialer.service',
'/etc/rc.d/init.d/issabeldialer') as $sUnitPath) {
if (file_exists($sUnitPath)) {
$bUnitFound = TRUE;
break;
}
}
if (!$bUnitFound) return TRUE;
$output = $retval = NULL;
exec('systemctl is-active --quiet issabeldialer', $output, $retval);
if ($retval == 0) {
$callcenter_dialer_running = TRUE;
exec('systemctl stop issabeldialer', $output, $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to stop issabeldialer prior to restore, database restore might hang!\n");
return FALSE;
}
}
return TRUE;
}
function postrestore_callcenter_db($sLevelTag, &$backupComponent, $sWorkingDir)
{
global $callcenter_dialer_running;
if ($callcenter_dialer_running) {
$output = $retval = NULL;
exec('systemctl start issabeldialer', $output, $retval);
if ($retval != 0) {
fwrite(STDERR, "ERR: $sLevelTag: failed to restart issabeldialer after restore!\n");
return FALSE;
}
}
return TRUE;
}
/* Custom processing before restoring mysql database. The mysql schema contains
the root mysql password, which is also present in /etc/issabel.conf. If the
root password has been changed, the act of restoring will impose the root
password of the backed-up system on the restored system. To counter that,
the root password will be restored. A mysql connection will be opened here
and left open through the restore, so that it can be used to GRANT the
password again. See Elastix bug #1462.
*/
$rootconn = NULL;
function prerestore_mysql_db($sLevelTag, &$backupComponent, $sWorkingDir)
{
global $rootconn;
global $sMysqlRootPass;
try {
$rootconn = new PDO('mysql:host=localhost;dbname=mysql', 'root', $sMysqlRootPass);
$rootconn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return TRUE;
} catch (PDOException $e) {
error_exit("FATAL: $sLevelTag: failed to open MySQL connection: ".$e->getMessage()."\n");
}
}
// Custom processing after restoring mysql database.
function postrestore_mysql_db($sLevelTag, &$backupComponent, $sWorkingDir)
{
global $rootconn;
global $sMysqlRootPass;
$bSuccess = TRUE;
try {
$quotedPwd = $rootconn->quote($sMysqlRootPass);
if ($quotedPwd === FALSE) {
fwrite(STDERR, 'FATAL: failed to quote MySQL password');
return FALSE;
}
$rootconn->exec("GRANT USAGE ON *.* TO root@localhost IDENTIFIED BY $quotedPwd");
$rootconn->exec("GRANT USAGE ON *.* TO root IDENTIFIED BY $quotedPwd");
/* In addition to the root password, the asteriskuser password must
also be restored. */
$passwords = load_keys();
if (isset($passwords['amiadminpwd'])) {
$quotedPwd = $rootconn->quote($passwords['amiadminpwd']);
if ($quotedPwd === FALSE) {
fwrite(STDERR, 'FATAL: failed to quote new AMPDBPASS password');
return FALSE;
}
$rootconn->exec("GRANT USAGE ON *.* TO asteriskuser@localhost IDENTIFIED BY $quotedPwd");
} else {
fwrite(STDERR, "ERR: $sLevelTag: failed to find amiadminpwd in issabel.conf\n");
$bSuccess = FALSE;
}
$rootconn->exec('FLUSH PRIVILEGES');
$rootconn = NULL;
return $bSuccess;
} catch (PDOException $e) {
error_exit("FATAL: $sLevelTag: failed to restore MySQL root password: ".$e->getMessage()."\n");
}
}
// Custom processing after restoring acl databases
function postrestore_menu_permissions($sLevelTag, &$backupComponent, $sWorkingDir)
{
global $adminpwd;
$passwords = load_keys();
try {
$conn = new PDO('sqlite:/var/www/db/acl.db');
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sth = $conn->prepare('UPDATE acl_user SET md5_password = ? WHERE name = ?');
$sth->execute(array($adminpwd, 'admin'));
$conn = NULL;
return TRUE;
} catch (PDOException $e) {
fwrite(STDERR, "ERR: $sLevelTag: failed to restore admin password for Issabel\n");
return FALSE;
}
}
?>