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

[Casper Gielen]

Op 02-11-17 om 16:57 schreef 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. 

I just realized that my documentation is not complete, thanks for
pointing that out before it my production environment :)

I changed schema.mysql, patch attached.

The trick is appending "ROW_FORMAT=DYNAMIC" to the table definitions.

In hindsight I think the first lines of this patch, (SET GLOBAL...)
are redundant with the configuration above, but I'm not sure.


-- 
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


-------------- next part --------------
A non-text attachment was scrubbed...
Name: schema.patch
Type: text/x-patch
Size: 1272 bytes
Desc: not available
URL: <http://lists.opendnssec.org/pipermail/opendnssec-user/attachments/20171102/e2071322/attachment.bin>