Something is wrong with contents of the file /usr/local/nagiosxi/cron/sysstat.php; that's not how those lines are supposed to look if you upgraded to Nagios XI 5.7.5.
The upgrade didn't fail, did it? Did it give any error messages?
Is there a way you could restore the VM to a state where you had 5.6.12 installed, and try the upgrade again?
If you try upgrading it from the command line using this guide, it'll give more detailed output that I can use to further diagnose.
Here's a diff of your lines, vs how those lines are supposed to look if your system had 5.7.5 installed:
db stopped after upgrading to 5.7.5
Re: db stopped after upgrading to 5.7.5
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Re: db stopped after upgrading to 5.7.5
what can be done to fix this ? thanks
Re: db stopped after upgrading to 5.7.5
If you try upgrading it from the command line using this guide, it'll give more detailed output that I can use to further diagnose.
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Re: db stopped after upgrading to 5.7.5
we are using rpm version of nagiosxi , we have another nagios server (server2) , I did yum update , updated it to 5.7.5-1,
files under /usr/local/nagiosxi/cron/ are modified on 2020-08-28, which should be the time 5.7.5-1 rpm was packaged.
but on the nagios server having issue (server1) , files under sysstat.php /usr/local/nagiosxi/cron/ are modified on 2019-10-21, should are probably from last yum package.
unfortunately I didn't create a snapshot for server1 , also I checked:
so not sure which packages are these files coming from , should I just try reinstall all the nagiosxi packages on server1 ? would this having issue if the db check/modify script would run again if reinstall nagiosxi packages?
files under /usr/local/nagiosxi/cron/ are modified on 2020-08-28, which should be the time 5.7.5-1 rpm was packaged.
but on the nagios server having issue (server1) , files under sysstat.php /usr/local/nagiosxi/cron/ are modified on 2019-10-21, should are probably from last yum package.
unfortunately I didn't create a snapshot for server1 , also I checked:
Code: Select all
> rpm -qf /usr/local/nagiosxi/cron/sysstat.php
file /usr/local/nagiosxi/cron/sysstat.php is not owned by any packageRe: db stopped after upgrading to 5.7.5
Apparently the package nagiosxi "owns" files under /tmp/nagiosxi, which it then copies to the correct location when it's installed.
If the package was installed, it would have the timestamp of the install time not the time inside of the package.
If you run the following command on server1, and server2, it may give a better idea of how Nagios XI was installed in each environment:
If the package was installed, it would have the timestamp of the install time not the time inside of the package.
If you run the following command on server1, and server2, it may give a better idea of how Nagios XI was installed in each environment:
Code: Select all
rpm -qa |grep -i nagiosIf you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Re: db stopped after upgrading to 5.7.5
the result of rpm -qa|grep nagios from both servers are the same ,
server1 ( the one has the issue):
server 2 ( the one that works fine):
I also did "yum reinstall" of all the nagios packages from the above list on server1, still the same issue, which packages do I need to reinstall to get the files correctly under /usr/local/nagiosxi/cron ?
server1 ( the one has the issue):
Code: Select all
server1 $ rpm -qa|grep nagios| sort
nagios-repo-7-4.el7.noarch
nagiosxi-ajaxterm-5-4.13.el7.x86_64
nagiosxi-mrtg-5.7.5-1.el7.x86_64
nagiosxi-nagioscore-5.7.5-1.el7.x86_64
nagiosxi-nagiosmobile-5.6.14-1.el7.x86_64
nagiosxi-nagiosplugins-5.7.5-1.el7.x86_64
nagiosxi-nagiosql-5-4.13.el7.x86_64
nagiosxi-nagvis-5.7.5-1.el7.x86_64
nagiosxi-ndoutils-5.7.5-1.el7.x86_64
nagiosxi-nrds-5.7.5-1.el7.x86_64
nagiosxi-nrpe-5.7.5-1.el7.x86_64
nagiosxi-nsca-5.7.5-1.el7.x86_64
nagiosxi-nxti-5.7.5-1.el7.x86_64
nagiosxi-pnp-5.7.5-1.el7.x86_64
nagiosxi-shellinabox-5.7.5-1.el7.x86_64
nagiosxi-wkhtmltox-5.7.5-1.el7.x86_64
nagiosxi-wmic-5.7.5-1.el7.x86_64Code: Select all
$
server2 $ rpm -qa|grep nagios |sort
nagios-repo-7-4.el7.noarch
nagiosxi-ajaxterm-5-4.13.el7.x86_64
nagiosxi-mrtg-5.7.5-1.el7.x86_64
nagiosxi-nagioscore-5.7.5-1.el7.x86_64
nagiosxi-nagiosmobile-5.6.14-1.el7.x86_64
nagiosxi-nagiosplugins-5.7.5-1.el7.x86_64
nagiosxi-nagiosql-5-4.13.el7.x86_64
nagiosxi-nagvis-5.7.5-1.el7.x86_64
nagiosxi-ndoutils-5.7.5-1.el7.x86_64
nagiosxi-nrds-5.7.5-1.el7.x86_64
nagiosxi-nrpe-5.7.5-1.el7.x86_64
nagiosxi-nsca-5.7.5-1.el7.x86_64
nagiosxi-nxti-5.7.5-1.el7.x86_64
nagiosxi-pnp-5.7.5-1.el7.x86_64
nagiosxi-shellinabox-5.7.5-1.el7.x86_64
nagiosxi-wkhtmltox-5.7.5-1.el7.x86_64
nagiosxi-wmic-5.7.5-1.el7.x86_64
percona-nagios-plugins-1.1.7-2.noarch
Re: db stopped after upgrading to 5.7.5
I just did a test run on a VM running Nagios XI 5.8, and "yum reinstall nagiosxi" had some adverse effects, so I'll not recommend you do that.
Here's a tarball of what's in an unmodified /usr/local/nagiosxi/cron directory with Nagios XI 5.7.5 installed.
Again, this should have come across whenever you upgraded to Nagios XI 5.7.5, but somehow it didn't.
Here's a tarball of what's in an unmodified /usr/local/nagiosxi/cron directory with Nagios XI 5.7.5 installed.
Again, this should have come across whenever you upgraded to Nagios XI 5.7.5, but somehow it didn't.
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.