mysql setup problem

Unimus support forum
Post Reply
hoeth
Posts: 2
Joined: Wed Feb 20, 2019 3:27 pm

Wed Feb 20, 2019 3:53 pm

Hi!

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';
Then the Unimus configuration wizard fails with the following messages:

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}
Any idea what's going on here? I'm a mysql illiterate, so probably I've missed something obvious.

Thanks a lot,

Hendrik
hoeth
Posts: 2
Joined: Wed Feb 20, 2019 3:27 pm

Thu Mar 14, 2019 10:54 am

I'm now using postgresql.
Post Reply