[keycloak-user] keycloak-user Digest, Vol 58, Issue 8
Ewan
spam at kukrilabs.com
Thu Oct 4 03:01:54 EDT 2018
Hi Christoph,
Some (hopefully) useful clarifications and explanations for you:
* The syntax `${env.DB_ADDR:mysql}` will look for the environment variable `DB_ADDR` falling back to `mysql` if this is not set
* Services in Openshift have their own internal DNS of the format `<service>.<pod_namespace>.svc.cluster.local` with `.<pod_namespace>.svc.cluster.local` being a default search domain inside the container. Therefore, using the the default `mysql` from the above, if you have a service called `mysql` and no DB_ADDR set this should not be a problem.
* Judging by the actual error `Caused by: java.lang.NumberFormatException: For input string: “tcp:` I would suggest that one environment variable is causing conflict by prepending with `tcp:`
* I see a warning `WARNING: MYSQL_PORT variable name is DEPRECATED replace with DB_PORT` in your startup log and the corresponding value `MYSQL_PORT=tcp://172.30.228.24:3306` in your environment variables. I believe this is causing a problem.
* Digging into the startup script, I think I have seen the issue which comes from this section in the docker entry point: https://github.com/jboss-dockerfiles/keycloak/blob/master/server/tools/docker-entrypoint.sh#L109
* Because the service is called `mysql` which creates an environment variable `MYSQL_PORT` this is being automatically detected and updated to be DB_PORT. Unfortunately this then contains the `tcp:` and is invalid.
* My suggestion to you is the following:
* Create a new namespace/project in Openshift (to avoid any naming conflicts)
* Deploy the MySQL template into the new namespace with the name “keycloak-mysql” (change this from the default `mysql` to avoid the environment renaming mentioned above. We will set a value in the deployment config) and database `keycloak`
* Deploy the `jboss/keycloak-openshift` image into the container with name `keycloak`
* Update the `keycloak` deployment config and add the environment variables `DB_VENDOR=mysql DB_ADDR=keycloak-mysql` and set the `DB_USER` and `DB_PASSWORD` values to the generated secret variables to have these maintained in a single place.
Hopefully some of the above will help you progress a little.
A useful tip if you are not aware: If you are trying to debug a pod or deployment in Openshift that fails on startup, use `oc debug dc/{{ name_of_deploymentconfig }}` from your command line to start a throwaway container that will not run the entry point script. You can then check some things and try running the startup script yourself (it tells you what command it would have run when you first run the debug command).
Happy Hacking
Ewan
On Thu, Oct 4, 2018, at 1:28 AM, keycloak-user-request at lists.jboss.org wrote:
> Send keycloak-user mailing list submissions to
> keycloak-user at lists.jboss.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.jboss.org/mailman/listinfo/keycloak-user
> or, via email, send a message with subject or body 'help' to
> keycloak-user-request at lists.jboss.org
>
> You can reach the person managing the list at
> keycloak-user-owner at lists.jboss.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of keycloak-user digest..."
>
>
> Today's Topics:
>
> 1. Deploying Keycloak with a Mysql database in Openshift Origin
> fails (Christoph John)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 4 Oct 2018 01:22:04 +0200
> From: Christoph John <christoph_john at gmx.de>
> Subject: [keycloak-user] Deploying Keycloak with a Mysql database in
> Openshift Origin fails
> To: keycloak-user at lists.jboss.org
> Message-ID: <CB883140-F030-41B6-8568-11EE092BCD21 at gmx.de>
> Content-Type: text/plain; charset=utf-8
>
> Hello together,
> I am trying to get keycloak up and running with a mysql database in
> Openshift Origin (3.10) without success. As I have no idea anymore what
> could go wrong, I hope someone on the list can give me a helpful hint.
> So far I tried the following:
>
> -The template from keycloak/openshift-examples/keycloak-https.json.
> Unfortunately, it does not work for me. To my understanding, when the
> keycloak pod is deployed, it does not find the mysql database and
> therefore fails, see attached log file. Unfortunately, I am quite new to
> openshift and have not understood yet, how the service discovery in
> Openshift works. When attaching a bash to the deployed keycloak pod, I
> can find the correct IP address of the mysql database service, for
> example in MYSQL_PORT=tcp://172.30.228.24:3306
> <tcp://172.30.228.24:3306> . I have attached the full list of
> environment variables as well.
>
> I also had a look into the keycloak sources. Under keycloak/server/
> tools/cli/databases/mysql/change-database.cl I have found the following
> line:
>
> /subsystem=datasources/data-source=KeycloakDS: add(jndi-
> name=java:jboss/datasources/KeycloakDS,enabled=true,use-java-context=true,use-ccm=true,
> connection-url=jdbc:mysql://${env.DB_ADDR:mysql}:${env.DB_PORT:3306}/$
> {env.DB_DATABASE:keycloak}${env.JDBC_PARAMS:}, driver-name=mysql)
>
> But I have not understood yet from where the variable $
> {env.DB_ADDR:mysql} should come. At least I do not find a DB_ADDR field
> in my environment.
>
> - My second attempt was therefore to use the container "jboss/keycloak-
> openshift? from Dockerhub with Docker directly, in the hope to get more
> reasonable debugging information from the docker logs. For the mysql
> container I used the same container like is deployed from the mysql 5.7
> template in Openshift. In both of the previous setups I manually
> configured a keyclock database scheme and granted privileges to the
> relevant user. With the following command line I got keycloak up and
> running smoothly.
>
> docker run -d --name keycloak --net keycloak-network -e
> KEYCLOAK_USER=user -e KEYCLOAK_PASSWORD=pwd -e DB_VENDOR=MYSQL -e
> DB_ADDR=mysql -e DB_DATABASE=keycloak -e DB_USER=user -e DB_PASSWORD=pwd
> -e JDBC_PARAMS='useSSL=false' -p 8443:8443 jboss/keycloak-openshift
> start-keycloak.sh
>
> I also checked the command line described on GitHub with the ?link
> option mysql:mysql. This does also work.
>
> Back in Openshift I tried to deploy Keycloak manually (Add to Project/
> Deploy Image) and added the same environment variables (different
> variants with and without DB_ADDR) like in the above command line.
> Unfortunately, I still do not get things up and running. Still keycloak
> does not find the database on deployment. I do not know how I have to
> specify the DB_ADDR environment variable correctly or how I have to
> connect keycloak with the mysql service object alternatively. If I bind
> the service via its secret, I do not get a DB_ADDR environment variable
> at all. The closest thing to it is an environment variable called
> uri=mysql://172.30.228.24:3306 <mysql://172.30.228.24:3306>.
>
> Would be great if someone could give me a hint here, what I am doing
> wrong, and how I could get keyclock up and running with a mysql database
> in Openshift Origin?
>
> Thanks a lot for your help.
>
> Best regards,
>
> Christoph
>
> ???????????????????????????
> Environment variables from keycloak pod whose deployment fails
>
>
> JGROUPS_DISCOVERY_PROTOCOL=dns.DNS_PING
> KEYCLOAK_PASSWORD=pwd
> JDBC_MYSQL_VERSION=5.1.46
> HOSTNAME=keycloak-2-6gtkj
> SECURE_KEYCLOAK_SERVICE_PORT=8443
> KUBERNETES_PORT_443_TCP_PORT=443
> KUBERNETES_PORT=tcp://172.30.0.1:443
> TERM=xterm
> SECURE_KEYCLOAK_PORT_8443_TCP=tcp://172.30.25.80:8443
> KEYCLOAK_SERVICE_HOST=172.30.104.119
> LAUNCH_JBOSS_IN_BACKGROUND=1
> KUBERNETES_SERVICE_PORT=443
> KUBERNETES_SERVICE_HOST=172.30.0.1
> KUBERNETES_PORT_53_TCP=tcp://172.30.0.1:53
> JBOSS_HOME=/opt/jboss/keycloak
> JDBC_MARIADB_VERSION=2.2.3
> KUBERNETES_PORT_53_TCP_PORT=53
> KUBERNETES_PORT_53_UDP=udp://172.30.0.1:53
> KUBERNETES_SERVICE_PORT_DNS=53
> KEYCLOAK_PORT=tcp://172.30.104.119:8080
> DB_VENDOR=MYSQL
> MYSQL_PORT_3306_TCP_PORT=3306
> KEYCLOAK_PORT_8080_TCP_PROTO=tcp
> KUBERNETES_PORT_53_TCP_ADDR=172.30.0.1
> MYSQL_PORT_3306_TCP=tcp://172.30.228.24:3306
> PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
> KUBERNETES_PORT_53_UDP_ADDR=172.30.0.1
> _=/usr/bin/env
> PWD=/opt/jboss
> SECURE_KEYCLOAK_SERVICE_HOST=172.30.25.80
> JAVA_HOME=/usr/lib/jvm/java
> JGROUPS_DISCOVERY_PROPERTIES=keycloak.imsproject.svc.cluster.local
> MYSQL_SERVICE_PORT_MYSQL=3306
> LANG=en_US.UTF-8
> KUBERNETES_PORT_53_UDP_PORT=53
> KEYCLOAK_VERSION=4.5.0.Final
> KEYCLOAK_PORT_8080_TCP_PORT=8080
> SECURE_KEYCLOAK_PORT=tcp://172.30.25.80:8443
> JDBC_POSTGRES_VERSION=42.2.2
> HOME=/
> SHLVL=2
> KEYCLOAK_PORT_8080_TCP=tcp://172.30.104.119:8080
> KUBERNETES_PORT_53_UDP_PROTO=udp
> KUBERNETES_PORT_443_TCP_PROTO=tcp
> KUBERNETES_SERVICE_PORT_HTTPS=443
> MYSQL_PORT_3306_TCP_PROTO=tcp
> KEYCLOAK_SERVICE_PORT=8080
> SECURE_KEYCLOAK_PORT_8443_TCP_PORT=8443
> MYSQL_PORT_3306_TCP_ADDR=172.30.228.24
> MYSQL_SERVICE_PORT=3306
> PROXY_ADDRESS_FORWARDING=false
> KEYCLOAK_PORT_8080_TCP_ADDR=172.30.104.119
> KUBERNETES_SERVICE_PORT_DNS_TCP=53
> KUBERNETES_PORT_53_TCP_PROTO=tcp
> KUBERNETES_PORT_443_TCP_ADDR=172.30.0.1
> KEYCLOAK_USER=IMSUser
> MYSQL_PORT=tcp://172.30.228.24:3306
> KUBERNETES_PORT_443_TCP=tcp://172.30.0.1:443
> SECURE_KEYCLOAK_PORT_8443_TCP_PROTO=tcp
> MYSQL_SERVICE_HOST=172.30.228.24
> SECURE_KEYCLOAK_PORT_8443_TCP_ADDR=172.30.25.80
>
> //////////////////////////////////////////////////////////////////////////////////////////////////////
> Log output from the failing keycloak pod
>
> Added 'IMSUser' to '/opt/jboss/keycloak/standalone/configuration/
> keycloak-add-user.json', restart server to load user
> -b 0.0.0.0
> WARNING: MYSQL_PORT variable name is DEPRECATED replace with DB_PORT
> =========================================================================
>
> Using MySQL database
>
> =========================================================================
>
> 22:46:32,107 INFO [org.jboss.modules] (CLI command executor) JBoss
> Modules version 1.8.5.Final
> 22:46:32,216 INFO [org.jboss.msc] (CLI command executor) JBoss MSC
> version 1.4.2.Final
> 22:46:32,235 INFO [org.jboss.threads] (CLI command executor) JBoss
> Threads version 2.3.2.Final
> 22:46:32,506 INFO [org.jboss.as] (MSC service thread 1-1) WFLYSRV0049:
> Keycloak 4.5.0.Final (WildFly Core 5.0.0.Final) starting
> 22:46:32,626 INFO [org.jboss.vfs] (MSC service thread 1-2) VFS000002:
> Failed to clean existing content for temp file provider of type temp.
> Enable DEBUG level log to find what caused this
> 22:46:34,920 INFO [org.jboss.as.controller.management-deprecated]
> (Controller Boot Thread) WFLYCTL0028: Attribute 'security-realm' in the
> resource at address '/core-service=management/management-interface=http-
> interface' is deprecated, and may be removed in a future version. See
> the attribute description in the output of the read-resource-description
> operation to learn more about the deprecation.
> 22:46:34,971 INFO [org.wildfly.security] (Controller Boot Thread)
> ELY00001: WildFly Elytron version 1.3.3.Final
> 22:46:35,071 INFO [org.jboss.as.controller.management-deprecated]
> (Controller Boot Thread) WFLYCTL0028: Attribute 'security-realm' in the
> resource at address '/subsystem=undertow/server=default-server/https-
> listener=https' is deprecated, and may be removed in a future version.
> See the attribute description in the output of the read-resource-
> description operation to learn more about the deprecation.
> 22:46:35,356 INFO [org.jboss.as.patching] (MSC service thread 1-2)
> WFLYPAT0050: Keycloak cumulative patch ID is: base, one-off patches
> include: none
> 22:46:35,388 WARN [org.jboss.as.domain.management.security] (MSC
> service thread 1-6) WFLYDM0111: Keystore /opt/jboss/keycloak/standalone/
> configuration/application.keystore not found, it will be auto generated
> on first use with a self signed certificate for host localhost
> 22:46:35,554 INFO [org.jboss.as.server] (Controller Boot Thread)
> WFLYSRV0212: Resuming server
> 22:46:35,560 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0025:
> Keycloak 4.5.0.Final (WildFly Core 5.0.0.Final) started in 3435ms -
> Started 65 of 79 services (25 services are lazy, passive or on-demand)
> The batch executed successfully
> 22:46:35,826 INFO [org.jboss.as] (MSC service thread 1-1) WFLYSRV0050:
> Keycloak 4.5.0.Final (WildFly Core 5.0.0.Final) stopped in 27ms
> 22:46:37,339 INFO [org.jboss.modules] (CLI command executor) JBoss
> Modules version 1.8.5.Final
> 22:46:37,420 INFO [org.jboss.msc] (CLI command executor) JBoss MSC
> version 1.4.2.Final
> 22:46:37,434 INFO [org.jboss.threads] (CLI command executor) JBoss
> Threads version 2.3.2.Final
> 22:46:37,662 INFO [org.jboss.as] (MSC service thread 1-2) WFLYSRV0049:
> Keycloak 4.5.0.Final (WildFly Core 5.0.0.Final) starting
> 22:46:37,772 INFO [org.jboss.vfs] (MSC service thread 1-1) VFS000002:
> Failed to clean existing content for temp file provider of type temp.
> Enable DEBUG level log to find what caused this
> 22:46:40,028 INFO [org.jboss.as.controller.management-deprecated]
> (Controller Boot Thread) WFLYCTL0028: Attribute 'security-realm' in the
> resource at address '/core-service=management/management-interface=http-
> interface' is deprecated, and may be removed in a future version. See
> the attribute description in the output of the read-resource-description
> operation to learn more about the deprecation.
> 22:46:40,073 INFO [org.wildfly.security] (Controller Boot Thread)
> ELY00001: WildFly Elytron version 1.3.3.Final
> 22:46:40,167 INFO [org.jboss.as.controller.management-deprecated]
> (Controller Boot Thread) WFLYCTL0028: Attribute 'security-realm' in the
> resource at address '/subsystem=undertow/server=default-server/https-
> listener=https' is deprecated, and may be removed in a future version.
> See the attribute description in the output of the read-resource-
> description operation to learn more about the deprecation.
> 22:46:40,456 INFO [org.jboss.as.patching] (MSC service thread 1-4)
> WFLYPAT0050: Keycloak cumulative patch ID is: base, one-off patches
> include: none
> 22:46:40,515 WARN [org.jboss.as.domain.management.security] (MSC
> service thread 1-2) WFLYDM0111: Keystore /opt/jboss/keycloak/standalone/
> configuration/application.keystore not found, it will be auto generated
> on first use with a self signed certificate for host localhost
> 22:46:40,626 INFO [org.jboss.as.server] (Controller Boot Thread)
> WFLYSRV0212: Resuming server
> 22:46:40,628 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0025:
> Keycloak 4.5.0.Final (WildFly Core 5.0.0.Final) started in 3282ms -
> Started 65 of 84 services (30 services are lazy, passive or on-demand)
> The batch executed successfully
> 22:46:40,897 INFO [org.jboss.as] (MSC service thread 1-4) WFLYSRV0050:
> Keycloak 4.5.0.Final (WildFly Core 5.0.0.Final) stopped in 18ms
> Setting JGroups discovery to dns.DNS_PING with properties
> {keycloak.imsproject.svc.cluster.local}
> =========================================================================
>
> JBoss Bootstrap Environment
>
> JBOSS_HOME: /opt/jboss/keycloak
>
> JAVA: /usr/lib/jvm/java/bin/java
>
> JAVA_OPTS: -server -Xms64m -Xmx512m -XX:MetaspaceSize=96M -
> XX:MaxMetaspaceSize=256m -Djava.net.preferIPv4Stack=true -
> Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true
>
> =========================================================================
>
> 22:46:48,021 INFO [org.jboss.modules] (main) JBoss Modules version
> 1.8.5.Final
> 22:46:48,691 INFO [org.jboss.msc] (main) JBoss MSC version 1.4.2.Final
> 22:46:48,730 INFO [org.jboss.threads] (main) JBoss Threads version
> 2.3.2.Final
> 22:46:49,029 INFO [org.jboss.as] (MSC service thread 1-1) WFLYSRV0049:
> Keycloak 4.5.0.Final (WildFly Core 5.0.0.Final) starting
> 22:46:49,191 INFO [org.jboss.vfs] (MSC service thread 1-2) VFS000002:
> Failed to clean existing content for temp file provider of type temp.
> Enable DEBUG level log to find what caused this
> 22:46:51,823 INFO [org.jboss.as.controller.management-deprecated]
> (Controller Boot Thread) WFLYCTL0028: Attribute 'security-realm' in the
> resource at address '/core-service=management/management-interface=http-
> interface' is deprecated, and may be removed in a future version. See
> the attribute description in the output of the read-resource-description
> operation to learn more about the deprecation.
> 22:46:51,874 INFO [org.wildfly.security] (ServerService Thread Pool --
> 6) ELY00001: WildFly Elytron version 1.3.3.Final
> 22:46:51,968 INFO [org.jboss.as.controller.management-deprecated]
> (ServerService Thread Pool -- 25) WFLYCTL0028: Attribute 'security-
> realm' in the resource at address '/subsystem=undertow/server=default-
> server/https-listener=https' is deprecated, and may be removed in a
> future version. See the attribute description in the output of the read-
> resource-description operation to learn more about the deprecation.
> 22:46:52,270 INFO [org.jboss.as.server] (Controller Boot Thread)
> WFLYSRV0039: Creating http management service using socket-binding
> (management-http)
> 22:46:52,349 INFO [org.xnio] (MSC service thread 1-4) XNIO version
> 3.6.3.Final
> 22:46:52,369 INFO [org.xnio.nio] (MSC service thread 1-4) XNIO NIO
> Implementation Version 3.6.3.Final
> 22:46:52,477 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 33) WFLYCLINF0001: Activating Infinispan subsystem.
> 22:46:52,585 INFO [org.jboss.as.connector.subsystems.datasources]
> (ServerService Thread Pool -- 28) WFLYJCA0004: Deploying JDBC-compliant
> driver class org.h2.Driver (version 1.4)
> 22:46:52,628 INFO [org.jboss.as.jaxrs] (ServerService Thread Pool --
> 35) WFLYRS0016: RESTEasy version 3.5.1.Final
> 22:46:52,623 INFO [org.jboss.as.security] (ServerService Thread Pool --
> 46) WFLYSEC0002: Activating Security Subsystem
> 22:46:52,567 INFO [org.jboss.as.naming] (ServerService Thread Pool --
> 43) WFLYNAM0001: Activating Naming Subsystem
> 22:46:52,596 INFO [org.wildfly.extension.io] (ServerService Thread Pool
> -- 34) WFLYIO001: Worker 'default' has auto-configured to 6 core threads
> with 48 task threads based on your 3 available processors
> 22:46:52,575 INFO [org.jboss.as.ee] (ServerService Thread Pool -- 30)
> WFLYEE0119: The system property 'ee8.preview.mode' is NOT set to 'true'.
> For provided EE 8 APIs where the EE 8 version of the API differs from
> what is supported in EE 7, the EE 7 variant of the API will be used.
> Support for this setting will be removed once all EE 8 APIs are provided
> and certified.
> 22:46:52,608 WARN [org.jboss.as.txn] (ServerService Thread Pool -- 48)
> WFLYTX0013: The node-identifier attribute on the /subsystem=transactions
> is set to the default value. This is a danger for environments running
> multiple servers. Please make sure the attribute value is unique.
> 22:46:52,599 INFO [org.jboss.as.clustering.jgroups] (ServerService
> Thread Pool -- 37) WFLYCLJG0001: Activating JGroups subsystem. JGroups
> version 4.0.11
> 22:46:52,687 INFO [org.jboss.as.connector] (MSC service thread 1-4)
> WFLYJCA0009: Starting JCA Subsystem (WildFly/IronJacamar 1.4.9.Final)
> 22:46:52,743 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service
> thread 1-3) WFLYJCA0018: Started Driver service with driver-name = h2
> 22:46:52,747 INFO [org.jboss.as.connector.subsystems.datasources]
> (ServerService Thread Pool -- 28) WFLYJCA0005: Deploying non-JDBC-
> compliant driver class com.mysql.jdbc.Driver (version 5.1)
> 22:46:52,770 INFO [org.jboss.as.security] (MSC service thread 1-3)
> WFLYSEC0001: Current PicketBox version=5.0.2.Final
> 22:46:52,789 INFO [org.jboss.remoting] (MSC service thread 1-5) JBoss
> Remoting version 5.0.7.Final
> 22:46:52,799 INFO [org.wildfly.extension.undertow] (MSC service thread
> 1-4) WFLYUT0003: Undertow 2.0.9.Final starting
> 22:46:52,794 INFO [org.jboss.as.naming] (MSC service thread 1-6)
> WFLYNAM0003: Starting Naming Service
> 22:46:52,839 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service
> thread 1-4) WFLYJCA0018: Started Driver service with driver-name = mysql
> 22:46:52,841 INFO [org.jboss.as.mail.extension] (MSC service thread 1-
> 4) WFLYMAIL0001: Bound mail session [java:jboss/mail/Default]
> 22:46:53,208 INFO [org.jboss.as.ejb3] (MSC service thread 1-5)
> WFLYEJB0481: Strict pool slsb-strict-max-pool is using a max instance
> size of 48 (per class), which is derived from thread worker pool sizing.
> 22:46:53,208 INFO [org.jboss.as.ejb3] (MSC service thread 1-6)
> WFLYEJB0482: Strict pool mdb-strict-max-pool is using a max instance
> size of 12 (per class), which is derived from the number of CPUs on this
> host.
> 22:46:53,389 INFO [org.wildfly.extension.undertow] (ServerService
> Thread Pool -- 49) WFLYUT0014: Creating file handler for path '/opt/
> jboss/keycloak/welcome-content' with options [directory-listing:
> 'false', follow-symlink: 'false', case-sensitive: 'true', safe-symlink-
> paths: '[]']
> 22:46:53,414 INFO [org.wildfly.extension.undertow] (MSC service thread
> 1-1) WFLYUT0012: Started server default-server.
> 22:46:53,442 INFO [org.wildfly.extension.undertow] (MSC service thread
> 1-1) WFLYUT0018: Host default-host starting
> 22:46:53,679 INFO [org.wildfly.extension.undertow] (MSC service thread
> 1-2) WFLYUT0006: Undertow HTTP listener default listening on
> 0.0.0.0:8080
> 22:46:53,681 INFO [org.wildfly.extension.undertow] (MSC service thread
> 1-5) WFLYUT0006: Undertow AJP listener ajp listening on 0.0.0.0:8009
> 22:46:53,710 INFO [org.jboss.modcluster] (ServerService Thread Pool --
> 50) MODCLUSTER000001: Initializing mod_cluster version 1.3.9.Final
> 22:46:53,765 INFO [org.jboss.modcluster] (ServerService Thread Pool --
> 50) MODCLUSTER000032: Listening to proxy advertisements on /
> 224.0.1.105:23364
> 22:46:53,944 INFO [org.jboss.as.ejb3] (MSC service thread 1-6)
> WFLYEJB0493: EJB subsystem suspension complete
> 22:46:54,216 INFO [org.jboss.as.connector.subsystems.datasources] (MSC
> service thread 1-4) WFLYJCA0001: Bound data source
> [java:jboss/datasources/ExampleDS]
> 22:46:54,217 INFO [org.jboss.as.connector.subsystems.datasources] (MSC
> service thread 1-5) WFLYJCA0001: Bound data source
> [java:jboss/datasources/KeycloakDS]
> 22:46:54,438 INFO [org.jboss.as.patching] (MSC service thread 1-4)
> WFLYPAT0050: Keycloak cumulative patch ID is: base, one-off patches
> include: none
> 22:46:54,545 WARN [org.jboss.as.domain.management.security] (MSC
> service thread 1-4) WFLYDM0111: Keystore /opt/jboss/keycloak/standalone/
> configuration/application.keystore not found, it will be auto generated
> on first use with a self signed certificate for host localhost
> 22:46:54,623 INFO [org.jboss.as.server.deployment.scanner] (MSC service
> thread 1-6) WFLYDS0013: Started FileSystemDeploymentService for
> directory /opt/jboss/keycloak/standalone/deployments
> 22:46:54,665 INFO [org.jboss.as.server.deployment] (MSC service thread
> 1-1) WFLYSRV0027: Starting deployment of "keycloak-server.war" (runtime-
> name: "keycloak-server.war")
> 22:46:55,185 INFO [org.wildfly.extension.undertow] (MSC service thread
> 1-3) WFLYUT0006: Undertow HTTPS listener https listening on 0.0.0.0:8443
> 22:46:56,388 WARN [org.jgroups.protocols.UDP] (ServerService Thread
> Pool -- 50) JGRP000015: the send buffer of socket MulticastSocket was
> set to 1.00MB, but the OS only allocated 212.99KB. This might lead to
> performance problems. Please set your max send buffer in the OS
> correctly (e.g. net.core.wmem_max on Linux)
> 22:46:56,389 WARN [org.jgroups.protocols.UDP] (ServerService Thread
> Pool -- 50) JGRP000015: the receive buffer of socket MulticastSocket was
> set to 20.00MB, but the OS only allocated 212.99KB. This might lead to
> performance problems. Please set your max receive buffer in the OS
> correctly (e.g. net.core.rmem_max on Linux)
> 22:46:56,390 WARN [org.jgroups.protocols.UDP] (ServerService Thread
> Pool -- 50) JGRP000015: the send buffer of socket MulticastSocket was
> set to 1.00MB, but the OS only allocated 212.99KB. This might lead to
> performance problems. Please set your max send buffer in the OS
> correctly (e.g. net.core.wmem_max on Linux)
> 22:46:56,391 WARN [org.jgroups.protocols.UDP] (ServerService Thread
> Pool -- 50) JGRP000015: the receive buffer of socket MulticastSocket was
> set to 25.00MB, but the OS only allocated 212.99KB. This might lead to
> performance problems. Please set your max receive buffer in the OS
> correctly (e.g. net.core.rmem_max on Linux)
> 22:47:00,310 INFO
> [org.infinispan.remoting.transport.jgroups.JGroupsTransport] (MSC
> service thread 1-2) ISPN000078: Starting JGroups channel ejb
> 22:47:00,324 INFO
> [org.infinispan.remoting.transport.jgroups.JGroupsTransport] (MSC
> service thread 1-6) ISPN000078: Starting JGroups channel ejb
> 22:47:00,326 INFO
> [org.infinispan.remoting.transport.jgroups.JGroupsTransport] (MSC
> service thread 1-4) ISPN000078: Starting JGroups channel ejb
> 22:47:00,336 INFO
> [org.infinispan.remoting.transport.jgroups.JGroupsTransport] (MSC
> service thread 1-1) ISPN000078: Starting JGroups channel ejb
> 22:47:00,336 INFO
> [org.infinispan.remoting.transport.jgroups.JGroupsTransport] (MSC
> service thread 1-3) ISPN000078: Starting JGroups channel ejb
> 22:47:00,377 INFO [org.infinispan.CLUSTER] (MSC service thread 1-3)
> ISPN000094: Received new cluster view for channel ejb: [keycloak-2-
> 6gtkj|0] (1) [keycloak-2-6gtkj]
> 22:47:00,370 INFO [org.infinispan.CLUSTER] (MSC service thread 1-2)
> ISPN000094: Received new cluster view for channel ejb: [keycloak-2-
> 6gtkj|0] (1) [keycloak-2-6gtkj]
> 22:47:00,379 INFO [org.infinispan.CLUSTER] (MSC service thread 1-1)
> ISPN000094: Received new cluster view for channel ejb: [keycloak-2-
> 6gtkj|0] (1) [keycloak-2-6gtkj]
> 22:47:00,378 INFO [org.infinispan.CLUSTER] (MSC service thread 1-6)
> ISPN000094: Received new cluster view for channel ejb: [keycloak-2-
> 6gtkj|0] (1) [keycloak-2-6gtkj]
> 22:47:00,378 INFO [org.infinispan.CLUSTER] (MSC service thread 1-4)
> ISPN000094: Received new cluster view for channel ejb: [keycloak-2-
> 6gtkj|0] (1) [keycloak-2-6gtkj]
> 22:47:00,399 INFO
> [org.infinispan.remoting.transport.jgroups.JGroupsTransport] (MSC
> service thread 1-6) ISPN000079: Channel ejb local address is keycloak-2-
> 6gtkj, physical addresses are [10.128.1.109:55200]
> 22:47:00,405 INFO
> [org.infinispan.remoting.transport.jgroups.JGroupsTransport] (MSC
> service thread 1-1) ISPN000079: Channel ejb local address is keycloak-2-
> 6gtkj, physical addresses are [10.128.1.109:55200]
> 22:47:00,412 INFO
> [org.infinispan.remoting.transport.jgroups.JGroupsTransport] (MSC
> service thread 1-4) ISPN000079: Channel ejb local address is keycloak-2-
> 6gtkj, physical addresses are [10.128.1.109:55200]
> 22:47:00,416 INFO
> [org.infinispan.remoting.transport.jgroups.JGroupsTransport] (MSC
> service thread 1-2) ISPN000079: Channel ejb local address is keycloak-2-
> 6gtkj, physical addresses are [10.128.1.109:55200]
> 22:47:00,461 INFO
> [org.infinispan.remoting.transport.jgroups.JGroupsTransport] (MSC
> service thread 1-3) ISPN000079: Channel ejb local address is keycloak-2-
> 6gtkj, physical addresses are [10.128.1.109:55200]
> 22:47:00,415 INFO [org.infinispan.factories.GlobalComponentRegistry]
> (MSC service thread 1-4) ISPN000128: Infinispan version: Infinispan
> 'Gaina' 9.2.4.Final
> 22:47:01,446 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 61) WFLYCLINF0002: Started keys cache from keycloak
> container
> 22:47:01,531 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 59) WFLYCLINF0002: Started users cache from keycloak
> container
> 22:47:01,532 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 58) WFLYCLINF0002: Started realms cache from keycloak
> container
> 22:47:01,533 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 54) WFLYCLINF0002: Started authorization cache from
> keycloak container
> 22:47:01,692 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 57) WFLYCLINF0002: Started actionTokens cache from
> keycloak container
> 22:47:01,698 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 52) WFLYCLINF0002: Started offlineSessions cache from
> keycloak container
> 22:47:01,703 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 55) WFLYCLINF0002: Started offlineClientSessions cache
> from keycloak container
> 22:47:01,707 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 60) WFLYCLINF0002: Started clientSessions cache from
> keycloak container
> 22:47:01,717 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 56) WFLYCLINF0002: Started work cache from keycloak
> container
> 22:47:01,720 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 51) WFLYCLINF0002: Started sessions cache from keycloak
> container
> 22:47:01,723 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 62) WFLYCLINF0002: Started client-mappings cache from ejb
> container
> 22:47:01,736 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 50) WFLYCLINF0002: Started authenticationSessions cache
> from keycloak container
> 22:47:01,737 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 53) WFLYCLINF0002: Started loginFailures cache from
> keycloak container
> 22:47:03,105 INFO [org.keycloak.services] (ServerService Thread Pool --
> 50) KC-SERVICES0001: Loading config from standalone.xml or domain.xml
> 22:47:04,201 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 50) WFLYCLINF0002: Started realmRevisions cache from
> keycloak container
> 22:47:04,214 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 50) WFLYCLINF0002: Started userRevisions cache from
> keycloak container
> 22:47:04,263 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 50) WFLYCLINF0002: Started authorizationRevisions cache
> from keycloak container
> 22:47:04,268 INFO
> [org.keycloak.connections.infinispan.DefaultInfinispanConnectionProviderFactory]
> (ServerService Thread Pool -- 50) Node name: keycloak-2-6gtkj, Site
> name: null
> 22:47:05,132 WARN
> [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool]
> (ServerService Thread Pool -- 50) IJ000604: Throwable while attempting
> to get a new connection: null: javax.resource.ResourceException:
> IJ031084: Unable to create connection
> at
> org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:345)
> at
> org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:352)
> at
> org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:287)
> at
> org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1326)
> at
> org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:499)
> at
> org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:632)
> at
> org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:604)
> at
> org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:624)
> at
> org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:430)
> at
> org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:789)
> at
> org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:138)
> at
> org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:64)
> at
> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.getConnection(DefaultJpaConnectionProviderFactory.java:367)
> at
> org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.lazyInit(LiquibaseDBLockProvider.java:65)
> at
> org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.lambda
> $waitForLock$0(LiquibaseDBLockProvider.java:97)
> at
> org.keycloak.models.utils.KeycloakModelUtils.suspendJtaTransaction(KeycloakModelUtils.java:611)
> at
> org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.waitForLock(LiquibaseDBLockProvider.java:95)
> at org.keycloak.services.resources.KeycloakApplication
> $1.run(KeycloakApplication.java:143)
> at
> org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:227)
> at
> org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:136)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> at
> org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:150)
> at
> org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2676)
> at
> org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:361)
> at
> org.jboss.resteasy.spi.ResteasyDeployment.startInternal(ResteasyDeployment.java:274)
> at
> org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:86)
> at
> org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:119)
> at
> org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36)
> at
> io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)
> at
> org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:78)
> at
> io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)
> at io.undertow.servlet.core.ManagedServlet
> $DefaultInstanceStrategy.start(ManagedServlet.java:300)
> at
> io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:140)
> at io.undertow.servlet.core.DeploymentManagerImpl
> $2.call(DeploymentManagerImpl.java:584)
> at io.undertow.servlet.core.DeploymentManagerImpl
> $2.call(DeploymentManagerImpl.java:555)
> at io.undertow.servlet.core.ServletRequestContextThreadSetupAction
> $1.call(ServletRequestContextThreadSetupAction.java:42)
> at io.undertow.servlet.core.ContextClassLoaderSetupAction
> $1.call(ContextClassLoaderSetupAction.java:43)
> at
> org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda
> $create$0(SecurityContextThreadSetupAction.java:105)
> at
> org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService
> $UndertowThreadSetupAction.lambda$create
> $0(UndertowDeploymentInfoService.java:1514)
> at
> org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService
> $UndertowThreadSetupAction.lambda$create
> $0(UndertowDeploymentInfoService.java:1514)
> at
> org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService
> $UndertowThreadSetupAction.lambda$create
> $0(UndertowDeploymentInfoService.java:1514)
> at
> org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService
> $UndertowThreadSetupAction.lambda$create
> $0(UndertowDeploymentInfoService.java:1514)
> at
> io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:597)
> at
> org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:97)
> at org.wildfly.extension.undertow.deployment.UndertowDeploymentService
> $1.run(UndertowDeploymentService.java:78)
> at java.util.concurrent.Executors
> $RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at
> org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
> at
> org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1985)
> at org.jboss.threads.EnhancedQueueExecutor
> $ThreadBody.doRunTask(EnhancedQueueExecutor.java:1487)
> at org.jboss.threads.EnhancedQueueExecutor
> $ThreadBody.run(EnhancedQueueExecutor.java:1378)
> at java.lang.Thread.run(Thread.java:748)
> at org.jboss.threads.JBossThread.run(JBossThread.java:485)
> Caused by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
> Cannot load connection class because of underlying exception:
> 'java.lang.NumberFormatException: For input string: "tcp:"'.
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
> at com.mysql.jdbc.Util.getInstance(Util.java:408)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:338)
> at
> org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:321)
> ... 55 more
> Caused by: java.lang.NumberFormatException: For input string: "tcp:"
> at
> java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> at java.lang.Integer.parseInt(Integer.java:580)
> at java.lang.Integer.parseInt(Integer.java:615)
> at
> com.mysql.jdbc.NonRegisteringDriver.port(NonRegisteringDriver.java:825)
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
> ... 56 more
>
> 22:47:05,168 INFO [org.jboss.as.server] (Thread-2) WFLYSRV0220: Server
> shutdown has been requested via an OS signal
> 22:47:05,177 ERROR [org.jboss.msc.service.fail] (ServerService Thread
> Pool -- 50) MSC000001: Failed to start service
> jboss.undertow.deployment.default-server.default-host./auth:
> org.jboss.msc.service.StartException in service
> jboss.undertow.deployment.default-server.default-host./auth:
> java.lang.RuntimeException: RESTEASY003325: Failed to construct public
> org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)
> at org.wildfly.extension.undertow.deployment.UndertowDeploymentService
> $1.run(UndertowDeploymentService.java:81)
> at java.util.concurrent.Executors
> $RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at
> org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
> at
> org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1985)
> at org.jboss.threads.EnhancedQueueExecutor
> $ThreadBody.doRunTask(EnhancedQueueExecutor.java:1487)
> at org.jboss.threads.EnhancedQueueExecutor
> $ThreadBody.run(EnhancedQueueExecutor.java:1378)
> at java.lang.Thread.run(Thread.java:748)
> at org.jboss.threads.JBossThread.run(JBossThread.java:485)
> Caused by: java.lang.RuntimeException: RESTEASY003325: Failed to
> construct public
> org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)
> at
> org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:162)
> at
> org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2676)
> at
> org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:361)
> at
> org.jboss.resteasy.spi.ResteasyDeployment.startInternal(ResteasyDeployment.java:274)
> at
> org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:86)
> at
> org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:119)
> at
> org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36)
> at
> io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)
> at
> org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:78)
> at
> io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)
> at io.undertow.servlet.core.ManagedServlet
> $DefaultInstanceStrategy.start(ManagedServlet.java:300)
> at
> io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:140)
> at io.undertow.servlet.core.DeploymentManagerImpl
> $2.call(DeploymentManagerImpl.java:584)
> at io.undertow.servlet.core.DeploymentManagerImpl
> $2.call(DeploymentManagerImpl.java:555)
> at io.undertow.servlet.core.ServletRequestContextThreadSetupAction
> $1.call(ServletRequestContextThreadSetupAction.java:42)
> at io.undertow.servlet.core.ContextClassLoaderSetupAction
> $1.call(ContextClassLoaderSetupAction.java:43)
> at
> org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda
> $create$0(SecurityContextThreadSetupAction.java:105)
> at
> org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService
> $UndertowThreadSetupAction.lambda$create
> $0(UndertowDeploymentInfoService.java:1514)
> at
> org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService
> $UndertowThreadSetupAction.lambda$create
> $0(UndertowDeploymentInfoService.java:1514)
> at
> org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService
> $UndertowThreadSetupAction.lambda$create
> $0(UndertowDeploymentInfoService.java:1514)
> at
> org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService
> $UndertowThreadSetupAction.lambda$create
> $0(UndertowDeploymentInfoService.java:1514)
> at
> io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:597)
> at
> org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:97)
> at org.wildfly.extension.undertow.deployment.UndertowDeploymentService
> $1.run(UndertowDeploymentService.java:78)
> ... 8 more
> Caused by: java.lang.RuntimeException: Failed to connect to database
> at
> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.getConnection(DefaultJpaConnectionProviderFactory.java:373)
> at
> org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.lazyInit(LiquibaseDBLockProvider.java:65)
> at
> org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.lambda
> $waitForLock$0(LiquibaseDBLockProvider.java:97)
> at
> org.keycloak.models.utils.KeycloakModelUtils.suspendJtaTransaction(KeycloakModelUtils.java:611)
> at
> org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.waitForLock(LiquibaseDBLockProvider.java:95)
> at org.keycloak.services.resources.KeycloakApplication
> $1.run(KeycloakApplication.java:143)
> at
> org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:227)
> at
> org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:136)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> at
> org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:150)
> ... 31 more
> Caused by: java.sql.SQLException: javax.resource.ResourceException:
> IJ000453: Unable to get managed connection for
> java:jboss/datasources/KeycloakDS
> at
> org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:146)
> at
> org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:64)
> at
> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.getConnection(DefaultJpaConnectionProviderFactory.java:367)
> ... 43 more
> Caused by: javax.resource.ResourceException: IJ000453: Unable to get
> managed connection for java:jboss/datasources/KeycloakDS
> at
> org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:690)
> at
> org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:430)
> at
> org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:789)
> at
> org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:138)
> ... 45 more
> Caused by: javax.resource.ResourceException: IJ031084: Unable to create
> connection
> at
> org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:345)
> at
> org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:352)
> at
> org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:287)
> at
> org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1326)
> at
> org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:499)
> at
> org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:632)
> at
> org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:604)
> at
> org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:624)
> ... 48 more
> Caused by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
> Cannot load connection class because of underlying exception:
> 'java.lang.NumberFormatException: For input string: "tcp:"'.
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
> at com.mysql.jdbc.Util.getInstance(Util.java:408)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:338)
> at
> org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:321)
> ... 55 more
> Caused by: java.lang.NumberFormatException: For input string: "tcp:"
> at
> java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
> at java.lang.Integer.parseInt(Integer.java:580)
> at java.lang.Integer.parseInt(Integer.java:615)
> at
> com.mysql.jdbc.NonRegisteringDriver.port(NonRegisteringDriver.java:825)
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
> ... 56 more
>
> 22:47:05,250 INFO
> [org.infinispan.remoting.transport.jgroups.JGroupsTransport] (MSC
> service thread 1-2) ISPN000080: Disconnecting JGroups channel ejb
> 22:47:05,253 INFO
> [org.infinispan.remoting.transport.jgroups.JGroupsTransport] (MSC
> service thread 1-2) ISPN000080: Disconnecting JGroups channel ejb
> 22:47:05,254 INFO
> [org.infinispan.remoting.transport.jgroups.JGroupsTransport] (MSC
> service thread 1-3) ISPN000080: Disconnecting JGroups channel ejb
> 22:47:05,279 INFO [org.jboss.as.connector.subsystems.datasources] (MSC
> service thread 1-2) WFLYJCA0010: Unbound data source
> [java:jboss/datasources/KeycloakDS]
> 22:47:05,283 INFO [org.wildfly.extension.undertow] (MSC service thread
> 1-5) WFLYUT0008: Undertow AJP listener ajp suspending
> 22:47:05,284 INFO [org.wildfly.extension.undertow] (MSC service thread
> 1-2) WFLYUT0008: Undertow HTTPS listener https suspending
> 22:47:05,290 INFO [org.jboss.modcluster] (ServerService Thread Pool --
> 55) MODCLUSTER000002: Initiating mod_cluster shutdown
> 22:47:05,313 INFO [org.jboss.as.connector.subsystems.datasources] (MSC
> service thread 1-6) WFLYJCA0010: Unbound data source
> [java:jboss/datasources/ExampleDS]
> 22:47:05,313 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service
> thread 1-6) WFLYJCA0019: Stopped Driver service with driver-name = mysql
> 22:47:05,315 INFO [org.wildfly.extension.undertow] (MSC service thread
> 1-2) WFLYUT0007: Undertow HTTPS listener https stopped, was bound to
> 0.0.0.0:8443
> 22:47:05,320 INFO [org.wildfly.extension.undertow] (MSC service thread
> 1-5) WFLYUT0007: Undertow AJP listener ajp stopped, was bound to
> 0.0.0.0:8009
> 22:47:05,340 INFO [org.wildfly.extension.undertow] (MSC service thread
> 1-5) WFLYUT0019: Host default-host stopping
> 22:47:05,348 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service
> thread 1-3) WFLYJCA0019: Stopped Driver service with driver-name = h2
> 22:47:05,364 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 52) WFLYCLINF0003: Stopped offlineSessions cache from
> keycloak container
> 22:47:05,373 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 58) WFLYCLINF0003: Stopped realms cache from keycloak
> container
> 22:47:05,378 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 50) WFLYCLINF0003: Stopped users cache from keycloak
> container
> 22:47:05,379 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 61) WFLYCLINF0003: Stopped authorization cache from
> keycloak container
> 22:47:05,384 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 54) WFLYCLINF0003: Stopped keys cache from keycloak
> container
> 22:47:05,391 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 55) WFLYCLINF0003: Stopped client-mappings cache from ejb
> container
> 22:47:05,392 INFO
> [org.infinispan.remoting.transport.jgroups.JGroupsTransport] (MSC
> service thread 1-1) ISPN000080: Disconnecting JGroups channel ejb
> 22:47:05,400 INFO [org.wildfly.extension.undertow] (MSC service thread
> 1-3) WFLYUT0008: Undertow HTTP listener default suspending
> 22:47:05,401 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 60) WFLYCLINF0003: Stopped work cache from keycloak
> container
> 22:47:05,403 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 56) WFLYCLINF0003: Stopped sessions cache from keycloak
> container
> 22:47:05,404 INFO [org.wildfly.extension.undertow] (MSC service thread
> 1-3) WFLYUT0007: Undertow HTTP listener default stopped, was bound to
> 0.0.0.0:8080
> 22:47:05,407 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 53) WFLYCLINF0003: Stopped offlineClientSessions cache
> from keycloak container
> 22:47:05,407 INFO [org.wildfly.extension.undertow] (MSC service thread
> 1-6) WFLYUT0004: Undertow 2.0.9.Final stopping
> 22:47:05,407 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 57) WFLYCLINF0003: Stopped authenticationSessions cache
> from keycloak container
> 22:47:05,409 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 62) WFLYCLINF0003: Stopped actionTokens cache from
> keycloak container
> 22:47:05,413 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 51) WFLYCLINF0003: Stopped clientSessions cache from
> keycloak container
> 22:47:05,415 INFO [org.jboss.as.clustering.infinispan] (ServerService
> Thread Pool -- 59) WFLYCLINF0003: Stopped loginFailures cache from
> keycloak container
> 22:47:05,440 INFO [org.jboss.as.clustering.infinispan] (MSC service
> thread 1-5) WFLYCLINF0003: Stopped authorizationRevisions cache from
> keycloak container
> 22:47:05,450 INFO [org.jboss.as.server.deployment] (MSC service thread
> 1-6) WFLYSRV0028: Stopped deployment keycloak-server.war (runtime-name:
> keycloak-server.war) in 277ms
> 22:47:05,454 INFO [org.jboss.as.clustering.infinispan] (MSC service
> thread 1-5) WFLYCLINF0003: Stopped realmRevisions cache from keycloak
> container
> 22:47:05,466 INFO [org.jboss.as.clustering.infinispan] (MSC service
> thread 1-5) WFLYCLINF0003: Stopped userRevisions cache from keycloak
> container
> 22:47:05,467 INFO
> [org.infinispan.remoting.transport.jgroups.JGroupsTransport] (MSC
> service thread 1-5) ISPN000080: Disconnecting JGroups channel ejb
>
>
>
>
> ------------------------------
>
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user
>
> End of keycloak-user Digest, Vol 58, Issue 8
> ********************************************
More information about the keycloak-user
mailing list