question Oozie Installation with Mysql in Archives of Support Questions (Read Only)

Oozie Installation with Mysql

ferdsngo — Fri, 16 Sep 2022 08:59:38 GMT

I have installed CDH5. I was able to install all services including oozie. But when I try to configure Oozie to use our mysql database, I am getting the following error :

SERVER[test.pldc.co.org] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] E0103: Could not load service classes, Cannot create PoolableConnectionFactory (Table 'oozie.VALIDATE_CONN' doesn't exist)
org.apache.oozie.service.ServiceException: E0103: Could not load service classes, Cannot create PoolableConnectionFactory (Table 'oozie.VALIDATE_CONN' doesn't exist

I am not sure if Cloudera Manager is supposed to create the database automatically in mysql after you enter the databasein information. But when I get this error, I created the database myself(db = oozie). But I am still getting this error.

Any help will be apprecaited.

Thanks
Ferds

Re: Oozie Installation with Mysql

Darren — Fri, 30 May 2014 15:11:40 GMT

After changing Oozie's database (you need to create the mysql user and database outside of CM,), you need to run the appropriate command to populate that database with oozie's tables.

Click on Oozie, then in the Actions menu on the right, select Create Database. Oozie must be stopped to do this.

Re: Oozie Installation with Mysql

Praseetha — Sun, 01 Mar 2015 11:42:46 GMT

How to populate the oozie tables into the database. I'm using mysql instead of oozie.

Re: Oozie Installation with Mysql

bgooley — Sun, 01 Mar 2015 14:35:47 GMT

As dlo mentioned, you need to use "Create Database" from Cloudera Manager. You can also create it from the command line if not using Cloudera Manager. See the following for more information:

http://www.cloudera.com/content/cloudera/en/documentation/core/latest/topics/cm_mc_oozie_service.html#cmig_topic_14_unique_1

Ben