Update icingaweb2 2.8 to 2.9 Error SQLSTATE in User Sessions

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

I’d the same problem. MySQL Query Error after upgrading to 2.9.0 - #3 by TheCry

This should help you
Regards
Sascha

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

image

@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}

Ouch, that’s an unintended incompatibility with PHP < 7.1. Please open an issue over at Github.

@nilmerg Indeed, I will migrate my master server to a new one with debian 10 and php 8