Looks like your icingaweb database is missing the correct schema.
In the web-based setup, after you have defined the settings for the ‘icingaweb’ database, the setup asks for an account with root/administrative privileges, if the database is not present/missing the schema.
Provide the root user for the MySQL databse there and the setup should do the rest.
thanks for your reply but I am new in icinga and mysql, could you let me know the through the command line of setting up schema. Web base setup doesn’t have an option for root privileges or may be i am missing something.
Tbh I have no idea where the icingaweb2 schema file is stored
If you followed the howto you posted the database should set itself up correctly in Step 19.5.
In case the web-based setup wasn’t able to do that in this step you should normally get another window where you are asked to provide administrative credentials with which the setup will then do the setup.
Check again if you have done the following steps:
Create the database for Icinga Web 2:
CREATE DATABASE icingaweb;
Now, configure permissions:
GRANT ALL PRIVILEGES ON icingaweb.* TO 'icingaweb'@'localhost' IDENTIFIED BY 'icingaweb';