• The APS Catalog has been deprecated and removed from all Plesk Obsidian versions.
    Applications already installed from the APS Catalog will continue working. However, Plesk will no longer provide support for APS applications.
  • Please be aware: with the Plesk Obsidian 18.0.78 release, the support for the ngx_pagespeed.so module will be deprecated and removed from the sw-nginx package.

SQL DB restore fails

W

wsani

Guest
We upload the database backup file, then when a restore is attempted, the following error comes up in the Plesk log:

dbbackup.DbBackupException: Unable to restore database 'cheeky_db' ---> System.ApplicationException: Unable to open connection. Error code: 0x00000520
at psacommon.RemoteWinConnection.ConnectToNetworkResource(String host, String resourceName, ConnectionParameters connParams)
at psacommon.RemoteWinConnection.ConnectToNetworkResource(String host, ConnectionParameters connParams)
at dbbackup.DbBackupManager.Restore(String database, String backupPath, String netPath, String netUser, String netPass, Boolean dropLogins)
--- End of inner exception stack trace ---
at dbbackup.DbBackupManager.Restore(String database, String backupPath, String netPath, String netUser, String netPass, Boolean dropLogins)
at dbbackup.DbBackupManager.Main(String[] args)

Suggestions?
 
This was a permission issue. Plesk is unable to pass along the username/password that is required by the remote directory properly. So, I had to remove the user ACL and rely on network ACL to secure the "shared" restore directory.

This is after paying Parallels $75 for an incident... I finally fixed it myself...
 
Back
Top