Page 1 of 2
Need help with Nagios XI database
Posted: Fri Apr 26, 2019 10:35 am
by 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
Re: Need help with Nagios XI database
Posted: Fri Apr 26, 2019 2:12 pm
by scottwilkerson
Can you show the output of the following:
Code: Select all
tail -50 /var/log/mariadb/mariadb.log
or on an older system
Re: Need help with Nagios XI database
Posted: Sun Apr 28, 2019 11:56 pm
by marcostecnitia
scottwilkerson wrote: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
Re: Need help with Nagios XI database
Posted: Mon Apr 29, 2019 6:21 am
by scottwilkerson
Lets repair the database following this procedure
https://assets.nagios.com/downloads/nag ... tabase.pdf
Then restart the nagios service
Re: Need help with Nagios XI database
Posted: Mon Apr 29, 2019 6:55 am
by marcostecnitia
I do everything but still the problem
https://ibb.co/7JWGzn5
Thanks for reply.
Regards
Re: Need help with Nagios XI database
Posted: Mon Apr 29, 2019 6:59 am
by scottwilkerson
Those are normal at the bottom of the repair script.
What errors are you seeing in the UI?
Re: Need help with Nagios XI database
Posted: Mon Apr 29, 2019 7:29 am
by marcostecnitia
scottwilkerson wrote:
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
Re: Need help with Nagios XI database
Posted: Mon Apr 29, 2019 8:17 am
by 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
Re: Need help with Nagios XI database
Posted: Tue Apr 30, 2019 12:17 am
by marcostecnitia
scottwilkerson wrote: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
Re: Need help with Nagios XI database
Posted: Tue Apr 30, 2019 12:44 am
by marcostecnitia
I cant work in web UI, this error still permanent.
https://ibb.co/xYJwhbX