[Opendnssec-user] upgrade debian Jessie to Stretch: database trouble

[Dennis Baaten]

Yes same here. Tried this already.

In /etc/mysql/mariadb.conf.d/50-server.cnf:

[mysqld]
innodb_file_format = Barracuda
innodb_large_prefix = on

Check variables with phpMyAdmin, and they are set correctly. 

Next: mysqladmin --defaults-file=/etc/mysql/debian.cnf create odsnew
Result: new database

Next: mysql --defaults-file=/etc/mysql/debian.cnf odsnew < /usr/share/opendnssec/schema.mysql
Result: ERROR 1709 (HY000) at line 50: Index column size too large. The maximum column size is 767 bytes.
The index column size...

I've installed opendnssec 2.1.3 from testing (rest is still from stable) and I'm using this schema. Seems to be the same as the one from 2.0.

-- 
Dennis

-----Oorspronkelijk bericht-----
Van: Casper Gielen [mailto:C.Gielen at uvt.nl] 
Verzonden: donderdag 2 november 2017 16:34
Aan: opendnssec-user at lists.opendnssec.org
CC: Dennis Baaten <dennis at baaten.com>
Onderwerp: Re: [Opendnssec-user] upgrade debian Jessie to Stretch: database trouble

Op 02-11-17 om 16:00 schreef Dennis Baaten:
> Thanks for the info! This is helpful. Still getting the error when 
> trying to load the new DB scheme (step 3). This probably is related to 
> the fact that I'm having trouble to explicitly create a database using 
> Barracuda with ROW_FORMAT=DYNAMIC.

That's done with innodb_large_prefix. Put the following in your config:

[mysqld]
innodb_large_prefix = on
innodb_file_format = Barracuda


PS. I'm on MariaDB, not MySQL, but you probably are as well so it shouldn't matter.
--
Casper Gielen <cgielen at uvt.nl> | LIS UNIX PGP fingerprint = 16BD 2C9F 8156 C242 F981  63B8 2214 083C F80E 4AF7

Universiteit van Tilburg | Postbus 90153, 5000 LE Warandelaan 2 | Telefoon 013 466 4100 | G 236 | http://www.uvt.nl