• Dear Pleskians! The Plesk Forum will be undergoing scheduled maintenance on Monday, 7th of July, at 9:00 AM UTC. The expected maintenance window is 2 hours.
    Thank you in advance for your patience and understanding on the matter.

mariadb

  1. Servus

    Issue MariaDB upgrade error

    Hi, in a few words: Today I made the upgrade of MariaB from 10.3.19 (from 10.3.18). Two hours later I also made the libmariadb3 upgrade. During the upgrade the question came, if I want to replace the /etc/mysql/my.cnf. I hit D for showing the differences. After examination, I wanted to hit: Keep...
  2. M

    Issue Plesk cant run Shopware 6 at Debian 9

    Some days ago I just saw that Debian 9 is the latest version of Debian which is officially supported atm. (LINK) So I'm running Plesk 18 (Obsidian) on Debian 9.11 with all Updates installed I wanted to try Shopware 6 (EA2) and installed it, after launching the Installer I got this message...
  3. Y

    Resolved I cannot log in to Plesk because MariaDB does not start.

    I'm full on my server and MariaDB crashes. I gave additional space and solved the capacity problem. However, MariaDB does not start. Why can't I start? Memory and space issues have been resolved. I used PleskRepair, but MariaDB does not respond. The following is the error content. ------- ●...
  4. M

    Issue Problem with DBs

    I took over maintenance on a server and not sure why, but db servers are screwed up. Plesk won't auto-update, I've tried doing the rpm update via: rpm -Uvh --nodeps...
  5. Z

    Question How to delete a non-existent database user

    I faced another problem with Plesk yesterday (it solved it) and a different problem occurred. When I run "plesk repair installation" command, the DB fails and fails. I had previously installed RoundCube. I have deleted it now. An error occurs that can not operate the user of the DB it was...
  6. 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...
  7. 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...
  8. 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 ?
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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.
  16. T

    Question [Poll] MariaDB vs MySQL

    Hi, what are you using on yours servers, MariaDB or MySQL and why?
  17. 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.
  18. 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...
  19. 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...
  20. 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...
Back
Top