Backup/Restore errors

Submitted by g.carabetta on Thu, 02/23/2017 - 09:50 Pro Licensee

I'm trying to migrate my domains from a Virtualmin on CentOs 6.8 (Webmin 1.821/Virtualmin 5.04) to CentOs 7 (Webmin 1.831/Virtualmin 5.05).

I'm following the virtualmin backup/restore precedure from cli: virtualmin restore-domain --source /mnt/backup/ --all-domains --all-features

I got some errors: some domains does not have the /etc/logrotate.d/$DOM.conf file, I don't know why. So, I created them by hand, copying anoter one and correcting name and content, but the errors persists.

I did a new copy of backup with --continue-on-error.

On the restore side, I did not find all logrotate files I expect, also the correctly backupped ones. The .tar.gz contains it (./.backup/$DOM_logrotate), but seems that they are not restored. Just few of them, I cannot undestand which one yes and which no...

But I can copy it by hand

Instead, I got errors in apache config and ssl certificates:

Applying web server configuration ..
.. failed! An Apache configuration error was detected : (2)No such file or directory: AH02297: Cannot access directory '/var/log/virtualmin/' for log file '/var/log/virtualmin/febaf.it_access_log' defined at /etc/httpd/conf/httpd.conf:367

AH00014: Configuration check failed

Applying web server configuration ..
.. failed! An Apache configuration error was detected : AH00526: Syntax error on line 733 of /etc/httpd/conf/httpd.conf:

SSLCACertificateFile: file '/home/ossif/ssl.ca' does not exist or is empty

And the .conf file seems to have not "imported" the failing lines, but both the folder and the files exists.

I'm wrong somewhere?

Thanks a lot!

Status: 
Active

Comments

Submitted by andreychek on Thu, 02/23/2017 - 10:06

Howdy -- thanks for contacting us!

Let's start with that first error... you're saying that /var/log/virtualmin/ does exist?

Perhaps there's a permissions issue of some sort then.

What is the output of this command:

ls -la /var/log/virtualmin/

Submitted by g.carabetta on Tue, 02/28/2017 - 05:35 Pro Licensee

[root@vsp01 ~]# ls -la /var/log/virtualmin/
total 32
drwx--x--x.  2 root          root   4096 Feb 26 03:36 .
drwxr-xr-x. 13 root          root   4096 Feb 28 03:38 ..
-rw-r--r--.  1 root          root      0 Feb 23 16:11 abics.it_access_log
-rw-r--r--.  1 root          root      0 Feb 23 16:06 abiformazione.it_access_log
-rw-rw----.  1 abi           apache    0 Feb 26 03:36 abi.it_access_log
-rw-rw----.  1 abi           apache 2997 Feb 23 14:36 abi.it_access_log-20170226.gz
-rw-rw----.  1 abi           apache    0 Feb 26 03:36 abi.it_error_log
-rw-rw----.  1 abi           apache   20 Feb 23 16:09 abi.it_error_log-20170226.gz
-rw-r--r--.  1 root          root      0 Feb 23 16:12 abilearning.it_access_log
-rw-r--r--.  1 root          root      0 Feb 23 16:10 apb.it_access_log
-rw-r--r--.  1 root          root      0 Feb 23 16:21 canali.abilearning.it_access_log
-rw-rw----.  1 comunicazione apache    0 Feb 26 03:36 comunicazione.bancariaeditrice.it_access_log
-rw-rw----.  1 comunicazione apache 2211 Feb 23 15:24 comunicazione.bancariaeditrice.it_access_log-20170226.gz
-rw-rw----.  1 comunicazione apache    0 Feb 26 03:36 comunicazione.bancariaeditrice.it_error_log
-rw-rw----.  1 comunicazione apache   20 Feb 23 16:09 comunicazione.bancariaeditrice.it_error_log-20170226.gz
-rw-r--r--.  1 root          root      0 Feb 23 16:20 culturacreativa.it_access_log
-rw-r--r--.  1 root          root      0 Feb 23 16:16 dev.abiformazione.it_access_log
-rw-r--r--.  1 root          root      0 Feb 23 16:06 ossif.it_access_log
-rw-r--r--.  1 root          root      0 Feb 23 16:20 scuderiedipalazzoaltieri.it_access_log
-rw-r--r--.  1 root          root      0 Feb 23 16:11 seda.sepaitalia.eu_access_log
-rw-r--r--.  1 root          root      0 Feb 23 16:16 svil.abiformazione.it_access_log
-rw-r--r--.  1 root          root      0 Feb 23 16:15 vsp01.abi.it_access_log
-rw-r--r--.  1 root          root      0 Feb 23 16:11 www2.conciliatorebancario.it_access_log
-rw-r--r--.  1 root          root      0 Feb 23 16:12 www3.abi.it_access_log
-rw-rw----.  1 tfargentina   apache    0 Feb 26 03:36 wwww.tfargentina.it_access_log
-rw-rw----.  1 tfargentina   apache   20 Feb 23 16:06 wwww.tfargentina.it_access_log-20170226.gz
-rw-rw----.  1 tfargentina   apache    0 Feb 26 03:36 wwww.tfargentina.it_error_log
-rw-rw----.  1 tfargentina   apache   20 Feb 23 16:06 wwww.tfargentina.it_error_log-20170226.gz
[root@vsp01 ~]#

