question Re: Oozie database access problem. in Support Questions

question Re: Oozie database access problem. in Support Questions https://community.cloudera.com/t5/Support-Questions/Oozie-database-access-problem/m-p/194090#M156150 Same problem but more complex. Can you help me ?<UL> <LI>oozie DB is created </LI><LI>user/pass and privileges are set OK</LI><LI>Connection test is OK</LI></UL><img src="https://community.cloudera.com/t5/image/serverpage/image-id/18150i562C8EB3A959F414/image-size/medium?v=v2&px=400" role="button" title="91648-test-connection.png" alt="91648-test-connection.png" /><UL><LI>I can connect through command line from the same server emulating JDBC connector with sqlline:</LI></UL><PRE># java -Djava.ext.dirs=/home/user/jline_sqlline__mysql_connector/ sqlline.SqlLine sqlline version 1.0.2 by Marc Prud'hommeaux sqlline> !connect jdbc:mysql://pro-hadoop-ambari/oozie oozie XXXXXXX Connecting to jdbc:mysql://pro-hadoop-ambari/oozie Connected to: MySQL (version 5.7.23) Driver: MySQL-AB JDBC Driver (version mysql-connector-java-5.1.17-SNAPSHOT ( Revision: ${bzr.revision-id} )) Autocommit status: true Transaction isolation: TRANSACTION_REPEATABLE_READ 0: jdbc:mysql://pro-hadoop-ambari/oozie> </PRE><UL> <LI>But ... the service doesn't start due to a JDBC error 😞</LI></UL><PRE>Validate DB Connection SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/hdp/2.6.5.0-292/oozie/libserver/slf4j-log4j12-1.6.6.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/hdp/2.6.5.0-292/oozie/lib/slf4j-simple-1.6.6.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See <A href="http://www.slf4j.org/codes.html#multiple_bindings" target="_blank" rel="nofollow noopener noreferrer">http://www.slf4j.org/codes.html#multiple_bindings</A> for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] DONE DB schema does not exist Check OOZIE_SYS table does not exist DONE Create SQL schema Error: A connection could not be obtained for driver class "com.mysql.jdbc.Driver" and URL "jdbc:mysql://pro-hadoop-ambari/oozie". You may have specified an invalid URL. Stack trace for the error was (for debug purposes): -------------------------------------- <openjpa-2.4.1-r422266:1730418 fatal user error> org.apache.openjpa.util.UserException: A connection could not be obtained for driver class "com.mysql.jdbc.Driver" and URL "jdbc:mysql://pro-hadoop-ambari/oozie". You may have specified an invalid URL. at org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectException(DataSourceFactory.java:272) at org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:258) at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getConnectionFactory(JDBCConfigurationImpl.java:733) at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDataSource(JDBCConfigurationImpl.java:878) at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDataSource2(JDBCConfigurationImpl.java:920) at org.apache.openjpa.jdbc.schema.SchemaTool.<init>(SchemaTool.java:132) at org.apache.openjpa.jdbc.meta.MappingTool.newSchemaTool(MappingTool.java:314) at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:495) at org.apache.openjpa.jdbc.meta.MappingTool.run(MappingTool.java:1095) at org.apache.openjpa.jdbc.meta.MappingTool.run(MappingTool.java:1006) at org.apache.openjpa.jdbc.meta.MappingTool$1.run(MappingTool.java:939) at org.apache.openjpa.lib.conf.Configurations.launchRunnable(Configurations.java:762) at org.apache.openjpa.lib.conf.Configurations.runAgainstAllAnchors(Configurations.java:752) at org.apache.openjpa.jdbc.meta.MappingTool.main(MappingTool.java:934) at org.apache.oozie.tools.OozieDBCLI.createUpgradeDB(OozieDBCLI.java:1191) at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:198) at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:131) at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:79) Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'oozie'@'pro-hadoop-ambari' (using password: YES)) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at org.apache.openjpa.jdbc.schema.DBCPDriverDataSource.getDBCPConnection(DBCPDriverDataSource.java:74) at org.apache.openjpa.jdbc.schema.AutoDriverDataSource.getConnection(AutoDriverDataSource.java:42) at org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getConnection(SimpleDriverDataSource.java:76) at org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:118) at org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:92) at org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSourceFactory.java:250) ... 16 more Caused by: java.sql.SQLException: Access denied for user 'oozie'@'pro-hadoop-ambari' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1709) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1252) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2488) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2521) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2306) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:839) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:421) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:350) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ... 24 more -------------------------------------- </PRE> Sun, 18 Aug 2019 06:54:03 GMT igortme 2019-08-18T06:54:03Z