Articles in this section

See more

MariaDB 10.3 error after upgrade: Plugin 'unix_socket' is not loaded

Avatar
Plesk Agent shadow
Updated
Follow
kb: bug Plesk Obsidian for Linux ABT: Group A

Applicable to:

  • Plesk Obsidian for Linux

Symptoms

The following error is shown to run any mysql command after upgrade to MariaDB 10.3:

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

Cause

It is caused by a MariaDB upgrade bug MDEV-14367

The unix_socket authentication plugin is not enabled by default on the MariaDB upgrade.
Plesk bug with ID PPPM-11057 has been created in order to track the issue.

Note: Consider subscribing to this article in order to get notified when the fix is released or check for the ID in our changelog

Resolution

As a workaround enable auth_socket.so plugin:

Debian-based distributions
  1. Open the /etc/mysql/mariadb.conf.d/50-server.cnf file in a text editor. In this example, we are using the vi editor:

    # vi /etc/mysql/mariadb.conf.d/50-server.cnf

  1. Add the line below [mysqld] section:

    CONFIG_TEXT: plugin-load-add = auth_socket.so

  1. Save the changes and close the file.

  2. Restart MariaDB service

    # service mariadb restart

Red Hat-based distributions
  1. Open the /etc/my.cnf file in a text editor. In this example, we are using the vi editor:

    # vi /etc/my.cnf

  1. Add the line below [mysqld] section:

    CONFIG_TEXT: plugin-load-add = auth_socket.so

  1. Save the changes and close the file.

  2. Restart MariaDB service:

    # service mariadb restart

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles