You can translate the question and the replies:

Diagnostic & Monitoring Tool: Unable to connect to VDP server with Token

Hi, I'm trying to connect to one of the VDP Server using Diagnostic and Monitoring Tool from SolutionManager. I get below error `Unable to connect to VDP server '10.x.0.x-nonprod' (admin@10.x.0.x:9999/admin with Token): Cannot connect to server '10.x.0.x-nonprod' (admin@10.x.0.x:9999/admin)` We have SolutionManager and VDP nodes running on its own servers. The VDP servers have below SSO config setup in SSOConfiguration.properties file ` https://solution-manager.nonprod.denodo.mydomain.com:443 sso.enabled=true sso.token-enabled=true ` We port map 443 to 19443 on Solution manager LB. Is there something we are missing in terms of configuration on SolutionManager end? Looking at the SolutionManager logs we found ==> vdp-dmt/vdp-dmt.log <== 516029156 [https-jsse-nio2-19443-exec-19] ERROR 2022-07-07T10:43:56.367 LoggedServerServiceImpl [] - Unexpected error executing ping on server &apos;10.x.0.x-nonprod&apos; (admin@10.x.0.x:9999&#x2F;admin) com.denodo.dashboard.business.service.exception.DashboardException: Unable to connect to VDP server '10.195.0.156-nonprod' (admin@10.x.0.x:9999/admin with Token): Cannot connect to server '10.x.0.x-nonprod' (admin@10.x.0.x:9999/admin) at com.denodo.dashboard.business.service.server.impl.ServerServiceImpl.ping(ServerServiceImpl.java:46) ~[classes/:8.0.3] at com.denodo.dashboard.business.service.server.impl.ValidatedServerServiceImpl.ping(ValidatedServerServiceImpl.java:38) ~[classes/:8.0.3] at com.denodo.dashboard.business.service.server.impl.LoggedServerServiceImpl.ping(LoggedServerServiceImpl.java:38) [classes/:8.0.3] at com.denodo.dashboard.web.controller.MonitoringPageController.doGetTimezone(MonitoringPageController.java:977) [classes/:8.0.3] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) [spring-web-5.2.20.RELEASE.jar:5.2.20.RELEASE] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) [spring-web-5.2.20.RELEASE.jar:5.2.20.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) [spring-webmvc-5.2.20.RELEASE.jar:5.2.20.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878) [spring-webmvc-5.2.20.RELEASE.jar:5.2.20.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792) [spring-webmvc-5.2.20.RELEASE.jar:5.2.20.RELEASE] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) [spring-webmvc-5.2.20.RELEASE.jar:5.2.20.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1043) [spring-webmvc-5.2.20.RELEASE.jar:5.2.20.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) [spring-webmvc-5.2.20.RELEASE.jar:5.2.20.RELEASE] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) [spring-webmvc-5.2.20.RELEASE.jar:5.2.20.RELEASE] at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) [spring-webmvc-5.2.20.RELEASE.jar:5.2.20.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [servlet-api.jar:4.0.FR] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) [spring-webmvc-5.2.20.RELEASE.jar:5.2.20.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) [servlet-api.jar:4.0.FR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [catalina.jar:9.0.56] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.56] at com.denodo.webapp.security.sso.filter.ForwardedHeaderConditionalFilter.doFilter(ForwardedHeaderConditionalFilter.java:83) [denodo-security-sso-web-lib-8.0.3-SNAPSHOT.jar:8.0.3] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358) [spring-web-5.2.20.RELEASE.jar:5.2.20.RELEASE] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271) [spring-web-5.2.20.RELEASE.jar:5.2.20.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.56] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.56] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:9.0.56] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.56] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.56] at org.apache.catalina.filters.HttpHeaderSecurityFilter.doFilter(HttpHeaderSecurityFilter.java:126) [catalina.jar:9.0.56] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.56] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.56] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) [spring-web-5.2.20.RELEASE.jar:5.2.20.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.2.20.RELEASE.jar:5.2.20.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.56] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.56] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [catalina.jar:9.0.56] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:9.0.56] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:659) [catalina.jar:9.0.56] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [catalina.jar:9.0.56] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.56] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:9.0.56] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) [catalina.jar:9.0.56] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382) [tomcat-coyote.jar:9.0.56] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.56] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895) [tomcat-coyote.jar:9.0.56] at org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.doRun(Nio2Endpoint.java:1690) [tomcat-coyote.jar:9.0.56] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.56] at org.apache.tomcat.util.net.AbstractEndpoint.processSocket(AbstractEndpoint.java:1176) [tomcat-coyote.jar:9.0.56] at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:622) [tomcat-coyote.jar:9.0.56] at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:600) [tomcat-coyote.jar:9.0.56] at org.apache.tomcat.util.net.SecureNio2Channel$1.completed(SecureNio2Channel.java:1020) [tomcat-coyote.jar:9.0.56] at org.apache.tomcat.util.net.SecureNio2Channel$1.completed(SecureNio2Channel.java:948) [tomcat-coyote.jar:9.0.56] at sun.nio.ch.Invoker.invokeUnchecked(Invoker.java:127) [?:?] at sun.nio.ch.Invoker$2.run(Invoker.java:219) [?:?] at sun.nio.ch.AsynchronousChannelGroupImpl$1.run(AsynchronousChannelGroupImpl.java:112) [?:?] at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:9.0.56] at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:9.0.56] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.56] at java.lang.Thread.run(Thread.java:834) [?:?] Caused by: com.denodo.dashboard.business.service.exception.DashboardException: Cannot connect to server '10.195.0.156-nonprod' (admin@10.195.0.156:9999/admin) at com.denodo.dashboard.business.connection.ConnectionManager.testDashboardConnection(ConnectionManager.java:324) ~[classes/:8.0.3] at com.denodo.dashboard.business.service.server.impl.ServerServiceImpl.ping(ServerServiceImpl.java:39) ~[classes/:8.0.3] ... 61 more Caused by: java.util.concurrent.TimeoutException at java.util.concurrent.FutureTask.get(FutureTask.java:204) ~[?:?] at com.denodo.dashboard.business.connection.ConnectionManager.testDashboardConnection(ConnectionManager.java:312) ~[classes/:8.0.3] at com.denodo.dashboard.business.service.server.impl.ServerServiceImpl.ping(ServerServiceImpl.java:39) ~[classes/:8.0.3] ... 61 more
user
07-07-2022 09:34:32 -0400

