Connect to Cluster from MC Console

ckotsidimos

I have installed the MC console on my system and I want to connect to a database. When I enter the IP and password, I get the message that says, Failed to retrieve databases from xx.xx.xx.xx Reason: Connection to host has been Lost. In the log I get the following messages ERROR DbAdminController java.lang.Exception: Connection to the host has been lost at com.vertica.admin.tools.webui.service.AgentConnectionServiceImpl.getDBs(AgentConnectionServiceImpl.java:371) at com.vertica.admin.tools.webui.controllers.DbAdminController.getDB(DbAdminController.java:651) at com.vertica.admin.tools.webui.controllers.DbAdminController.importDB(DbAdminController.java:575) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:427) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:415) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:788) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:717) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:547) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:480) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:520) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:941) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:409) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:875) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:241) at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:115) at com.vertica.admin.tools.webui.servlets.VuiWebSocketServlet.forwardToDispatcher(VuiWebSocketServlet.java:61) at com.vertica.admin.tools.webui.servlets.VuiWebSocketServlet.doGet(VuiWebSocketServlet.java:39) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at org.eclipse.jetty.websocket.WebSocketServlet.service(WebSocketServlet.java:80) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:547) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1359) at org.spring... 30 Jul 2013 15:06:50 ERROR DbAdminController getDB>> Exception while getting database information from xx.xx.xx.xx: Connection to the host has been lost 30 Jul 2013 15:06:50 ERROR AgentConnectionServiceImpl getDBs>> Error response from agent. transferObject: TransferObject [success=false, messageCode=0, messageStr=Connection to the host has been lost, obj=null] 30 Jul 2013 15:06:50 WARN AgentConnectionServiceImpl executeCommandWithRetry>> cluster is null, is this while importing (connecting to) a database Can you help?

[Deleted User]

Hi,

A few things to check:

1. If MC's internal DB is running.

Check on MC machine, if vertica process is running:

$ ps -ef | grep vertica

You should show a Vertica database process as below:

 /opt/vertica/bin/vertica -C <db name> -D <catalog directory path> -h <host IP> -p <port number>

2. Check if Vertica agent is runnin on all database cluster nodes. 

$ service vertica_agent status

If agent are not running, start them:

$ service vertica_agent start

3. MC machine can access port 5444 on Vertica nodes.

telnel port 5444 from MC --> Vertica node

4. Nodes can access port 5444 on other nodes in the cluster

5. All database nodes can access port 5450 on MC server.

telnet port 5450 from Node(s) --> MC 


Thanks,
Pravesh

ckotsidimos

1) It is OK 2) In the nodes I get: No RPM: no package provides vertica [Failed] 3) I'm fixing it 4) I'm fixing it Can you help on 2?

Raul_1

On the cluster nodes:

Check if they are listening on port 5444:
# netstat -an | grep 5444

If not, restart the Vertifca Agent on the node:
# sudo /etc/init.d/vertica_agent restart

ckotsidimos

The problem that I had, was with agent start and a check it was running!! Solved and now working fine!!!

Rinkesh_Jajpuri

Thanks a lot its really help me to figure out the problem