Upgrade from 2011 to 2012 Failed

[JulianFDRacing]

I've just attempted to upgrade our production Nagios XI box and got the following at the end of the log

Code: Select all

Stopping nagios:                                           [  OK  ]
Starting nagios:                                           [  OK  ]
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror01.th.ifl.net
 * epel: mirrors.coreix.net
 * extras: mirror01.th.ifl.net
 * updates: mirror01.th.ifl.net
Setting up Install Process
Package bc-1.06-21.i386 already installed and latest version
Package matching dstat-0.6.6-5.el5.noarch already installed. Checking for update.
Package mailx-8.1.1-44.2.2.i386 already installed and latest version
Package perl-Net-DNS-0.59-3.el5.i386 already installed and latest version
Package pymssql-1.0.2-2.el5.i386 already installed and latest version
Package rpmdevtools-6.8-1.el5.noarch already installed and latest version
Package rrdtool-python is obsoleted by python-rrdtool, trying to install python-rrdtool-1.4.7-1.el5.rf.i386 instead
Resolving Dependencies
--> Running transaction check
---> Package expat-devel.i386 0:1.95.8-11.el5_8 set to be updated
--> Processing Dependency: expat = 1.95.8-11.el5_8 for package: expat-devel
---> Package mod_ssl.i386 1:2.2.3-65.el5.centos set to be updated
--> Processing Dependency: httpd = 2.2.3-65.el5.centos for package: mod_ssl
---> Package numpy.i386 0:1.2.1-2.el5 set to be updated
--> Processing Dependency: python-nose for package: numpy
--> Processing Dependency: libatlas.so.3 for package: numpy
--> Processing Dependency: python-devel for package: numpy
--> Processing Dependency: libptcblas.so.3 for package: numpy
--> Processing Dependency: liblapack.so.3 for package: numpy
--> Processing Dependency: libptf77blas.so.3 for package: numpy
---> Package openldap.i386 0:2.3.43-25.el5_8.1 set to be updated
---> Package openldap-devel.i386 0:2.3.43-25.el5_8.1 set to be updated
---> Package perl-DBD-MySQL.i386 0:3.0007-2.el5 set to be updated
---> Package perl-Mail-IMAPClient.noarch 0:3.32-1.el5 set to be updated
--> Processing Dependency: perl(Parse::RecDescent) for package: perl-Mail-IMAPClient
---> Package python-lxml.i386 0:2.0.11-1.el5 set to be updated
---> Package python-rrdtool.i386 0:1.4.7-1.el5.rf set to be updated
--> Processing Dependency: rrdtool = 1.4.7 for package: python-rrdtool
---> Package python-simplejson.i386 0:2.0.9-8.el5 set to be updated
---> Package sudo.i386 0:1.7.2p1-14.el5_8.4 set to be updated
---> Package traceroute.i386 3:2.0.1-6.el5 set to be updated
--> Running transaction check
---> Package atlas-sse.i386 0:3.8.3-1.el5 set to be updated
--> Processing Dependency: libgfortran.so.1 for package: atlas-sse
---> Package expat.i386 0:1.95.8-11.el5_8 set to be updated
--> Processing Dependency: httpd = 2.2.3-45.el5.centos.1 for package: httpd-manual
--> Processing Dependency: httpd = 2.2.3-45.el5.centos.1 for package: httpd-devel
---> Package httpd.i386 0:2.2.3-65.el5.centos set to be updated
---> Package perl-Parse-RecDescent.noarch 0:1.965.1-2.el5.rf set to be updated
---> Package python-devel.i386 0:2.4.3-46.el5_8.2 set to be updated
--> Processing Dependency: python = 2.4.3-46.el5_8.2 for package: python-devel
---> Package python-nose.noarch 0:0.11.3-2.el5 set to be updated
--> Processing Dependency: python-setuptools for package: python-nose
--> Processing Dependency: rrdtool = 1.4.4 for package: perl-rrdtool
---> Package rrdtool.i386 0:1.4.7-1.el5.rf set to be updated
--> Running transaction check
---> Package httpd-devel.i386 0:2.2.3-65.el5.centos set to be updated
---> Package httpd-manual.i386 0:2.2.3-65.el5.centos set to be updated
---> Package libgfortran.i386 0:4.1.2-52.el5_8.1 set to be updated
---> Package perl-rrdtool.i386 0:1.4.7-1.el5.rf set to be updated
---> Package python.i386 0:2.4.3-46.el5_8.2 set to be updated
--> Processing Dependency: python-libs-i386 = 2.4.3-46.el5_8.2 for package: python
---> Package python-setuptools.noarch 0:0.6c5-2.el5 set to be updated
--> Running transaction check
---> Package python-libs.i386 0:2.4.3-46.el5_8.2 set to be updated
dag/filelists_db                                                                                                                                                      | 6.1 MB     01:04
epel/filelists_db                                                                                                                                                     | 4.8 MB     00:50
extras/filelists_db                                                                                                                                                   | 216 kB     00:01
updates/filelists_db                                                                                                                                                  | 3.6 MB     00:19
--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================================================================================================================================
 Package                                             Arch                                 Version                                                Repository                             Size
