[icinga-users] icinga installed from yum repo

Tom Ku tku703 at gmail.com
Fri Aug 8 15:57:27 CEST 2014


Does anyone know the difference between the following directories?

[root at mon01-test mysql]# cd
/usr/share/doc/icinga-idoutils-libdbi-mysql-1.11.6/db/mysql/upgrade
[root at mon01-test upgrade]# ls -l
total 160
-rw-r--r-- 1 root root   350 Aug  6 14:52 mysql-upgrade-0.8.3.sql
-rw-r--r-- 1 root root 14391 Aug  6 14:52 mysql-upgrade-1.0.1.sql
-rw-r--r-- 1 root root 19486 Aug  6 14:52
mysql-upgrade-1.0.2-fix-object-relations.sql
-rw-r--r-- 1 root root  1004 Aug  6 14:52 mysql-upgrade-1.0.2.sql
-rw-r--r-- 1 root root   476 Aug  6 14:52 mysql-upgrade-1.0.3.sql
-rw-r--r-- 1 root root   898 Aug  6 14:52 mysql-upgrade-1.0rc.sql
-rw-r--r-- 1 root root  7624 Aug  6 14:52 mysql-upgrade-1.0.sql
-rw-r--r-- 1 root root  3027 Aug  6 14:52 mysql-upgrade-1.10.0.sql
-rw-r--r-- 1 root root  4634 Aug  6 14:52 mysql-upgrade-1.11.0.sql
-rw-r--r-- 1 root root  1330 Aug  6 14:52 mysql-upgrade-1.11.3.sql
-rw-r--r-- 1 root root   887 Aug  6 14:52 mysql-upgrade-1.11.6.sql
-rw-r--r-- 1 root root  1946 Aug  6 14:52 mysql-upgrade-1.3.0.sql
-rw-r--r-- 1 root root 40283 Aug  6 14:52 mysql-upgrade-1.4.0.sql
-rw-r--r-- 1 root root  1171 Aug  6 14:52 mysql-upgrade-1.5.0.sql
-rw-r--r-- 1 root root  9090 Aug  6 14:52 mysql-upgrade-1.6.0.sql
-rw-r--r-- 1 root root  5338 Aug  6 14:52 mysql-upgrade-1.7.0.sql
-rw-r--r-- 1 root root  5700 Aug  6 14:52 mysql-upgrade-1.8.0.sql
-rw-r--r-- 1 root root   984 Aug  6 14:52 mysql-upgrade-1.9.0.sql


[root at mon01-test upgrade]# cd
/usr/share/doc/icinga-web-1.11.0/schema/updates/mysql
[root at mon01-test mysql]# ls -l
total 64
-rw-r--r-- 1 root root  198 Mar 13 06:24 mysql_v1-0-3_to_v1-2.sql
-rw-r--r-- 1 root root  206 Mar 13 06:24 mysql_v1-10-0_to_1-10-1.sql
-rw-r--r-- 1 root root 2688 Mar 13 06:24 mysql_v1-2_to_v1-3.sql
-rw-r--r-- 1 root root  153 Mar 13 06:24 mysql_v1-3_to_v1-4.sql
-rw-r--r-- 1 root root  167 Mar 13 06:24 mysql_v1-4_to_v1-5.sql
-rw-r--r-- 1 root root  216 Mar 13 06:24 mysql_v1-5_to_v1-6.sql
-rw-r--r-- 1 root root  705 Mar 13 06:24 mysql_v1-6-2_to_v1-7.sql
-rw-r--r-- 1 root root   59 Mar 13 06:24 mysql_v1-6_to_v1-6-2.sql
-rw-r--r-- 1 root root  103 Mar 13 06:24 mysql_v1-7-0_to_v1-7-1.sql
-rw-r--r-- 1 root root  298 Mar 13 06:24 mysql_v1-7-1_to_v1-7-2.sql
-rw-r--r-- 1 root root 1486 Mar 13 06:24 mysql_v1-7-2_to_v1-8-0.sql
-rw-r--r-- 1 root root  237 Mar 13 06:24 mysql_v1-8-0_to_v-1-8-1.sql
-rw-r--r-- 1 root root 1073 Mar 13 06:24 mysql_v1-8-1_to_v1-8-3.sql
-rw-r--r-- 1 root root  496 Mar 13 06:24 mysql_v1-8-3_to_v1-9.sql
-rw-r--r-- 1 root root  129 Mar 13 06:24 mysql_v1-9-0_to_1-9-1.sql
-rw-r--r-- 1 root root  194 Mar 13 06:24 mysql_v1-9-1_to_1-10-0.sql


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?

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?

BTW, please see the following version of icinga installed:

[root at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.icinga.org/pipermail/icinga-users/attachments/20140808/bc19c843/attachment.html>


More information about the icinga-users mailing list