Need help with Nagios XI database

[marcostecnitia]

Hi all,

I have a problem with my Nagios XI databases,

In web interface i can see
https://ibb.co/SnZn3td

When I run the command:
https://ibb.co/BPK0VvB

I restored backups for nagios, nagiosql and nagiosxi but problem persist. Any solution?

Regards

[scottwilkerson]

Can you show the output of the following:

Code: Select all

tail -50 /var/log/mariadb/mariadb.log

or on an older system

Code: Select all

tail -50 /var/log/mysqld.log

[marcostecnitia]

Can you show the output of the following:

Code: Select all

tail -50 /var/log/mariadb/mariadb.log

thanks for the reply

This is the output of the requested command.

https://ibb.co/JnPVqTb

regards

[scottwilkerson]

Lets repair the database following this procedure
https://assets.nagios.com/downloads/nag ... tabase.pdf

Then restart the nagios service

Code: Select all

systemctl restart nagios

[marcostecnitia]

I do everything but still the problem
https://ibb.co/7JWGzn5

Thanks for reply.

Regards

[scottwilkerson]

I do everything but still the problem
https://ibb.co/7JWGzn5

Thanks for reply.

Regards

Those are normal at the bottom of the repair script.

What errors are you seeing in the UI?

[marcostecnitia]

Those are normal at the bottom of the repair script.

What errors are you seeing in the UI?

Hi Scott, output from UI
https://ibb.co/Smfng9g

Regards

[scottwilkerson]

Ok, these are usually caused by cron not running for some reason.

Can you show the output of the following:

Code: Select all

chage -l nagios
service crond status
tail -20 /var/log/cron

[marcostecnitia]

Ok, these are usually caused by cron not running for some reason.

Can you show the output of the following:

Code: Select all

chage -l nagios
service crond status
tail -20 /var/log/cron

Hi Scott
chage -l nagios
https://ibb.co/RvdtpSC

crond status
https://ibb.co/Vg6dtbj

log cron
https://ibb.co/Bq3q2W1

Regards

[marcostecnitia]

I cant work in web UI, this error still permanent.

https://ibb.co/xYJwhbX