failing at the start of the install - mariadb

[darkpaw]

Greetings,

My Zoneminder system crashed (lost /var) so I had to reinstall Ubuntu Server from scratch. I installed 20.04.4 and patched it prior to starting the Zoneminder setup.

The RPMs installed fine, but the next step is to harden the database, which fails.

Code: Select all

root@videosurv:~# mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Enter current password for root (enter for none):
Aborting!

Cleaning up...

I've tried a blank password, and I tried resetting the root user password and using that, but both fail. What's wrong?

[Magic919]

Is MariaDB running?

You should probably install 1.36, not the old version. https://launchpad.net/~iconnor/+archive ... inder-1.36

[darkpaw]

Looks like it's not running. Failing to start, fantastic. This is a clean install...I guess it's no big deal if I have to start over.

Code: Select all

root@videosurv:~# service mysql status
● mariadb.service - MariaDB 10.3.34 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
     Active: failed (Result: timeout) since Mon 2022-03-14 17:42:48 UTC; 22h ago
       Docs: man:mysqld(8)
             https://mariadb.com/kb/en/library/systemd/
   Main PID: 7477 (code=exited, status=0/SUCCESS)

Mar 14 17:27:46 videosurv systemd[1]: Starting MariaDB 10.3.34 database server...
Mar 14 17:27:46 videosurv mysqld[7477]: 2022-03-14 17:27:46 0 [Note] /usr/sbin/mysqld (mysqld 10.3.34-MariaDB-0ubuntu0.20.04.1) starting as process 7477 ...
Mar 14 17:42:46 videosurv systemd[1]: mariadb.service: start operation timed out. Terminating.
Mar 14 17:42:48 videosurv systemd[1]: mariadb.service: Failed with result 'timeout'.
Mar 14 17:42:48 videosurv systemd[1]: Failed to start MariaDB 10.3.34 database server.

OK, let me see if I can find out why that's happening...timeout error.

[Magic919]

Have a Google and include apparmor. I suspect it is intervening.