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

[Hynek Mlnarik]

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 at neposoft.com> 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 at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user
>