2023-04-08 11:43:38 2023-04-08 16:43:38,456 INFO [org.keycloak.broker.provider.AbstractIdentityProviderMapper] (main) Registering class org.keycloak.broker.provider.mappersync.ConfigSyncEventListener
2023-04-08 11:43:40 2023-04-08 16:43:40,511 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (main) SQL Error: 1046, SQLState: 3D000
2023-04-08 11:43:40 2023-04-08 16:43:40,511 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (main) No database selected
2023-04-08 11:43:40 2023-04-08 16:43:40,808 INFO [org.infinispan.CLUSTER] (main) ISPN000080: Disconnecting JGroups channel ISPN
2023-04-08 11:43:40 2023-04-08 16:43:40,885 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Failed to start server in (production) mode
2023-04-08 11:43:40 2023-04-08 16:43:40,886 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: org.hibernate.exception.GenericJDBCException: could not extract ResultSet
2023-04-08 11:43:40 2023-04-08 16:43:40,886 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: could not extract ResultSet
2023-04-08 11:43:40 2023-04-08 16:43:40,886 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: No database selected
2023-04-08 11:43:40 2023-04-08 16:43:40,886 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) For more details run the same command passing the ‘–verbose’ option. Also you can use ‘–help’ to see the details about the usage of the particular command
I need help with this error when starting keycloak
Dockerfile:
FROM Quay as builder
Enable health and metrics support
ENV KC_HEALTH_ENABLED=true
ENV KC_METRICS_ENABLED=true
Configure a database vendor
ENV JDBC_MYSQL_VERSION 8.0.34
ENV KC_DB=mysql
WORKDIR /opt/keycloak
for demonstration purposes only, please make sure to use proper certificates in production instead
RUN keytool -genkeypair -storepass password -storetype PKCS12 -keyalg RSA -keysize 2048 -dname “CN=server” -alias server -ext “SAN:c=DNS:localhost,IP:127.0.0.1” -keystore conf/server.keystore
RUN /opt/keycloak/bin/kc.sh build
FROM Quay
COPY --from=builder /opt/keycloak/ /opt/keycloak/
change these values to point to a running postgres instance
ENV KC_DB=mysql
ENV KC_DB_URL=jdbc:mysql://dbkeycloak.cluster-ckr12345.us-east-1.rds.amazonaws.com
ENV KC_DB_USERNAME=keycloak
ENV KC_DB_PASSWORD=12345
ENV KC_DB_SCHEMA=Autenticacion
ENV KC_HOSTNAME=localhost
ENTRYPOINT [“/opt/keycloak/bin/kc.sh”]