Re: [icinga-users] Icinga-web installation problem - connection refused, missing db schema

[Michael Friedrich]

On 17.07.2014 13:10, Kasia Macias wrote: 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? icinga2-ido-mysql ships the mysql schema version 1.11.3 which is required by Icinga 2 at least. The warning tells you about it. Your schema seems to be coming from the 'icinga-idoutils' package you had installed previously (and I told you to purge it). 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 As said, you don't need that package, nor its shipped example files. 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.cfg is part of icinga-idoutils. Which is part of Icinga 1.x. You're using Icinga 2 and should only install the packages remarked in the documentation. Entirely purge the icinga-idoutils package, drop the icinga database and start again with reinstalling icinga2-ido-mysql kind regards, Michael 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 --  Michael Friedrich, DI (FH) Application Developer NETWAYS GmbH | Deutschherrnstr. 15-19 | D-90429 Nuernberg Tel: +49 911 92885-0 | Fax: +49 911 92885-77 GF: Julian Hein, Bernd Erk | AG Nuernberg HRB18461 http://www.netways.de | michael.friedr...@netways.de ** Open Source Backup Conference 2014 - September - osbconf.org ** ** Puppet Camp Duesseldorf 2014 - Oktober - netways.de/puppetcamp ** ** OSMC 2014 - November - netways.de/osmc ** ** OpenNebula Conf 2014 - Dezember - opennebulaconf.com **

_______________________________________________
icinga-users mailing list
icinga-users@lists.icinga.org
https://lists.icinga.org/mailman/listinfo/icinga-users