[keycloak-user] Data truncation: Data too long for column 'ID' at row 1

[Corentin Dupont]

I did this, it seems to work:
alter table RESOURCE_SERVER_RESOURCE    modify ID          varchar(255);
alter table RESOURCE_POLICY             modify RESOURCE_ID varchar(255);
alter table RESOURCE_POLICY             modify RESOURCE_ID varchar(255);
alter table RESOURCE_ATTRIBUTE          modify RESOURCE_ID varchar(255);
alter table RESOURCE_SCOPE              modify RESOURCE_ID varchar(255);
alter table RESOURCE_SERVER_PERM_TICKET modify RESOURCE_ID varchar(255);

On Mon, Nov 4, 2019 at 12:11 AM Corentin Dupont <corentin.dupont at gmail.com>
wrote:

> Hi guys,
> I'm creating keycloak protection resources by providing my own ID, in
> order to map my resources easily with my own database. The naming schema
> is: <prefix>-<DB_ID>
> However, I get some errors: Data truncation: Data too long for column 'ID'
> at row 1
>
> The DB_ID can be long, we didn't think to limit it. If I understand,
> Keycloak IDs are limited to 36 characters or something like that? How to
> relax this constraint?
> Thanks
> Corentin
>