3 Answers

Hello, I was able to reproduce the error on my end, the error may have been caused due to a different host name for the VDP server in the “registryURL” property of the “VDBConfiguration.properties” file from * <Denodo-Home>\conf\vdp folder Can you try setting the registryURL property to localhost as follows: * com.denodo.vdb.vdbinterface.server.VDBManagerImpl.registryURL= localhost Please restart the server after updating the VDBConfiguration.properties file. Once restarted, check if you are able to connect from the Diagnostic & Monitoring tool. Hope this helps!
Denodo Team
07-07-2022 17:16:00 -0400
Hi, Thanks for looking into the issue. Glad it can be reproduced. I have checked the VDBConfiguration.properties file on the target VDP server the DMT tool is connecting to. The registryURL is already set to localhost. Below is the config [root@ip-10-195-0-156 vdp]# cat VDBConfiguration.properties | grep com.denodo.vdb.vdbinterface.server.VDBManagerImpl `#com.denodo.vdb.vdbinterface.server.VDBManagerImpl.hostName=localhost com.denodo.vdb.vdbinterface.server.VDBManagerImpl.port=9999 com.denodo.vdb.vdbinterface.server.VDBManagerImpl.shutdownPort=9998 com.denodo.vdb.vdbinterface.server.VDBManagerImpl.odbcPort=9996 com.denodo.vdb.vdbinterface.server.VDBManagerImpl.registryURL=localhost com.denodo.vdb.vdbinterface.server.VDBManagerImpl.registryPort=9997 com.denodo.vdb.vdbinterface.server.VDBManagerImpl.factoryPort=9995 com.denodo.vdb.vdbinterface.server.VDBManagerImpl.iconRoute=/opt/denodo-platform/resources/vdp/ico com.denodo.vdb.vdbinterface.server.VDBManagerImpl.maxWorkers=0 com.denodo.vdb.vdbinterface.server.VDBManagerImpl.rmiMinWorkers=4 com.denodo.vdb.vdbinterface.server.VDBManagerImpl.rmiMaxWorkers=100 com.denodo.vdb.vdbinterface.server.VDBManagerImpl.rmiWorkerTimeout=10 com.denodo.vdb.vdbinterface.server.VDBManagerImpl.refreshMetadataPeriod = 60 com.denodo.vdb.vdbinterface.server.VDBManagerImpl.refreshMBeansPeriod = 0 com.denodo.vdb.vdbinterface.server.VDBManagerImpl.runtimeRegistryPort=9999 com.denodo.vdb.vdbinterface.server.VDBManagerImpl.runtimeShutdownPort=9998 `
user
08-07-2022 04:34:58 -0400
Hi, I think I figured out the issue, the jmx port was not open from the VDP server, once we open it the login issue is resolved and can see metrics in DMT tool. Thanks for your time to look into this.
user
08-07-2022 09:30:03 -0400
You must sign in to add an answer. If you do not have an account, you can register here