Either you have to adjust your database settings to utf8 or adjust your query settings to match whatever you have set in the database.Some applications expect uft8 by default, but I noticed that MariaDB comes with latin1 settings by default.
Thake a look into this forum https://github.com/Icinga/icinga2/issues/5412 Regards Regards. 2018-05-10 12:10 GMT-06:00 Nimigean Horatiu <seccentr...@gmail.com>: > 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 > > -- *Alvaro Cordero RetanaConsultor de Tecnologias* *Tel: 22585757 ext 123* *Email:* alv...@gridshield.net
_______________________________________________ icinga-users mailing list icinga-users@lists.icinga.org https://lists.icinga.org/mailman/listinfo/icinga-users
