Package: pdns-backend-mysql Version: 3.0-1.1 Severity: normal Tags: sid wheezy patch
MySQL database uprgrade script fails with "ERROR 1071 (42000) at line 30: Specified key was too long; max key length is 1000 bytes" while running "create unique index namealgoindex on tsigkeys(name, algorithm);" if the database uses unicode collation (server-wide default of utf8_general_ci). The reason being two varchar(255) columns being used as the key (apparently resulting in 2*2*255=1020 bytes for the key. The problem can be fixed by specifying a single byte encoding, like: create table tsigkeys ( id INT auto_increment, name VARCHAR(255), algorithm VARCHAR(255), secret VARCHAR(255), primary key(id) ) COLLATE = ascii_bin; I'm not sure what the ideal encoding would be though, or if the size of the columns could/should be changed. -- Micu -- System Information: Debian Release: 6.0.4 APT prefers stable APT policy: (990, 'stable'), (600, 'stable-updates'), (500, 'oldstable'), (100, 'testing'), (2, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.6.32.16domU-32 (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/bash Versions of packages pdns-backend-mysql depends on: ii dbconfig-common 1.8.46+squeeze.0 common framework for packaging dat ii debconf [debconf-2.0] 1.5.36.1 Debian configuration management sy ii libc6 2.11.3-2 Embedded GNU C Library: Shared lib ii libgcc1 1:4.4.5-8 GCC support library ii libmysqlclient16 5.1.49-3 MySQL database client library ii libstdc++6 4.4.5-8 The GNU Standard C++ Library v3 ii pdns-server 3.0-1.1 extremely powerful and versatile n ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime Versions of packages pdns-backend-mysql recommends: ii mysql-client-5.1 [mysql-clien 5.1.49-3 MySQL database client binaries Versions of packages pdns-backend-mysql suggests: ii mysql-server 5.1.49-3 MySQL database server (metapackage ii mysql-server-5.1 [mysql-serve 5.1.49-3 MySQL database server binaries and -- debconf information excluded -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org