Your message dated Thu, 5 Jul 2018 10:28:35 +0200
with message-id <[email protected]>
and subject line Closing
has caused the Debian Bug report #854984,
regarding otrs2: When upgrading from 3.3 to 5 you get errors if the database
character set is utf8mb4
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.)
--
854984: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=854984
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: otrs2
Version: 3.3.9-3
Severity: normal
Dear Maintainer,
I included jessie-backports non-free to update otrs2 to version 5.
The database upgrade aborts with this error:
> Specified key was too long; max key length is 767 bytes
This happens if the character set of the database is utf8mb4.
The bug is already known here:
> https://bugs.otrs.org/show_bug.cgi?id=12361
This happens when the upgrade script tries to create the
table cloud_service_config with UNIQUE INDEX cloud_service_config_name (name)
and name is defined as name VARCHAR (200) NOT NULL.
The otrs perl upgrade script afterwards wants to change the database to utf8,
but then it's already too late.
The Debian updater should check if the database is set to utf8mb4 before
starting
the upgrade and abort with an error.
-- System Information:
Debian Release: 8.6
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 3.16.0-4-amd64 (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages otrs2 depends on:
ii adduser 3.113+nmu3
ii apache2 [httpd-cgi] 2.4.10-10+deb8u7
ii apache2-mpm-worker [httpd-cgi] 2.4.10-10+deb8u7
ii dbconfig-common 1.8.47+nmu3+deb8u1
ii debconf [debconf-2.0] 1.5.56
ii fonts-font-awesome 4.2.0~dfsg-1
ii libapache-dbi-perl 1.12-1
ii libapache2-reload-perl 0.12-3
ii libauthen-sasl-perl 2.1600-1
ii libcrypt-passwdmd5-perl 1.3-10
ii libcss-minifier-perl 0.01-1
ii libdate-pcalc-perl 6.1-4
ii libdbd-mysql-perl 4.028-2+deb8u2
ii libdbd-pg-perl 3.4.2-1
ii libdbi-perl 1.631-3+b1
ii libemail-valid-perl 1.195-1
ii libgd-graph-perl 1.48-2
ii libgd-text-perl 0.86-9
ii libio-interactive-perl 0.0.6-1
ii libio-stringy-perl 2.110-5
ii libjavascript-minifier-perl 1.11-1
ii libjs-jquery-ui 1.10.1+dfsg-1
ii libjson-perl 2.61-1
ii liblinux-distribution-perl 0.21-1
ii libmail-imapclient-perl 3.35-1
ii libmail-pop3client-perl 2.18-1
ii libmailtools-perl 2.13-1
ii libmime-tools-perl 5.505-1
ii libnet-imap-simple-perl 1.2205-1
ii libnet-imap-simple-ssl-perl 1.3-3
ii libnet-smtp-ssl-perl 1.01-3
ii libnet-sslglue-perl 1.052-1
ii libpdf-api2-perl 2.023-1
ii libproc-daemon-perl 0.14-2
ii libsoap-lite-perl 1.11-1
ii libsys-hostname-long-perl 1.4-3
ii libtext-csv-perl 1.32-1
ii libtext-diff-perl 1.41-1
ii libxml-feedpp-perl 0.43-1
ii libxml-parser-lite-perl 0.720-1
ii libxml-parser-perl 2.41-3
ii libyaml-libyaml-perl 0.41-6
ii libyaml-perl 1.13-1
ii perl [libdigest-sha-perl] 5.20.2-3+deb8u6
ii ttf-dejavu-core 2.34-1
ii ttf-dejavu-extra 2.34-1
ii ucf 3.0030
Versions of packages otrs2 recommends:
ii ispell 3.3.02-6
ii libcrypt-eksblowfish-perl 0.009-1+b2
ii libencode-hanextra-perl 0.23-3+b1
ii libjson-xs-perl 2.340-1+b2
ii libtext-csv-xs-perl 1.11-2
ii mysql-server 5.5.53-0+deb8u1
ii procmail 3.22-24
Versions of packages otrs2 suggests:
ii libnet-ldap-perl 1:0.6400+dfsg-2
pn libnet-smtp-tls-butmaintained-perl <none>
pn otrs2-doc-en | otrs2-doc-de <none>
-- Configuration Files:
/etc/apache2/conf-available/otrs2.conf changed [not included]
-- debconf information excluded
--- End Message ---
--- Begin Message ---
tag #854984 + wontfix
thanks
Closing. utf8mb4 is not supported
--
/*
Mit freundlichem Gruß / With kind regards,
Patrick Matthäi
GNU/Linux Debian Developer
Blog: http://www.linux-dev.org/
E-Mail: [email protected]
[email protected]
*/
--- End Message ---
