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

[java_os]

Thanks
> 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
>>
>