Hi,
I have installed the reporting module, but getting errors:
SQLSTATE[42000]: Syntax error or access violation: 1370 execute command denied to user ‘icinga2’@‘172.20.25.136’ for routine ‘icinga2.idoreports_get_sla_ok_percent’, query was: SELECT h.display_name COLLATE latin1_general_ci AS host_display_name, h.display_name COLLATE latin1_general_ci AS host_display_name, idoreports_get_sla_ok_percent(ho.object_id, ‘2020-07-20 15:26:23’, ‘2020-07-21 16:26:23’, NULL) AS sla FROM icinga_objects AS ho
INNER JOIN icinga_hosts AS h ON h.host_object_id = ho.object_id AND ho.is_active = 1 AND ho.objecttype_id = 1 WHERE ( (EXISTS (SELECT 1 FROM icinga_objects AS sub_hgo
INNER JOIN icinga_hostgroups AS sub_hg ON sub_hg.hostgroup_object_id = sub_hgo.object_id AND sub_hgo.is_active = 1 AND sub_hgo.objecttype_id = 3
INNER JOIN icinga_hostgroup_members AS sub_hgm ON sub_hgm.hostgroup_id = sub_hg.hostgroup_id
INNER JOIN icinga_objects AS sub_ho ON sub_hgm.host_object_id = sub_ho.object_id AND sub_ho.is_active = 1 AND sub_ho.objecttype_id = 1 WHERE ((sub_hgo.name1 IN (‘all-down’)) AND sub_hgm.host_object_id = ho.object_id))) ) ORDER BY h.display_name COLLATE latin1_general_ci ASC (Pdo.php:225)
#0 /usr/share/icingaweb2/library/vendor/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array)
#1 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array)
#2 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT h.displa…’, Array)
#3 /usr/share/icingaweb2/modules/idoreports/library/Idoreports/IdoReport.php(190): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select))
#4 /usr/share/icingaweb2/modules/idoreports/library/Idoreports/HostSlaReport.php(85): Icinga\Module\Idoreports\IdoReport->fetchHostSla(Object(Icinga\Module\Reporting\Timerange), Array)
#5 /usr/share/icingaweb2/modules/idoreports/library/Idoreports/IdoReport.php(29): Icinga\Module\Idoreports\HostSlaReport->fetchSla(Object(Icinga\Module\Reporting\Timerange), Array)
#6 /usr/share/icingaweb2/modules/reporting/library/Reporting/Report.php(293): Icinga\Module\Idoreports\IdoReport->getHtml(Object(Icinga\Module\Reporting\Timerange), Array)
#7 /usr/share/icingaweb2/modules/reporting/application/controllers/ReportController.php(42): Icinga\Module\Reporting\Report->toHtml()
#8 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action.php(507): Icinga\Module\Reporting\Controllers\ReportController->indexAction()
#9 /usr/share/php/Icinga/Web/Controller/Dispatcher.php(76): Zend_Controller_Action->dispatch(‘indexAction’)
#10 /usr/share/icingaweb2/library/vendor/Zend/Controller/Front.php(937): Icinga\Web\Controller\Dispatcher->dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response))
#11 /usr/share/php/Icinga/Application/Web.php(300): Zend_Controller_Front->dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response))
#12 /usr/share/php/Icinga/Application/webrouter.php(99): Icinga\Application\Web->dispatch()
#13 /usr/share/icingaweb2/public/index.php(4): require_once(‘/usr/share/php/…’)
#14 {main}
reactbundle 0.7.0
ipl v0.4.0
pdfexport 0.9.1
