3.4. Troubleshooting Non-Default Databases with Oozie
Use these entries to help you troubleshoot any issues you might have installing Oozie with non-default databases.
3.4.1. Problem: Oozie Server Install Fails Using MySQL
Check the install log:
cp /usr/share/java/mysql-connector-java.jar
usr/lib/oozie/libext/mysql-connector-java.jar has failures: true
The MySQL JDBC.jar file cannot be found.
3.4.1.1. Solution
Make sure the file is in the appropriate directory on the Oozie server and click Retry.
3.4.2. Problem: Oozie Server Install Fails Using Oracle or MySQL
Check the install log:
Exec[exec cd /var/tmp/oozie && /usr/lib/oozie/bin/ooziedb.sh create
-sqlfile oozie.sql -run ] has failures: true
Oozie was unable to connect to the database or was unable to successfully setup the schema for Oozie.
3.4.2.1. Solution
Check the database connection settings provided during the Customize
Services step in the install wizard by browsing back to Customize
Services > Oozie. After confirming and adjusting your database settings,
proceed forward with the install wizard.
If the Install Oozie Server wizard continues to fail, get more information by connecting directly to the Oozie server and executing the following command as <OOZIEUSER>:
su oozie /usr/lib/oozie/bin/ooziedb.sh create -sqlfile oozie.sql
-run