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

[Markus Frosch]

Control: forwarded -1 https://github.com/Icinga/icinga-web/issues/1382

On 17.01.2017 14:09, John Lines wrote:
> 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

Thanks for the report, I think the explicit character set would be the best solution.

Testing pending.

Cheers
Markus Frosch
-- 
markus at lazyfrosch.de / lazyfrosch at debian.org
http://www.lazyfrosch.de