Your message dated Mon, 7 Aug 2023 11:56:10 +0200
with message-id <[email protected]>
and subject line Re: [Pkg-nagios-devel] Bug#1043188: icingaweb2 doesn't ship
schema/mysql-upgrades/2.11.0.sql
has caused the Debian Bug report #1043188,
regarding icingaweb2 doesn't ship schema/mysql-upgrades/2.11.0.sql
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
1043188: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1043188
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
On 8/7/23 11:30, Philipp Niemann wrote:
Please include the schema update file in the debian package.
The entire schema directory structure is included in the package.
Upstream moved the files around, which generated some complaints:
https://github.com/Icinga/icingaweb2/pull/4964#issuecomment-1406803872
The file is included in the package:
/usr/share/icingaweb2/schema/mysql-upgrades/2.11.0.sql
Kind Regards,
Bas
--
GPG Key ID: 4096R/6750F10AE88D4AF1
Fingerprint: 8182 DE41 7056 408D 6146 50D1 6750 F10A E88D 4AF1
--- End Message ---