=============================================================================================================================================================================================
Installing:
 numpy                                               i386                                 1.2.1-2.el5                                            epel                                  2.4 M
 perl-DBD-MySQL                                      i386                                 3.0007-2.el5                                           base                                  148 k
 perl-Mail-IMAPClient                                noarch                               3.32-1.el5                                             epel                                  233 k
 python-lxml                                         i386                                 2.0.11-1.el5                                           epel                                  1.7 M
 python-rrdtool                                      i386                                 1.4.7-1.el5.rf                                         dag                                    28 k
 python-simplejson                                   i386                                 2.0.9-8.el5                                            base                                  140 k
Updating:
 expat-devel                                         i386                                 1.95.8-11.el5_8                                        updates                               132 k
 mod_ssl                                             i386                                 1:2.2.3-65.el5.centos                                  updates                                94 k
 openldap                                            i386                                 2.3.43-25.el5_8.1                                      updates                               298 k
 openldap-devel                                      i386                                 2.3.43-25.el5_8.1                                      updates                               2.9 M
 sudo                                                i386                                 1.7.2p1-14.el5_8.4                                     updates                               353 k
 traceroute                                          i386                                 3:2.0.1-6.el5                                          base                                   40 k
Installing for dependencies:
 atlas-sse                                           i386                                 3.8.3-1.el5                                            epel                                  2.6 M
 libgfortran                                         i386                                 4.1.2-52.el5_8.1                                       updates                               232 k
 perl-Parse-RecDescent                               noarch                               1.965.1-2.el5.rf                                       dag                                   145 k
 python-devel                                        i386                                 2.4.3-46.el5_8.2                                       updates                               3.0 M
 python-nose                                         noarch                               0.11.3-2.el5                                           epel                                  310 k
 python-setuptools                                   noarch                               0.6c5-2.el5                                            base                                  479 k
Updating for dependencies:
 expat                                               i386                                 1.95.8-11.el5_8                                        updates                                78 k
 httpd                                               i386                                 2.2.3-65.el5.centos                                    updates                               1.2 M
 httpd-devel                                         i386                                 2.2.3-65.el5.centos                                    updates                               153 k
 httpd-manual                                        i386                                 2.2.3-65.el5.centos                                    updates                               817 k
 perl-rrdtool                                        i386                                 1.4.7-1.el5.rf                                         dag                                    52 k
 python                                              i386                                 2.4.3-46.el5_8.2                                       updates                                59 k
 python-libs                                         i386                                 2.4.3-46.el5_8.2                                       updates                               5.8 M
 rrdtool                                             i386                                 1.4.7-1.el5.rf                                         dag                                   906 k

Transaction Summary
=============================================================================================================================================================================================
Install      12 Package(s)
Upgrade      14 Package(s)

