Pivotal Knowledge Base


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


Product Version
Pivotal HD 3.0.x
Ambari 2.1.2


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 <CLUSTER_NAME> oozie-env | grep oozie_hostname
"oozie_hostname" : "",
[root@amb171hawq scripts]# 


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.


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



Powered by Zendesk