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 <tmcconnell...@gmail.com> On Wed, 2023-01-11 at 10:52 +0100, Faustin Lammler wrote: > Hi Tim! > > Tim McConnell <tmcconnell...@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! >