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:[email protected]] Verzonden: donderdag 2 november 2017 16:34 Aan: [email protected] CC: Dennis Baaten <[email protected]> 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 <[email protected]> | 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 _______________________________________________ Opendnssec-user mailing list [email protected] https://lists.opendnssec.org/mailman/listinfo/opendnssec-user
