Hi

I am currently using  Icinga 1.9.3 for monitoring 200+ host and 400+
services.

In my company we use many radios which also monitoring.

My question is: In your experience what is the best plugin to display on a
map the infrastructure and relationships of children and parents?

Abraham Rico

Guadalajara Jalsico Mexico


2013/11/14 Hans Scheffers <hans.scheff...@outlook.com>

> 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
>
>


-- 
por
Mi Blog <http://www.abricolabs.net>
------------------------------------------------------------------------------
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

Reply via email to