Total download size: 24 M
Downloading Packages:
(1/26): python-rrdtool-1.4.7-1.el5.rf.i386.rpm                                                                                                                        |  28 kB     00:00
(2/26): traceroute-2.0.1-6.el5.i386.rpm                                                                                                                               |  40 kB     00:00
(3/26): perl-rrdtool-1.4.7-1.el5.rf.i386.rpm                                                                                                                          |  52 kB     00:00
(4/26): python-2.4.3-46.el5_8.2.i386.rpm                                                                                                                              |  59 kB     00:00
(5/26): expat-1.95.8-11.el5_8.i386.rpm                                                                                                                                |  78 kB     00:00
(6/26): mod_ssl-2.2.3-65.el5.centos.i386.rpm                                                                                                                          |  94 kB     00:00
(7/26): expat-devel-1.95.8-11.el5_8.i386.rpm                                                                                                                          | 132 kB     00:00
(8/26): python-simplejson-2.0.9-8.el5.i386.rpm                                                                                                                        | 140 kB     00:00
(9/26): perl-Parse-RecDescent-1.965.1-2.el5.rf.noarch.rpm                                                                                                             | 145 kB     00:01
(10/26): perl-DBD-MySQL-3.0007-2.el5.i386.rpm                                                                                                                         | 148 kB     00:00
(11/26): httpd-devel-2.2.3-65.el5.centos.i386.rpm                                                                                                                     | 153 kB     00:00
(12/26): libgfortran-4.1.2-52.el5_8.1.i386.rpm                                                                                                                        | 232 kB     00:01
(13/26): perl-Mail-IMAPClient-3.32-1.el5.noarch.rpm                                                                                                                   | 233 kB     00:02
(14/26): openldap-2.3.43-25.el5_8.1.i386.rpm                                                                                                                          | 298 kB     00:01
(15/26): python-nose-0.11.3-2.el5.noarch.rpm                                                                                                                          | 310 kB     00:02
(16/26): sudo-1.7.2p1-14.el5_8.4.i386.rpm                                                                                                                             | 353 kB     00:01
(17/26): python-setuptools-0.6c5-2.el5.noarch.rpm                                                                                                                     | 479 kB     00:01
(18/26): httpd-manual-2.2.3-65.el5.centos.i386.rpm                                                                                                                    | 817 kB     00:04
(19/26): rrdtool-1.4.7-1.el5.rf.i386.rpm                                                                                                                              | 906 kB     00:07
(20/26): httpd-2.2.3-65.el5.centos.i386.rpm                                                                                                                           | 1.2 MB     00:07
(21/26): python-lxml-2.0.11-1.el5.i386.rpm                                                                                                                            | 1.7 MB     00:19
(22/26): numpy-1.2.1-2.el5.i386.rpm                                                                                                                                   | 2.4 MB     00:25
(23/26): atlas-sse-3.8.3-1.el5.i386.rpm                                                                                                                               | 2.6 MB     00:24
(24/26): openldap-devel-2.3.43-25.el5_8.1.i386.rpm                                                                                                                    | 2.9 MB     00:16
(25/26): python-devel-2.4.3-46.el5_8.2.i386.rpm                                                                                                                       | 3.0 MB     00:14
(26/26): python-libs-2.4.3-46.el5_8.2.i386.rpm                                                                                                                        | 5.8 MB     00:37
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                        139 kB/s |  24 MB     02:58
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test


