Re: [keycloak-user] KC4.3.0.Final- mariadb db errors on fresh install

Struggled with this fresh install. You get this error on startup: 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 'INT DEFAULT 30 NULL, ADD ALGORITHM VARCHAR(36) DEFAULT 'HmacSHA1' NULL' at line 1 [Failed SQL: ALTER TABLE keycloak.CREDENTIAL ADD COUNTER INT DEFAULT 0 NULL, ADD DIGITS INT DEFAULT 6 NULL, ADD PERIOD INT DEFAULT 30 NULL, ADD ALGORITHM VARCHAR(36) DEFAULT 'HmacSHA1' NULL]^M ====== I ran it in manual mode db upgrade to get the generated .sql, changed the alter on credentials as follows (injecting COLUMN into the sql - weird?) ALTER TABLE keycloak.CREDENTIAL ADD COLUMN COUNTER INT DEFAULT 0 NULL, ADD COLUMN DIGITS INT DEFAULT 6 NULL, ADD COLUMN PERIOD INT DEFAULT 30 NULL, ADD ALGORITHM VARCHAR(36) DEFAULT 'HmacSHA1' NULL; especially before PERIOD when it bailed out. Re-run the sql update - works, able to bring kc up. Really? why ? Anyone gone through this? _______________________________________________ keycloak-user mailing list keycloak-user(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/keycloak-user