Package: icingaweb2
Version: 2.11.4-2
Severity: normal
Dear Maintainer,
after upgrading buckwheat to bookworm and thus upgrading icingaweb2, I
tried the "Remember Me" check box on the login screen of the icingaweb2
Webpage.
I could login as expected. After waiting some time (several hours), the
login is no longer possible. I get an error message:
SQLSTATE[42S02]: Base table or view not found: 1146 Table
'icinga2.icingaweb_rememberme' doesn't exist
#0 /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php(401):
PDO->prepare()
#1 /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php(489):
ipl\Sql\Connection->prepexec()
#2 /usr/share/php/Icinga/Web/RememberMe.php(292): ipl\Sql\Connection->delete()
#3 /usr/share/php/Icinga/Web/RememberMe.php(84): Icinga\Web\RememberMe->remove()
#4
/usr/share/icingaweb2/application/controllers/AuthenticationController.php(63):
Icinga\Web\RememberMe::forget()
#5 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action.php(507):
Icinga\Controllers\AuthenticationController->loginAction()
#6 /usr/share/php/Icinga/Web/Controller/Dispatcher.php(76):
Zend_Controller_Action->dispatch()
#7 /usr/share/icingaweb2/library/vendor/Zend/Controller/Front.php(937):
Icinga\Web\Controller\Dispatcher->dispatch()
#8 /usr/share/php/Icinga/Application/Web.php(290):
Zend_Controller_Front->dispatch()
#9 /usr/share/php/Icinga/Application/webrouter.php(105):
Icinga\Application\Web->dispatch()
#10 /usr/share/icingaweb2/public/index.php(4): require_once(String)
#11 {main}
When digging into that error I find, that the schema update to
icingaweb2 database was not in the package (and was not done
automagically with the upgrade). I looked in
/usr/share/icingaweb2/schema/mysql-upgrades/
There I expected the file 2.11.0.sql, which can be found in the source
package of icingaweb2.
Please include the schema update file in the debian package.
Kind regards,
Philipp
-- System Information:
Debian Release: 12.1
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 6.1.0-10-amd64 (SMP w/6 CPU threads; PREEMPT)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages icingaweb2 depends on:
ii fonts-dejavu-core 2.37-6
ii fonts-dejavu-extra 2.37-6
ii icingaweb2-common 2.11.4-2
ii php-xml 2:8.2+93
ii php8.2-xml [php-xml] 8.2.7-1~deb12u1
Versions of packages icingaweb2 recommends:
ii apache2 [httpd] 2.4.57-2
ii icingacli 2.11.4-2
ii icingaweb2-module-doc 2.11.4-2
ii icingaweb2-module-monitoring 2.11.4-2
ii libapache2-mod-php8.2 [php-json] 8.2.7-1~deb12u1
ii nagios-images 0.9.5
ii php 2:8.2+93
pn php-cli <none>
ii php-curl 2:8.2+93
ii php-gd 2:8.2+93
ii php-imagick 3.7.0-4
ii php-intl 2:8.2+93
ii php-json 2:8.2+93
pn php-ldap <none>
ii php-mbstring 2:8.2+93
ii php8.2 [php] 8.2.7-1~deb12u1
ii php8.2-cli [php-json] 8.2.7-1~deb12u1
ii php8.2-curl [php-curl] 8.2.7-1~deb12u1
ii php8.2-gd [php-gd] 8.2.7-1~deb12u1
ii php8.2-imagick [php-imagick] 3.7.0-4
ii php8.2-intl [php-intl] 8.2.7-1~deb12u1
ii php8.2-mbstring [php-mbstring] 8.2.7-1~deb12u1
ii php8.2-phpdbg [php-json] 8.2.7-1~deb12u1
ii php8.2-xml [php-dom] 8.2.7-1~deb12u1
icingaweb2 suggests no packages.
-- no debconf information
