Hi,

My apologies for my first post on the mailing list, it was a total
disaster.
I copied/pasted my Stack Overflow question in an email and sent to the
mailing list.
The result was totally unreadable! The whole email was a Iong and
endless one line email.
I hope this email won't have an unexpected format too.

@Eric: I use an Ansible role to configure either PostgreSQL or MySQL
backend (not both at the same time).

About the issue, with the support of Icinga IRC users, I figured out
that, when comparing my two separate environments, one with PostgreSQL
backend and the other with MySQL Backend, I had misconfigured my
PostgreSQL IDO backend. My Ansible role was working with MySQL but
PostgreSQL.

As relayed by Alex, it was a "wrong categories setting" in my
"/etc/icinga2/features-enabled/ido-pgsql.conf".
I used the IDO example provided in the documentation
<http://docs.icinga.org/icinga2/latest/doc/module/icinga2/chapter/object-types#%21/icinga2/latest/doc/module/icinga2/chapter/object-types#objecttype-idomysqlconnection>
as is.

To fix my problem, i.e to get historical data store in the DB and then
be able to list them in the UI, I had to remove:

    categories = DbCatConfig | DbCatState

Note: Here is my Stack Overflow answer
<http://stackoverflow.com/a/34917861/5251001>.

Thank you everyone,
Mickael
_______________________________________________
icinga-users mailing list
icinga-users@lists.icinga.org
https://lists.icinga.org/mailman/listinfo/icinga-users

Reply via email to