Created 09-01-2016 10:56 PM
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
Created 09-04-2016 05:47 PM
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
Created 09-03-2016 10:38 PM
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?
Created 09-04-2016 05:47 PM
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