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