Page 1 of 2
Nagios XI url is not available of NagiosXi.xi is missing
Posted: Mon Jul 22, 2019 9:56 am
by ITOMB_IMT
Hi,
we have Nagios XI 5.6.2 on RHEL environment. All of a sudden, when we tried to login we are seeing SQL errors on Login page. I had to restore XI from backups and we lost data of a day and also the new config added to XI. so we would like to what caused to crash the databases and is there any way to restore that particular table without restoring whole database.please see the attached error on Login page.
Thanks,
Re: Nagios XI url is not available of NagiosXi.xi is missing
Posted: Mon Jul 22, 2019 3:01 pm
by ssax
It looks like someone deleted the nagiosxi.xi_options table given the error.
Please PM a copy of your profile, you can download it from
Admin > System Profile > Download Profile.
If you're unable to generate the the profile through the web interface, please try generating it from the command line by running these commands as root:
Code: Select all
rm -rf /usr/local/nagiosxi/var/components/profile*
/usr/local/nagiosxi/html/includes/components/profile/getprofile.sh SUPPORT
Then send me the resulting
/usr/local/nagiosxi/var/components/profile.zip file.
If the profile script fails, please include the ENTIRE output.
Yes, you can restore the individual table, see here:
Code: Select all
https://stackoverflow.com/questions/1013852/can-i-restore-a-single-table-from-a-full-mysql-mysqldump-file
Re: Nagios XI url is not available of NagiosXi.xi is missing
Posted: Mon Jul 22, 2019 3:29 pm
by ITOMB_IMT
Please have a look at the PM sent to you.
Thanks,
Re: Nagios XI url is not available of NagiosXi.xi is missing
Posted: Mon Jul 22, 2019 3:34 pm
by ssax
I do not see a message in my inbox.
Re: Nagios XI url is not available of NagiosXi.xi is missing
Posted: Mon Jul 22, 2019 3:44 pm
by ssax
Looks like you probably have some sudoers issues:
Code: Select all
[Mon Jul 22 10:47:14.182632 2019] [core:notice] [pid 5325] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
We trust you have received the usual lecture from the local System
Administrator. It usually boils down to these three things:
#1) Respect the privacy of others.
#2) Think before you type.
#3) With great power comes great responsibility.
sudo: no tty present and no askpass program specified
Please PM me these:
Code: Select all
/etc/sudoers
/etc/sudoers.d <- Any file that exists in this directory, include it
Since your DB is offloaded you will need to investigate your DB server as well as that external server contains the data, you will need to review your SQL logs on the external DB server to find root cause of a DB table going missing, it would likely have been a manual drop.
Re: Nagios XI url is not available of NagiosXi.xi is missing
Posted: Tue Jul 23, 2019 8:06 am
by ITOMB_IMT
Please see the PM for details asked.
Re: Nagios XI url is not available of NagiosXi.xi is missing
Posted: Tue Jul 23, 2019 9:50 am
by ssax
Please add this to your
/etc/sudoers:
Then restart the apache and nagios services.
Code: Select all
systemctl restart httpd
systemctl restart nagios
Just to be sure, please send the output of this command:
Code: Select all
grep "User \|Group " /etc/httpd/conf/httpd.conf
Re: Nagios XI url is not available of NagiosXi.xi is missing
Posted: Tue Jul 23, 2019 10:00 am
by ITOMB_IMT
grep "User \|Group " /etc/httpd/conf/httpd.conf
User apache
Group apache
One question, if the nagios.xi_options table is missing can we restore only that table from dump to nagiosxi database and make it functional, instead of restoring the whole database from dump and loosing data( changes made after the backup).
Re: Nagios XI url is not available of NagiosXi.xi is missing
Posted: Tue Jul 23, 2019 4:20 pm
by ssax
Already answered, this would be the process:
Yes, you can restore the individual table, see here:
Code: Select all
https://stackoverflow.com/questions/1013852/can-i-restore-a-single-table-from-a-full-mysql-mysqldump-file
Re: Nagios XI url is not available of NagiosXi.xi is missing
Posted: Wed Jul 24, 2019 10:25 am
by ITOMB_IMT
Thanks,
if a table in nagiosxi database or any database is missing will it effect monitoring?