Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Add Service BigSQL failed

Add Service BigSQL failed

All,

I have setup HDPv2.6.1 in Single Node server and adding BigSQL service in Ambari portal failed due to passwordless SSH connection. I setup passwordless ssh for hdpadmin id but root id being used when adding BigSQL service.

Why BigSQL using root id? Appreciate your help.

stderr: /var/lib/ambari-agent/data/errors-304.txt
Permission denied, please try again.
Permission denied, please try again.
Permission denied (publickey,gssapi-keyex,gssapi-with-mic,password).

ERROR: Failed to deploy custom action script. RC = 65280 
Verify the user running Ambari has passwordless SSH to the Ambari server host and retry

Running Ambari as: root
Tokens in hdfs data path: [1]
2017-09-06 15:44:47,403 - Execute['sudo chown bigsql:hadoop /home/bigsql'] {}
2017-09-06 15:44:47,441 - Execute[' echo bigsql:[PROTECTED] | sudo /usr/sbin/chpasswd; exit 0'] {}

Going to update bigsql-head-env with properties: 
('bigsql_active_primary', ':', 'xx.xx.xx.com')

Running Ambari as: root
Tokens in hdfs data path: [1]
2017-09-06 15:44:51,064 - Execute['sudo chmod 755 /var/lib/ambari-agent/cache/extensions/IBM-Big_SQL/5.0.1.0/services/BIGSQL/package; exit 0'] {}
2017-09-06 15:44:51,081 - Execute['sudo chmod 755 /var/lib/ambari-agent/cache/extensions/IBM-Big_SQL/5.0.1.0/services/BIGSQL/package/scripts; exit 0'] {}
2017-09-06 15:44:51,097 - Execute['sudo chmod 755 /var/lib/ambari-agent/cache/extensions/IBM-Big_SQL/5.0.1.0/services/BIGSQL/package/scripts/*; exit 0'] {}

Command failed after 1 tries
Don't have an account?
Coming from Hortonworks? Activate your account here