I’m in a new to this tool. We have successfully installed and configured ICINGAweb2 and able to login to the console, able to add the devices and all but we need the reports for all the added devices so i’m trying to installing the reporting module but unfortunately getting the below error. Can any one help me to resolve this issue.
Cloning into ‘reporting’… firstname.lastname@example.org: Permission denied (publickey) in icinga
Thanks for the command and it works fantastic. But although after creating the database and provided all the permission then i have executed the below command to import the schema but unfortunately getting the below error. Kindly help me on this.
ERROR: mysql -p -u root reporting < schema/mysql.sql
bash: schema/mysql.sql: No such file or directory
In which directory are you running the command?
Because it is trying to import the schema that lies in reporting/schema/mysql.sql and since schema/mysql.sql is a relative path it matters where you run it - so try again while in the reporting directory.
PS: I just want to clarify that this here is a community forum where users help other users - so there really isn’t a “team” here - just a bunch of people that use Icinga and want to help each other.
Yes, Thanks for the info. I’m trying to execute this command from root. What i did i was created the database and provided the all the permission to the database so after that i’m trying to importing the schema using the below command.
mysql -p -u root reporting < schema/mysql.sql. But getting the error. Then I created the folder in /etc/schema and created the file called mysql.sql. After that i execute the below command and it showing completed but when i go and checked the file it is showing 0KB.
Can you please suggest is there any other way to install this reporting module.