[Pkg-nagios-devel] Bug#851671: icinga-web: Mysql error: Specified key was too long; max key length is 767 bytes

[John Lines]

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 at 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