• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.

mysql

  1. S

    Resolved resources monitor for individual domains

    Plesk version: Plesk Onyx 17.0.17 Update #29 Is it possible to limit and monitor resources for individual domains? Noticed some domains are using more resources than other domains and causes my server resources to be depleted. I want to limit each individual domain if possible? Does Plesk have...
  2. Alexander Liebrecht

    Resolved Plesk Upgrade to 17.5.3 fails due to php-mysql

    Hello Community and Pleskians! I have an upgrade problem from Plesk Onyx to the new version 17.5.3. It is on the psa-php5-configruator and related to php-mysql. When upgrading from Plesk I have these lines that are displayed. Installation started in background Loaded plugins: fastestmirror...
  3. Bjorn

    Question fail2ban log bans to mysql

    Hi, I want to add a custom action to all jails, this action calls a script that writes the ban info to mysql. When i run my script directly from the console, it works fine. But it does not get called with the actionban... First some info: Plesk 17.5.3 CentOS 7 Fail2Ban v0.9.6 MariaDB 5.5.52...
  4. W

    Issue ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] Connection refused

    Hi guys, by connecting plesk i got this error, where should I start my search? ERROR: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Connection refused' in /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0...
  5. R

    Resolved How to run mysql_secure_installation?

    Hi all, I tried to run "mysql_secure_installation" command on my server where Onyx is running but I always get login error because the Onyx default db user is admin and not root: I also tried to run: "mysql_secure_installation -uadmin" but with no success. Can anyone help me on this and tell...
  6. Pedro Reinoso

    Resolved Plesk is not operational MySQL password changed

    Hello, I was creating users in MySQL server, as i dont know the "admin" password i tried update the password. Onces I updated i got this error message: I was performing some of the KB solutions but could not be able to fix it, i create a ticket because maybe you have faced this situation...
  7. CoyoteKG

    Question Fail2ban for MySQL

    Hi, I can't find here on forum similar question. I need to have open port 3306 for all IPs. Is it possible somehow to protect mysql authentification with Fail2Ban? I found that enabling general log can slow server, but also I saw that is possible to enable only "log_warnings = 2", Is someone...
  8. L. Hagen

    Question MySQL wont start after restore

    Hi, two days ago I made a terrible mistake by removing some packages with dependencies to Plesk. So I had to restore from a backup. But unfortunately this fails and MySql wont start. So Plesk isn't staring as well. My service is hosted by STRATO and the guys told me that when I'm using their...
  9. BNB

    Question Upgrade MySQL + Install Elasticsearch + PHP libraries

    Hi, I am using Plesk Onyx v17.0.17 on CentOS 7 and I am quite new to command line but I need a few configurations done: 1) My MySQL is showing 5.5 and I would like to upgrade it to 5.6. I wasn't able to following the instructions here because I have no idea how to point "4. Add MariaDB...
  10. Loris Modena

    Question Server Plesk configuration for eCommerce in PrestaShop

    I would like to know how to optimize the configuration in order to increase performance especially with regard to database requests. The server at my disposal is as follows: Server OVH Enterprise SP-32 Linux Plesk 12.5 (Cent OS 7) Intel(R) Xeon(R) CPU E3-1231 v3 @ 3.40GHz – Core: 8 32 GB RAM...
  11. T

    Resolved Unable to manage DB server from plesk but mysql is reachable from ssh

    Hello, I've got a problem on my plesk panel. Actually, everything works well (all my websites are running) but I cannot manage my database server from plesk. Plesk tell me that it cannot connect to the server. In addition, when I try to create a new user on this database, i've got this message...
  12. B

    Question MariaDB change data directory location

    Hi, I'm trying to change the MariaDB data directory from /var/lib/mysql to /my_folder/mysql. Everything is good I can log into mysql in command line but plesk give me a hard time with Zend Errors. I've change my /etc/my.cnf and my /etc/psa/psa.conf to match with the new mysql location but...
  13. tonyo

    Resolved error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'

    I i'v tried every procedor found in google but i cannot restart mysql in centos. any suggestion. here is my tail -100 /var/log/mysql.log # tail -100 /var/log/mysqld.log the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB...
  14. H

    Resolved rpm_check_debug vs depsolve mysql update Error

    Hi I am having an update issue updating Plesk 12.5.30 from Version #42 to #59. The error log is the following: Running rpm_check_debug Fatal error during packages installation: [u'ERROR with rpm_check_debug vs depsolve:', 'rpmlib(FileDigests) is needed by...
  15. R

    Resolved Backup: The dump has wrong format!

    Hello, I want to start automatic backups for the Plesk setup in Plesk Onyx 17.0.17 but I get the following error log: Error: Runtime error: The dump has wrong format! domains/example.com/backup_info_1702080331.xml: Line 1103 error: Element 'database', attribute 'type': [facet 'enumeration']...
  16. M

    Issue What caused this error?

    Hi, Suddenly this error showed up: ERROR: PleskDBException: Unable to connect to database: mysql_connect(): Connection refused /var/lib/mysql/mysql.sock (Error code: 2002). Please check that database server is started and accessible. (Abstract.php:69) Since nothing changed on the server i...
  17. I

    Issue ERROR: PleskDBException: Unable to connect to database: mysql_connect():

    i am using plesk 12.0.18 with centos 7, when i try to login plesk this error appeared ERROR: PleskDBException: Unable to connect to database: mysql_connect(): Access denied for user 'admin'@'localhost' (using password: YES) (Error code: 1045) (Abstract.php:69) using this help i was able to...
  18. Dumitru

    Resolved mysqli - Cannot assign requested address between two server

    Hello I have two servers with Plesk Onyx One server for files , second for mysql (more the 1K request per /s) If I have online visitor more then 700 it give me some error PHP message: PHP Warning: mysqli::__construct(): (HY000/2002): Cannot assign requested address .. while reading response...
  19. Hoerli

    Question SQL-BackUp

    Hello! Is it possible to create an automatic backup of the MySQL database? Problem what I currently have: I can not use the normal backup function. It creates a Backup of the website-files and databases in one backup. The websites are big and are stored on a extra hard drive. The System-drive...
  20. J

    Resolved MySQL 5.1 work in Plesk 12.5?

    What is the best version of MySQL to use? How to upgrade? Thanks. God bless you.
Back
Top