While doing the installation, i keep getting a failure on the step "Creating Oozie database"
java.lang.Exception: DB schema exists
at org.apache.oozie.tools.OozieDBCLI.validateDBSchema(OozieDBCLI.java:877)
at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:184)
at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:127)
at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:78)
How do i fix this? Where do i get the password/username/dbname for the PostgreSQL database to drop the existing schema?
I tried cat /etc/cloudera-scm-server/db*.properties | grep pass
and
/var/lib/cloudera-scm-server-db/data/generated-password.txt
but the passwords don't work!