OK. I tried this:
mysql -p icinga < /usr/local/icinga/etc/modules/icinga-core/module/idoutils/db/mysql/upgrade/m ysql-upgrade-1.7.0.sql till mysql -p icinga < /usr/local/icinga/etc/modules/icinga-core/module/idoutils/db/mysql/upgrade/m ysql-upgrade-1.12.0.sql He asked for the password everytime. Seems to be ok. After that, it showed this in /var/log/messages: Feb 9 14:10:22 icinga ido2db: IDO2DB 1.12.1 starting... (PID=7066) Feb 9 14:10:22 icinga ido2db: Successfully connected to mysql database Feb 9 14:10:22 icinga ido2db: Error: DB Version 1.6.0 does not match needed schema version 1.12.0. Please check the upgrade docs! Feb 9 14:10:22 icinga ido2db: Successfully disconnected from mysql database Feb 9 14:10:37 icinga icinga: idomod: Still unable to connect to data sink. 8283 items lost, 5000 queued items to flush. Is ido2db running and processing data? -----Ursprüngliche Nachricht----- Von: icinga-users [mailto:[email protected]] Im Auftrag von Carl R. Friend Gesendet: Montag, 9. Februar 2015 13:51 An: Icinga User's Corner Betreff: Re: [icinga-users] Still unable to connect to data sink On Mon, 9 Feb 2015, Florian Kluender wrote: > Ok, i think i have bigger problems: > > Error: DB Version 1.6.0 does not match needed schema version 1.12.0. Why didn't that come up before? Now that we know what the problem is, we can properly address it. First off, it seems you're working from prebuilt packages (usually a very good idea), and the package-manager isn't properly updating the database schema. This means you get to do it yourself -- from the source tree. 1) Get a copy of the source tree using git: git clone git://git.icinga.org/icinga-core 2) Figure out which database you're using. 3) In the directory that results from step 1 above (icinga-core): cd module/idoutils/db cd <database-type> (e.g. "mysql", "pgsql", &c.) cd upgrade 4) You are currently at DB schema version 1.6.0 (which matches the version of Icinga). You need to run all the *.sql files IN ORDER starting at <database-type>-upgrade-1.7.0.sql to 1.12.0.sql. DO NOT SKIP ANY -- doing so will corrupt your existing data. 5) Connect to your database using a client and "source" each of the files in order (e.g. for PostgreSQL): \i pgsql-upgrade-1.7.0.sql \i pgsql-upgrade-1.8.0.sql \i pgsql-upgrade-1.9.0.sql \i pgsql-upgrade-1.10.0.sql \i pgsql-upgrade-1.11.0.sql \i pgsql-upgrade-1.11.3.sql \i pgsql-upgrade-1.11.6.sql \i pgsql-upgrade-1.11.7.sql \i pgsql-upgrade-1.12.0.sql If you're running MySQL, everything will be mysql-upgrade-*.sql and you'll be using the command "source <filename>". 6) Restart ido2db and let us know the results. +------------------------------------------------+---------------------+ | Carl Richard Friend (UNIX Sysadmin) | West Boylston | | Minicomputer Collector / Enthusiast | Massachusetts, USA | | mailto:[email protected] +---------------------+ | http://users.rcn.com/crfriend/museum | ICBM: 42:22N 71:47W | +------------------------------------------------+---------------------+ _______________________________________________ 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
