0000842: Cannot create database anymore on MySQL 5.17 and higher

ID	Project	Category	View Status	Date Submitted	Last Update

0000842	bareos-core	director	public	2017-08-08 14:23	2017-11-28 12:38

Reporter	hostedpower	Assigned To	joergs
Priority	high	Severity	major	Reproducibility	have not tried
Status	closed	Resolution	duplicate
Platform	Linux	OS	Debian	OS Version	8
Product Version	16.2.5

Summary	0000842: Cannot create database anymore on MySQL 5.17 and higher
Description	Script to create database fails on certain tables, result is non working install. Server version: 5.7.19
Steps To Reproduce	/usr/lib/bareos/scripts/make_bareos_tables Making mysql tables ERROR 1071 (42000) at line 388: Specified key was too long; max key length is 255 bytes ERROR 1071 (42000) at line 396: Specified key was too long; max key length is 255 bytes Creation of Bareos MySQL tables succeeded.
Additional Information	https://bugs.mysql.com/bug.php?id=86725 5.7.17 or later - "ADD KEY" to the TEXT columns with over key length, got a warning. (key length is auto resize) - "ADD UNIQUE KEY" to the TEXT columns with over key length, got long key error. 5.7.16 or earlier - "ADD KEY" to the TEXT columns with over key length, is succeeded. (key length is no resize) - "ADD UNIQUE KEY" to the TEXT columns with over key length, is succeeded. (key length is no resize)
Tags	No tags attached.

Date Modified	Username	Field	Change
2017-08-08 14:23	hostedpower	New Issue
2017-11-28 12:35	joergs	Relationship added	duplicate of 0000705
2017-11-28 12:38	joergs	Note Added: 0002826
2017-11-28 12:38	joergs	Status	new => closed
2017-11-28 12:38	joergs	Assigned To	=> joergs
2017-11-28 12:38	joergs	Resolution	open => duplicate

joergs 2017-11-28 12:38 developer ~0002826	Thank you for the information. This problem will be handled by ticket 0000705, as it already contains a patch.