I’m trying to install Keycloak in docker with an external MySQL database (hosted on a shared webspace provider).
When trying to execute
docker run ^ -p 8080:8080 ^ -e KEYCLOAK_USER=admin ^ -e KEYCLOAK_PASSWORD=admin ^ -e DB_VENDOR=mysql ^ -e DB_ADDR=<myhost.de> ^ -e DB_DATABASE=<DB> ^ -e DB_USER=<USER> ^ -e DB_PASSWORD=<PASSWORD> ^ -e JDBC_PARAMS="useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Europe/Berlin" ^ --name keycloak ^ quay.io/keycloak/keycloak:13.0.1
I get an error:
Error: Specified key was too long; max key length is 1000 bytes [Failed SQL: ALTER TABLE d036bf1a.REALM_SOCIAL_CONFIG ADD PRIMARY KEY (REALM_ID, NAME)]
I found out that this might be due to restrictions of the MyISAM engine. I have no chance to change the default-engine of the database as my provider restricts this.
My question is if there is a chance to tell Keycloak (or the liquibase files) to install the tables with the INNODB engine as I hope that this will solve my problem.
Or is there another chance to solve this error?
Thanks in Advance,