mariadb

I have to migrate a lot of old sites over that require a lower version of MySQL, but there is no documentation on how to move from MariaDB to MySQL on Plesk, only going from one MySQL version to the next or one MariaDB version to the next. Does anyone have any insight into this? I need to...

Hi there, I have a relatively new Plesk Obsidian, CentOS 8 server. I am getting frequent mysql crashes. The mariadb.log has many of these: 2020-05-09 23:01:50 0 [ERROR] mysqld: Server GSSAPI error (major 851968, minor 2529639093) : gss_acquire_cred failed -Unspecified GSS failure. Minor...

Hello guys, we just did a restart, after that we get error: "DB query failed: SQLSTATE[HY000] [2002] No such file or directory" We need your help very urgent. What can we do, we can not restart mariadb? No access to plesk an no access to the websites...

HI, After upgrading MariaDB like here: https://support.plesk.com/hc/en-us/articles/213403429-How-to-upgrade-MySQL-5-5-to-5-6-5-7-or-MariaDB-5-5-to-10-0-10-1-10-2-on-Linux- I can't access to Plesk: Server Error 500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000] [2002] No such file or...

I'm having difficulties for a couple of days now and really dont know how to solve it. Im getting this error everytime when i try to run the updates. Whenever im updating in SSH with yum update i get the error: But whenever i try to update the components within plesk GUI i get the following...

We had a problem on our server and all the free space got used up, which caused mariadb to stop. After freeing up the space and trying to access the Plesk Panel we are presented with: DB query failed: SQLSTATE[HY000] [2002] No such file or directory Trying to restart the mariadb process ends...

Hello, Since I updated database to 10.4.12-MariaDB the Plesk updates are no longer possible. On the interface I have Plesk obsidian 18.0.23 but not update 18.0.24. I tried in plsk installer update & plesk installer update but I got the message below (View attachments). I tried to also update...

I've just updated Plesk Onyx to Plesk Obsidian, hoping it will update MySql version as well. Now I have MariaDB which shows as MySql 5.5.64 in https://domain.com:8443/plesk/server/db/ Here is the screenshot: https://tinyurl.com/u9hr4vo How can I update version to MariaDB 10.3, or at least...

Today I came to the realization that I cannot add or delete any of the databases that belong to any of my clients on my server. I had been receiving this error: Error: Unable to remove some of the selected databases. The user specified as a definer ('root'@'localhost') does not exist So I...

Hi there, I just received a new ubuntu 18.04 VPS to migrate to from my old ubuntu 16.04 VPS. I wanted to use the Plesk Migrator again, but received following issue in regards to databases and could not find any solution in this forum: Failed to copy content of database 'xxDB' Migration tools...

..or can it work with 10.2? Here is my current setup: Centos 7.7, Plesk 17.8.11, MariaDb 10.2.3 ==== Attempting the latest Onyx updates (before attempting Obsidian), I received this warning: MariaDB-server-10.2.30-1.el7.centos.x86_64.rpm | 24 MB 00:00 Running...

Hi, i am using Plesk Obsidian 18.0.20 on CentOS 7 and i recently updated my MariaDB from 5.x to 10.4 with SSH. And now i cant update my Plesk to 18.0.21. When i try it, i always get the "ERROR while trying to backup MySQL database" and the update stopps. Can someone help me please? best...

Hello i have a script that purges a MariaDB and Update with new date on daily basis. However when executing i get following error: " LOAD DATA LOCAL INFILE is forbidden, check mysqli.allow_local_infile " I looked everywhere and very little info out there. i modified /etc/my.cnf.d to...

Hello. I'm using Plesk Obsidian on Debian 9. I accidentally upgraded to MariaDB 10.4, so my databases got upgraded/etc. Can anyone help me to correct this (downgrade to 10.3) while preserving my databases? Most things are working fine, only thing I noticed is backups are not correctly backing up...

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

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

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

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

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

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