You can translate the question and the replies:

Denodo Data catalog issue

hi Team, I am getting below after installation Denodo.Updated only VDBconfiguration.properties . Please help me the data catalog is not getting up 22-Oct-2019 18:29:07.819 WARNING [main] org.apache.catalina.startup.SetAllPropertiesRule.begin [SetAllPropertiesRule]{Server/Service/Connector} Setting property 'redirectPort' to '' did not find a matching property. 22-Oct-2019 18:29:07.961 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.27 22-Oct-2019 18:29:07.961 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Jan 18 2018 20:12:40 UTC 22-Oct-2019 18:29:07.961 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.27.0 22-Oct-2019 18:29:07.961 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux 22-Oct-2019 18:29:07.961 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 3.10.0-957.21.3.el7.x86_64 22-Oct-2019 18:29:07.961 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64 22-Oct-2019 18:29:07.961 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /opt/denodo/jre 22-Oct-2019 18:29:07.962 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_162-b12 22-Oct-2019 18:29:07.962 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation 22-Oct-2019 18:29:07.962 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /opt/denodo/resources/apache-tomcat 22-Oct-2019 18:29:07.962 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /opt/denodo/resources/apache-tomcat 22-Oct-2019 18:29:07.962 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/opt/denodo/resources/apache-tomcat/conf/logging.properties 22-Oct-2019 18:29:07.962 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 22-Oct-2019 18:29:07.962 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1024m 22-Oct-2019 18:29:07.962 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.tomcat.util.buf.UDecoder.ALLOW_ENCODED_SLASH=true 22-Oct-2019 18:29:07.962 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.connector.CoyoteAdapter.ALLOW_BACKSLASH=true 22-Oct-2019 18:29:07.963 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048 22-Oct-2019 18:29:07.963 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources 22-Oct-2019 18:29:07.963 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -DDENODO_APP=Denodo Web Container 7.0 22-Oct-2019 18:29:07.963 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote 22-Oct-2019 18:29:07.963 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.port=9098 22-Oct-2019 18:29:07.963 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.rmi.port=9097 22-Oct-2019 18:29:07.963 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.rmi.server.hostname=localhost 22-Oct-2019 18:29:07.963 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.authenticate=false 22-Oct-2019 18:29:07.963 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.ssl=false 22-Oct-2019 18:29:07.963 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.denodo.tomcat.shutdown.port=9099 22-Oct-2019 18:29:07.963 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.denodo.tomcat.http.port=9090 22-Oct-2019 18:29:07.963 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.denodo.tomcat.https.port= 22-Oct-2019 18:29:07.963 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.denodo.tomcat.engine.name=DenodoPlatform-7.0 22-Oct-2019 18:29:07.964 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.denodo.security.ssl.keyStore= 22-Oct-2019 18:29:07.964 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.denodo.security.ssl.keyStorePassword= 22-Oct-2019 18:29:07.964 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.denodo.vdp.port=9999 22-Oct-2019 18:29:07.964 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs= 22-Oct-2019 18:29:07.964 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/opt/denodo/resources/apache-tomcat 22-Oct-2019 18:29:07.964 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/opt/denodo/resources/apache-tomcat 22-Oct-2019 18:29:07.964 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/opt/denodo/resources/apache-tomcat/temp 22-Oct-2019 18:29:08.153 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-9090"] 22-Oct-2019 18:29:08.172 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read 22-Oct-2019 18:29:08.184 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 674 ms 22-Oct-2019 18:29:08.567 WARNING [main] org.apache.naming.NamingContext.lookup Unexpected exception resolving reference java.sql.SQLException: Cannot create PoolableConnectionFactory (connection error: Connection refused (Connection refused)) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2342) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2067) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getLogWriter(BasicDataSource.java:1598) at org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.createDataSource(BasicDataSourceFactory.java:596) at org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance(BasicDataSourceFactory.java:275) at org.apache.naming.factory.FactoryBase.getObjectInstance(FactoryBase.java:94) at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321) at org.apache.naming.NamingContext.lookup(NamingContext.java:840) at org.apache.naming.NamingContext.lookup(NamingContext.java:159) at org.apache.naming.NamingContext.lookup(NamingContext.java:827) at org.apache.naming.NamingContext.lookup(NamingContext.java:173) at org.apache.catalina.core.NamingContextListener.addResource(NamingContextListener.java:1091) at org.apache.catalina.core.NamingContextListener.createNamingContext(NamingContextListener.java:661) at org.apache.catalina.core.NamingContextListener.lifecycleEvent(NamingContextListener.java:249) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:94) at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:785) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.startup.Catalina.start(Catalina.java:670) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:353) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:493) Caused by: java.sql.SQLException: connection error: Connection refused (Connection refused) at com.denodo.vdb.jdbcdriver.dao.DAOVDBProxy.connect(DAOVDBProxy.java:217) at com.denodo.vdb.jdbcdriver.VDBJDBCConnection.getConnection(VDBJDBCConnection.java:127) at com.denodo.vdb.jdbcdriver.VDBJDBCDriver.connect(VDBJDBCDriver.java:202) at org.apache.tomcat.dbcp.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:262) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2352) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2338) ... 23 more 22-Oct-2019 18:29:08.568 WARNING [main] org.apache.catalina.core.NamingContextListener.addResource Failed to register in JMX: [javax.naming.NamingException: Cannot create PoolableConnectionFactory (connection error: Connection refused (Connection refused))] 22-Oct-2019 18:29:08.586 WARNING [main] org.apache.naming.NamingContext.lookup Unexpected exception resolving reference java.sql.SQLException: Cannot create PoolableConnectionFactory (connection error: Connection refused (Connection refused)) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2342) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2067) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getLogWriter(BasicDataSource.java:1598) at org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.createDataSource(BasicDataSourceFactory.java:596) at org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance(BasicDataSourceFactory.java:275) at org.apache.naming.factory.FactoryBase.getObjectInstance(FactoryBase.java:94) at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321) at org.apache.naming.NamingContext.lookup(NamingContext.java:840) at org.apache.naming.NamingContext.lookup(NamingContext.java:159) at org.apache.naming.NamingContextBindingsEnumeration.nextElementInternal(NamingContextBindingsEnumeration.java:117) at org.apache.naming.NamingContextBindingsEnumeration.next(NamingContextBindingsEnumeration.java:71) at org.apache.naming.NamingContextBindingsEnumeration.next(NamingContextBindingsEnumeration.java:34) at org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans(GlobalResourcesLifecycleListener.java:138) at org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans(GlobalResourcesLifecycleListener.java:145) at org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans(GlobalResourcesLifecycleListener.java:110) at org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.lifecycleEvent(GlobalResourcesLifecycleListener.java:82) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:94) at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:395) at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:339) at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:786) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.startup.Catalina.start(Catalina.java:670) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:353) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:493) Caused by: java.sql.SQLException: connection error: Connection refused (Connection refused) at com.denodo.vdb.jdbcdriver.dao.DAOVDBProxy.connect(DAOVDBProxy.java:217) at com.denodo.vdb.jdbcdriver.VDBJDBCConnection.getConnection(VDBJDBCConnection.java:127) at com.denodo.vdb.jdbcdriver.VDBJDBCDriver.connect(VDBJDBCDriver.java:202) at org.apache.tomcat.dbcp.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:262) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2352) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2338) ... 27 more 22-Oct-2019 18:29:08.587 SEVERE [main] org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans Exception processing Global JNDI Resources javax.naming.NamingException: Cannot create PoolableConnectionFactory (connection error: Connection refused (Connection refused)) at org.apache.naming.NamingContext.lookup(NamingContext.java:856) at org.apache.naming.NamingContext.lookup(NamingContext.java:159) at org.apache.naming.NamingContextBindingsEnumeration.nextElementInternal(NamingContextBindingsEnumeration.java:117) at org.apache.naming.NamingContextBindingsEnumeration.next(NamingContextBindingsEnumeration.java:71) at org.apache.naming.NamingContextBindingsEnumeration.next(NamingContextBindingsEnumeration.java:34) at org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans(GlobalResourcesLifecycleListener.java:138) at org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans(GlobalResourcesLifecycleListener.java:145) at org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans(GlobalResourcesLifecycleListener.java:110) at org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.lifecycleEvent(GlobalResourcesLifecycleListener.java:82) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:94) at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:395) at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:339) at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:786) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.startup.Catalina.start(Catalina.java:670) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:353) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:493) 22-Oct-2019 18:29:08.592 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [DenodoPlatform-7.0] 22-Oct-2019 18:29:08.592 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.27 22-Oct-2019 18:29:09.354 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time. 22-Oct-2019 18:29:09.407 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-9090"] 22-Oct-2019 18:29:09.422 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 1238 ms 22-Oct-2019 18:29:09.473 INFO [main] org.apache.catalina.core.StandardServer.await A valid shutdown command was received via the shutdown port. Stopping the Server instance. 22-Oct-2019 18:29:09.473 INFO [main] org.apache.coyote.AbstractProtocol.pause Pausing ProtocolHandler ["http-nio-9090"] 22-Oct-2019 18:29:09.525 INFO [main] org.apache.catalina.core.StandardService.stopInternal Stopping service [DenodoPlatform-7.0] 22-Oct-2019 18:29:09.543 INFO [main] org.apache.coyote.AbstractProtocol.stop Stopping ProtocolHandler ["http-nio-9090"] 22-Oct-2019 18:29:09.547 INFO [main] org.apache.coyote.AbstractProtocol.destroy Destroying ProtocolHandler ["http-nio-9090"] 22-Oct-2019 18:29:11.668 WARNING [main] org.apache.catalina.startup.SetAllPropertiesRule.begin [SetAllPropertiesRule]{Server/Service/Connector} Setting property 'redirectPort' to '' did not find a matching property. 22-Oct-2019 18:29:11.745 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.27 22-Oct-2019 18:29:11.745 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Jan 18 2018 20:12:40 UTC 22-Oct-2019 18:29:11.745 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.27.0 22-Oct-2019 18:29:11.745 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux 22-Oct-2019 18:29:11.745 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 3.10.0-957.21.3.el7.x86_64 22-Oct-2019 18:29:11.745 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64 22-Oct-2019 18:29:11.745 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /opt/denodo/jre 22-Oct-2019 18:29:11.745 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_162-b12 22-Oct-2019 18:29:11.745 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation 22-Oct-2019 18:29:11.745 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /opt/denodo/resources/apache-tomcat 22-Oct-2019 18:29:11.745 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /opt/denodo/resources/apache-tomcat 22-Oct-2019 18:29:11.746 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/opt/denodo/resources/apache-tomcat/conf/logging.properties 22-Oct-2019 18:29:11.746 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 22-Oct-2019 18:29:11.746 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1024m 22-Oct-2019 18:29:11.746 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.tomcat.util.buf.UDecoder.ALLOW_ENCODED_SLASH=true 22-Oct-2019 18:29:11.746 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.connector.CoyoteAdapter.ALLOW_BACKSLASH=true 22-Oct-2019 18:29:11.746 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048 22-Oct-2019 18:29:11.746 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
user
22-10-2019 14:41:39 -0400

1 Answer

Hi, The ''Cannot create PoolableConnectionFactory (connection error: Connection refused)'' error usually occurs when there is a Network connectivity issue or if the ports required by the Denodo Platform is already in use by some other applications. For more information, you can refer to the similar community question [Data Catalog tomcat issue](https://community.denodo.com/answers/question/details?questionId=9060g000000XfDvAAK&title=Data+Catalog+tomcat+issue). Hope this helps!
Denodo Team
23-10-2019 08:37:52 -0400
You must sign in to add an answer. If you do not have an account, you can register here