Hi,
Here we are again.....
We have tried some things, to get a decent system running icinga, and so far
almost everything is working allright.
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
------------------------------------------------------------------------------
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users
