• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

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