• 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.

mysql

  1. J

    Issue MySQL TLS enabled: The localhost is not compatible with enabling a secure connection.

    Hi, I'm attempting to enable MySQL secure connection on 18.0.52 but when I edit panel.ini with tls.enable to true Plesk gives the following fatal error "The localhost is not compatible with enabling a secure connection." This plesk instance is connected to a localhost instance and one remote...
  2. B

    Question How to get Docker Host IP - Password Pusher

    Hey, i want to install Password Pusher (GitHub - pglombardo/PasswordPusher: An application to securely communicate passwords over the web. Passwords automatically expire after a certain number of views and/or time has passed. Track who, what and when.) (MySQL) via docker hub, that works...
  3. A

    Issue Plesk down after trying to upgrade mysql

    Hello, My VPS is hosted to OVH. I can't access my VPS, even via ssh (I insist: even via SSH). I did a snapshot before a mysql update: unfortunately, I couldn't go through with it... When I came back, I couldn't connect anywhere. So I asked for the snapshot to be installed, but it didn't work...
  4. P

    Resolved No remote MySQL connections after update

    Hi guys, I'm struggling with an issue after updating Plesk and system packages. Before the update it was possible to remotely connect to the server for MySQL. I've checked all possible parameters for enabling remote MySQL connections, but I can't find the issue. My environment Plesk Obsidian...
  5. E

    Issue Problem with special chars after migration

    HI, I did a migration (through Plesk tool) from an Ubuntu machine to a Debian machine. In the new environment I have a problem with special characters (è é ò, ...). At the database level the charsets of the tables are the same between the two servers and the data saved within the database are...
  6. G

    Resolved ERROR 1049 (42000): Unknown database 'psa'

    I guess I did something really stupid, but any help or advice will be welcome. Long story short: My server was full, so I couldn't login into Plesk and all my sites were down. I tried to fix it with the repair tool kit, but I could not login, my credentials were rejected (I tried to use root &...
  7. S

    Question How to upgrade MariaDB 5.5.68 to 10.5 or higher version?

    My server is running MariaDB 5.5.68. I would like to upgrade to 10.5 or a higher version. Could someone please assist me in upgrading it?
  8. S

    Question High server resource and mysql error

    Hi, Can anyone advise on the below error? [2023-06-08 17:18:00.922] 22273:64819cba84ccd ERR [panel] DB query failed: SQLSTATE[HY000] [2002] Connection refused: 0: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79 Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''') 1...
  9. D

    Question Failed to start MariaDB 10 database server

    Unable to start mariadb service. when i tried to repair the result did not change. The first cause of the problem was that mariadb could not be started because the server disk capacity was full. After deleting the logs, disk space was freed, but mysqld.sock continued to give an error because...
  10. K

    Resolved How to create a database user with a known password hash

    Dear Community. I am trying to make a migration script and came to the part where i need to export/import the database. I can create a database and import the database content from the old mysql server without a problem. But now i need to create the database user. And i like to dont change the...
  11. dotmaki

    Issue MySQL not starting after update

    Hello, yesterday i did an update on packages and while everything was working ok tomorrow i was greeted with this: This is when i try to restart mariadb I've tried to use plesk repair mysql but i get this error => I have tried other relative topics in the forums but couldn't get it to...
  12. J

    Issue plesk sbin statistics fails for database on a non-standard database server

    After running plesk sbin statistics --calculate-one --domain-name=example.com I get WARN: WARNING during statistics_collector execution: statistics_collector[17429]: Failed to process database 'example' from domain 'example.com': MySQL error 1049: Unknown database 'example' executing query...
  13. U

    Resolved mysql tuning

    Dear support team, I use a server with AMD Ryzen™ 5 3600, 64 GB DDR4, NVMe SSD 512 GB and Plesk. Are there ideal settings to increase mysql performance and achieve better performance? If so, can you provide me with recommended settings for /etc/mysql/my.cnf The following is currently stored...
  14. N

    Issue I lost panel access after changing mysql directory

    I lost painel access after change mysql directory, I did all mysql's socket configurations, but the issue persist
  15. Quinten

    Resolved MariaDB Backup issue

    Hello, Since a week ago there seems to be an issue with my backups on one of my servers The backup is incomplete with a bunch of these same message. I looked up the error and found some topics on ehre but none of the solutions seem to work for me. I attached my 50-server.cnf and the my.cnf are...
  16. E

    Issue Plesk Obsidian - Version 18.0.50 - Database Servers Missing

    Hi, after upgrading plesk to 18.0.50, it looks like the database support isn't working anymore or there is a gui problem. Product version: Plesk Obsidian 18.0.50.0 OS version: AlmaLinux 9.1 x86_64 Database version: 10.5.16-2.e19_0 plesk repair mysql Checking MySQL database servers...
  17. Quinten

    Resolved MySQL/MariaDB does not service all requests due to mismatch of socket definitions

    Hello, Ive stumbled on a problem that is quite urgent. I was working on grafana when plesk on my server went down (plesk panel unreachable due to database error). The last change i made was 2 days before that and all i did was change the bind adress in my.cnf to :: After some troubleshooting i...
  18. A

    Resolved How to access MySQL customer tables on Windows?

    Hello, We are developing an extension for Plesk in PHP and we have need of interacting with WordPress databases on Customer domains. On Linux, we have been using the pm_Bootstrap::getDbAdapter() to make all of our requests using PDO. On Windows, however, the adapter could not interact with the...
  19. Quinten

    Question Database information of the main plesk database

    Hello, I would like to connect my plesk database to our Grafana panel as a data source to read out some data. Where do i find the database connection info of the main database of the Plesk server? Any help would be appriciated. Kind Regards, Quinten
  20. zoldos

    Resolved Submitting my PHP FPM config for review and recommendations please!

    I run a fully dedicated Ubunto 20.04 server and a forum with around 60-70 members on-line daily (*not* all at once, but still a fair amount of constant activity). I'm looking to optimize my PHP FPM settings. Here's my server: Intel(R) Xeon(R) CPU E3-1230 v3 @ 3.30GHz (8 core(s), 32GB RAM...
Back
Top