installed and configured the reporting module but when i tried to open the reporting module in icingaweb2 console getting the below error. Kindly help me how to resolve this issue.
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘reporting.report’ doesn’t exist
Yes, I tried the same steps which is mentioned in the documents but still im getting the same error. Also when i go and checked in the database the tables are not created for reporting database. Could you please help me on this. Below are the steps i performed.
went to /etc folder and running the below command
git clone https://github.com/Icinga/icingaweb2-module-reporting.git reporting
2.mysql -p -u root reporting < /etc/schema/mysql.sql
3.After entering above command it’s asking the password and i’m providing the password and after that the folder also created in the /etc directory.
But still facing the same error.
Did i missed any steps. Kindly help me out of this issue.
The issue has been resolved. My bad i’m trying to importing the schema from different directory so then i executed it from correct directory it went perfect.