You can translate the question and the replies:

Denodo Server after Installation error

I installed the denodo server and started service after setting up SSL. THe srevice say's running. But i amnot able access the datacatalog and VDP server. Then check logs of VDP. Below error found in VDP.log 5484 [Thread-3] TRACE 2019-10-19T00:43:53.766 com.denodo.util.security.DenodoRMISocketFactory [] - Enter method createSocket(host = localhost, port = 9098) 5484 [Thread-3] DEBUG 2019-10-19T00:43:53.766 com.denodo.util.security.DenodoRMISocketFactory [] - createSocket(host, port): id = 'localhost:9098', currentSSL = false; currentReuseSockets = true; currentHostSocketIds = [] 5524 [main] TRACE 2019-10-19T00:43:53.806 com.denodo.vdb.catalog.CatalogCache [] - retrieveServer(String) - start 5524 [main] DEBUG 2019-10-19T00:43:53.806 com.denodo.util.cache.MapCache [] - Cache success ... server=null 5524 [main] TRACE 2019-10-19T00:43:53.806 com.denodo.vdb.catalog.CatalogCache [] - retrieveServer(String) - end 5525 [main] TRACE 2019-10-19T00:43:53.807 com.denodo.vdb.catalog.storage.DBDerbyStorageManager [] - load(server, 6, Connection) - start 5531 [main] TRACE 2019-10-19T00:43:53.813 com.denodo.vdb.catalog.storage.DBDerbyStorageManager [] - Executing query to load the object: 'SELECT bin_data FROM server WHERE id = ?' with parameter 'server'. 5531 [main] TRACE 2019-10-19T00:43:53.813 com.denodo.vdb.catalog.CatalogCache [] - storeServer(MetaServer) - start 5532 [main] DEBUG 2019-10-19T00:43:53.814 com.denodo.util.cache.MapCache [] - Storing object 'server'='com.denodo.vdb.catalog.server.MetaServer@37637a24' 5532 [main] TRACE 2019-10-19T00:43:53.814 com.denodo.vdb.engine.session.DBSession [] - Cache not used for object: server.server 5533 [main] TRACE 2019-10-19T00:43:53.815 com.denodo.vdb.catalog.storage.DBDerbyStorageManager [] - loadAllNames(5, Connection) - start 5541 [main] TRACE 2019-10-19T00:43:53.823 com.denodo.vdb.catalog.storage.DBDerbyStorageManager [] - loadAllNames(5, Connection) - end 5545 [ODBCListener] INFO 2019-10-19T00:43:53.827 com.denodo.vdb.vdbinterface.server.odbc.ODBCListener [] - ODBC connections listener started in port 9996 5546 [main] DEBUG 2019-10-19T00:43:53.828 com.denodo.vdb.vdbinterface.server.VDBManagerImpl [] - Starting JMS listeners. 5546 [main] TRACE 2019-10-19T00:43:53.828 com.denodo.vdb.catalog.storage.DBDerbyStorageManager [] - loadAllNames(1, Connection) - start 5546 [main] TRACE 2019-10-19T00:43:53.828 com.denodo.vdb.catalog.storage.DBDerbyStorageManager [] - loadAllNames(1, Connection) - end 5547 [main] TRACE 2019-10-19T00:43:53.829 com.denodo.vdb.catalog.CatalogCache [] - retrieveDatabase(String) - start 5547 [main] DEBUG 2019-10-19T00:43:53.829 com.denodo.util.cache.MapCache [] - Cache success ... admin=com.denodo.vdb.catalog.database.Database@70730db 5548 [main] TRACE 2019-10-19T00:43:53.830 com.denodo.vdb.catalog.CatalogCache [] - retrieveDatabase(String) - end 5548 [main] TRACE 2019-10-19T00:43:53.830 com.denodo.vdb.engine.session.DBSession [] - Cache not used for object: database.admin 5548 [main] TRACE 2019-10-19T00:43:53.830 com.denodo.vdb.catalog.CatalogCache [] - retrieveDatabase(String) - start 5548 [main] DEBUG 2019-10-19T00:43:53.830 com.denodo.util.cache.MapCache [] - Cache success ... itpilot=com.denodo.vdb.catalog.database.Database@6f1a16fe 5548 [main] TRACE 2019-10-19T00:43:53.830 com.denodo.vdb.catalog.CatalogCache [] - retrieveDatabase(String) - end 5548 [main] TRACE 2019-10-19T00:43:53.830 com.denodo.vdb.engine.session.DBSession [] - Cache not used for object: database.itpilot 6578 [Thread-3] WARN 2019-10-19T00:43:54.860 com.denodo.tomcat.manager.TomcatManager [] - TomcatManager.deploy[/denodo-restfulws] javax.management.InstanceNotFoundException: DenodoPlatform-7.0:type=Deployer,host=localhost at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.getMBean(DefaultMBeanServerInterceptor.java:1095) ~[?:1.8.0_162] at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.getClassLoaderFor(DefaultMBeanServerInterceptor.java:1444) ~[?:1.8.0_162] at com.sun.jmx.mbeanserver.JmxMBeanServer.getClassLoaderFor(JmxMBeanServer.java:1324) ~[?:1.8.0_162] at javax.management.remote.rmi.RMIConnectionImpl$6.run(RMIConnectionImpl.java:1365) ~[?:1.8.0_162] at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_162] at javax.management.remote.rmi.RMIConnectionImpl.getClassLoaderFor(RMIConnectionImpl.java:1362) ~[?:1.8.0_162] at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:813) ~[?:1.8.0_162] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_162] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_162] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_162] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_162] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:361) ~[?:1.8.0_162] at sun.rmi.transport.Transport$1.run(Transport.java:200) ~[?:1.8.0_162] at sun.rmi.transport.Transport$1.run(Transport.java:197) ~[?:1.8.0_162] at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_162] at sun.rmi.transport.Transport.serviceCall(Transport.java:196) ~[?:1.8.0_162] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:568) ~[?:1.8.0_162] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:826) ~[?:1.8.0_162] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:683) ~[?:1.8.0_162] at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_162] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:682) ~[?:1.8.0_162] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_162] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_162] at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_162] at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:283) ~[?:1.8.0_162] at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:260) ~[?:1.8.0_162] at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:161) ~[?:1.8.0_162] at com.sun.jmx.remote.internal.PRef.invoke(Unknown Source) ~[?:?] at javax.management.remote.rmi.RMIConnectionImpl_Stub.invoke(Unknown Source) ~[?:1.8.0_162] at javax.management.remote.rmi.RMIConnector$RemoteMBeanServerConnection.invoke(RMIConnector.java:1020) ~[?:1.8.0_162] at com.denodo.tomcat.manager.TomcatManager.removeServiced(TomcatManager.java:793) ~[denodo-tomcat.jar:7.0.0] at com.denodo.tomcat.manager.TomcatManager.deploy(TomcatManager.java:663) [denodo-tomcat.jar:7.0.0] at com.denodo.tomcat.manager.TomcatManager.startTomcat(TomcatManager.java:301) [denodo-tomcat.jar:7.0.0] at com.denodo.vdb.management.tomcat.VDPTomcatManagement$1.run(Unknown Source) [denodo-vdp-server.jar:7.0.0] 6588 [Thread-3] INFO 2019-10-19T00:43:54.870 com.denodo.tomcat.manager.TomcatManager [] - 'denodo-restfulws' has not been deployed. 6908 [Thread-3] WARN 2019-10-19T00:43:55.190 com.denodo.tomcat.manager.TomcatManager [] - java.rmi.ConnectException: Connection refused to host: localhost; nested exception is: java.net.ConnectException: Connection refused (Connection refused) 6909 [Thread-3] TRACE 2019-10-19T00:43:55.191 com.denodo.util.security.DenodoRMISocketFactory [] - Enter method setSsl(ssl = false, reuseSockets = true, hostSocketIds =[]) 6909 [Thread-3] TRACE 2019-10-19T00:43:55.191 com.denodo.util.security.DenodoRMISocketFactory [] - Exit method setSsl(ssl = false, reuseSockets = true, hostSocketIds =[]) 6909 [Thread-3] TRACE 2019-10-19T00:43:55.191 com.denodo.util.security.DenodoRMISocketFactory [] - Enter method createSocket(host = localhost, port = 9098) 6909 [Thread-3] DEBUG 2019-10-19T00:43:55.191 com.denodo.util.security.DenodoRMISocketFactory [] - createSocket(host, port): id = 'localhost:9098', currentSSL = false; currentReuseSockets = true; currentHostSocketIds = [] 6909 [Thread-3] DEBUG 2019-10-19T00:43:55.191 com.denodo.util.security.DenodoRMISocketFactory [] - A socket could not be created java.net.ConnectException: Connection refused (Connection refused) at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:1.8.0_162] at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) ~[?:1.8.0_162] at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[?:1.8.0_162] at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[?:1.8.0_162] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:1.8.0_162] at java.net.Socket.connect(Socket.java:589) ~[?:1.8.0_162] at java.net.Socket.connect(Socket.java:538) ~[?:1.8.0_162] at java.net.Socket.<init>(Socket.java:434) ~[?:1.8.0_162] at java.net.Socket.<init>(Socket.java:211) ~[?:1.8.0_162] at sun.rmi.transport.proxy.RMIDirectSocketFactory.createSocket(RMIDirectSocketFactory.java:40) ~[?:1.8.0_162] at sun.rmi.transport.proxy.RMIMasterSocketFactory.createSocket(RMIMasterSocketFactory.java:148) ~[?:1.8.0_162] at com.denodo.util.security.DenodoRMISocketFactory.createSocket(DenodoRMISocketFactory.java:145) [denodo-commons-util-web.jar:7.0.0] at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:613) [?:1.8.0_162] at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:216) [?:1.8.0_162] at sun.rmi.transport.tcp.TCPChannel.newConnection(TCPChannel.java:202) [?:1.8.0_162] at sun.rmi.server.UnicastRef.newCall(UnicastRef.java:338) [?:1.8.0_162] at sun.rmi.registry.RegistryImpl_Stub.lookup(RegistryImpl_Stub.java:112) [?:1.8.0_162] at com.denodo.tomcat.manager.TomcatManager.getConnector(TomcatManager.java:848) [denodo-tomcat.jar:7.0.0] at com.denodo.tomcat.manager.TomcatManager.initMBeanServer(TomcatManager.java:255) [denodo-tomcat.jar:7.0.0] at com.denodo.tomcat.manager.TomcatManager.checkServerStarted(TomcatManager.java:418) [denodo-tomcat.jar:7.0.0] at com.denodo.tomcat.manager.TomcatManager.isTomcatStarted(TomcatManager.java:251) [denodo-tomcat.jar:7.0.0] at com.denodo.tomcat.manager.TomcatManager.deploy(TomcatManager.java:641) [denodo-tomcat.jar:7.0.0] at com.denodo.tomcat.manager.TomcatManager.startTomcat(TomcatManager.java:301) [denodo-tomcat.jar:7.0.0] at com.denodo.vdb.management.tomcat.VDPTomcatManagement$1.run(Unknown Source) [denodo-vdp-server.jar:7.0.0] 6910 [Thread-3] TRACE 2019-10-19T00:43:55.192 com.denodo.util.security.DenodoRMISocketFactory [] - Enter method setSsl(ssl = true, reuseSockets = true, hostSocketIds =[]) 6910 [Thread-3] TRACE 2019-10-19T00:43:55.192 com.denodo.util.security.DenodoRMISocketFactory [] - Exit method setSsl(ssl = true, reuseSockets = true, hostSocketIds =[]) 6910 [Thread-3] TRACE 2019-10-19T00:43:55.192 com.denodo.util.security.DenodoRMISocketFactory [] - Enter method setSsl(ssl = false, reuseSockets = true, hostSocketIds =[]) 6910 [Thread-3] TRACE 2019-10-19T00:43:55.192 com.denodo.util.security.DenodoRMISocketFactory [] - Exit method setSsl(ssl = false, reuseSockets = true, hostSocketIds =[]) 6910 [Thread-3] INFO 2019-10-19T00:43:55.192 com.denodo.tomcat.manager.TomcatManager [] - 'denodo-odata4-service' has not been deployed. 6910 [Thread-3] WARN 2019-10-19T00:43:55.192 com.denodo.tomcat.manager.TomcatManager [] - java.lang.NullPointerException 6910 [Thread-3] TRACE 2019-10-19T00:43:55.192 com.denodo.util.security.DenodoRMISocketFactory [] - Enter method setSsl(ssl = false, reuseSockets = true, hostSocketIds =[]) 6910 [Thread-3] TRACE 2019-10-19T00:43:55.192 com.denodo.util.security.DenodoRMISocketFactory [] - Exit method setSsl(ssl = false, reuseSockets = true, hostSocketIds =[]) 6910 [Thread-3] TRACE 2019-10-19T00:43:55.192 com.denodo.util.security.DenodoRMISocketFactory [] - Enter method createSocket(host = localhost, port = 9098) 6910 [Thread-3] DEBUG 2019-10-19T00:43:55.192 com.denodo.util.security.DenodoRMISocketFactory [] - createSocket(host, port): id = 'localhost:9098', currentSSL = false; currentReuseSockets = true; currentHostSocketIds = [] 6910 [Thread-3] DEBUG 2019-10-19T00:43:55.192 com.denodo.util.security.DenodoRMISocketFactory [] - A socket could not be created java.net.ConnectException: Connection refused (Connection refused) at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:1.8.0_162] Could you please help me
user
18-10-2019 20:51:00 -0400
code

