Hello Group, I am new to keycloak and just following steps mentioned in the configuration to setup with mysql. I am using keycloak v 20.0.3 and mysql v 15.1
bin/kc.sh build --db=mysql - works fine
bin/kc.sh start-dev --db mysql --db-url-host 127.0.0.1 --db-username keycloak --db-password xxxx - Generates following error
2023-02-03 08:47:30,434 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: liquibase.exception.MigrationFailedException: Migration failed for change set META-INF/jpa-changelog-1.2.0.Beta1.xml::1.2.0.Beta1::psilva@redhat.com:
Reason: liquibase.exception.DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ’ NAME VARCHAR(255) NOT NULL)’ at line 1 [Failed SQL: (1064) CREATE TABLE PROTOCOL_MAPPER_CONFIG (PROTOCOL_MAPPER_ID VARCHAR(36) NOT NULL, VALUE CLOB, NAME VARCHAR(255) NOT NULL)]
Can anybody help me?