xseth
(might)
1
Hi,
I have this error now I don’t know if I’m still missing an dependencies? What do you think about it?
SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: ‘’
#0 [internal function]: PDO->exec(String)
#1 /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php(82): call_user_func_array(Array, Array)
#2 /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php(164): ipl\Sql\Connection->__call(String, Array)
#3 /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php(399): ipl\Sql\Connection->connect()
#4 /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php(418): ipl\Sql\Connection->prepexec(String, Array)
#5 /usr/share/php/Icinga/Web/RememberMe.php(301): ipl\Sql\Connection->select(Object(ipl\Sql\Select))
#6 /usr/share/icingaweb2/application/controllers/ManageUserDevicesController.php(42): Icinga\Web\RememberMe::getAllUser()
#7 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action.php(507): Icinga\Controllers\ManageUserDevicesController->indexAction()
#8 /usr/share/php/Icinga/Web/Controller/Dispatcher.php(76): Zend_Controller_Action->dispatch(String)
#9 /usr/share/icingaweb2/library/vendor/Zend/Controller/Front.php(937): Icinga\Web\Controller\Dispatcher->dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response))
#10 /usr/share/php/Icinga/Application/Web.php(304): Zend_Controller_Front->dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response))
#11 /usr/share/php/Icinga/Application/webrouter.php(107): Icinga\Application\Web->dispatch()
#12 /usr/share/icingaweb2/public/index.php(4): require_once(String)
#13 {main}
- Icinga Web 2 version 2.9
- Used modules and their versions (System - About)
- Web browser used Brave
- Icinga 2 version used (
icinga2 --version
) r2.12.5-1
- PHP version used (
php --version
) 7.0
- Server operating system and version Debian 9
TheCry
(Sascha Bay)
2
I’d the same problem. MySQL Query Error after upgrading to 2.9.0 - #3 by TheCry
This should help you
Regards
Sascha
BarbUk
(BarbUk)
3
Edit /etc/icingaweb2/resources.ini and change for your icingaweb_db ressource:
charset = ""
to
charset = "utf8"
You can also edit from icingaweb interface: https://icinga.url/config/resource#!/config/editresource?resource=icingaweb_db
xseth
(might)
4
@BarbUk thank you for your reply I don’t have this error anymore.
However, if I want to check stay logged I get this error:
I added the icingaweb_rememberme table in my icinga_users database and granted privileges…
openssl_encrypt() expects at most 5 parameters, 6 given
#0 [internal function]: Icinga\Application\ApplicationBootstrap->Icinga\Application{closure}(Integer, String, String, Integer, Array)
#1 /usr/share/php/Icinga/Crypt/AesCrypt.php(198): openssl_encrypt(String, String, String, Integer, String, NULL)
#2 /usr/share/php/Icinga/Crypt/AesCrypt.php(218): Icinga\Crypt\AesCrypt->encrypt(String)
#3 /usr/share/php/Icinga/Web/RememberMe.php(114): Icinga\Crypt\AesCrypt->encryptToBase64(String)
#4 /usr/share/icingaweb2/application/forms/Authentication/LoginForm.php(140): Icinga\Web\RememberMe::fromCredentials(String, String)
#5 /usr/share/php/Icinga/Web/Form.php(1178): Icinga\Forms\Authentication\LoginForm->onSuccess()
#6 /usr/share/icingaweb2/application/controllers/AuthenticationController.php(83): Icinga\Web\Form->handleRequest()
#7 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action.php(507): Icinga\Controllers\AuthenticationController->loginAction()
#8 /usr/share/php/Icinga/Web/Controller/Dispatcher.php(76): Zend_Controller_Action->dispatch(String)
#9 /usr/share/icingaweb2/library/vendor/Zend/Controller/Front.php(937): Icinga\Web\Controller\Dispatcher->dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response))
#10 /usr/share/php/Icinga/Application/Web.php(304): Zend_Controller_Front->dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response))
#11 /usr/share/php/Icinga/Application/webrouter.php(107): Icinga\Application\Web->dispatch()
#12 /usr/share/icingaweb2/public/index.php(4): require_once(String)
#13 {main}
nilmerg
(Johannes Meyer)
5
Ouch, that’s an unintended incompatibility with PHP < 7.1. Please open an issue over at Github.
xseth
(might)
6
@nilmerg Indeed, I will migrate my master server to a new one with debian 10 and php 8