question Re: Add Service - BigSQL fails in Archives of Support Questions (Read Only)

Add Service - BigSQL fails

mmohammedniaz — Thu, 07 Sep 2017 20:58:13 GMT

All,

I have installed HDPv2.6.1 in single node server and adding new BigSQL service fails because of passwordless SSH failed. I configured passwordless ssh for userid: hdpadmin.

Why bigsql using root id ?

Here is the log: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.

stdout:

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.one.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

Re: Add Service - BigSQL fails

deepesh1 — Tue, 19 Sep 2017 03:33:21 GMT

Typically BigSQL should be installed on 3 nodes at minimum, with BigSQL Master node on one node and BigSQL worker node on the other two. Also establish passwordless ssh for root user from BigSQL master node to the worker nodes. You can find detailed instructions from IBM BigSQL Install document. Make sure that the pre-requisites are followed before installing BigSQL.

Re: Add Service - BigSQL fails

mmohammedniaz — Wed, 20 Sep 2017 16:54:45 GMT

Thanks Deepesh. Added BigSQL service a week ago.

Re: Add Service - BigSQL fails

a_bardone — Tue, 31 Oct 2017 22:20:01 GMT

Hi @Mohammed Niaz

I've the same errror described in you post.

2017-09-0615: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-0615: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-0615: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']{}

How do you solve it?

I start ambari as root user and I confiured ssh as described here:

https://docs.hortonworks.com/HDPDocuments/Ambari-2.5.2.0/bk_ambari-installation/content/set_up_password-less_ssh.html

Thank you very much

Regards

Re: Add Service - BigSQL fails

mmohammedniaz — Thu, 02 Nov 2017 13:54:44 GMT

Hi @Andrea Bardone

Please post your stderr here to assist you. Thanks.

Re: Add Service - BigSQL fails

a_bardone — Thu, 02 Nov 2017 20:32:32 GMT

Hi @Mohammed Niaz,

we resolve the first problem.

Now, we've started to install BIGSQL: we've followed the guide https://www.ibm.com/support/knowledgecenter/en/SSCRJT_5.0.1/com.ibm.swg.im.bigsql.install.doc/doc/hdp_valaddinst.html

and it's all ok.

Then now we're blocked in the ambari service configuration.

We're following this guide:

https://www.ibm.com/support/knowledgecenter/en/SSCRJT_5.0.1/com.ibm.swg.im.bigsql.install.doc/doc/hdp_bigsql_inst.html

but after this step, during the installation:

You can review your selections in the Review page before accepting them. If you want to modify any values, click the Back button. If you are satisfied with your setup, click Deploy.

we obtain the error in attached file.(stderrtxt.txt)

Could you have some advice for me?

Thank you!

Re: Add Service - BigSQL fails

mmohammedniaz — Fri, 03 Nov 2017 20:05:00 GMT

@Andrea Bardone

Error message says it's failed while downloading the db2luw package.

resource_management.core.exceptions.ExecutionFailed: Execution of '/usr/bin/yum -d 0 -e 0 -y install db2luw_5_0_1_0' returned 1. Error downloading packages:
  db2luw_5_0_1_0-11.1.9.0-s170813.x86_64: [Errno 256] No more mirrors to try.

Please run again and make sure you are connected to internet.