Recurring Database Connection Error

[tacolover101]

[root@localhost mariadb]# tail mariadb.log
171013 16:29:33 InnoDB: remove old data files which contain your precious data!
171013 16:29:33 [ERROR] Plugin 'InnoDB' init function returned error.
171013 16:29:33 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
171013 16:29:33 [Note] Plugin 'FEEDBACK' is disabled.
171013 16:29:33 [ERROR] Unknown/unsupported storage engine: InnoDB
171013 16:29:33 [ERROR] Aborting

171013 16:29:33 [Note] /usr/libexec/mysqld: Shutdown complete

171013 16:29:33 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended

i think this is where your issue lies. https://stackoverflow.com/questions/264 ... d-when-sta

[npolovenko]

Thanks, @tacolover101.

@venturegardengroup, Go ahead and increase the InnoDB buffer size:

Code: Select all

/etc/mysql/my.cnf:
or the path could be 
/etc/my.cnf
change this line
innodb_buffer_pool_size = 10M

After that restart your maraDB with

Code: Select all

service mariadb restart

Also restart nagios with

Code: Select all

service nagios restart

and

Code: Select all

service httpd restart

If that doesn't solve the issue please upload your system profile. You can generate a profile manually using the script at /usr/local/nagiosxi/html/includes/components/profile/getprofile.sh

That should generate a profile in /usr/local/nagiosxi/var/components/ which you can get off the server with an application such as FileZilla.

If you get an error that PROFILE BUILD FAILED, please see https://support.nagios.com/kb/article.p ... ategory=44

[venturegardengroup]

Hello npolovenko,

Please find attached the outputs I got from following the instructions you laid out.

Regards,

[npolovenko]

@venturegardengroup, Can you try running the script as a root user:

Code: Select all

mkdir /usr/local/nagiosxi/var/components/profile/
cd  /usr/local/nagiosxi/html/includes/components/profile/
sudo ./getprofile.sh

[venturegardengroup]

Hello npolovenko,

Please find attached. Looking forward to your feedback. Thanks.

[npolovenko]

@venturegardengroup,

Please remove this two files:

Code: Select all

rm /var/lib/mysql/ib_logfile0
rm /var/lib/mysql/ib_logfile1
after that:
service mysqld restart

Also, lets try to run repair_databses as sudo:

Code: Select all

cd /usr/local/nagiosxi/scripts
sudo ./repair_databases.sh

Please run this command to check the storage space on the root partition.

Code: Select all

df -h

Finally, please send us the contents of your my.cnf file located at:

Code: Select all

/etc/my.cnf

[venturegardengroup]

Hello npolovenko,

Thanks for the update. I have attached the outputs from the steps you suggested.

Regards,

[npolovenko]

@venturegardengroup , Please remove ibdata1 file from /var/lib/mysql/
After that please run:

Code: Select all

service httpd restart
service mariadb restart

Let us know whether both services started.

[venturegardengroup]

Hello npolovenko,

Both services failed to start. See outputs attached.

[npolovenko]

@venturegardengroup, Ok, so the biggest problem we have is broken MySQL. Without MYSQL running Nagios will not work. We'd need to see more related log files. Please run the commands below and then upload info1, info2 and info3 files here.

Code: Select all

yum list installed >/tmp/info1.txt
cat /etc/my.cnf.d/* >>/tmp/info2.txt
tail -100 /var/log/mariadb/mariadb.log >>/tmp/info3.txt