The upstream fix (SVN revision 2400) is to reduce the column size for 'algorithm' to 50.
Kind regards, Peter van Dijk On Mar 7, 2012, at 12:48 , Michael Wikberg wrote: > 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
