Backup & Restore Gone Wrong
Posted: 05 Dec 2022 15:08
Hi Everyone,
I appear to be at the limits of my ability on this one. I need to restore a backup of my efa 4.0.4 to a new instance. I have provisioned the new machine, hardware and storage all the same. I have gone for an AlmaLinux 8.7 install, whereas the old system was CentOS7.
All goes well, until the data is restored from the backup. I have now tried this 3 times, each time I get the same result.
Once the restore is complete, I can no longer log into the Mailwatch GUI, as I just get the red
---
Error: Database connection failed
It is possible that the database is overloaded or otherwise not running properly
Contact the system administrator if the problem persists
---
MariaDB is running, but I cannot login to it no matter which password I use. I have tried root, sqlgrey, and mailwatch passwords from their respective files in /etc/eFa/
Below is the log from the restore process. Can someone see a specific issue here that may help get my restore to work. I can see there are some errors in this, but I do not have enough understanding to know what needs to be addressed here.
--------------------------------------------------------------
--- Welcome to the eFa Configuration program ---
--- https://www.efa-project.org ---
--------------------------------------------------------------
System Restore
!!!WARNING!!!
System Restore is intended to be used in disaster recovery
situations only as a last resort! Rolling back the system
to a recent backup can have consequences, such as the need to
clean up MySQL databases and loss of recent configuration changes.
[eFa] Are you sure you want to continue? (y/N):y
--------------------------------------------------------------
--- Welcome to the eFa Configuration program ---
--- https://www.efa-project.org ---
--------------------------------------------------------------
Backup Listing
1) /var/eFa/backup/backup-20221204-150610.tar.gz
2) /var/eFa/backup/backup-20221128-061549.tar.gz
3) /var/eFa/backup/backup-20221129-081626.tar.gz
4) /var/eFa/backup/backup-20221130-052429.tar.gz
5) /var/eFa/backup/backup-20221201-035145.tar.gz
6) /var/eFa/backup/backup-20221202-084449.tar.gz
7) /var/eFa/backup/backup-20221203-055937.tar.gz
Choose a backup or press (e) to exit:4
You have chosen 4
4) /var/eFa/backup/backup-20221130-052429.tar.gz
Proceed with restore? (y/N)
y
Beginning Restore of /var/eFa/backup/backup-20221130-052429.tar.gz...
./
./backup/
./backup/sql/
./backup/sql/backup.sql
./backup/etc/
./backup/etc/postfix/
./backup/etc/postfix/ssl/
./backup/etc/postfix/ssl/dhparam.pem
./backup/etc/postfix/ssl/smtpd.pem
./backup/etc/postfix/dynamicmaps.cf
./backup/etc/postfix/main.cf
./backup/etc/postfix/master.cf
./backup/etc/postfix/access
./backup/etc/postfix/helo_access
./backup/etc/postfix/recipient_access
./backup/etc/postfix/sender_access
./backup/etc/postfix/transport
./backup/etc/postfix/virtual
./backup/etc/postfix/sasl_passwd
./backup/etc/postfix/relocated
./backup/etc/postfix/canonical
./backup/etc/postfix/generic
./backup/etc/postfix/header_checks
./backup/etc/eFa/
./backup/etc/eFa/eFa-Config
./backup/etc/eFa/MailWatch-Config
./backup/etc/eFa/MySQL-Config
./backup/etc/eFa/openDMARC-Config
./backup/etc/eFa/SA-Config
./backup/etc/eFa/SQLGrey-Config
./backup/etc/sysconfig/
./backup/etc/sysconfig/anaconda
./backup/etc/sysconfig/atd
./backup/etc/sysconfig/cbq/
./backup/etc/sysconfig/cbq/avpkt
./backup/etc/sysconfig/cbq/cbq-0000.example
./backup/etc/sysconfig/certbot
./backup/etc/sysconfig/chronyd
./backup/etc/sysconfig/console/
./backup/etc/sysconfig/cpupower
./backup/etc/sysconfig/crond
./backup/etc/sysconfig/daemons/
./backup/etc/sysconfig/daemons/webmin
./backup/etc/sysconfig/ebtables-config
./backup/etc/sysconfig/firewalld
./backup/etc/sysconfig/freshclam
./backup/etc/sysconfig/grub
./backup/etc/sysconfig/htcacheclean
./backup/etc/sysconfig/httpd
./backup/etc/sysconfig/init
./backup/etc/sysconfig/ip6tables-config
./backup/etc/sysconfig/iptables-config
./backup/etc/sysconfig/irqbalance
./backup/etc/sysconfig/kdump
./backup/etc/sysconfig/kernel
./backup/etc/sysconfig/man-db
./backup/etc/sysconfig/modules/
./backup/etc/sysconfig/netconsole
./backup/etc/sysconfig/network
./backup/etc/sysconfig/network-scripts/
./backup/etc/sysconfig/network-scripts/ifcfg-lo
./backup/etc/sysconfig/network-scripts/ifdown-bnep
./backup/etc/sysconfig/network-scripts/ifdown-eth
./backup/etc/sysconfig/network-scripts/ifdown-ippp
./backup/etc/sysconfig/network-scripts/ifdown-ipv6
./backup/etc/sysconfig/network-scripts/ifdown-post
./backup/etc/sysconfig/network-scripts/ifdown-ppp
./backup/etc/sysconfig/network-scripts/ifdown-routes
./backup/etc/sysconfig/network-scripts/ifdown-sit
./backup/etc/sysconfig/network-scripts/ifdown-tunnel
./backup/etc/sysconfig/network-scripts/ifup-aliases
./backup/etc/sysconfig/network-scripts/ifup-bnep
./backup/etc/sysconfig/network-scripts/ifup-eth
./backup/etc/sysconfig/network-scripts/ifup-ippp
./backup/etc/sysconfig/network-scripts/ifup-ipv6
./backup/etc/sysconfig/network-scripts/ifup-plip
./backup/etc/sysconfig/network-scripts/ifup-plusb
./backup/etc/sysconfig/network-scripts/ifup-post
./backup/etc/sysconfig/network-scripts/ifup-ppp
./backup/etc/sysconfig/network-scripts/ifup-routes
./backup/etc/sysconfig/network-scripts/ifup-sit
./backup/etc/sysconfig/network-scripts/ifup-tunnel
./backup/etc/sysconfig/network-scripts/ifup-wireless
./backup/etc/sysconfig/network-scripts/init.ipv6-global
./backup/etc/sysconfig/network-scripts/network-functions
./backup/etc/sysconfig/network-scripts/network-functions-ipv6
./backup/etc/sysconfig/network-scripts/ifdown-Team
./backup/etc/sysconfig/network-scripts/ifdown-TeamPort
./backup/etc/sysconfig/network-scripts/ifup-Team
./backup/etc/sysconfig/network-scripts/ifup-TeamPort
./backup/etc/sysconfig/network-scripts/ifcfg-eth0
./backup/etc/sysconfig/network-scripts/ifdown-isdn
./backup/etc/sysconfig/network-scripts/ifup-isdn
./backup/etc/sysconfig/network-scripts/ifup
./backup/etc/sysconfig/network-scripts/ifdown
./backup/etc/sysconfig/network-scripts.bak/
./backup/etc/sysconfig/network-scripts.bak/ifcfg-eth0.bak
./backup/etc/sysconfig/ntpdate
./backup/etc/sysconfig/opendkim
./backup/etc/sysconfig/opendmarc
./backup/etc/sysconfig/qemu-ga
./backup/etc/sysconfig/raid-check
./backup/etc/sysconfig/rdisc
./backup/etc/sysconfig/readonly-root
./backup/etc/sysconfig/rpcbind
./backup/etc/sysconfig/rpc-rquotad
./backup/etc/sysconfig/rsyncd
./backup/etc/sysconfig/rsyslog
./backup/etc/sysconfig/run-parts
./backup/etc/sysconfig/saslauthd
./backup/etc/sysconfig/selinux
./backup/etc/sysconfig/smartmontools
./backup/etc/sysconfig/sshd
./backup/etc/sysconfig/sysstat
./backup/etc/sysconfig/sysstat.ioconf
./backup/etc/sysconfig/unbound
./backup/etc/sysconfig/wpa_supplicant
./backup/etc/passwd
./backup/etc/fstab
./backup/etc/shadow
./backup/etc/clamd.d/
./backup/etc/clamd.d/scan.conf
./backup/etc/hosts
./backup/etc/hosts.allow
./backup/etc/hosts.bak
./backup/etc/hosts.deny
./backup/etc/networks
./backup/etc/my.cnf
./backup/etc/my.cnf.d/
./backup/etc/my.cnf.d/client.cnf
./backup/etc/my.cnf.d/enable_encryption.preset
./backup/etc/my.cnf.d/mariadb-server.cnf
./backup/etc/my.cnf.d/mariadb-server.cnf.rpmnew
./backup/etc/my.cnf.d/mysql-clients.cnf
./backup/etc/php.ini
./backup/etc/php-fpm.conf
./backup/etc/php-fpm.d/
./backup/etc/php-fpm.d/www.conf
./backup/etc/resolv.conf
./backup/etc/sudo.conf
./backup/etc/sudoers.d/
./backup/etc/sudoers.d/eFa-Services
./backup/etc/sudoers.d/eFa-users
./backup/etc/sudoers.d/mailwatch
./backup/etc/MailScanner/
./backup/etc/MailScanner/archives.filename.rules
./backup/etc/MailScanner/archives.filename.rules.allowall.conf
./backup/etc/MailScanner/archives.filename.rules.conf
./backup/etc/MailScanner/archives.filetype.rules
./backup/etc/MailScanner/archives.filetype.rules.allowall.conf
./backup/etc/MailScanner/archives.filetype.rules.conf
./backup/etc/MailScanner/conf.d/
./backup/etc/MailScanner/conf.d/README
./backup/etc/MailScanner/country.domains.conf
./backup/etc/MailScanner/custom
./backup/etc/MailScanner/defaults
./backup/etc/MailScanner/filename.rules
./backup/etc/MailScanner/filename.rules.allowall.conf
./backup/etc/MailScanner/filename.rules.conf
./backup/etc/MailScanner/filetype.rules
./backup/etc/MailScanner/filetype.rules.allowall.conf
./backup/etc/MailScanner/filetype.rules.conf
./backup/etc/MailScanner/MailScanner.conf
./backup/etc/MailScanner/mcp/
./backup/etc/MailScanner/mcp/10_example.cf
./backup/etc/MailScanner/mcp/mcp.spamassassin.conf
./backup/etc/MailScanner/mcp/v342.pre
./backup/etc/MailScanner/mcp/v341.pre
./backup/etc/MailScanner/mcp/v340.pre
./backup/etc/MailScanner/mcp/v330.pre
./backup/etc/MailScanner/mcp/v320.pre
./backup/etc/MailScanner/mcp/v312.pre
./backup/etc/MailScanner/mcp/v310.pre
./backup/etc/MailScanner/mcp/init.pre
./backup/etc/MailScanner/numeric.phishing.rules
./backup/etc/MailScanner/phishing.bad.sites.conf
./backup/etc/MailScanner/phishing.bad.sites.conf.master
./backup/etc/MailScanner/phishing.bad.sites.conf.master.backup
./backup/etc/MailScanner/phishing.bad.sites.custom
./backup/etc/MailScanner/phishing.safe.sites.conf
./backup/etc/MailScanner/phishing.safe.sites.conf.master
./backup/etc/MailScanner/phishing.safe.sites.conf.master.backup
./backup/etc/MailScanner/phishing.safe.sites.custom
./backup/etc/MailScanner/reports
./backup/etc/MailScanner/rules/
./backup/etc/MailScanner/rules/EXAMPLES
./backup/etc/MailScanner/rules/README
./backup/etc/MailScanner/rules/bounce.rules
./backup/etc/MailScanner/rules/external.message.rules
./backup/etc/MailScanner/rules/max.message.size.rules
./backup/etc/MailScanner/rules/spam.whitelist.rules
./backup/etc/MailScanner/rules/spam.blacklist.rules
./backup/etc/MailScanner/rules/sig.html.rules
./backup/etc/MailScanner/rules/sig.text.rules
./backup/etc/MailScanner/rules/content.scanning.rules
./backup/etc/MailScanner/rules/password.rules
./backup/etc/MailScanner/spamassassin.conf
./backup/etc/MailScanner/spamassassin.conf.bak
./backup/etc/MailScanner/spam.lists.conf
./backup/etc/MailScanner/virus.scanners.conf
./backup/etc/cron.d/
./backup/etc/cron.d/0hourly
./backup/etc/cron.d/sysstat
./backup/etc/cron.d/raid-check
./backup/etc/cron.d/clamav-update
./backup/etc/cron.d/msre_reload
./backup/etc/cron.d/checkreboot
./backup/etc/cron.d/eFa-Monitor.cron
./backup/etc/cron.daily/
./backup/etc/cron.daily/logrotate
./backup/etc/cron.daily/mlocate
./backup/etc/cron.daily/man-db.cron
./backup/etc/cron.daily/mailscanner
./backup/etc/cron.daily/0yum-daily.cron
./backup/etc/cron.daily/mailwatch
./backup/etc/cron.daily/eFa-Backup.cron
./backup/etc/cron.daily/trim-txrep
./backup/etc/cron.daily/eFa-SAClean
./backup/etc/cron.daily/eFa-Tokens.cron
./backup/etc/cron.daily/eFa-Daily-DMARC
./backup/etc/cron.daily/cron-dccd
./backup/etc/cron.deny
./backup/etc/cron.hourly/
./backup/etc/cron.hourly/0anacron
./backup/etc/cron.hourly/mailscanner
./backup/etc/cron.hourly/0yum-hourly.cron
./backup/etc/cron.monthly/
./backup/etc/cron.monthly/mailwatch
./backup/etc/crontab
./backup/etc/cron.weekly/
./backup/etc/cron.weekly/eFa-Weekly-DMARC
./backup/etc/sqlgrey/
./backup/etc/sqlgrey/clients_fqdn_whitelist
./backup/etc/sqlgrey/clients_fqdn_whitelist.local
./backup/etc/sqlgrey/clients_ip_whitelist
./backup/etc/sqlgrey/clients_ip_whitelist.local
./backup/etc/sqlgrey/discrimination.regexp
./backup/etc/sqlgrey/dyn_fqdn.regexp
./backup/etc/sqlgrey/README
./backup/etc/sqlgrey/smtp_server.regexp
./backup/etc/sqlgrey/sqlgrey.conf
./backup/etc/ssh/
./backup/etc/ssh/moduli
./backup/etc/ssh/ssh_config
./backup/etc/ssh/sshd_config
./backup/etc/ssh/ssh_host_dsa_key
./backup/etc/ssh/ssh_host_dsa_key.pub
./backup/etc/ssh/ssh_host_ecdsa_key
./backup/etc/ssh/ssh_host_ecdsa_key.pub
./backup/etc/ssh/ssh_host_ed25519_key
./backup/etc/ssh/ssh_host_ed25519_key.pub
./backup/etc/ssh/ssh_host_rsa_key
./backup/etc/ssh/ssh_host_rsa_key.pub
./backup/etc/pki/
./backup/etc/pki/CA/
./backup/etc/pki/CA/certs/
./backup/etc/pki/CA/crl/
./backup/etc/pki/CA/newcerts/
./backup/etc/pki/CA/private/
./backup/etc/pki/ca-trust/
./backup/etc/pki/ca-trust/README
./backup/etc/pki/ca-trust/ca-legacy.conf
./backup/etc/pki/ca-trust/extracted/
./backup/etc/pki/ca-trust/extracted/README
./backup/etc/pki/ca-trust/extracted/java/
./backup/etc/pki/ca-trust/extracted/java/README
./backup/etc/pki/ca-trust/extracted/java/cacerts
./backup/etc/pki/ca-trust/extracted/openssl/
./backup/etc/pki/ca-trust/extracted/openssl/README
./backup/etc/pki/ca-trust/extracted/openssl/ca-bundle.trust.crt
./backup/etc/pki/ca-trust/extracted/pem/
./backup/etc/pki/ca-trust/extracted/pem/README
./backup/etc/pki/ca-trust/extracted/pem/tls-ca-bundle.pem
./backup/etc/pki/ca-trust/extracted/pem/email-ca-bundle.pem
./backup/etc/pki/ca-trust/extracted/pem/objsign-ca-bundle.pem
./backup/etc/pki/ca-trust/source/
./backup/etc/pki/ca-trust/source/README
./backup/etc/pki/ca-trust/source/anchors/
./backup/etc/pki/ca-trust/source/blacklist/
./backup/etc/pki/ca-trust/source/ca-bundle.legacy.crt
./backup/etc/pki/dovecot/
./backup/etc/pki/dovecot/certs/
./backup/etc/pki/dovecot/certs/dovecot.pem
./backup/etc/pki/dovecot/dovecot-openssl.cnf
./backup/etc/pki/dovecot/private/
./backup/etc/pki/dovecot/private/dovecot.pem
./backup/etc/pki/java/
./backup/etc/pki/java/cacerts
./backup/etc/pki/nssdb/
./backup/etc/pki/nssdb/cert8.db
./backup/etc/pki/nssdb/cert9.db
./backup/etc/pki/nssdb/key3.db
./backup/etc/pki/nssdb/key4.db
./backup/etc/pki/nssdb/pkcs11.txt
./backup/etc/pki/nssdb/secmod.db
./backup/etc/pki/nss-legacy/
./backup/etc/pki/nss-legacy/nss-rhel7.config
./backup/etc/pki/rpm-gpg/
./backup/etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
./backup/etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-Debug-7
./backup/etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-Testing-7
./backup/etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7
./backup/etc/pki/rpm-gpg/RPM-GPG-KEY-IUS-7
./backup/etc/pki/rsyslog/
./backup/etc/pki/tls/
./backup/etc/pki/tls/certs/
./backup/etc/pki/tls/certs/Makefile
./backup/etc/pki/tls/certs/make-dummy-cert
./backup/etc/pki/tls/certs/renew-dummy-cert
./backup/etc/pki/tls/certs/localhost.crt
./backup/etc/pki/tls/certs/ca-bundle.trust.crt
./backup/etc/pki/tls/certs/ca-bundle.crt
./backup/etc/pki/tls/misc/
./backup/etc/pki/tls/misc/CA
./backup/etc/pki/tls/misc/c_hash
./backup/etc/pki/tls/misc/c_info
./backup/etc/pki/tls/misc/c_issuer
./backup/etc/pki/tls/misc/c_name
./backup/etc/pki/tls/openssl.cnf
./backup/etc/pki/tls/private/
./backup/etc/pki/tls/private/localhost.key
./backup/etc/pki/tls/cert.pem
./backup/etc/httpd/
./backup/etc/httpd/conf/
./backup/etc/httpd/conf/httpd.conf
./backup/etc/httpd/conf/magic
./backup/etc/httpd/conf.d/
./backup/etc/httpd/conf.d/README
./backup/etc/httpd/conf.d/userdir.conf
./backup/etc/httpd/conf.d/php.conf
./backup/etc/httpd/conf.d/ssl.conf
./backup/etc/httpd/conf.d/autoindex.conf.orig
./backup/etc/httpd/conf.d/redirectssl.conf
./backup/etc/httpd/conf.d/fpm.conf
./backup/etc/httpd/conf.d/autoindex.conf
./backup/etc/httpd/conf.d/welcome.conf
./backup/etc/httpd/conf.modules.d/
./backup/etc/httpd/conf.modules.d/00-base.conf
./backup/etc/httpd/conf.modules.d/00-dav.conf
./backup/etc/httpd/conf.modules.d/00-lua.conf
./backup/etc/httpd/conf.modules.d/00-mpm.conf
./backup/etc/httpd/conf.modules.d/00-optional.conf
./backup/etc/httpd/conf.modules.d/00-proxy.conf
./backup/etc/httpd/conf.modules.d/00-systemd.conf
./backup/etc/httpd/conf.modules.d/01-cgi.conf
./backup/etc/httpd/conf.modules.d/README
./backup/etc/httpd/conf.modules.d/15-php.conf
./backup/etc/httpd/conf.modules.d/00-ssl.conf
./backup/etc/httpd/logs
./backup/etc/httpd/modules
./backup/etc/httpd/run
./backup/etc/unbound/
./backup/etc/unbound/conf.d/
./backup/etc/unbound/conf.d/example.com.conf
./backup/etc/unbound/conf.d/forwarders.conf
./backup/etc/unbound/icannbundle.pem
./backup/etc/unbound/keys.d/
./backup/etc/unbound/keys.d/example.com.key
./backup/etc/unbound/local.d/
./backup/etc/unbound/local.d/block-example.com.conf
./backup/etc/unbound/root.key
./backup/etc/unbound/unbound.conf
./backup/etc/unbound/unbound.conf.rpmnew
./backup/etc/unbound/unbound_control.key
./backup/etc/unbound/unbound_control.pem
./backup/etc/unbound/unbound_server.key
./backup/etc/unbound/unbound_server.pem
./backup/etc/mail/
./backup/etc/mail/spamassassin/
./backup/etc/mail/spamassassin/local.cf
./backup/etc/opendkim/
./backup/etc/opendkim/keys/
./backup/etc/opendkim/KeyTable
./backup/etc/opendkim/SigningTable
./backup/etc/opendkim/TrustedHosts
./backup/var/
./backup/var/www/
./backup/var/www/html/
./backup/var/www/html/mailscanner/
./backup/var/www/html/mailscanner/conf.php
Foreign backup detected, performing import...
postmap: warning: /etc/postfix/dynamicmaps.cf: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/cdb: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/ldap: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/mysql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pcre: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pgsql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/sqlite: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/cdb: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/ldap: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/mysql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pcre: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pgsql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/sqlite: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/cdb: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/ldap: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/mysql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pcre: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pgsql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/sqlite: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/cdb: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/ldap: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/mysql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pcre: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pgsql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/sqlite: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/cdb: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/ldap: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/mysql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pcre: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pgsql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/sqlite: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/cdb: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/ldap: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/mysql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pcre: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pgsql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/sqlite: file is owned or writable by non-root users -- skipping this file
Added new: Lockfile Dir = /var/spool/MailScanner/incoming/Locks
Added new: include /etc/MailScanner/conf.d/*
Summary
-------
Read 390 settings from old /etc/MailScanner/MailScanner.conf.original
Used 389 settings from old /etc/MailScanner/MailScanner.conf.original
Used 3 default settings from new /etc/MailScanner/MailScanner.conf.restore
ERROR 1105 (HY000) at line 1: Unknown error
Error: Database connection failed: it is possible that the database is overloaded or otherwise not running properly; contact the system administrator if the problem persists
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Phase 1/7: Checking and upgrading mysql database
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Processing databases
mysql
mysql.column_stats OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.global_priv OK
mysql.gtid_slave_pos OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.index_stats OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.transaction_registry OK
mysql.user OK
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Phase 2/7: Installing used storage engines... Skipped
Phase 3/7: Fixing views
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Phase 4/7: Running 'mysql_fix_privilege_tables'
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Phase 5/7: Fixing table and database names
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Phase 6/7: Checking and upgrading tables
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Processing databases
efa
efa.tokens OK
information_schema
mailscanner
mailscanner.audit_log OK
mailscanner.autorelease OK
mailscanner.blacklist OK
mailscanner.inq OK
mailscanner.maillog OK
mailscanner.mcp_rules OK
mailscanner.mtalog OK
mailscanner.mtalog_ids OK
mailscanner.outq OK
mailscanner.sa_rules OK
mailscanner.saved_filters OK
mailscanner.user_filters OK
mailscanner.users OK
mailscanner.whitelist OK
opendmarc
opendmarc.arcauthresults OK
opendmarc.arcseals OK
opendmarc.domains OK
opendmarc.ipaddr OK
opendmarc.messages OK
opendmarc.reporters OK
opendmarc.requests OK
opendmarc.selectors OK
opendmarc.signatures OK
performance_schema
sa_bayes
sa_bayes.bayes_expire OK
sa_bayes.bayes_global_vars OK
sa_bayes.bayes_seen OK
sa_bayes.bayes_token OK
sa_bayes.bayes_vars OK
sa_bayes.txrep OK
sqlgrey
sqlgrey.config OK
sqlgrey.connect OK
sqlgrey.domain_awl OK
sqlgrey.from_awl OK
sqlgrey.optin_domain OK
sqlgrey.optin_email OK
sqlgrey.optout_domain OK
sqlgrey.optout_email OK
temp
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Phase 7/7: Running 'FLUSH PRIVILEGES'
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
OK
Restore Complete!
A restart is needed to complete restore. Press enter to reboot.
Press [Enter] key to continue...
I appear to be at the limits of my ability on this one. I need to restore a backup of my efa 4.0.4 to a new instance. I have provisioned the new machine, hardware and storage all the same. I have gone for an AlmaLinux 8.7 install, whereas the old system was CentOS7.
All goes well, until the data is restored from the backup. I have now tried this 3 times, each time I get the same result.
Once the restore is complete, I can no longer log into the Mailwatch GUI, as I just get the red
---
Error: Database connection failed
It is possible that the database is overloaded or otherwise not running properly
Contact the system administrator if the problem persists
---
MariaDB is running, but I cannot login to it no matter which password I use. I have tried root, sqlgrey, and mailwatch passwords from their respective files in /etc/eFa/
Below is the log from the restore process. Can someone see a specific issue here that may help get my restore to work. I can see there are some errors in this, but I do not have enough understanding to know what needs to be addressed here.
--------------------------------------------------------------
--- Welcome to the eFa Configuration program ---
--- https://www.efa-project.org ---
--------------------------------------------------------------
System Restore
!!!WARNING!!!
System Restore is intended to be used in disaster recovery
situations only as a last resort! Rolling back the system
to a recent backup can have consequences, such as the need to
clean up MySQL databases and loss of recent configuration changes.
[eFa] Are you sure you want to continue? (y/N):y
--------------------------------------------------------------
--- Welcome to the eFa Configuration program ---
--- https://www.efa-project.org ---
--------------------------------------------------------------
Backup Listing
1) /var/eFa/backup/backup-20221204-150610.tar.gz
2) /var/eFa/backup/backup-20221128-061549.tar.gz
3) /var/eFa/backup/backup-20221129-081626.tar.gz
4) /var/eFa/backup/backup-20221130-052429.tar.gz
5) /var/eFa/backup/backup-20221201-035145.tar.gz
6) /var/eFa/backup/backup-20221202-084449.tar.gz
7) /var/eFa/backup/backup-20221203-055937.tar.gz
Choose a backup or press (e) to exit:4
You have chosen 4
4) /var/eFa/backup/backup-20221130-052429.tar.gz
Proceed with restore? (y/N)
y
Beginning Restore of /var/eFa/backup/backup-20221130-052429.tar.gz...
./
./backup/
./backup/sql/
./backup/sql/backup.sql
./backup/etc/
./backup/etc/postfix/
./backup/etc/postfix/ssl/
./backup/etc/postfix/ssl/dhparam.pem
./backup/etc/postfix/ssl/smtpd.pem
./backup/etc/postfix/dynamicmaps.cf
./backup/etc/postfix/main.cf
./backup/etc/postfix/master.cf
./backup/etc/postfix/access
./backup/etc/postfix/helo_access
./backup/etc/postfix/recipient_access
./backup/etc/postfix/sender_access
./backup/etc/postfix/transport
./backup/etc/postfix/virtual
./backup/etc/postfix/sasl_passwd
./backup/etc/postfix/relocated
./backup/etc/postfix/canonical
./backup/etc/postfix/generic
./backup/etc/postfix/header_checks
./backup/etc/eFa/
./backup/etc/eFa/eFa-Config
./backup/etc/eFa/MailWatch-Config
./backup/etc/eFa/MySQL-Config
./backup/etc/eFa/openDMARC-Config
./backup/etc/eFa/SA-Config
./backup/etc/eFa/SQLGrey-Config
./backup/etc/sysconfig/
./backup/etc/sysconfig/anaconda
./backup/etc/sysconfig/atd
./backup/etc/sysconfig/cbq/
./backup/etc/sysconfig/cbq/avpkt
./backup/etc/sysconfig/cbq/cbq-0000.example
./backup/etc/sysconfig/certbot
./backup/etc/sysconfig/chronyd
./backup/etc/sysconfig/console/
./backup/etc/sysconfig/cpupower
./backup/etc/sysconfig/crond
./backup/etc/sysconfig/daemons/
./backup/etc/sysconfig/daemons/webmin
./backup/etc/sysconfig/ebtables-config
./backup/etc/sysconfig/firewalld
./backup/etc/sysconfig/freshclam
./backup/etc/sysconfig/grub
./backup/etc/sysconfig/htcacheclean
./backup/etc/sysconfig/httpd
./backup/etc/sysconfig/init
./backup/etc/sysconfig/ip6tables-config
./backup/etc/sysconfig/iptables-config
./backup/etc/sysconfig/irqbalance
./backup/etc/sysconfig/kdump
./backup/etc/sysconfig/kernel
./backup/etc/sysconfig/man-db
./backup/etc/sysconfig/modules/
./backup/etc/sysconfig/netconsole
./backup/etc/sysconfig/network
./backup/etc/sysconfig/network-scripts/
./backup/etc/sysconfig/network-scripts/ifcfg-lo
./backup/etc/sysconfig/network-scripts/ifdown-bnep
./backup/etc/sysconfig/network-scripts/ifdown-eth
./backup/etc/sysconfig/network-scripts/ifdown-ippp
./backup/etc/sysconfig/network-scripts/ifdown-ipv6
./backup/etc/sysconfig/network-scripts/ifdown-post
./backup/etc/sysconfig/network-scripts/ifdown-ppp
./backup/etc/sysconfig/network-scripts/ifdown-routes
./backup/etc/sysconfig/network-scripts/ifdown-sit
./backup/etc/sysconfig/network-scripts/ifdown-tunnel
./backup/etc/sysconfig/network-scripts/ifup-aliases
./backup/etc/sysconfig/network-scripts/ifup-bnep
./backup/etc/sysconfig/network-scripts/ifup-eth
./backup/etc/sysconfig/network-scripts/ifup-ippp
./backup/etc/sysconfig/network-scripts/ifup-ipv6
./backup/etc/sysconfig/network-scripts/ifup-plip
./backup/etc/sysconfig/network-scripts/ifup-plusb
./backup/etc/sysconfig/network-scripts/ifup-post
./backup/etc/sysconfig/network-scripts/ifup-ppp
./backup/etc/sysconfig/network-scripts/ifup-routes
./backup/etc/sysconfig/network-scripts/ifup-sit
./backup/etc/sysconfig/network-scripts/ifup-tunnel
./backup/etc/sysconfig/network-scripts/ifup-wireless
./backup/etc/sysconfig/network-scripts/init.ipv6-global
./backup/etc/sysconfig/network-scripts/network-functions
./backup/etc/sysconfig/network-scripts/network-functions-ipv6
./backup/etc/sysconfig/network-scripts/ifdown-Team
./backup/etc/sysconfig/network-scripts/ifdown-TeamPort
./backup/etc/sysconfig/network-scripts/ifup-Team
./backup/etc/sysconfig/network-scripts/ifup-TeamPort
./backup/etc/sysconfig/network-scripts/ifcfg-eth0
./backup/etc/sysconfig/network-scripts/ifdown-isdn
./backup/etc/sysconfig/network-scripts/ifup-isdn
./backup/etc/sysconfig/network-scripts/ifup
./backup/etc/sysconfig/network-scripts/ifdown
./backup/etc/sysconfig/network-scripts.bak/
./backup/etc/sysconfig/network-scripts.bak/ifcfg-eth0.bak
./backup/etc/sysconfig/ntpdate
./backup/etc/sysconfig/opendkim
./backup/etc/sysconfig/opendmarc
./backup/etc/sysconfig/qemu-ga
./backup/etc/sysconfig/raid-check
./backup/etc/sysconfig/rdisc
./backup/etc/sysconfig/readonly-root
./backup/etc/sysconfig/rpcbind
./backup/etc/sysconfig/rpc-rquotad
./backup/etc/sysconfig/rsyncd
./backup/etc/sysconfig/rsyslog
./backup/etc/sysconfig/run-parts
./backup/etc/sysconfig/saslauthd
./backup/etc/sysconfig/selinux
./backup/etc/sysconfig/smartmontools
./backup/etc/sysconfig/sshd
./backup/etc/sysconfig/sysstat
./backup/etc/sysconfig/sysstat.ioconf
./backup/etc/sysconfig/unbound
./backup/etc/sysconfig/wpa_supplicant
./backup/etc/passwd
./backup/etc/fstab
./backup/etc/shadow
./backup/etc/clamd.d/
./backup/etc/clamd.d/scan.conf
./backup/etc/hosts
./backup/etc/hosts.allow
./backup/etc/hosts.bak
./backup/etc/hosts.deny
./backup/etc/networks
./backup/etc/my.cnf
./backup/etc/my.cnf.d/
./backup/etc/my.cnf.d/client.cnf
./backup/etc/my.cnf.d/enable_encryption.preset
./backup/etc/my.cnf.d/mariadb-server.cnf
./backup/etc/my.cnf.d/mariadb-server.cnf.rpmnew
./backup/etc/my.cnf.d/mysql-clients.cnf
./backup/etc/php.ini
./backup/etc/php-fpm.conf
./backup/etc/php-fpm.d/
./backup/etc/php-fpm.d/www.conf
./backup/etc/resolv.conf
./backup/etc/sudo.conf
./backup/etc/sudoers.d/
./backup/etc/sudoers.d/eFa-Services
./backup/etc/sudoers.d/eFa-users
./backup/etc/sudoers.d/mailwatch
./backup/etc/MailScanner/
./backup/etc/MailScanner/archives.filename.rules
./backup/etc/MailScanner/archives.filename.rules.allowall.conf
./backup/etc/MailScanner/archives.filename.rules.conf
./backup/etc/MailScanner/archives.filetype.rules
./backup/etc/MailScanner/archives.filetype.rules.allowall.conf
./backup/etc/MailScanner/archives.filetype.rules.conf
./backup/etc/MailScanner/conf.d/
./backup/etc/MailScanner/conf.d/README
./backup/etc/MailScanner/country.domains.conf
./backup/etc/MailScanner/custom
./backup/etc/MailScanner/defaults
./backup/etc/MailScanner/filename.rules
./backup/etc/MailScanner/filename.rules.allowall.conf
./backup/etc/MailScanner/filename.rules.conf
./backup/etc/MailScanner/filetype.rules
./backup/etc/MailScanner/filetype.rules.allowall.conf
./backup/etc/MailScanner/filetype.rules.conf
./backup/etc/MailScanner/MailScanner.conf
./backup/etc/MailScanner/mcp/
./backup/etc/MailScanner/mcp/10_example.cf
./backup/etc/MailScanner/mcp/mcp.spamassassin.conf
./backup/etc/MailScanner/mcp/v342.pre
./backup/etc/MailScanner/mcp/v341.pre
./backup/etc/MailScanner/mcp/v340.pre
./backup/etc/MailScanner/mcp/v330.pre
./backup/etc/MailScanner/mcp/v320.pre
./backup/etc/MailScanner/mcp/v312.pre
./backup/etc/MailScanner/mcp/v310.pre
./backup/etc/MailScanner/mcp/init.pre
./backup/etc/MailScanner/numeric.phishing.rules
./backup/etc/MailScanner/phishing.bad.sites.conf
./backup/etc/MailScanner/phishing.bad.sites.conf.master
./backup/etc/MailScanner/phishing.bad.sites.conf.master.backup
./backup/etc/MailScanner/phishing.bad.sites.custom
./backup/etc/MailScanner/phishing.safe.sites.conf
./backup/etc/MailScanner/phishing.safe.sites.conf.master
./backup/etc/MailScanner/phishing.safe.sites.conf.master.backup
./backup/etc/MailScanner/phishing.safe.sites.custom
./backup/etc/MailScanner/reports
./backup/etc/MailScanner/rules/
./backup/etc/MailScanner/rules/EXAMPLES
./backup/etc/MailScanner/rules/README
./backup/etc/MailScanner/rules/bounce.rules
./backup/etc/MailScanner/rules/external.message.rules
./backup/etc/MailScanner/rules/max.message.size.rules
./backup/etc/MailScanner/rules/spam.whitelist.rules
./backup/etc/MailScanner/rules/spam.blacklist.rules
./backup/etc/MailScanner/rules/sig.html.rules
./backup/etc/MailScanner/rules/sig.text.rules
./backup/etc/MailScanner/rules/content.scanning.rules
./backup/etc/MailScanner/rules/password.rules
./backup/etc/MailScanner/spamassassin.conf
./backup/etc/MailScanner/spamassassin.conf.bak
./backup/etc/MailScanner/spam.lists.conf
./backup/etc/MailScanner/virus.scanners.conf
./backup/etc/cron.d/
./backup/etc/cron.d/0hourly
./backup/etc/cron.d/sysstat
./backup/etc/cron.d/raid-check
./backup/etc/cron.d/clamav-update
./backup/etc/cron.d/msre_reload
./backup/etc/cron.d/checkreboot
./backup/etc/cron.d/eFa-Monitor.cron
./backup/etc/cron.daily/
./backup/etc/cron.daily/logrotate
./backup/etc/cron.daily/mlocate
./backup/etc/cron.daily/man-db.cron
./backup/etc/cron.daily/mailscanner
./backup/etc/cron.daily/0yum-daily.cron
./backup/etc/cron.daily/mailwatch
./backup/etc/cron.daily/eFa-Backup.cron
./backup/etc/cron.daily/trim-txrep
./backup/etc/cron.daily/eFa-SAClean
./backup/etc/cron.daily/eFa-Tokens.cron
./backup/etc/cron.daily/eFa-Daily-DMARC
./backup/etc/cron.daily/cron-dccd
./backup/etc/cron.deny
./backup/etc/cron.hourly/
./backup/etc/cron.hourly/0anacron
./backup/etc/cron.hourly/mailscanner
./backup/etc/cron.hourly/0yum-hourly.cron
./backup/etc/cron.monthly/
./backup/etc/cron.monthly/mailwatch
./backup/etc/crontab
./backup/etc/cron.weekly/
./backup/etc/cron.weekly/eFa-Weekly-DMARC
./backup/etc/sqlgrey/
./backup/etc/sqlgrey/clients_fqdn_whitelist
./backup/etc/sqlgrey/clients_fqdn_whitelist.local
./backup/etc/sqlgrey/clients_ip_whitelist
./backup/etc/sqlgrey/clients_ip_whitelist.local
./backup/etc/sqlgrey/discrimination.regexp
./backup/etc/sqlgrey/dyn_fqdn.regexp
./backup/etc/sqlgrey/README
./backup/etc/sqlgrey/smtp_server.regexp
./backup/etc/sqlgrey/sqlgrey.conf
./backup/etc/ssh/
./backup/etc/ssh/moduli
./backup/etc/ssh/ssh_config
./backup/etc/ssh/sshd_config
./backup/etc/ssh/ssh_host_dsa_key
./backup/etc/ssh/ssh_host_dsa_key.pub
./backup/etc/ssh/ssh_host_ecdsa_key
./backup/etc/ssh/ssh_host_ecdsa_key.pub
./backup/etc/ssh/ssh_host_ed25519_key
./backup/etc/ssh/ssh_host_ed25519_key.pub
./backup/etc/ssh/ssh_host_rsa_key
./backup/etc/ssh/ssh_host_rsa_key.pub
./backup/etc/pki/
./backup/etc/pki/CA/
./backup/etc/pki/CA/certs/
./backup/etc/pki/CA/crl/
./backup/etc/pki/CA/newcerts/
./backup/etc/pki/CA/private/
./backup/etc/pki/ca-trust/
./backup/etc/pki/ca-trust/README
./backup/etc/pki/ca-trust/ca-legacy.conf
./backup/etc/pki/ca-trust/extracted/
./backup/etc/pki/ca-trust/extracted/README
./backup/etc/pki/ca-trust/extracted/java/
./backup/etc/pki/ca-trust/extracted/java/README
./backup/etc/pki/ca-trust/extracted/java/cacerts
./backup/etc/pki/ca-trust/extracted/openssl/
./backup/etc/pki/ca-trust/extracted/openssl/README
./backup/etc/pki/ca-trust/extracted/openssl/ca-bundle.trust.crt
./backup/etc/pki/ca-trust/extracted/pem/
./backup/etc/pki/ca-trust/extracted/pem/README
./backup/etc/pki/ca-trust/extracted/pem/tls-ca-bundle.pem
./backup/etc/pki/ca-trust/extracted/pem/email-ca-bundle.pem
./backup/etc/pki/ca-trust/extracted/pem/objsign-ca-bundle.pem
./backup/etc/pki/ca-trust/source/
./backup/etc/pki/ca-trust/source/README
./backup/etc/pki/ca-trust/source/anchors/
./backup/etc/pki/ca-trust/source/blacklist/
./backup/etc/pki/ca-trust/source/ca-bundle.legacy.crt
./backup/etc/pki/dovecot/
./backup/etc/pki/dovecot/certs/
./backup/etc/pki/dovecot/certs/dovecot.pem
./backup/etc/pki/dovecot/dovecot-openssl.cnf
./backup/etc/pki/dovecot/private/
./backup/etc/pki/dovecot/private/dovecot.pem
./backup/etc/pki/java/
./backup/etc/pki/java/cacerts
./backup/etc/pki/nssdb/
./backup/etc/pki/nssdb/cert8.db
./backup/etc/pki/nssdb/cert9.db
./backup/etc/pki/nssdb/key3.db
./backup/etc/pki/nssdb/key4.db
./backup/etc/pki/nssdb/pkcs11.txt
./backup/etc/pki/nssdb/secmod.db
./backup/etc/pki/nss-legacy/
./backup/etc/pki/nss-legacy/nss-rhel7.config
./backup/etc/pki/rpm-gpg/
./backup/etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
./backup/etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-Debug-7
./backup/etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-Testing-7
./backup/etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7
./backup/etc/pki/rpm-gpg/RPM-GPG-KEY-IUS-7
./backup/etc/pki/rsyslog/
./backup/etc/pki/tls/
./backup/etc/pki/tls/certs/
./backup/etc/pki/tls/certs/Makefile
./backup/etc/pki/tls/certs/make-dummy-cert
./backup/etc/pki/tls/certs/renew-dummy-cert
./backup/etc/pki/tls/certs/localhost.crt
./backup/etc/pki/tls/certs/ca-bundle.trust.crt
./backup/etc/pki/tls/certs/ca-bundle.crt
./backup/etc/pki/tls/misc/
./backup/etc/pki/tls/misc/CA
./backup/etc/pki/tls/misc/c_hash
./backup/etc/pki/tls/misc/c_info
./backup/etc/pki/tls/misc/c_issuer
./backup/etc/pki/tls/misc/c_name
./backup/etc/pki/tls/openssl.cnf
./backup/etc/pki/tls/private/
./backup/etc/pki/tls/private/localhost.key
./backup/etc/pki/tls/cert.pem
./backup/etc/httpd/
./backup/etc/httpd/conf/
./backup/etc/httpd/conf/httpd.conf
./backup/etc/httpd/conf/magic
./backup/etc/httpd/conf.d/
./backup/etc/httpd/conf.d/README
./backup/etc/httpd/conf.d/userdir.conf
./backup/etc/httpd/conf.d/php.conf
./backup/etc/httpd/conf.d/ssl.conf
./backup/etc/httpd/conf.d/autoindex.conf.orig
./backup/etc/httpd/conf.d/redirectssl.conf
./backup/etc/httpd/conf.d/fpm.conf
./backup/etc/httpd/conf.d/autoindex.conf
./backup/etc/httpd/conf.d/welcome.conf
./backup/etc/httpd/conf.modules.d/
./backup/etc/httpd/conf.modules.d/00-base.conf
./backup/etc/httpd/conf.modules.d/00-dav.conf
./backup/etc/httpd/conf.modules.d/00-lua.conf
./backup/etc/httpd/conf.modules.d/00-mpm.conf
./backup/etc/httpd/conf.modules.d/00-optional.conf
./backup/etc/httpd/conf.modules.d/00-proxy.conf
./backup/etc/httpd/conf.modules.d/00-systemd.conf
./backup/etc/httpd/conf.modules.d/01-cgi.conf
./backup/etc/httpd/conf.modules.d/README
./backup/etc/httpd/conf.modules.d/15-php.conf
./backup/etc/httpd/conf.modules.d/00-ssl.conf
./backup/etc/httpd/logs
./backup/etc/httpd/modules
./backup/etc/httpd/run
./backup/etc/unbound/
./backup/etc/unbound/conf.d/
./backup/etc/unbound/conf.d/example.com.conf
./backup/etc/unbound/conf.d/forwarders.conf
./backup/etc/unbound/icannbundle.pem
./backup/etc/unbound/keys.d/
./backup/etc/unbound/keys.d/example.com.key
./backup/etc/unbound/local.d/
./backup/etc/unbound/local.d/block-example.com.conf
./backup/etc/unbound/root.key
./backup/etc/unbound/unbound.conf
./backup/etc/unbound/unbound.conf.rpmnew
./backup/etc/unbound/unbound_control.key
./backup/etc/unbound/unbound_control.pem
./backup/etc/unbound/unbound_server.key
./backup/etc/unbound/unbound_server.pem
./backup/etc/mail/
./backup/etc/mail/spamassassin/
./backup/etc/mail/spamassassin/local.cf
./backup/etc/opendkim/
./backup/etc/opendkim/keys/
./backup/etc/opendkim/KeyTable
./backup/etc/opendkim/SigningTable
./backup/etc/opendkim/TrustedHosts
./backup/var/
./backup/var/www/
./backup/var/www/html/
./backup/var/www/html/mailscanner/
./backup/var/www/html/mailscanner/conf.php
Foreign backup detected, performing import...
postmap: warning: /etc/postfix/dynamicmaps.cf: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/cdb: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/ldap: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/mysql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pcre: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pgsql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/sqlite: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/cdb: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/ldap: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/mysql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pcre: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pgsql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/sqlite: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/cdb: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/ldap: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/mysql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pcre: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pgsql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/sqlite: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/cdb: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/ldap: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/mysql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pcre: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pgsql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/sqlite: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/cdb: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/ldap: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/mysql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pcre: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pgsql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/sqlite: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/cdb: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/ldap: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/mysql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pcre: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/pgsql: file is owned or writable by non-root users -- skipping this file
postmap: warning: /etc/postfix/dynamicmaps.cf.d/sqlite: file is owned or writable by non-root users -- skipping this file
Added new: Lockfile Dir = /var/spool/MailScanner/incoming/Locks
Added new: include /etc/MailScanner/conf.d/*
Summary
-------
Read 390 settings from old /etc/MailScanner/MailScanner.conf.original
Used 389 settings from old /etc/MailScanner/MailScanner.conf.original
Used 3 default settings from new /etc/MailScanner/MailScanner.conf.restore
ERROR 1105 (HY000) at line 1: Unknown error
Error: Database connection failed: it is possible that the database is overloaded or otherwise not running properly; contact the system administrator if the problem persists
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Phase 1/7: Checking and upgrading mysql database
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Processing databases
mysql
mysql.column_stats OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.global_priv OK
mysql.gtid_slave_pos OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.index_stats OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.transaction_registry OK
mysql.user OK
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Phase 2/7: Installing used storage engines... Skipped
Phase 3/7: Fixing views
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Phase 4/7: Running 'mysql_fix_privilege_tables'
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Phase 5/7: Fixing table and database names
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Phase 6/7: Checking and upgrading tables
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Processing databases
efa
efa.tokens OK
information_schema
mailscanner
mailscanner.audit_log OK
mailscanner.autorelease OK
mailscanner.blacklist OK
mailscanner.inq OK
mailscanner.maillog OK
mailscanner.mcp_rules OK
mailscanner.mtalog OK
mailscanner.mtalog_ids OK
mailscanner.outq OK
mailscanner.sa_rules OK
mailscanner.saved_filters OK
mailscanner.user_filters OK
mailscanner.users OK
mailscanner.whitelist OK
opendmarc
opendmarc.arcauthresults OK
opendmarc.arcseals OK
opendmarc.domains OK
opendmarc.ipaddr OK
opendmarc.messages OK
opendmarc.reporters OK
opendmarc.requests OK
opendmarc.selectors OK
opendmarc.signatures OK
performance_schema
sa_bayes
sa_bayes.bayes_expire OK
sa_bayes.bayes_global_vars OK
sa_bayes.bayes_seen OK
sa_bayes.bayes_token OK
sa_bayes.bayes_vars OK
sa_bayes.txrep OK
sqlgrey
sqlgrey.config OK
sqlgrey.connect OK
sqlgrey.domain_awl OK
sqlgrey.from_awl OK
sqlgrey.optin_domain OK
sqlgrey.optin_email OK
sqlgrey.optout_domain OK
sqlgrey.optout_email OK
temp
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Phase 7/7: Running 'FLUSH PRIVILEGES'
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
OK
Restore Complete!
A restart is needed to complete restore. Press enter to reboot.
Press [Enter] key to continue...