Error configuring Cluster in Management Console
I have verified I can ssh as dbadmin without providing a password.
But when I try to "validate Hosts" in the Manage Console (MC) It show this error:
Validate hosts failed. Reason: SqlMapClient operation; SQL[];--- The error occurred in create-cluster-step-sqlmap.xml.--- The error occurred while applying a parameter map.--- Check the createClusterStep.deleteByHostId-InlineParameterMap.--- Check the statement (update failed).--- Cause: java.sql.SQLTransactionRollbackException: Container was opened in read-only mode.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:--- The error occurred in create-cluster-step-sqlmap.xml.--- The error occurred while applying a parameter map.--- Check the createClusterStep.deleteByHostId-InlineParameterMap.--- Check the statement (update failed).--- Cause: java.sql.SQLTransactionRollbackException: Container was opened in read-only mode.
In "Show Detail" it show another error:
Success: Test: Validating Ping: INFO: Ping succeeded.
Error: Test: Validating SSH connection: ERROR: athentication failed for user root. Could be because SELinux is enabled on the host OR a wrong private key is being used. If the problem still persists, please contact your administrator or HP/Vertica support.
My question is: why this second error indicates "failed for user root"? The default user is dbadmin, and I have configure ssh by dbadmin.
I hope you can help me.
Thanks,
But when I try to "validate Hosts" in the Manage Console (MC) It show this error:
Validate hosts failed. Reason: SqlMapClient operation; SQL[];--- The error occurred in create-cluster-step-sqlmap.xml.--- The error occurred while applying a parameter map.--- Check the createClusterStep.deleteByHostId-InlineParameterMap.--- Check the statement (update failed).--- Cause: java.sql.SQLTransactionRollbackException: Container was opened in read-only mode.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:--- The error occurred in create-cluster-step-sqlmap.xml.--- The error occurred while applying a parameter map.--- Check the createClusterStep.deleteByHostId-InlineParameterMap.--- Check the statement (update failed).--- Cause: java.sql.SQLTransactionRollbackException: Container was opened in read-only mode.
In "Show Detail" it show another error:
Success: Test: Validating Ping: INFO: Ping succeeded.
Error: Test: Validating SSH connection: ERROR: athentication failed for user root. Could be because SELinux is enabled on the host OR a wrong private key is being used. If the problem still persists, please contact your administrator or HP/Vertica support.
My question is: why this second error indicates "failed for user root"? The default user is dbadmin, and I have configure ssh by dbadmin.
I hope you can help me.
Thanks,
0
Comments
$sudo
Could this be a problem?
http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/InstallationGuide/InstallingMC/BeforeYouIn...
Are you using a dedicated MC server or it is installed in one of the node?
I have reviewed the requirements several times but the problem persist.
The MC is installed in one of the node.
Do you know what could be causing these errors?
Thanks,
logon the node where MC is installed as root and try to do ssh from that node to other nodes, if it asks for "RSA key fingerprint" select 'yes'