1 Answer

Hi, For this scenario, I would perform the following checks: * Verify the steps mentioned in the following sections of Virtual DataPort Administration Guide. * [Obtaining and Installing an SSL/TLS Certificate](https://community.denodo.com/docs/html/browse/7.0/platform/installation/postinstallation_tasks/enable_ssl_connections_in_the_denodo_platform_servers/obtaining_and_installing_an_ssl_certificate#obtaining-and-installing-an-ssl-tls-certificate) * [Enabling SSL/TLS in Denodo Platform Servers](https://community.denodo.com/docs/html/browse/7.0/platform/installation/postinstallation_tasks/enable_ssl_connections_in_the_denodo_platform_servers/enabling_ssl_in_denodo_platform_servers) * And, the most important one is [Enabling HTTPS in the Embedded Apache Tomcat](https://community.denodo.com/docs/html/browse/7.0/platform/installation/postinstallation_tasks/enable_ssl_connections_in_the_denodo_platform_servers/enabling_https_in_the_embedded_apache_tomcat), since the issue occured when accessing Data Catalog. Ensure to stop all the Denodo Platform Servers, make the necessary changes in the files as mentioned in the above documentation and start the Denodo servers you use. * Make sure that the port "9098" is open and no other process is using this port. Also, port is opened in the firewall. * Check "<Denodo_Home>\logs\vdp-data-catalog\vdp-data-catalog.log" file to get more details about the error. If the issue still persists and if you have a valid Support user account, you could raise a Support case so that the Denodo Support team can help you. Hope this helps !
Denodo Team
21-10-2019 02:25:08 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here