Failed to install Oozie. "Failed to create Oozie database tables.

paultader — Fri, 16 Sep 2022 10:28:59 GMT

CDH 5.7.1

Atempts to install Oozie with Cloudera Manager fails with the error in stderr log file:

Error: Could not connect to the database: java.sql.SQLException: Access denied for user 'oozie'@'localhost' (using password: YES)

There is no password configured, but even with a pasword configured the process still fails.
Using the command line mysql client I can connect ( "mysql -u oozie oozie")
After connecting via the command line as the "oozie" user I can create and drop tables.
I've dropped the database and user and then recreated. No joy.

Steps I'm running.

Add a service
Chose the host for the Oozie Server service
Test (external mysql) database connetion is successful
Review changes and start the installation.

Full disclosure: This is the second attempt to install this cluster (after removing packages, dropping databases, etc) so I'm thinking some configuration file was left behind (but it would still have been the same values). Datanode DNS issues caused me to reset the installation.

Re: Failed to install Oozie. "Failed to create Oozie database tables.

paultader — Fri, 08 Jul 2016 16:15:23 GMT

Well, not really a solution, but after trying various combinations I was able to install and start the Oozie process. It worked after I created a mysql user like this:

MariaDB [(none)]> grant all on oozie.* TO 'oozie'@'host.company.com' IDENTIFIED BY 'secretpassword';

question Re: Failed to install Oozie. "Failed to create Oozie database tables. in Archives of Support Questions (Read Only)

Failed to install Oozie. "Failed to create Oozie database tables.

Re: Failed to install Oozie. "Failed to create Oozie database tables.