Your message dated Tue, 18 Apr 2023 11:43:17 +0200
with message-id <eec3d456-f624-f627-6d2b-9b515e85c...@debian.org>
and subject line icinga-web has been removed from Debian
has caused the Debian Bug report #851671,
regarding icinga-web: Mysql error: Specified key was too long; max key length
is 767 bytes
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 ow...@bugs.debian.org
immediately.)
--
851671: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=851671
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: icinga-web
Version: 1.13.1-2
Severity: normal
Dear Maintainer,
*** Reporter, please consider answering these questions, where appropriate ***
On installing icinga-web, with default-mysql-server already freshly
installed I receive the message
mysql said: ERROR 1071 (42000) at line 18: Specified key was too long;
max key length is 767 bytes
The problem would appear to be in line 18 of
/usr/share/dbconfig-common/data/icinga-web/install/mysql
which attempts to create the nsm_session table.
With the default UTF encoding it seems varchar(255) is larger than
session_id is allowed to be.
I have worked around it by specifying varchar(125)
A dpkg-reconfigure icinga-web then succeeded
-- System Information:
Debian Release: stretch/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: armel (armv5tel)
Kernel: Linux 4.8.0-2-marvell
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages icinga-web depends on:
ii dbconfig-common 2.0.7
ii debconf [debconf-2.0] 1.5.59
ii php 1:7.0+49
ii php-gd 1:7.0+49
ii php-mysql 1:7.0+49
ii php7.0 [php] 7.0.14-2
ii php7.0-cli [php-cli] 7.0.14-2
ii php7.0-gd [php-gd] 7.0.14-2
ii php7.0-json [php-json] 7.0.14-2
ii php7.0-xml [php-xsl] 7.0.14-2
ii ucf 3.0036
Versions of packages icinga-web recommends:
ii apache2 [httpd] 2.4.25-1
pn mysql-client | postgresql-client <none>
Versions of packages icinga-web suggests:
pn icinga-doc <none>
ii icinga-web-config-icinga2-ido-mysql 1.13.1-2
pn nagios-images <none>
-- Configuration Files:
/etc/icinga-web/conf.d/access.xml [Errno 13] Permission denied:
'/etc/icinga-web/conf.d/access.xml'
/etc/icinga-web/conf.d/auth.xml [Errno 13] Permission denied:
'/etc/icinga-web/conf.d/auth.xml'
/etc/icinga-web/conf.d/databases.xml [Errno 13] Permission denied:
'/etc/icinga-web/conf.d/databases.xml'
/etc/icinga-web/conf.d/module_reporting.xml [Errno 13] Permission denied:
'/etc/icinga-web/conf.d/module_reporting.xml'
-- debconf information:
icinga-web/remove-error: abort
* icinga-web/dbconfig-reinstall: true
* icinga-web/dbconfig-install: true
icinga-web/internal/skip-preseed: false
icinga-web/remote/newhost:
* icinga-web/mysql/method: Unix socket
icinga-web/remote/port:
* icinga-web/db/dbname: icinga_web
* icinga-web/passwords-do-not-match:
* icinga-web/db/app-user: icinga_web@localhost
* icinga-web/database-type: mysql
* icinga-web/install-error: ignore
* icinga-web/rootpassword-mismatch:
* icinga-web/mysql/admin-user: root
icinga-web/upgrade-error: abort
icinga-web/missing-db-package-error: abort
icinga-web/purge: false
icinga-web/dbconfig-remove: true
icinga-web/remote/host: localhost
icinga-web/upgrade-backup: true
icinga-web/dbconfig-upgrade: true
icinga-web/internal/reconfiguring: false
--- End Message ---
--- Begin Message ---
Version: 1.13.1-2.1+rm
icinga-web was last released with Debian 8 (jessie) in April 2015
and was removed from the Debian archive afterwards.
I'm closing the remaining bug reports now.
Andreas
--- End Message ---