Unable to access Keycloak 18.0.2 embedded h2 db file

Question

I am trying to access keycloak\data\h2\keycloakdb.mv using DBeaver. I am getting Wrong username or password.Any help on this is so much appreciated

I tried

Username:sa Password:

Username:sa Password:sa

Username:keycloak Password:

Username:keycloak Password:keycloak

Answer 1

If anyone comes looking. The dev mode credentials for the embedded db can be found in the DatabasePropertyMappers class.

For now it seems to be:

username: sa
password: password

https://github.com/keycloak/keycloak/blob/f0988a62b8f5ca211bf4aaab4f5aa11120115451/quarkus/runtime/src/main/java/org/keycloak/quarkus/runtime/configuration/mappers/DatabasePropertyMappers.java

private static Optional<String> resolveUsername(Optional<String> value, ConfigSourceInterceptorContext context) {
    if (isDevModeDatabase(context)) {
        return of("sa");
    }
    
    return Database.getDatabaseKind(value.get()).isEmpty() ? value : null;
}
    
private static Optional<String> resolvePassword(Optional<String> value, ConfigSourceInterceptorContext context) {
    if (isDevModeDatabase(context)) {
        return of("password");
    }
    
    return Database.getDatabaseKind(value.get()).isEmpty() ? value : null;
}