Am 08.08.2014 15:57, schrieb Tom Ku:
Does anyone know the difference between the following directories?

[root@mon01-test mysql]# cd /usr/share/doc/icinga-idoutils-libdbi-mysql-1.11.6/db/mysql/upgrade

As the package name implies - Icinga IDOUtils.



[root@mon01-test upgrade]# cd /usr/share/doc/icinga-web-1.11.0/schema/updates/mysql

Icinga Web.



I think these are for upgrading the MySQL databases for icinga and icinga web but i'm not 100% sure.  Also, in the /usr/share/doc/icinga-idoutils-libdbi-mysql-1.11.6/db/mysql/upgrade dir, I assume these are to upgrade the icinga DB but which one do I use?

See my previous reply:

install the software, but do not start any daemons or use the web app.

logs, other files
* depends on your requirements

database
* import the mysqldump of your icinga idoutils and icinga web database
* upgrade icinga idoutils db from 1.8 to 1.11.6 (incremential steps as shown on the docs - http://docs.icinga.org/latest/en/upgrading_idoutils.html)
* upgrade icinga web db from 1.9 to 1.11 (incremential steps)

config
* /etc/icinga for icinga 1.x stays the same, look into the changelog for updates/changes
* not sure how you did install icinga-web from source, but you generally want to keep the etc/ directory
* copy icinga web xml config to /etc/icinga-web and clear the config cache

Note all the steps you've done and share them with the community once you're finished please.




My current icinga db version:

mysql> use icinga;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from icinga_dbversion;
+--------------+----------+---------+---------------------+---------------------+
| dbversion_id | name     | version | create_time         | modify_time         |
+--------------+----------+---------+---------------------+---------------------+
|            1 | idoutils | 1.8.0   | 2013-05-21 06:53:40 | 2013-05-21 06:53:40 |
+--------------+----------+---------+---------------------+---------------------+
1 row in set (0.00 sec)

I have 1.8 installed so do i incrementally install all the way up to mysql-upgrade-1.11.6.sql?

Jep.

kind regards,
Michael

PS: Replying to a mailinglist works like "hit reply to list in thunderbird".


BTW, please see the following version of icinga installed:

[root@mon01-test mysql]# rpm -qa | grep icinga
icinga-idoutils-libdbi-mysql-1.11.6-0.el6.x86_64
icinga-debuginfo-1.11.6-0.el6.x86_64
icinga-doc-1.11.6-0.el6.x86_64
icinga-web-1.11.0-1.el6.noarch
icinga-idoutils-1.11.6-0.el6.x86_64
icinga-gui-config-1.11.6-0.el6.x86_64
icinga-web-mysql-1.11.0-1.el6.noarch
icinga-1.11.6-0.el6.x86_64
icinga-gui-1.11.6-0.el6.x86_64
icinga-devel-1.11.6-0.el6.x86_64




_______________________________________________
icinga-users mailing list
[email protected]
https://lists.icinga.org/mailman/listinfo/icinga-users


-- 
Michael Friedrich, DI (FH)
Application Developer

NETWAYS GmbH | Deutschherrnstr. 15-19 | D-90429 Nuernberg
Tel: +49 911 92885-0 | Fax: +49 911 92885-77
GF: Julian Hein, Bernd Erk | AG Nuernberg HRB18461
http://www.netways.de | [email protected]

** Open Source Backup Conference 2014 - September - osbconf.org **
** Puppet Camp Duesseldorf 2014 - Oktober - netways.de/puppetcamp **
** OSMC 2014 - November - netways.de/osmc **
** OpenNebula Conf 2014 - Dezember - opennebulaconf.com **


_______________________________________________
icinga-users mailing list
[email protected]
https://lists.icinga.org/mailman/listinfo/icinga-users

Reply via email to