[AMBARI-2249] Allow users to edit Hive Metastore and Oozie database post-install

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.4
• Fix Version/s: 1.2.4
• Component/s: ambari-web
• Assignee: Yusaku Sako
• Reporter: Yusaku Sako
• Created: 01/Jun/13 04:40
• Updated: 01/Jun/13 04:51
• Resolved: 01/Jun/13 04:51

Description

Services > Hive > Configs > Hive Metastore: Allow users to edit database host, database name, username, password and save.

Services > Oozie > Configs > Oozie: Allow users to edit database host, database name, username, password and save.

Changes required:
On the Hive / Oozie config page:
Expose database host name and make it editable
Make database name editable
Make database username editable
Make database password editable
When we save Oozie configs, update the globals for the database host, name, username, password, as well as corresponding configs in oozie-site.xml:
oozie.db.schema.name
oozie.service.JPAService.jdbc.driver
oozie.service.JPAService.jdbc.url
oozie.service.JPAService.jdbc.username
oozie.service.JPAService.jdbc.password
Make the above properties hidden from "Advanced" section.

When we save Hive configs, update the globals for the database host, name, username, password, as well as corresponding configs in hive-site.xml:
javax.jdo.option.ConnectionURL
javax.jdo.option.ConnectionUserName
javax.jdo.option.ConnectionPassword
javax.jdo.option.ConnectionDriverName
Make the above properties hidden from "Advanced" section (also there's a bug that shows javax.jdo.option.ConnectionURL in custom hive-site.xml - make sure this does not happen)