Hi,

Although the pop-up errors do not show up anymore, I still cannot see any
hosts and services (I assume, after setup I should be able to see localhost
at least?). I have suspicion that it can be problem with the database still.

I tested the connection with:
mysql icinga -u icinga -p
mysql icinga_web -u icinga_web -p
and it works.

In databases.xml I have:
<ae:parameter name="dsn">mysql://icinga_web:icinga_web@localhost
:3306/icinga_web</ae:parameter>
<ae:parameter name="dsn">mysql://icinga:icinga@localhost
:3306/icinga</ae:parameter>

In docs there is written that I should update the credentials in file:
/etc/icinga2/features-available/ido-mysql.conf. After installation I have
there:
 user = "icinga2-ido-mysq”,
 password = "icinga",
 host = "localhost",
 database = “icinga2idomysql”.

(With this config in icinga2.log I have only 'TcpSocket: Invalid socket'
etc.)
When I change data in file ido-mysql.conf that they match databases.xml
config:
 user = "icinga”,
 password = "icinga",
 host = "localhost",
 database = “icinga”,

I have additional message in logs about: "IdoMysqlConnection: Schema
version '1.7.0' does not match the required version '1.11.3'! Please check
the upgrade documentation."

I am not sure if the change in the file was proper?

If it was, and I should make upgrade, the only file with upgrades I have in
location:
/usr/share/doc/icinga-idoutils/examples/mysql/upgrade/mysql-upgrade-XXX.sql
but the most fresh version is 1.7.0. I do not have any upgrades in the
folder /usr/share/icinga2-ido-mysql/schema/, and anywhere else - checked
with "find / -name '*.sql'".

Should I also change db_user and db_pass file /etc/icinga/ido2db.cfg? I
have there:
ido2db_user=nagios
ido2db_group=nagios
db_name=icinga
db_user=icinga-idoutils
db_pass=FFgvu1ljLn4j

Thank you again,
Kasia




2014-07-14 18:05 GMT+00:00 Kasia Macias <kasia.mac...@gmail.com>:

> Sorry, I was mistaken because the Icinga-Web wiki page pointed to
> IDOutils as requirement. Now I see it was only for Icinga 1.x. After
> redoing everything, but without this unnecessary part, it still works
> without previous errors.
> So the problem was with my database only.
>
> Thank you for your patience.
>
> Kind regards,
> Kasia
>
_______________________________________________
icinga-users mailing list
icinga-users@lists.icinga.org
https://lists.icinga.org/mailman/listinfo/icinga-users

Reply via email to