Not able to connect to a database from management console

saumya_tamma

Hi, I am trying to connect to a database from management console but it is not allowing it and fails with the following error. The database is running on the cluster. 22 Aug 2013 14:24:45,151 [MCThread-1377206684124] AgentConnectionServiceImpl WARN - Agent Response Not OK: 400 22 Aug 2013 14:24:45,151 [MCThread-1377206684124] AgentConnectionServiceImpl INFO - getIpBeingTried>> !*!*!*!*! could not connect to 15.224.232.62 (from agentconn) 22 Aug 2013 14:24:45,153 [MCThread-1377206684124] AgentConnectionServiceImpl ERROR - getVerticaDbConfigs>> Error response from agent. transferObject: missing password parameter 22 Aug 2013 14:24:45,157 [MCThread-1377206684124] AgentConnectionServiceImpl INFO - theCommand = https://15.224.232.62:5444/hosts?only=hostname,host_id,nics.name,nics.ipaddr,total_memory,cpu_info.number_of_cpus,cpu_info.cpu_type,vertica httpMethod:GET 22 Aug 2013 14:24:45,554 [MCThread-1377206684124] AgentConnectionServiceImpl INFO - getIpBeingTried>> !*!*!*!*! could not connect to 15.224.232.62 (from agentconn) 22 Aug 2013 14:24:45,565 [MCThread-1377206684124] AgentConnectionServiceImpl INFO - theCommand = https://15.224.232.62:5444/databases/VERLABQA01/hosts httpMethod:GET 22 Aug 2013 14:24:46,036 [MCThread-1377206684124] AgentConnectionServiceImpl INFO - getIpBeingTried>> !*!*!*!*! could not connect to 15.224.232.62 (from agentconn) 22 Aug 2013 14:24:46,046 [MCThread-1377206684124] DatabaseDaoImpl INFO - in dbDao insertdb, db:Database [id=0, name=VERLABQA01, removed=false, port=5433, status=UP, prevStatus=null, password=[dummypwd], k_safety=0, cluster_id=0, pwd_validated=false, readOnly=false, running_job_id=null, flags= 0, insert_time=null, create_time=null, create_elapse_time=null, last_updated_time=null, cluster=Cluster [id=3, name=1377206686043_cluster, agentConnection=null, create_time=2013-08-22 14:24:46.044, last_updated_time=2013-08-22 14:24:46.044 nodes=[]], nodes=null, hosts=null, currentlyRunningOperation=null, showMessage=false, messageToShow=null, agentJobMessageId=0, error=false, passwordValidationPromptRequired=false] 22 Aug 2013 14:24:46,049 [MCThread-1377206684124] HostDaoImpl INFO - -->insertNew, host:Host [id=0, name=msalb002qvdb01.ast.lab, ip=1.1.51.2, status=VALIDATED, clusterName=1377206686043_cluster, standby=false, agentStatus=null, verticaRelease=0, verticaVersion=6.1.2, verticaBrand=vertica, verticaArch=x86_64, cpuCount=32, cpuType= Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz, totalMemory=258295, nics=[{"name":"bond0","ipaddr":""}, {"name":"bond0.27","ipaddr":"15.224.232.62"}, {"name":"bond0.751","ipaddr":"1.1.51.2"}, {"name":"eth2","ipaddr":""}, {"name":"eth3","ipaddr":""}], create_time=null, last_updated_time=null, nodes=[Node [id=0, name=v_verlabqa01_node0001, status=UP, host_ip=1.1.51.2, statusText=, validationMaxStep=1, validationCurrStep=1, agentOperation=null, showMessage=false, messageToShow=null, agentJobMessageId=0, error=false, create_time=null, last_updated_time=null]], agentOperation=null, statusText=null, showMessage=false, messageToShow=null, agentJobMessageId=0, error=false] 22 Aug 2013 14:24:46,051 [MCThread-1377206684124] HostDaoImpl INFO - -->insertNew, host:Host [id=0, name=msalb002qvdb02.ast.lab, ip=1.1.51.3, status=VALIDATED, clusterName=1377206686043_cluster, standby=false, agentStatus=null, verticaRelease=0, verticaVersion=6.1.2, verticaBrand=vertica, verticaArch=x86_64, cpuCount=32, cpuType= Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz, totalMemory=258295, nics=[{"name":"bond0","ipaddr":""}, {"name":"bond0.27","ipaddr":"15.224.232.63"}, {"name":"bond0.751","ipaddr":"1.1.51.3"}, {"name":"eth2","ipaddr":""}, {"name":"eth3","ipaddr":""}], create_time=null, last_updated_time=null, nodes=[Node [id=0, name=v_verlabqa01_node0002, status=UP, host_ip=1.1.51.3, statusText=, validationMaxStep=1, validationCurrStep=1, agentOperation=null, showMessage=false, messageToShow=null, agentJobMessageId=0, error=false, create_time=null, last_updated_time=null]], agentOperation=null, statusText=null, showMessage=false, messageToShow=null, agentJobMessageId=0, error=false] 22 Aug 2013 14:24:46,053 [MCThread-1377206684124] HostDaoImpl INFO - -->insertNew, host:Host [id=0, name=msalb002qvdb03.ast.lab, ip=1.1.51.4, status=VALIDATED, clusterName=1377206686043_cluster, standby=false, agentStatus=null, verticaRelease=0, verticaVersion=6.1.2, verticaBrand=vertica, verticaArch=x86_64, cpuCount=32, cpuType= Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz, totalMemory=258295, nics=[{"name":"bond0","ipaddr":""}, {"name":"bond0.27","ipaddr":"15.224.232.64"}, {"name":"bond0.751","ipaddr":"1.1.51.4"}, {"name":"eth2","ipaddr":""}, {"name":"eth3","ipaddr":""}], create_time=null, last_updated_time=null, nodes=[Node [id=0, name=v_verlabqa01_node0003, status=UP, host_ip=1.1.51.4, statusText=, validationMaxStep=1, validationCurrStep=1, agentOperation=null, showMessage=false, messageToShow=null, agentJobMessageId=0, error=false, create_time=null, last_updated_time=null]], agentOperation=null, statusText=null, showMessage=false, messageToShow=null, agentJobMessageId=0, error=false] 22 Aug 2013 14:24:46,142 [MCThread-1377206684124] AgentConnectionServiceImpl INFO - theCommand = https://15.224.232.62:5444/databases/VERLABQA01/license?passwd=[dummypwd] httpMethod:GET 22 Aug 2013 14:24:46,195 [MCThread-1377206684124] AgentConnectionServiceImpl WARN - Agent Response Not OK: 400 22 Aug 2013 14:24:46,195 [MCThread-1377206684124] AgentConnectionServiceImpl INFO - getIpBeingTried>> !*!*!*!*! could not connect to 15.224.232.62 (from agentconn) 22 Aug 2013 14:24:46,215 [MCThread-1377206684124] AgentConnectionServiceImpl ERROR - processErrorAndGenerateAlert>> Agent's response was not a success once. Message: missing password parameter 22 Aug 2013 14:24:46,223 [MCThread-1377206684124] RepositoryAccessServiceImpl INFO - removeCluster>> removing data for cluster:Cluster [id=3, name=1377206686043_cluster, agentConnection=null, create_time=2013-08-22 14:24:46.044, last_updated_time=2013-08-22 14:24:46.044 nodes=[]]

Daniel_Leybovic

hi! missing password: ERROR - getVerticaDbConfigs>> Error response from agent. transferObject: missing password parameter

saumya_tamma

Hi, I dont understand. Can you please help me know how to fix this? Thanks saumya