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
