[Pkg-nagios-devel] Bug#1043188: icingaweb2 doesn't ship schema/mysql-upgrades/2.11.0.sql

[Philipp Niemann]

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