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