[b]Transaction Check Error:
  file /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/Bundle/DBD/mysql.pm from install of perl-DBD-MySQL-3.0007-2.el5.i386 conflicts with file from package perl-DBD-mysql-4.014-1.el5.rf.i386
  file /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBD/mysql.pm from install of perl-DBD-MySQL-3.0007-2.el5.i386 conflicts with file from package perl-DBD-mysql-4.014-1.el5.rf.i386
  file /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBD/mysql/GetInfo.pm from install of perl-DBD-MySQL-3.0007-2.el5.i386 conflicts with file from package perl-DBD-mysql-4.014-1.el5.rf.i386
  file /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBD/mysql/INSTALL.pod from install of perl-DBD-MySQL-3.0007-2.el5.i386 conflicts with file from package perl-DBD-mysql-4.014-1.el5.rf.i386
  file /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.so from install of perl-DBD-MySQL-3.0007-2.el5.i386 conflicts with file from package perl-DBD-mysql-4.014-1.el5.rf.i386
  file /usr/share/man/man3/Bundle::DBD::mysql.3pm.gz from install of perl-DBD-MySQL-3.0007-2.el5.i386 conflicts with file from package perl-DBD-mysql-4.014-1.el5.rf.i386
  file /usr/share/man/man3/DBD::mysql.3pm.gz from install of perl-DBD-MySQL-3.0007-2.el5.i386 conflicts with file from package perl-DBD-mysql-4.014-1.el5.rf.i386
  file /usr/share/man/man3/DBD::mysql::INSTALL.3pm.gz from install of perl-DBD-MySQL-3.0007-2.el5.i386 conflicts with file from package perl-DBD-mysql-4.014-1.el5.rf.i386[/b]
Error Summary
-------------

[root@NagiosXI nagiosxi]#

Can I fix this or should I revert back to the VM snapshot I took before the upgrade, concerned that I may lose performance data if I do

Thanks

[JulianFDRacing]

I went through this process with a fresh 2012 VM install that I restored a 2011 backup image of our production server to and it ran the upgrade fine once the restore completed. I've checked that VM and it doesn't have perl-DBD-mysql installed, so I went back to the production box and ran a yum remove perl-DBD-mysql.i386, this claimed it was also going to remove "mysql-server" which surely will trash the NagiosXI installation? I cancelled the process but need to know if its possible to downgrade this version 4 to version 3 which it looks like the installation script is trying to install?

[JulianFDRacing]

I've just noticed a real problem, the graphs are no longer updating since I attempted to upgrade, the rrd files datastamp is current so looks like its writing the data but the graph data stops around the time I started the upgrade.

This is now a big issue and I need to make a decision to either go back to snapshot of the VM and defintely lose perfdata or wait until I get a response from Nagios support and see if it can be repaired.

[lmiltchev]

Try this:

Open the "install-2012-prereqs" in a text editor:

Code: Select all

vi /tmp/nagiosxi/install-2012-prereqs

and remove the "perl-DBD-MySQL" from the "yum install ..." line

Save, exit, and run the "./upgrade" again.

Hope this helps.

[JulianFDRacing]

Looking good now, appears to be completing the upgrade now but will confirm when its up and tested, thanks

[JulianFDRacing]

Preliminary checks look good, the upgrade completed and everything looking fine, thanks for the assistance

[slansing]

Glad you got it up and running, thanks for the feedback.

[JulianFDRacing]

Hmm, just when I thought it was all going to plan, I'm not able to see any perfdata in graphs since I ran the final upgrade, I've restarted everything and checked the rrd files time stamps and they look OK but still nothing in the graphs post upgrade.

All services are saying good to go but cannot see anything hitting service-perfdata.out using 'less -f service-perfdata.out', owner and group were set to root but I've changed them to nagios now, any suggestions?

[mguthrie]

Are you seeing empty graphs, or no graphs?

Right click and select "refresh" in your browser. If you're using IE, clear your javascript/css cached files. We updated some of our javascript libraries and the browser may still be caching old files.

[JulianFDRacing]

They had data up till the time of the upgrade, then nothing, seems to be creeping up but not convinced its catching up, is there a way of checking the rrd files?

Tried the cache but defintely not that, something that could be related is this is a VM and the hardware clock get reset by ESX every time it restarts, I usually set the system clock correctly and sync the system to hardware clock, never had an issue with losing performance data like this though

So far looks like I've lost about three hours data which could equate to three reboots? I would have thought that the graphs would just show a flat line from the previous time reading to the next one an hour long.