4. Configure Your Database for Oozie

  • For Derby:

    No database configuration is required.

  • For MySQL:

    echo "create database if not exists oozie;" | mysql -u rootecho "grant all privileges on oozie.* to 'oozie'@'localhost' identified by 'oozie';" | mysql -u root echo "grant all privileges on oozie.* to 'oozie'@`hostname -f` identified by 'oozie';" | mysql -u root

  • For PostgreSQL:

    psql -U postgres -c "CREATE DATABASE oozie;" | psql -U postgres -c "CREATE USER oozie WITH PASSWORD 'oozie';" | psql -U postgres -c "GRANT ALL PRIVILEGES ON DATABASE oozie TO oozie;"

  • For Oracle:

    bash -l -c 'echo "create user oozie identified by oozie;" | sqlplus system/root@`hostname -f`' bash -l -c 'echo "GRANT SELECT_CATALOG_ROLE TO oozie;" | sqlplus system/ root@`hostname -f`' bash -l -c 'echo "GRANT CONNECT, RESOURCE TO oozie;" | sqlplus system/ root@`hostname -f`'


loading table of contents...