This will be fixed in 4.4.0. See https://issues.jboss.org/browse/KEYCLOAK-6411 for details On Tue, Sep 4, 2018 at 6:26 PM java_os <java(a)neposoft.com&gt; wrote: > 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 >