enterprise-support team mailing list archive

[Wolfgang Balzer <1970597@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

I was building a docker container with Ubuntu 22.04 including MySQL 8.0
yesterday. At first everything was fine, the containers bash shell runs
as root and I could connect to the database via the mysql command.

But then I was running a CGI script via the Apache web server running
with user www-data, I received the following error message in the Apache
logs:

```
Can't connect to database, DBI:mysql:host=localhost;port=3306;database=mysql, Reason: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (13)
```

Important to note is the 13 at end of the error message, it means:
"Permission denied". Normally it is 2 for "File or directory not found"
when to database is not running.

It took me some time to find that the directory /var/run/mysqld has a
permission of:

```
drwx------ 1 mysql mysql 4096 Apr 26 06:52 mysqld
```

Nobody else then root can reach the socket file to access the database.
After changing the directory permissions to 0755 everything works fine.
Please repair this.

** Affects: gearman-mysql-udf
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1970597

Title:
  Installation of MySQL 8.0 with Ubuntu 22.04 (jammy)

To manage notifications about this bug go to:
https://bugs.launchpad.net/gearman-mysql-udf/+bug/1970597/+subscriptions