Can't apply config, but no error message

[JakeHatMacys]

Hi, I'm working with Andrew:

service mysqld status
Redirecting to /bin/systemctl status mysqld.service
Unit mysqld.service could not be found.

[nagios@xxxxxxxxx bin]$ service mariadb status
Redirecting to /bin/systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: active (running) since Fri 2018-05-18 08:36:18 EDT; 2h 37min ago
Process: 99573 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
Process: 99541 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 99572 (mysqld_safe)
CGroup: /system.slice/mariadb.service
├─99572 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─99806 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/r...



We don't have sudo access yet for MariaDB to stop / start etc... I'm going to work on that. Only two of our servers use Maria atm. I have a feeling the last security patches ran over something mucking us up...

[npolovenko]

Hi, @JakeHatMacys. Are you able to sign in with the following command?

Code: Select all

mysql -pnagiosxi

Also, please run the following command and show me the output:

Code: Select all

grep -i password= /root/scripts/automysqlbackup | head -n 1

[JakeHatMacys]

I get an access denied error, should that work given we're running mariadb?

[npolovenko]

@JakeHatMacys, Yes, this command should work on the mariadb as well.

I have a feeling the last security patches ran over something mucking us up...

Most likely the database password was overridden during the patching, and now Nagios can not access it.

[JakeHatMacys]

If I can get someone with root to set the password back to the default on mariadb what would that command look like??? can DM me it if you like....

[npolovenko]

@JakeHatMacys, You can try following this tutorial:
https://www.digitalocean.com/community/ ... t-password

Try to backup your system before doing this though. If you run it on a VM make a system snapshot.