[debian-mysql] Bug#1025784: Bug#1025784: Acknowledgement (mariadb-server-core-10.6: Can't connect to local server through socket '/run/mysqld/mysqld.sock' (111))

[Tim McConnell]

Hi Faustin, 
I do have libpam-tempdir installed: 
sudo dpkg -l | grep libpam-tmpdir
[sudo] password for tmick: 
ii  libpam-tmpdir                                      0.09+b2        
amd64        automatic per-user temporary directories

However I was getting different errors. Like so: 
RROR 2013 (HY000): Lost connection to server at 'handshake: reading
initial communication packet', system error: 104
and I have to use 'sudo systemctl start mariadb.socket' instead of
'sudo systemctl start mariadb.service' but it has to be restarted if
authentication fails.

And

2022-12-30 14:48:23 0 [ERROR] InnoDB: Operating system error number 13
in a file operation.
2022-12-30 14:48:23 0 [ERROR] InnoDB: The error means mariadbd does not
have the access rights to the directory.

MariaDB can't start because it can't read your files, the logs state it
very clearly:
Likely, you created the DB files and folders with the wrong
permissions. Please run : chown -R mysql:mysql /var/lib/mysql to fix
the issue and restart MariaDB again which allowed the DB to start etc. 
I then had to initialize it with the install_db command. 
So I'm not sure if it's a duplicate of the bug you mention, I'll leave
that to you to decide. 
Thanks!

-- 
Tim McConnell <tmcconnell168 at gmail.com>


On Wed, 2023-01-11 at 10:52 +0100, Faustin Lammler wrote:
> Hi Tim!
> 
> Tim McConnell <tmcconnell168 at gmail.com>,
> 10/01/2023 – 15:49:20 (-0600):
> 
> > Hi Faustin, 
> > Steps to recreate: 
> > 1.Install Mariadb client/server
> > 2. Attempt to run mysql -u root -p
> > 3. fail to be able to login
> 
> On a clean installation, I can't reproduce the problem with those
> steps
> and this is heavily tested in our CI pipelines. So, my best guess is
> that there is something else with your setup that caused the problem.
> 
> I can't be sure but what you described also in the mailing list makes
> me
> think of https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1022994,
> is
> it possible that you had libpam-tmpdir package installed before
> installing MariaDB?
> 
> You can verify with `dpkg -l | grep libpam-tmpdir`.
> 
> If that's the case, then this will be fixed in the next release, see:
> https://salsa.debian.org/mariadb-team/mariadb-server/-/commit/cde8b8613e08ecb8d5f4a5de09d34418576d3040
> 
> And #1025784 should be marked as duplicate of #1022994.
> 
> Cheers!
>