Ambari 2.4.0.1 and HDP 2.5 is not able to Test Connection to oozie or Hive metastore

ram_pratapa — Fri, 02 Sep 2016 05:56:39 GMT

Hi,

good evening,

I started installing Ambari 2.4.0.1 and HDP 2.5 but I am not able to Test connection either for Oozie or Hive.

I am getting the following error

Ambari 2.4.0.1-1 and HDP 2.5 is not able to Test Connection to oozie or Hive metastore

2016-09-01 22:46:22,247 - There was an unknown error while checking database connectivity: coercing to Unicode: need string or buffer, NoneType found

Traceback (most recent call last):
  File "/var/lib/ambari-agent/cache/custom_actions/scripts/check_host.py", line 144, in actionexecute
    db_connection_check_structured_output = self.execute_db_connection_check(config, tmp_dir)
  File "/var/lib/ambari-agent/cache/custom_actions/scripts/check_host.py", line 285, in execute_db_connection_check
    jdbc_url = jdk_location + jdbc_driver_mysql_name
TypeError: coercing to Unicode: need string or buffer, NoneType found
2016-09-01 22:46:22,248 - Check db_connection_check was unsuccessful. Exit code: 1. Message: coercing to Unicode: need string or buffer, NoneType found

Traceback (most recent call last):
  File "/var/lib/ambari-agent/cache/custom_actions/scripts/check_host.py", line 506, in <module>
    CheckHost().execute()
  File "/usr/lib/python2.6/site-packages/resource_management/libraries/script/script.py", line 280, in execute
    method(env)
  File "/var/lib/ambari-agent/cache/custom_actions/scripts/check_host.py", line 206, in actionexecute
    raise Fail(error_message)
resource_management.core.exceptions.Fail: Check db_connection_check was unsuccessful. Exit code: 1. Message: coercing to Unicode: need string or buffer, NoneType found

Can any one point me in right direction to resolve this issue.

Thank you

Ram

Re: Ambari 2.4.0.1 and HDP 2.5 is not able to Test Connection to oozie or Hive metastore

nshawa — Sun, 04 Sep 2016 05:38:36 GMT

Which Operating System you are installing on? also can you connect to this Database manually? was that an auto-created database or you did the creation on the server?

Re: Ambari 2.4.0.1 and HDP 2.5 is not able to Test Connection to oozie or Hive metastore

ram_pratapa — Mon, 05 Sep 2016 00:47:59 GMT

I was able to identify my mistake. I forgot one step i.e

ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar

Once I executed that command, it started working. The OS is centos 7.2.

Thank you for your help.

Thanks

Ram

question Ambari 2.4.0.1 and HDP 2.5 is not able to Test Connection to oozie or Hive metastore in Support Questions

Ambari 2.4.0.1 and HDP 2.5 is not able to Test Connection to oozie or Hive metastore

Re: Ambari 2.4.0.1 and HDP 2.5 is not able to Test Connection to oozie or Hive metastore

Re: Ambari 2.4.0.1 and HDP 2.5 is not able to Test Connection to oozie or Hive metastore