Here is how I installed it // populate the icinga2 DB # cp /usr/share/icinga2-ido-mysql/schema/mysql.sql . # sed -i "1iuse icinga;" mysql.sql # mysql -u root -p < mysql.sql
AFAIK, there is a packaging problem with it. I'm trying to get it fixed. I've written to the email address in the .deb file, but I got no reply yet. On 07/17/2014 08:10 PM, 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? > > 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 <[email protected]>: > >> 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 > [email protected] > https://lists.icinga.org/mailman/listinfo/icinga-users > _______________________________________________ icinga-users mailing list [email protected] https://lists.icinga.org/mailman/listinfo/icinga-users
