# Error connecting to H2 database **URL:** \ **Category:** Configuring the server\ **Created:** [March 5, 2020, 1:31pm UTC](https://forum.keycloak.org/t/error-connecting-to-h2-database/1554 "2020-03-05T13:31:50Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![amushkovski](https://avatars.discourse-cdn.com/v4/letter/a/a88e57/32.png) [@amushkovski](https://forum.keycloak.org/u/amushkovski)\ **Post date:** [March 5, 2020, 1:31pm UTC](https://forum.keycloak.org/t/error-connecting-to-h2-database/1554/1 "2020-03-05T13:31:50Z")
Hi, I’m trying to configure keycloak, instruction: [https://medium.com/@hasnat.saeed/setup-keycloak-server-on-ubuntu-18-04-ed8c7c79a2d9](https://medium.com/@hasnat.saeed/setup-keycloak-server-on-ubuntu-18-04-ed8c7c79a2d9) When I start standalone.sh, I receive following: 15:49:37,504 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (ServerService Thread Pool – 66) 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:1328) 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:440) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:789) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:151) at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:64) at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.getConnection(DefaultJpaConnectionProviderFactory.java:371) at org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.lazyInit(LiquibaseDBLockProvider.java:65) at org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.lambda$waitForLock$2(LiquibaseDBLockProvider.java:96) at org.keycloak.models.utils.KeycloakModelUtils.suspendJtaTransaction(KeycloakModelUtils.java:682) at org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.waitForLock(LiquibaseDBLockProvider.java:94) 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.startup(KeycloakApplication.java:136) at org.keycloak.provider.wildfly.WildflyPlatform.onStartup(WildflyPlatform.java:29) at org.keycloak.services.resources.KeycloakApplication.(KeycloakApplication.java:123) 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:152) at org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2784) at org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:364) at org.jboss.resteasy.spi.ResteasyDeployment.startInternal(ResteasyDeployment.java:277) at org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:89) 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:305) at io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:145) at io.undertow.servlet.core.DeploymentManagerImpl$2.call(DeploymentManagerImpl.java:585) at io.undertow.servlet.core.DeploymentManagerImpl$2.call(DeploymentManagerImpl.java:556) 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:1504) at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1504) at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1504) at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1504) at io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:598) 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:1982) at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486) at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377) at java.lang.Thread.run(Thread.java:748) at org.jboss.threads.JBossThread.run(JBossThread.java:485) Caused by: org.h2.jdbc.JdbcSQLException: IO Exception: “java.net.UnknownHostException: 44-206-124-178-static.mgts.by: 44-206-124-178-static.mgts.by: Name or service not known” [90028-193] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:168) at org.h2.message.DbException.convert(DbException.java:287) at org.h2.util.NetUtils.getLocalAddress(NetUtils.java:273) at org.h2.server.TcpServer.getURL(TcpServer.java:198) at org.h2.tools.Server.start(Server.java:485) at org.h2.engine.Database.startServer(Database.java:806) at org.h2.engine.Database.open(Database.java:662) at org.h2.engine.Database.openDatabase(Database.java:273) at org.h2.engine.Database.(Database.java:267) at org.h2.engine.Engine.openSession(Engine.java:64) at org.h2.engine.Engine.openSession(Engine.java:176) at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154) at org.h2.engine.Engine.createSession(Engine.java:137) at org.h2.engine.Engine.createSession(Engine.java:27) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349) at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:115) at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:99) at org.h2.Driver.connect(Driver.java:69) at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:321) … 57 more Caused by: java.net.UnknownHostException: 44-206-124-178-static.mgts.by: 44-206-124-178-static.mgts.by: Name or service not known at java.net.InetAddress.getLocalHost(InetAddress.java:1506) at org.h2.util.NetUtils.getLocalAddress(NetUtils.java:271) … 73 more Caused by: java.net.UnknownHostException: 44-206-124-178-static.mgts.by: Name or service not known at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method) at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:929) at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1324) at java.net.InetAddress.getLocalHost(InetAddress.java:1501) … 74 more 15:49:37,514 FATAL [org.keycloak.services] (ServerService Thread Pool – 66) java.lang.RuntimeException: Failed to connect to database ---
**Author:** ![Robinyo](https://avatars.discourse-cdn.com/v4/letter/r/dec6dc/32.png) [@Robinyo](https://forum.keycloak.org/u/Robinyo)\ **Post date:** [March 5, 2020, 9:55pm UTC](https://forum.keycloak.org/t/error-connecting-to-h2-database/1554/2 "2020-03-05T21:55:39Z")
The easiest way to get started with Keycloak is to use a Docker [image](https://hub.docker.com/r/jboss/keycloak/), for example: ```auto docker pull jboss/keycloak:9.0.0 docker run -d --name keycloak \ -p 10001:8080 \ -e KEYCLOAK_USER=admin \ -e KEYCLOAK_PASSWORD=secret \ jboss/keycloak:9.0.0 ``` Ref: [Getting started with Keycloak](https://robferguson.org/blog/2019/12/24/getting-started-with-keycloak/) ---
**Author:** ![amushkovski](https://avatars.discourse-cdn.com/v4/letter/a/a88e57/32.png) [@amushkovski](https://forum.keycloak.org/u/amushkovski)\ **Post date:** [March 6, 2020, 1:20pm UTC](https://forum.keycloak.org/t/error-connecting-to-h2-database/1554/3 "2020-03-06T13:20:14Z")
> [@Robinyo](#): > > jboss/keycloak:9.0.0 I’ve tried container. Start page is ok but when I go to Administration Console so it is redirected from DNS to IP. Proxy to https via nginx. ![keycloak2](https://global.discourse-cdn.com/free1/uploads/keycloak/original/1X/3346d30f891797146bff6642f0a13233685acf1a.png)