Can't Restore Backup as User with Remote MySQL Server

Submitted by cnasal on Fri, 03/18/2016 - 05:33

I have recently set up a Virtualmin system with a remote MySQL server. I have configured Virtualmin to use the remote MySQL server. Creating domains, creating and removing databases, backing up, etc. all works well when I'm logged in as a user to Virtualmin. However, if I try to restore a backup as a user (rather than as a root user), then I get the following output from the Web UI during the restore:

Starting restore of 1 domains from local file /home/test/virtualmin-backup/test.camna.com_20160318_1008 ..
Extracting backup archive files ..
.. done
 
Restoring backup for virtual server test.camna.com ..
Extracting TAR file of home directory ..
.. done
Setting ownership of home directory ..
.. done
 
Restoring allowed MySQL hosts ..
.. done
 
Deleting old MySQL databases ..
.. done
 
Re-loading MySQL database dbtest ..
Creating MySQL database dbtest ..
.. done
.. load failed!
ERROR 1045 (28000): Access denied for user 'test'@'192.168.217.82' (using password: YES)
.. failed! See the progress output above for the reason why.

I can do a restore from the command line as the user just fine and everything else continue to works fine. Does the permissions change at all during a restore? If so, could it be that it's trying to do the restore before it gives the user permissions from this host? Just a theory I wanted to mention, but I don't know that it's the problem.

Thanks, Carl

Status: 
Active

Comments

Submitted by JamieCameron on Sat, 03/19/2016 - 00:32

That's odd, because the permissions are granted before the restore happens. You should check on the remote host if the test user is granted access from the Virtualmin system.

Submitted by cnasal on Sat, 03/19/2016 - 05:41

I have confirmed it has access. Even after the restore fails, I can connect just fine via command line MySQL or via a PHP script. I just wasn't sure if the permissions were changed at all during the restore process. Any other thoughts on how to track this down?

Thanks, Carl

Submitted by JamieCameron on Sat, 03/19/2016 - 18:58

If you try another restore over the existing domain on the new system, does it complete successfully?