question Re: Oozie db to PGSQL in Ambari install. in Archives of Support Questions (Read Only)

Oozie db to PGSQL in Ambari install.

David_Woodruff — Sat, 16 Jan 2016 03:16:45 GMT

While installing Ambari on CentOS7, i was asked about the Oozie db target. I opted to use PGSQL, but that failed, since i did not have any idea what the UserName, Pwd or DBName defaulted to or where to set them. The instructions page gives not idea what to use for them.

Re: Oozie db to PGSQL in Ambari install.

aervits — Sat, 16 Jan 2016 03:35:47 GMT

@Dave Woodruff I highly recommend using the search tool on Hortonworks Documentation page to find what you're looking for. Here's the doc that can help.

Re: Oozie db to PGSQL in Ambari install.

nsabharwal — Sat, 16 Jan 2016 10:10:13 GMT

@Dave Woodruff

Hi, Please see this guide http://docs.hortonworks.com/HDPDocuments/Ambari-2.1.2.0/bk_ambari_reference_guide/content/_using_oozie_with_postgresql.html

Using Oozie with PostgreSQL

To set up PostgreSQL for use with Oozie:

On the Ambari Server host, stage the appropriate PostgreSQL connector for later deployment.
1. Install the connector.
  RHEL/CentOS/Oracle Linux
  yum install postgresql-jdbc
  SLES
  zypper install -y postgresql-jdbc
  UBUNTU
  apt-get install -y postgresql-jdbc
  DEBIAN
  apt-get install -y postgresql-jdbc
2. Confirm that .jar is in the Java share directory.
  ls /usr/share/java/postgresql-jdbc.jar
3. Change the access mode of the .jar file to 644.
  chmod 644 /usr/share/java/postgresql-jdbc.jar
4. Execute the following command:
  ambari-server setup --jdbc-db=postgres --jdbc-driver=/usr/share/java/postgresql-jdbc.jar
Create a user for Oozie and grant it permissions.
- Using the PostgreSQL database admin utility:
  echo "CREATE DATABASE <OOZIEDATABASE>;" | psql -U postgres
  echo "CREATE USER <OOZIEUSER> WITH PASSWORD '<OOZIEPASSWORD>';" | psql -U postgres
  echo "GRANT ALL PRIVILEGES ON DATABASE <OOZIEDATABASE> TO <OOZIEUSER>;" | psql -U postgres
- Where <OOZIEUSER> is the Oozie user name, <OOZIEPASSWORD> is the Oozie user password and <OOZIEDATABASE> is the Oozie database name.

Re: Oozie db to PGSQL in Ambari install.

peter_bartal — Thu, 11 Feb 2016 00:38:04 GMT

This is not reqired anymore when deploying ?

oozie.service.JPAService.create.db.schema=true

Re: Oozie db to PGSQL in Ambari install.

aervits — Thu, 11 Feb 2016 00:41:13 GMT

@Peter Bartal I would follow the documentation.