• The ImunifyAV extension is now deprecated and no longer available for installation.
    Existing ImunifyAV installations will continue operating for three months, and after that will automatically be replaced with the new Imunify extension. We recommend that you manually replace any existing ImunifyAV installations with Imunify at your earliest convenience.
  • 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.

mariadb

  1. J

    Issue Daily logrotate cron not working anymore

    A few days ago I've changed my Plesk and server root password. After this I've had problem connection to the database after server restart. So I used the Plesk MySQL reset password script. All works fine, I can login and the database is also still accessable from the frontend. But today I've got...
  2. E

    Issue Slown queries with mariadb

    Hi all, I want to log slow queries from Mariab (Plesk Onyx 17.8 - 5.5.60-MariaDB version 10). I have updated the file /etc/my.cnf with: slow_query_log = 1 log-slow-queries = /var/log/mysql-slow.log long_query_time = 2 And after restarted Mariadb: #service mariadb restart All like that: How...
  3. batoniq

    Question How to connect installed database from Docker for customers?

    Hi! I have installed MariaDB 10.4.0 from Docker. But in customers accounts (Log In as Customer) I can add only default mysql 10.1.37. see screenshot please How can I add docker-installed MariaDB 10.4 for my customers ?
  4. B

    Issue HELP: Plesk repair no such file or directory

    Hello guys, we need your help. We can not access plesk. Server Error 500 Zend_Db_Adapter_Exception SQLSTATE[HY000] [2002] No such file or directory Type Zend_Db_Adapter_Exception Message SQLSTATE[HY000] [2002] No such file or directory File Abstract.php Line 144 But plesk repair does not...
  5. Z

    Question I want to set table_open_cache of MariaDB

    I'm using MariaDB 10.3.9. I am troubled because the setting value of table_open_cache in /etc/my.cnf is not setted. I'm enter the mysql with "mysql -uadmin -p`cat /etc/psa/.psa.shadow`". If I run it with "set global table_open_cache = XXX;" the setting will be setted. I check the value of that...
    • Zoo3
    • Thread
    • mariadb mariadb 10 mariadb 10.3 my.cnf table_open_cache
    • Replies: 3
    • Forum: Plesk Onyx for Linux
  6. Z

    Question About mysqld.service in MariaDB

    Does "mysqld.service" exist in Plesk (17.8.11)? At least it currently does not exist on my server. When asking a certain person, I was told that MariaDB should also have mysqld.service. mysqld.service does not exist because I am using Plesk? I installed a database search program from rpm. Then...
  7. Edward Dekker

    Input Upgrade your MariaDB

    CentOS 7 is shipped with MariaDB. MariaDB 10.x version is a drop-in replacement for MySQL 5.5-5.7. Open the SSH terminal by the root user and/or sudo with your username if you have rights to upgrade: Domain / IP adress : Portnumber : Username & Password Create a backup of all databases with...
  8. stas styler

    Question increasing innodb_buffer_pool_size & memory bottleneck

    Dear pleskers! Love your forum and platform. Plesk is my main server manager and I totally love it. Unfortunately there are some things that are different when considering plesk installed. I got a new server with couple of websites on it (im providing hosting). It hosts big woo commerce...
  9. H

    Question Migration Unable to copy content of database Too many open files

    I am trying to migrate a huge website from cpanel to plesk. This website is a WordPress multisite that allows users to create their own blog. Wordpress multisite create new tables for each new user and blog, this is how it works. I have set open-files-limit to 65535 on both servers but I am...
  10. Q

    Question How to remove MariaDB and install Percona and/or MySQL ?

    Hi , since nowadays centos7 comes out with MariaDB 5.5 so any plesk I installed on centos7 , it is already binded with mariadb how can I switch to Percona or Mysql ? because all I googled out is about change from mysql to mariadb, no vice versa.
  11. T

    Question [Poll] MariaDB vs MySQL

    Hi, what are you using on yours servers, MariaDB or MySQL and why?
  12. M

    Issue mariadb can't create IP socket

    Hello In mariadb log file I see this errors: 171021 10:38:35 [ERROR] Can't create IP socket: Success 171021 10:38:35 [ERROR] Aborting I use Plesk Onyx 17.5.3 and mariadb 5.5.56.
  13. learning_curve

    Resolved Unable to modify "/usr/share/psa-roundcube/config/config.inc.php"

    As the thread title says really but we can't We suspect this MAY be linked back to the MySql / Maria DB setup... We want to ensure that if/when on the rare occasions that Roundcube is used, it's via https only. Post_#6 in that previous thread clearly explains how to do this. However, in our...
  14. F

    Issue Error mariadb stop because InnoDB storage engine failed

    Hi, i've this version plesk 17.5.3 patch #26 installed on a centos 7.4.1708 and this morning i've realized that mariadb service is down because of this : Oct 24 11:01:50 lev-plesk-02 mysqld[14730]: 2017-10-24 11:01:50 139851548907648 [Note] InnoDB: Starting shutdown... Oct 24 11:01:51...
  15. NicolasP.

    Resolved Upgrade MySQL 5.5 to 5.6/5.7 on Linux

    Hello. Server Details: OS: ‪CentOS Linux 7.3.1611 (Core)‬ Product: Plesk Onyx Version 17.5.3 Update #19 Mariadb: 5.5.52-MariaDB I am trying to upgrade mysql using this link How to upgrade MySQL 5.5 to 5.6/5.7 on Linux but I am getting this error when I run "yum install mariadb" Error...
  16. A

    Resolved Plesk Web admin panel access

    Hi I'm new to this forum. Just turned from cPanel to Plesk and I'm loving it. Anyway, I managed to Install Onyx on CentOS7 with no problem and the forum really helped. I was trying to secure my installation so I did not know Plesk changed root to admin so I updated admin user's password and my...
  17. N

    Question Upgrading to Mariadb 10 and the benefits to shared hosting?

    Hi Everyone, I've seen on various best practices websites that people are recommending mariadb10 now over 5 (which is pre-installed on Plesk. Is there any real benefits and how easy is it to upgrade?
  18. 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...
  19. somemorestuff

    Resolved Manual updates or re-installation?

    Hi all, We have a dedicated Centos 7.3 server which came with Plesk Onyx 17.5.3 and MariaDB. We followed this guide: Database Server to change the DB to Percona. The only step that wasn't carried out was the re-installation of Plesk, which seems to have been an optional step. Everything...
  20. sjerp van wouden

    Question How to safely update mysql "Client API header version"

    Tip to everyone: Plesk itself uses mysql. Dont fool around if you're not sure what you're doing! You might mess up your installation. EDIT 7 june 2017: Do not follow up with code posted below here! If I find out the proper way I will post it! just messed up my server! ...which is the reason...
Back
Top