SQLSTATE[42S02]: Base table or view not found: 1146 Table 'icinga_ido.icinga_dbversion' doesn't exist, query was: SELECT icinga_dbversion.version FROM icinga_dbversion

Icinga Web
1

Hello,
I have just installed Icinga2 via the Icinga doku. Now I have this Problem can anyone help me?

image

i don’t remember having to create a icinga_dbversion database in the doku. These are my databases:
image

thx

2

ok i found it
I didnt have the right schema for the database Icinga_ido

with “mariadb -u root -p icinga < /usr/share/icinga2-ido-mysql/schema/mysql.sql”

I altered the schema and now it seems to be working

3

Great! But since you are probably creating a new setup you might want to use the IcingaDB-Backend instead of the IDO one.