I have latest icinga2 and web2 running on latest debian 9.4 updated to the
day.
I have graphite running as docker container, i can access it's web ui all
is good, metrics are recorded.
In icingaweb2 graphs dont show anything, no error no nothing.
If i select Graphite from the menu and click either Hosts or Services i
get this
SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION
> 'latin1_general_ci' is not valid for CHARACTER SET 'utf8', query was:
> SELECT so.name1 AS host_name, h.display_name COLLATE latin1_general_ci AS
> host_display_name, so.name2 AS service_description, s.display_name COLLATE
> latin1_general_ci AS service_display_name, ss.check_command AS
> service_check_command, scv_check_command.varvalue AS _service_check_command
> FROM icinga_objects AS so
> INNER JOIN icinga_services AS s ON s.service_object_id = so.object_id AND
> so.is_active = 1 AND so.objecttype_id = 2
> INNER JOIN icinga_hosts AS h ON h.host_object_id = s.host_object_id
> INNER JOIN icinga_hoststatus AS hs ON hs.host_object_id = s.host_object_id
> INNER JOIN icinga_servicestatus AS ss ON ss.service_object_id =
> so.object_id
> LEFT JOIN icinga_customvariablestatus AS scv_check_command ON
> s.service_object_id = scv_check_command.object_id AND
> scv_check_command.varname = 'check_command' COLLATE latin1_general_ci ORDER
> BY s.display_name COLLATE latin1_general_ci ASC LIMIT 25
> ------------------------------
>
> #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(232):
> Zend_Db_Adapter_Abstract->query(String, Array)
> #3 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Abstract.php(744):
> Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select), Array)
> #4 /usr/share/php/Icinga/Data/Db/DbConnection.php(301):
> Zend_Db_Adapter_Abstract->fetchRow(Object(Zend_Db_Select))
> #5 /usr/share/php/Icinga/Data/SimpleQuery.php(579):
> Icinga\Data\Db\DbConnection->fetchRow(Object(Icinga\Module\Monitoring\Backend\Ido\Query\ServicestatusQuery))
> #6 /usr/share/php/Icinga/Data/SimpleQuery.php(455):
> Icinga\Data\SimpleQuery->fetchRow()
> #7
> /usr/share/icingaweb2/modules/monitoring/library/Monitoring/DataView/DataView.php(538):
> Icinga\Data\SimpleQuery->hasResult()
> #8
> zend.view:///usr/share/icingaweb2/modules/graphite/application/views/scripts/list/services.phtml(26):
> Icinga\Module\Monitoring\DataView\DataView->hasResult()
> #9 /usr/share/php/Icinga/Web/View.php(270): include(String)
> #10 /usr/share/icingaweb2/library/vendor/Zend/View/Abstract.php(877):
> Icinga\Web\View->_run(String)
> #11
> /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/Helper/ViewRenderer.php(904):
> Zend_View_Abstract->render(NULL)
> #12
> /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/Helper/ViewRenderer.php(925):
> Zend_Controller_Action_Helper_ViewRenderer->renderScript(String, NULL)
> #13
> /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/Helper/ViewRenderer.php(964):
> Zend_Controller_Action_Helper_ViewRenderer->render()
> #14
> /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/HelperBroker.php(272):
> Zend_Controller_Action_Helper_ViewRenderer->postDispatch()
> #15 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action.php(518):
> Zend_Controller_Action_HelperBroker->notifyPostDispatch()
> #16 /usr/share/php/Icinga/Web/Controller/Dispatcher.php(76):
> Zend_Controller_Action->dispatch(String)
> #17 /usr/share/icingaweb2/library/vendor/Zend/Controller/Front.php(937):
> Icinga\Web\Controller\Dispatcher->dispatch(Object(Icinga\Web\Request),
> Object(Icinga\Web\Response))
> #18 /usr/share/php/Icinga/Application/Web.php(409):
> Zend_Controller_Front->dispatch(Object(Icinga\Web\Request),
> Object(Icinga\Web\Response))
> #19 /usr/share/php/Icinga/Application/webrouter.php(104):
> Icinga\Application\Web->dispatch()
> #20 /usr/share/icingaweb2/public/index.php(4): require_once(String)
> #21 {main}
>
> SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION
> 'latin1_general_ci' is not valid for CHARACTER SET 'utf8'
> ------------------------------
>
> #0 /usr/share/icingaweb2/library/vendor/Zend/Db/Statement/Pdo.php(219):
> PDOStatement->execute(Array)
> #1 /usr/share/icingaweb2/library/vendor/Zend/Db/Statement.php(297):
> Zend_Db_Statement_Pdo->_execute(Array)
> #2 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Abstract.php(470):
> Zend_Db_Statement->execute(Array)
> #3
> /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Pdo/Abstract.php(232):
> Zend_Db_Adapter_Abstract->query(String, Array)
> #4 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Abstract.php(744):
> Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select), Array)
> #5 /usr/share/php/Icinga/Data/Db/DbConnection.php(301):
> Zend_Db_Adapter_Abstract->fetchRow(Object(Zend_Db_Select))
> #6 /usr/share/php/Icinga/Data/SimpleQuery.php(579):
> Icinga\Data\Db\DbConnection->fetchRow(Object(Icinga\Module\Monitoring\Backend\Ido\Query\ServicestatusQuery))
> #7 /usr/share/php/Icinga/Data/SimpleQuery.php(455):
> Icinga\Data\SimpleQuery->fetchRow()
> #8
> /usr/share/icingaweb2/modules/monitoring/library/Monitoring/DataView/DataView.php(538):
> Icinga\Data\SimpleQuery->hasResult()
> #9
> zend.view:///usr/share/icingaweb2/modules/graphite/application/views/scripts/list/services.phtml(26):
> Icinga\Module\Monitoring\DataView\DataView->hasResult()
> #10 /usr/share/php/Icinga/Web/View.php(270): include(String)
> #11 /usr/share/icingaweb2/library/vendor/Zend/View/Abstract.php(877):
> Icinga\Web\View->_run(String)
> #12
> /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/Helper/ViewRenderer.php(904):
> Zend_View_Abstract->render(NULL)
> #13
> /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/Helper/ViewRenderer.php(925):
> Zend_Controller_Action_Helper_ViewRenderer->renderScript(String, NULL)
> #14
> /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/Helper/ViewRenderer.php(964):
> Zend_Controller_Action_Helper_ViewRenderer->render()
> #15
> /usr/share/icingaweb2/library/vendor/Zend/Controller/Action/HelperBroker.php(272):
> Zend_Controller_Action_Helper_ViewRenderer->postDispatch()
> #16 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action.php(518):
> Zend_Controller_Action_HelperBroker->notifyPostDispatch()
> #17 /usr/share/php/Icinga/Web/Controller/Dispatcher.php(76):
> Zend_Controller_Action->dispatch(String)
> #18 /usr/share/icingaweb2/library/vendor/Zend/Controller/Front.php(937):
> Icinga\Web\Controller\Dispatcher->dispatch(Object(Icinga\Web\Request),
> Object(Icinga\Web\Response))
> #19 /usr/share/php/Icinga/Application/Web.php(409):
> Zend_Controller_Front->dispatch(Object(Icinga\Web\Request),
> Object(Icinga\Web\Response))
> #20 /usr/share/php/Icinga/Application/webrouter.php(104):
> Icinga\Application\Web->dispatch()
> #21 /usr/share/icingaweb2/public/index.php(4): require_once(String)
> #22 {main}
>
> I suppose this is why no graphs are rendered.
How do i fix this ?
_______________________________________________
icinga-users mailing list
icinga-users@lists.icinga.org
https://lists.icinga.org/mailman/listinfo/icinga-users
