Bobcares

For every $500 you spend, we will provide you with a $500 credit on your account*

BLACK FRIDAY SPECIAL EXTENSION

*The maximum is $4000 in credits, Offer valid till December 6th, 2024, New Customers Only, Credit will be applied after purchase and expires after six (6) months

For every $500 you spend, we will provide you with a $500 credit on your account*

BLACK FRIDAY SPECIAL EXTENSION

*The maximum is $4000 in credits, Offer valid till December 6th, 2024, New Customers Only, Credit will be applied after purchase and expires after six (6) months

Plesk MariaDB 10.3 error after upgrade | An easy fix

by | Dec 29, 2021

Plesk MariaDB 10.3 error after upgrade causing trouble? Our in-house experts have a solution.

At Bobcares, we offer solutions for every query, big and small, as a part of our Server Management Service.

Let’s take a look at how our Support Team recently helped out a customer with the Plesk MariaDB 10.3 error after upgrade.

How to resolve Plesk MariaDB 10.3 error after upgrade

If you have been coming across the following error, you have come to the right place!

ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded

According to our Support Techs, the error is due to a MariaDB upgrade bug MDEV-14367. Consequently, the error causes the unix_socket authentication plugin to remain disabled by default on the MariaDB upgrade. We can use the Plesk bug with ID PPPM-11057 to track the issue.

Plesk MariaDB 10.3 error after upgrade

 

However, if you do not want to wait around for a fix, our Support Team has come up with a workaround that works perfectly. It involves enabling the auth_socket.so plugin.

Workaround solution for Debian-based distributions

  1. First, we have to open the /etc/mysql/mariadb.conf.d/50-server.cnf file via any text editor.

    For instance, if we open it with vi editor:

    # vi /etc/mysql/mariadb.conf.d/50-server.cnf
  2. Then, we will add the following line to the [mysqld] section:
    plugin-load-add = auth_socket.so
  3. After that, we will save the changes and close the file.
  4. Finally, we have to restart the MariaDB service with the following command:
    # service mariadb restart

Workaround solution for RedHat-based distributions

  1. First, we have to open the /etc/my.cnf file via any text editor.

    For instance, if we open it with vi editor:

    # vi /etc/my.cnf
  2. Then, we will add the following line to the [mysqld] section:
    plugin-load-add = auth_socket.so
  3. After that, we will save the changes and close the file.
  4. Finally, we have to restart the MariaDB service with the following command:
    # service mariadb restart

[Seeking a solution to another query? We have your back.]

Conclusion

In brief, the skilled Support Engineers at Bobcares demonstrated how to resolve Plesk MariaDB 10.3 error after the upgrade.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Never again lose customers to poor
server speed! Let us help you.