Submitted by andreychek on Tue, 02/28/2017 - 10:27

Hmm, we may want to try to make a few permissions tweaks to see if that helps.

Try running these commands:

chmod 660 /var/log/virtualmin/*
chgrp apache /var/log/virtualmin/*
service httpd restart

Does that resolve the error about not being able to access /var/log/virtualmin?

Submitted by g.carabetta on Wed, 03/01/2017 - 05:09 Pro Licensee

I did some other tests. After faild restore (I let the VM in its state, not going back to previous snapshot), I added one of the failing lines in httpd.conf:

CustomLog /var/log/virtualmin/mediakit.bancaforte.it_access_log combined

Doing a httpd -t it does not report errors. Then service httpd restart: /var/log/messages, /var/log/httpd/error_log, /var/log/httpd/access_log does not report errors.

Only news is the presence of a new file, as expected:

[root@vsp01 virtualmin]# ls -latr /var/log/virtualmin
total 32
-rw-rw----.  1 abi           apache 2997 Feb 23 14:36 abi.it_access_log-20170226.gz
[...omissis...]
-rw-rw----.  1 tfargentina   apache    0 Feb 26 03:36 wwww.tfargentina.it_access_log
drwxr-xr-x. 13 root          root   4096 Mar  1 03:46 ..
-rw-r--r--.  1 root          root      0 Mar  1 11:46 mediakit.bancaforte.it_access_log
drwx--x--x.  2 root          root   4096 Mar  1 11:46 .

Then I launched the chmod/chown hack.

Now I'm running the restore again, overwritting all.

I think there is some little problem in restore script: may be related to dots in file/folder names, or something like that? No, not dots, because at least one other domain is restored... uhm...

Submitted by g.carabetta on Wed, 03/01/2017 - 07:37 Pro Licensee

Ok, restore ended without the /var/log/virtualmin error. But the httpd.conf lack a lot of CustomLog settings... I think I'll recreate the new by diff/hand...

Also the certificate error's are gone: may be they are copyed too late, respect the apache test?

Now I'll try to do the restore again from the snapshot point (near a fresh install).

Submitted by g.carabetta on Tue, 03/07/2017 - 05:15 Pro Licensee

Now I found that the restore process does not import DB data....

Submitted by andreychek on Tue, 03/07/2017 - 08:54

It sounds like you're seeing a lot of issues with restores there!

Normally those work very smoothly. Sorry about all the trouble!

Are you by chance seeing any errors during the restore process? Actually, could you perhaps share the full output you receive while restoring a domain?

Submitted by g.carabetta on Tue, 03/07/2017 - 09:47 Pro Licensee

Unfortunately... :(

Being production environment, I have to check step by step the correctness of restore: I hope I do not introduce errors!

To avoid this, I reboot from a clean situation, through a vmware snapshot, and try to "find" things to fix.

Now, the last log restore has not given specific errors, but the db were not imported, the logrotate not exported / imported, and the httpd.conf me are redone by hand.

It is not that there is a more detailed log of the restore?

What is shown in stdout is this:

[root@vsp01 ~]# virtualmin restore-domain --source /mnt/backup/virtualmin.tar.gz --all-virtualmin
Checking for missing features ..
.. all features in backup are supported

Checking for errors in backup ..
.. no errors found

Starting restore..
Extracting backup archive file ..
.. done

Restoring Virtualmin settings ..
    Restoring Virtualmin configuration ..
    .. done

    Restoring templates and plans ..
    .. done

    Restoring resellers ..
    .. done

    Restoring email templates ..
    .. done

    Restoring custom fields, links, categories and shells ..
    .. done

    Restoring custom script installers ..
    .. done

    Restoring scheduled backups and keys ..
    .. done

    Restoring FTP directory restrictions ..
    .. done

    Restoring DKIM settings ..
    .. not installed

    Restoring greylisting settings ..
    .. not installed

    Restoring rate limiting settings ..
    .. not configured on this system

    Restoring mail server configuration ..
    .. done

.. done

Applying FTP server configuration ..
.. done

Restore completed successfully.

[root@vsp01 ~]# time virtualmin restore-domain --source /mnt/backup/ --all-domains --all-features --continue-on-error
Checking for missing features ..
.. all features in backup are supported

Checking for errors in backup ..
.. no errors found

Starting restore..
Extracting backup archive files ..
.. done

Re-creating virtual server febaf.it ..
    Creating administration group febaf ..
    .. done

    Creating administration user febaf ..
    .. done

    Creating aliases for administration user ..
    .. done

    Adding administration user to groups ..
    .. done

    Creating home directory ..
    .. done

    Creating mailbox for administration user ..
    .. done

    Adding new virtual website ..
    .. done

    Adding webserver user apache to server's group ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Creating MySQL login ..
    .. done

    Creating MySQL database febaf ..
    .. done

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Creating Webmin user ..
Use of uninitialized value in split at /usr/libexec/webmin/acl/acl-lib.pl line 625.
    .. done

    Applying web server configuration ..
    .. done

    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

Re-disabling virtual server febaf.it ..
    Locking administration user's password ..
    .. done

    Replacing website with error page ..
    .. done

    Locking MySQL user's password ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server febaf.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Updating administration password and quotas ..
    .. done

    Restoring Cron jobs ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring Logrotate configuration ..
    .. Error: no log rotation configuration found!

Re-creating virtual server muvir.eu ..
    Creating administration group muvir ..
    .. done

    Creating administration user muvir ..
    .. done

    Creating aliases for administration user ..
    .. done

    Adding administration user to groups ..
    .. done

    Creating home directory ..
    .. done

    Creating mailbox for administration user ..
    .. done

    Adding new virtual website ..
    .. done

    Adding webserver user apache to server's group ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up scheduled Webalizer reporting ..
    .. no logging directive found in webserver configuration!

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Creating MySQL login ..
    .. done

    Creating MySQL database muvir ..
    .. done

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Creating Webmin user ..
    .. done

    Applying web server configuration ..
    .. done

    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server muvir.eu ..
    Restoring virtual server password, quota and other details ..
    .. done

    Updating administration password and quotas ..
    .. done

    Restoring Cron jobs ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring Logrotate configuration ..
    .. Error: no log rotation configuration found!

Re-creating virtual server istein.org ..
    Creating administration group istein ..
    .. done

    Creating administration user istein ..
    .. done

    Creating aliases for administration user ..
    .. done

    Adding administration user to groups ..
    .. done

    Creating home directory ..
    .. done

    Creating mailbox for administration user ..
    .. done

    Adding new virtual website ..
    .. done

    Adding webserver user apache to server's group ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Creating MySQL login ..
    .. done

    Creating MySQL database istein ..
    .. done

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Creating Webmin user ..
    .. done

    Applying web server configuration ..
    .. done

    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server istein.org ..
    Restoring virtual server password, quota and other details ..
    .. done

    Updating administration password and quotas ..
    .. done

    Restoring Cron jobs ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring Logrotate configuration ..
    .. Error: no log rotation configuration found!

Re-creating virtual server cvitae.abi.it ..
    Creating administration group cvitae ..
    .. done

    Creating administration user cvitae ..
    .. done

    Creating aliases for administration user ..
    .. done

    Adding administration user to groups ..
    .. done

    Creating home directory ..
    .. done

    Creating mailbox for administration user ..
    .. done

    Adding new virtual website ..
    .. done

    Adding webserver user apache to server's group ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Creating Webmin user ..
    .. done

    Applying web server configuration ..
    .. done

    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server cvitae.abi.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Updating administration password and quotas ..
    .. done

    Restoring Cron jobs ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Webmin ACL files ..
    .. done

    Restoring AWstats configuration file ..
    .. done

    Updating Webmin user ..
    .. done

Re-creating virtual server ccamilano.it ..
    Creating administration group ccamilano ..
    .. done

    Creating administration user ccamilano ..
    .. done

    Creating aliases for administration user ..
    .. done

    Adding administration user to groups ..
    .. done

    Creating home directory ..
    .. done

    Creating mailbox for administration user ..
    .. done

    Adding new virtual website ..
    .. done

    Adding webserver user apache to server's group ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Creating Webmin user ..
    .. done

    Applying web server configuration ..
    .. done

    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server ccamilano.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Updating administration password and quotas ..
    .. done

    Restoring Cron jobs ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring Logrotate configuration ..
    .. Error: no log rotation configuration found!

Re-creating virtual server mediakit.bancaforte.it ..
    Creating administration group mediakit_bancaforte ..
    .. done

    Creating administration user mediakit_bancaforte ..
    .. done

    Creating aliases for administration user ..
    .. done

    Adding administration user to groups ..
    .. done

    Creating home directory ..
    .. done

    Creating mailbox for administration user ..
    .. done

    Adding new virtual website ..
    .. done

    Adding webserver user apache to server's group ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Creating Webmin user ..
    .. done

    Applying web server configuration ..
    .. done

    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server mediakit.bancaforte.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Updating administration password and quotas ..
    .. done

    Restoring Cron jobs ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring Logrotate configuration ..
    .. Error: no log rotation configuration found!

Re-creating virtual server ossif.it ..
    Creating administration group ossif ..
    .. done

    Creating administration user ossif ..
    .. done

    Creating aliases for administration user ..
    .. done

    Adding administration user to groups ..
    .. done

    Creating home directory ..
    .. done

    Creating mailbox for administration user ..
    .. done

    Adding new virtual website ..
    .. done

    Adding webserver user apache to server's group ..
    .. done

    Performing other Apache configuration ..
    .. done

    Creating SSL certificate and private key ..
    .. done

    Adding new SSL virtual website ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Creating MySQL login ..
    .. done

    Creating MySQL database ossif ..
    .. done

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Creating Webmin user ..
    .. done

    Applying web server configuration ..
    .. failed! An Apache configuration error was detected : AH00526: Syntax error on line 733 of /etc/httpd/conf/httpd.conf:
SSLCACertificateFile: file '/home/ossif/ssl.ca' does not exist or is empty


    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server ossif.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Updating administration password and quotas ..
    .. done

    Restoring Cron jobs ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring SSL Apache virtual host configuration and certificate ..
    .. done

    Restoring Logrotate configuration ..
    .. Error: no log rotation configuration found!

Re-creating virtual server wwww.tfargentina.it ..
    Creating administration group tfargentina ..
    .. done

    Creating administration user tfargentina ..
    .. done

    Creating aliases for administration user ..
    .. done

    Adding administration user to groups ..
    .. done

    Creating home directory ..
    .. done

    Creating mailbox for administration user ..
    .. done

    Adding new virtual website ..
    .. done

    Adding webserver user apache to server's group ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. done

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Creating Webmin user ..
    .. done

    Applying web server configuration ..
    .. done

    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server wwww.tfargentina.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Updating administration password and quotas ..
    .. done

    Restoring Cron jobs ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Webmin ACL files ..
    .. done

    Restoring AWstats configuration file ..
    .. done

    Updating Webmin user ..
    .. done

Re-creating virtual server abiformazione.it ..
    Creating administration group abiformazione ..
    .. done

    Creating administration user abiformazione ..
    .. done

    Creating aliases for administration user ..
    .. done

    Adding administration user to groups ..
    .. done

    Creating home directory ..
    .. done

    Creating mailbox for administration user ..
    .. done

    Adding new virtual website ..
    .. done

    Adding webserver user apache to server's group ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Creating MySQL login ..
    .. done

    Creating MySQL database abiformazione ..
    .. done

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Creating Webmin user ..
    .. done

    Re-loading Webmin ..
    .. done

    Applying web server configuration ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server abiformazione.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Updating administration password and quotas ..
    .. done

    Restoring Cron jobs ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring Logrotate configuration ..
    .. Error: no log rotation configuration found!

Re-creating virtual server abi.it ..
    Creating administration group abi ..
    .. done

    Creating administration user abi ..
    .. done

    Creating aliases for administration user ..
    .. done

    Adding administration user to groups ..
    .. done

    Creating home directory ..
    .. done

    Creating mailbox for administration user ..
    .. done

    Adding new virtual website ..
    .. done

    Adding webserver user apache to server's group ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. done

    Creating Webmin user ..
    .. done

    Applying web server configuration ..
    .. done

    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server abi.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Updating administration password and quotas ..
    .. done

    Restoring Cron jobs ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring Logrotate configuration ..
    .. done

    Restoring Webmin ACL files ..
    .. done

    Updating Webmin user ..
    .. done

Re-creating virtual server comunicazione.bancariaeditrice.it ..
    Creating administration group comunicazione ..
    .. done

    Creating administration user comunicazione ..
    .. done

    Creating aliases for administration user ..
    .. done

    Adding administration user to groups ..
    .. done

    Creating home directory ..
    .. done

    Creating mailbox for administration user ..
    .. done

    Adding new virtual website ..
    .. done

    Adding webserver user apache to server's group ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. done

    Creating MySQL login ..
    .. done

    Creating MySQL database comunicazione ..
    .. done

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Creating Webmin user ..
    .. done

    Applying web server configuration ..
    .. done

    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server comunicazione.bancariaeditrice.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Updating administration password and quotas ..
    .. done

    Restoring Cron jobs ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring Logrotate configuration ..
    .. done

    Restoring allowed MySQL hosts ..
    .. done

    Re-loading MySQL database comunicazione ..
    .. done

    Restoring Webmin ACL files ..
    .. done

    Restoring AWstats configuration file ..
    .. done

    Updating Webmin user ..
    .. done

Re-creating virtual server apb.it ..
    Creating administration group adminapb ..
    .. done

    Creating administration user adminapb ..
    .. done

    Creating aliases for administration user ..
    .. done

    Adding administration user to groups ..
    .. done

    Creating home directory ..
    .. done

    Creating mailbox for administration user ..
    .. done

    Adding new virtual website ..
    .. done

    Adding webserver user apache to server's group ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Creating MySQL login ..
    .. done

    Creating MySQL database apb_news ..
    .. done

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Creating Webmin user ..
    .. done

    Applying web server configuration ..
    .. done

    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server apb.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Updating administration password and quotas ..
    .. done

    Restoring Cron jobs ..
    .. done

    Extracting TAR file of home directory ..
    .. TAR failed! /bin/tar: ./public_html: Cannot create symlink to `public_html.20161203/wordpress': File exists
/bin/tar: Exiting with failure status due to previous errors


Re-creating virtual server www2.conciliatorebancario.it ..
    Creating administration group conciliatore ..
    .. done

    Creating administration user conciliatore ..
    .. done

    Creating aliases for administration user ..
    .. done

    Adding administration user to groups ..
    .. done

    Creating home directory ..
    .. done

    Creating mailbox for administration user ..
    .. done

    Adding new virtual website ..
    .. done

    Adding webserver user apache to server's group ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up scheduled Webalizer reporting ..
    .. no logging directive found in webserver configuration!

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Creating MySQL login ..
    .. done

    Creating MySQL database conciliatore ..
    .. done

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Creating Webmin user ..
    .. done

    Applying web server configuration ..
    .. done

    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server www2.conciliatorebancario.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Updating administration password and quotas ..
    .. done

    Restoring Cron jobs ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring allowed MySQL hosts ..
    .. done

    Re-loading MySQL database conciliatore ..
    .. done

    Restoring Webmin ACL files ..
    .. done

    Restoring AWstats configuration file ..
    .. done

    Updating Webmin user ..
    .. done

Re-creating virtual server abics.it ..
    Creating administration group abics ..
    .. done

    Creating administration user abics ..
    .. done

    Creating aliases for administration user ..
    .. done

    Adding administration user to groups ..
    .. done

    Creating home directory ..
    .. done

    Creating mailbox for administration user ..
    .. done

    Adding new virtual website ..
    .. done

    Adding webserver user apache to server's group ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Applying web server configuration ..
    .. done

    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server abics.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Updating administration password and quotas ..
    .. done

    Restoring Cron jobs ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring Logrotate configuration ..
    .. Error: no log rotation configuration found!

Re-creating virtual server seda.sepaitalia.eu ..
    Creating administration group seda ..
    .. done

    Creating administration user seda ..
    .. done

    Creating aliases for administration user ..
    .. done

    Adding administration user to groups ..
    .. done

    Creating home directory ..
    .. done

    Creating mailbox for administration user ..
    .. done

    Adding new virtual website ..
    .. done

    Adding webserver user apache to server's group ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Creating Webmin user ..
    .. done

    Applying web server configuration ..
    .. done

    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server seda.sepaitalia.eu ..
    Restoring virtual server password, quota and other details ..
    .. done

    Updating administration password and quotas ..
    .. done

    Restoring Cron jobs ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring Logrotate configuration ..
    .. Error: no log rotation configuration found!

Re-creating virtual server abilearning.it ..
    Creating administration group abilearning ..
    .. done

    Creating administration user abilearning ..
    .. done

    Creating aliases for administration user ..
    .. done

    Adding administration user to groups ..
    .. done

    Creating home directory ..
    .. done

    Creating mailbox for administration user ..
    .. done

    Adding new virtual website ..
    .. done

    Adding webserver user apache to server's group ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up scheduled Webalizer reporting ..
    .. no logging directive found in webserver configuration!

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Creating MySQL login ..
    .. done

    Creating MySQL database abilearning ..
    .. done

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Creating Webmin user ..
    .. done

    Applying web server configuration ..
    .. done

    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server abilearning.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Updating administration password and quotas ..
    .. done

    Restoring Cron jobs ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring Logrotate configuration ..
    .. Error: no log rotation configuration found!

Re-creating virtual server www3.abi.it ..
    Creating home directory ..
    .. done

    Adding new virtual website ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Applying web server configuration ..
    .. done

    Saving server details ..
    .. done

    Updating Webmin user ..
    .. done

    Re-loading Webmin ..
    .. done

Restoring backup for virtual server www3.abi.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring AWstats configuration file ..
    .. done

    Updating Webmin user ..
    .. done

Re-creating virtual server vsp01.abi.it ..
    Creating home directory ..
    .. done

    Adding new virtual website ..
    .. done

    Performing other Apache configuration ..
    .. done

    Creating SSL certificate and private key ..
    .. done

    Adding new SSL virtual website ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Applying web server configuration ..
    .. done

    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

    Updating Webmin user ..
    .. done

    Re-loading Webmin ..
    .. done

Restoring backup for virtual server vsp01.abi.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring SSL Apache virtual host configuration and certificate ..
    .. done

    Restoring Logrotate configuration ..
    .. Error: no log rotation configuration found!

Re-creating virtual server dev.abiformazione.it ..
    Creating home directory ..
    .. done

    Adding new virtual website ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Creating MySQL database dev ..
    .. done

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Applying web server configuration ..
    .. done

    Saving server details ..
    .. done

    Updating Webmin user ..
    .. done

    Re-loading Webmin ..
    .. done

Restoring backup for virtual server dev.abiformazione.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring Logrotate configuration ..
    .. Error: no log rotation configuration found!

Re-creating virtual server svil.abiformazione.it ..
    Creating home directory ..
    .. done

    Adding new virtual website ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Applying web server configuration ..
    .. done

    Saving server details ..
    .. done

    Updating Webmin user ..
    .. done

    Re-loading Webmin ..
    .. done

Restoring backup for virtual server svil.abiformazione.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring Logrotate configuration ..
    .. Error: no log rotation configuration found!

Re-creating virtual server culturacreativa.it ..
    Creating home directory ..
    .. done

    Adding new virtual website ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Creating MySQL database culturacreativa ..
    .. done

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Applying web server configuration ..
    .. done

    Saving server details ..
    .. done

    Updating Webmin user ..
    .. done

    Re-loading Webmin ..
    .. done

Restoring backup for virtual server culturacreativa.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Re-loading MySQL database culturacreativa ..
    .. done

    Restoring AWstats configuration file ..
    .. done

    Updating Webmin user ..
    .. done

Re-creating virtual server abics.eu ..
    Creating home directory ..
    .. done

    Updating target virtual website ..
    .. done

    Performing other Apache configuration ..
    .. done

    Applying web server configuration ..
    .. done

    Re-loading Webmin ..
    .. done

    Saving server details ..
    .. done

Restoring backup for virtual server abics.eu ..
    Restoring virtual server password, quota and other details ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache aliases ..
    .. done

Re-creating virtual server scuderiedipalazzoaltieri.it ..
    Creating home directory ..
    .. done

    Adding new virtual website ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Applying web server configuration ..
    .. done

    Saving server details ..
    .. done

    Updating Webmin user ..
    .. done

    Re-loading Webmin ..
    .. done

Restoring backup for virtual server scuderiedipalazzoaltieri.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring Logrotate configuration ..
    .. Error: no log rotation configuration found!

Re-creating virtual server canali.abilearning.it ..
    Creating home directory ..
    .. done

    Adding new virtual website ..
    .. done

    Performing other Apache configuration ..
    .. done

    Setting up log file rotation ..
    .. no logging directive found in webserver configuration!

    Creating MySQL database canali ..
    .. done

    Setting up AWstats reporting ..
    .. done

    Setting up password protection for AWstats ..
    .. done

    Applying web server configuration ..
    .. done

    Saving server details ..
    .. done

    Updating Webmin user ..
    .. done

    Re-loading Webmin ..
    .. done

Restoring backup for virtual server canali.abilearning.it ..
    Restoring virtual server password, quota and other details ..
    .. done

    Extracting TAR file of home directory ..
    .. done

    Setting ownership of home directory ..
    .. done

    Restoring Apache virtual host configuration ..
    .. done

    Checking restored PHP execution mode ..
    .. mode FCGId OK for this system

    Updating home directory in PHP configuration ..
    .. done

    Restoring Apache log files ..
    .. done

    Restoring Logrotate configuration ..
    .. Error: no log rotation configuration found!

Enabling PHP modules for restored scripts ..
.. no PHP modules needed to be installed

Applying web server configuration ..
.. done

Restore failed!


real    40m13.752s
user    28m4.066s
sys     11m48.099s

[root@vsp01 ~]# mysql -u abiformazione abiformazione -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1022
Server version: 5.5.52-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [abiformazione]> show tables;
Empty set (0.00 sec)

MariaDB [abiformazione]> Bye
[root@vsp01 ~]#

Submitted by andreychek on Sun, 03/12/2017 - 15:12

Sorry for the delay!

What is an example of a domain that should have had MySQL databases restored, but you found that there were no databases after the restore had completed?

Submitted by g.carabetta on Mon, 03/13/2017 - 02:22 Pro Licensee

Just as example, abiformazione, ossif, muvir (that contains 2 DB: muvir and muvir_wordpress), etc