Skip to main content

Error configuring Cluster in Management Console

  • September 23, 2014
  • 5 replies
  • 15 views

Eqtconsulting
Forum|alt.badge.img+1
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,

5 replies

Prasanta_Pal
Forum|alt.badge.img
  • Participating Frequently
  • September 24, 2014
Did you try as user root or used sudo for dbadmin?
if you are as root
$rpm -Uvh vertica-console-<current-version>.x86_64.RHEL5.rpm
or else if you are other user ( who has root access)
$sudo
rpm -Uvh vertica-console-<current-version>.x86_64.RHEL5.rpm 

Eqtconsulting
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • September 24, 2014
Hi, I used sudo for dbadmin (with root access).

Could this be a problem?


Prasanta_Pal
Forum|alt.badge.img
  • Participating Frequently
  • September 24, 2014
That should be ok, but you may review all the requirements for MC
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?

Eqtconsulting
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • September 24, 2014
Hi,

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,


Prasanta_Pal
Forum|alt.badge.img
  • Participating Frequently
  • September 24, 2014
Other option could be
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'