• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • (Plesk for Windows):
    MySQL Connector/ODBC 3.51, 5.1, and 5.3 are no longer shipped with Plesk because they have reached end of life. MariaDB Connector/ODBC 64-bit 3.2.4 is now used instead.
  • 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