Hi,
We
are running on opensuse that defaults to a mariadb instead of mysql
install, so we were running icinga 1.9.2 / idoutils 1.9.2 on a opensuse
ppc system, with mariadb 5.5.33. This generated a lot of errors in de
database (with restarts):
InnoDB: Assertion failure in thread 70366933971360 in file buf0buf.ic line 1277
Some googling showed this could be a problem in Percona XtraDB, which is as
INNODB replacement in MariaDB.
Next
step: install MySQL Server instead of MariaDB. We were able to install
MySQL-5.5.6 in PPC, and the number of MySQL crashes went down to 1 in 2
days now (instead of 8 crashes a night). For now this is acceptable, and
we started with icinga-web on a separate system. We now have the
following setup:
LPAR 1 (OpenSuSE 13.1) - Icinga /idoutils (1.9.2)
LPAR 2 (OpenSuSE 13.1) - MySQL 5.5.6
X86 (OpenSuSE 12.2) - Icinga-Web 1.9.2
When
we log in in icinga-web we get a screen showing we don't have enough
permissions, and no servers show up. After debugging, googling a.s.o. I
found that if we install the databases on mariaDB 5.5.33 (local on
X86), we get all the hosts & services.
Installing icinga-web db local, and icinga db remote (LPAR2), we can see the
hosts, but not the services.
I tried the following statement in the different DB's (X86 DB is a restore of
the LPAR2 dump):
LPAR2:
MySQL
[nagios]> select count(*) from icinga_hosts join icinga_objects on
icinga_hosts.host_object_id=icinga_objects.object_id join
icinga_hoststatus on
icinga_hoststatus.host_object_id=icinga_objects.object_id;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)
X86:
mysql>
select count(*) from icinga_hosts join icinga_objects on
icinga_hosts.host_object_id=icinga_objects.object_id join
icinga_hoststatus on
icinga_hoststatus.host_object_id=icinga_objects.object_id;
+----------+
| count(*) |
+----------+
| 153 |
+----------+
1 row in set (0.00 sec)
Both statements are executed as root user in mysql (so all grants should be OK)
and are on the same database.
The only difference I see is the mysql / mariadb version, it looks like the
syntax in the newer mysql has been changed.
Anyone can shed a light on this ;)
Hans Scheffers
AIX / Linux Systeembeheer
