How to know which 'core' schema version upgrade to

Icinga Web 2
1

Hi all!

As the title says, I would like to know “how to know which ‘core’ schema version upgrade to”.
Is it a manual step or is it something that is applied automatically when upgrading the package?
If it is a manual step, I would like to now how to work out what version we last updated to in order to know how many schema files in /usr/share/icinga2-ido-mysql/schema/upgrade I would need to apply.

Thank you all in advance.

Some details:

  • Icinga Core version: 2.14.1-1
  • Icinga Web 2 version: 2.12.0
  • PHP version used: 7.4.33
  • Server operating system and version: Ubuntu Server 20.04
2

Hii @mdaleo404, welcome to the Icinga Community!

You can use this query to determine which schema is currently applied: SELECT * FROM icinga_dbversion;

Yes it’s a manual step! You can apply the upgrade scripts as described here.

1 Like
3

That’s great! Thank you!