I'm trying to setup a new Unimus installation using mariadb (10.1.37 on Debian). I've created a database and a user like this:
Code: Select all
create database unimus;
create user 'unimus'@'localhost';
grant all privileges on unimus.* to 'unimus'@'localhost' identified by 'somepassword';
Code: Select all
2019-02-20 15:17:50.036 ERROR 11311 --- [cTaskExecutor-2] liquibase : classpath:/db/changelog/mysql/db.changelog-master-mysql.xml: classpath:/db/changelog/mysql/db.changelog-0.3.0-mysql.xml::1487083811541-31::jozef (generated): Change Set classpath:/db/changelog/mysql/db.changelog-0.3.0-mysql.xml::1487083811541-31::jozef (generated) failed. Error: Specified key was too long; max key length is 767 bytes [Failed SQL: ALTER TABLE unimus.system_account ADD CONSTRAINT UK_1grra4lqs8iomichvxoa2ybt8 UNIQUE (username)]
2019-02-20 15:17:50.083 WARN 11311 --- [cTaskExecutor-2] n.u.s.b.wizard.step.DatabaseUpdate : Failed to connect and create / update database. Reason = liquibase.exception.MigrationFailedException: Migration failed for change set classpath:/db/changelog/mysql/db.changelog-0.3.0-mysql.xml::1487083811541-31::jozef (generated):
Reason: liquibase.exception.DatabaseException: Specified key was too long; max key length is 767 bytes [Failed SQL: ALTER TABLE unimus.system_account ADD CONSTRAINT UK_1grra4lqs8iomichvxoa2ybt8 UNIQUE (username)]
2019-02-20 15:17:50.083 WARN 11311 --- [cTaskExecutor-2] n.unimus.system.bootstrap.wizard.Wizard : Wizard failed. Reason = liquibase.exception.MigrationFailedException: Migration failed for change set classpath:/db/changelog/mysql/db.changelog-0.3.0-mysql.xml::1487083811541-31::jozef (generated):
Reason: liquibase.exception.DatabaseException: Specified key was too long; max key length is 767 bytes [Failed SQL: ALTER TABLE unimus.system_account ADD CONSTRAINT UK_1grra4lqs8iomichvxoa2ybt8 UNIQUE (username)]. Wizard{running=true, finished=false, failed=true}
Thanks a lot,
Hendrik