Pivotal Knowledge Base

Follow

Oozie configuration in Ambari displays error message asking for "Database Host"

Environment

Product Version
Pivotal HD 3.0.x
Ambari 2.1.2

Symptom

The Oozie configuration page in Ambari 2.1.2 displays an error indicating that "Database Host" is required:

 

However, when attempting to enter the "Database Host", the field becomes greyed out:

If the configuration is checked via command line on the Ambari node, the value "oozie_hostname" is empty:

/var/lib/ambari-server/resources/scripts/configs.sh -u admin -p admin get 127.0.0.1 <CLUSTER_NAME> oozie-env | grep oozie_hostname
"oozie_hostname" : "",
[root@amb171hawq scripts]# 

Cause

In previous versions of Ambari, the "Database Host" did not need to be set. However, from Ambari 2.1.2, the value does need to be set. This is likely linked to a recent Ambari upgrade from 1.7.1 to a later version.

Resolution

1. Set the hostname of the Oozie server in the Ambari configuration by running this command as the user "root" on the Ambari node (how to find the Pivotal HD cluster name):

/var/lib/ambari-server/resources/scripts/configs.sh -u admin -p admin set 127.0.0.1 <CLUSTER_NAME> oozie-env "oozie_hostname" "<OOZIE_SEVER_HOSTNAME>"

2. Confirm that the hostname has been set correctly:

/var/lib/ambari-server/resources/scripts/configs.sh -u admin -p admin get 127.0.0.1 <CLUSTER_NAME> oozie-env | grep oozie_hostname
"oozie_hostname" : "ambar171hawq",
[root@amb171hawq scripts]# 

3. Refresh the configuration page in Ambari and the issue should now be resolved.

Note: If the Ambari server API enforces use of SSL, the "-s" command may need to be added to the config.sh command, just after the username and password fields.

 

Comments

Powered by Zendesk