[keycloak-user] Internal server error with event logging

[Matthias Kesternich]

Hello Stian,

thanks for your help.

I temporarily increased the size of the database column for the event details. When looking in there I found a few redirect uris that were too long. The whole event details field was consuming ~3800 bytes. I convinced the application developers to use shorter redirect uris to fix the issue. This works for now.

If somebody exceeds the limit I will get a 500 again of course.

Best,
-Matthias

Von: Stian Thorgersen <sthorger at redhat.com>
Antworten an: "stian at redhat.com" <stian at redhat.com>
Datum: Donnerstag, 16. August 2018 um 17:20
An: Matthias Kesternich <matthias.kesternich at moneymeets.com>
Cc: keycloak-user <keycloak-user at lists.jboss.org>
Betreff: Re: [keycloak-user] Internal server error with event logging

Seems like something is putting to much information in the details of the events. It should be short and concise to prevent filling up the database. Do you know what event it is and how to reproduce?

On Thu, 16 Aug 2018 at 14:30, Matthias Kesternich <matthias.kesternich at moneymeets.com<mailto:matthias.kesternich at moneymeets.com>> wrote:
Hello,

with event detail logging enabled I keep getting 500 Internal Server Error. There was also a post on this list in May detailing the same problem (see http://lists.jboss.org/pipermail/keycloak-dev/2018-May/010807.html ).

As outlined in the post the problematic piece of code is

    @Column(name="DETAILS_JSON", length = 2550)
    private String detailsJson;

This hardcodes length to 2550 and apparently some of my event details get bigger than that.

Any idea what I can do about this? Manually changing the database column could work, but I’m afraid a future  keycloak db migration will badly interfere with this.

Is there any “official” way to override values like this? E.g. some configuration setting or JPA way to overwrite this?

Thanks,
-Matthias
_______________________________________________
keycloak-user mailing list
keycloak-user at lists.jboss.org<mailto:keycloak-user at lists.jboss.org>
https://lists.jboss.org/mailman/listinfo/keycloak-user