Missing Table

When I log in to the web interface that is the error message i get and i cannot use the icinga itself. i hope someone can help me fix this.

— new installation —

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

Blind guess, you did not setup two databases (icinga2 and icingaweb2) or mixed them up. Can you share your /etc/icingaweb2/resources.ini (with passwords redacted off course)?

sorry for the ignorance but how can i do that?
i have tried this but i’m denied for some reason as well.


this is what i found out

This is what I was expecting, you mixed up the databases. What you need is one database for icinga2 and another one for icingaweb2. You have just one database for both instead.

When somethihng like this is not right, I’d be suspicious about other things
being missing as well, so let’s go back to basics:

  1. How did you install Icinga and Icingaweb2?

  2. What documentation did you follow to configure them after installation?


i followed the installation i found on the website of icinga, with regards to the configuration i just follow these instruction from this website.

How To Install Icinga 2 on CentOS 7 / RHEL 7 - Centos/Redhat (itzgeek.com)
how can i check what are missing on my installation and configuration?

how can i create a separate db for each other?

what also needs to be done for the configuration of it?

i appreciate the help.

When you have followed those instructions then you should have both databases. In that case you just need to correct resource.ini directly or via icingweb Configuration/Application/Ressources.

how can i do it?

Installation - Icinga DB

should i just run all these again?

IcingaDB is a total different story.

How can i move forward to this?
what is needed for it to work?

thanks for your inputs.

Please check my comment.