• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Issue restore database to mariadb 11.7.2 (Docker) create 500 exception

gbailey123

New Pleskian
Server operating system version
Ubuntu 20.04 LTS
Plesk version and microupdate number
Obsidian 18.0.68
Hy,

After a total crash, we have restored the whole server from plesk with encryption.

It restored the local database mariadb on localhost with user normaly, but the second db with the newer mariadb on docker over the ip 127.0.0.1 and port 32768 is not possible.
It ends with this Exception.

Code:
      [B]Warning:[/B]             [B]Restore domain[/B] "2getonline.com"
Failed deployment of the database getonl_demo7 (domain 2getonline.com)
Code:
       [B]Warning:[/B]     
       Execution of /opt/psa/admin/plib/api-cli/database.php --update getonl_demo7 -add_user backup_1q07qIB -type mysql -server 127.0.0.1:32768 -set-acl % -passwd '' -ignore-nonexistent-options failed with return code 500.Stderr isUnable to create database user: Specified database was not found

i can connect over cli with mysql -h 127.0.0.1 -P 32768 -u root -p without any issues.

And for the restore, the database is for all hosts enabled.

how i can restore the databases?

thanks
 
What mean Specified database was not found ?

The Database is in plesk registered, and we have now manual imported the databases from mariadb 10 (Ubuntu Native installation) to mariadb 11.7.2 (Docker).
Without any issues.

Thanks :)
 
Back
Top