Local socket access to MariaDB does not work anymore after update to version 10.0.30

This document (7019021) is provided subject to the disclaimer at the end of this document.

Environment

SUSE Linux Enterprise Server 12 Service Pack 2 (SLES 12 SP2)
SUSE Linux Enterprise Server 12 Service Pack 1 (SLES 12 SP1)

Situation

After a maintenance update of MariaDB to version 10.0.30 build 25.1 a connection to the database via local (AF_UNIX) sockets is not possible anymore.

Resolution

This issue has been fixed with build 28.1 of MariaDB 10.0.30:
As a quick workaround, manually setting the correct permissions of /var/run/mysql and restarting MariaDB restores connectivity:

chmod 755 /var/run/mysql
systemctl restart mysql

This needs to be done after every reboot as /var/run is a symlink to /run which is located on a ramdisk.

Cause

The MariaDB start script was hardened to reduce the default permissions of created files to the minimum. Due to an oversight, the script does not set the correct permissions for /var/run/mysql after it creates the directory. Subsequently, MariaDB cannot create its socket when it runs as a user other than root.

Additional Information


Disclaimer

This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:7019021
  • Creation Date: 19-May-2017
  • Modified Date:03-Mar-2020
    • SUSE Linux Enterprise Server

< Back to Support Search

For questions or concerns with the SUSE Knowledgebase please contact: tidfeedback@suse.com

SUSE Support Forums

Get your questions answered by experienced Sys Ops or interact with other SUSE community experts.

Join Our Community

Support Resources

Learn how to get the most from the technical support you receive with your SUSE Subscription, Premium Support, Academic Program, or Partner Program.


SUSE Customer Support Quick Reference Guide SUSE Technical Support Handbook Update Advisories
Support FAQ

Open an Incident

Open an incident with SUSE Technical Support, manage your subscriptions, download patches, or manage user access.

Go to Customer Center