AnsweredAssumed Answered

Access denied for user 'oozie'

Question asked by subhash on May 9, 2016
Latest reply on May 9, 2016 by subhash

Hi,

 

Can any one provide solution for below error and i am facing error in one node.

 

OS: Centos 7.1

MapR ver: 5.1

Java version: JDK(Java 1.8.0_91)

4 Node cluster

 

 

 

[root@ostest]# cat   /opt/mapr/oozie/oozie-4.1.0/logs/catalina.out

 

May 09, 2016 4:07:21 PM org.apache.catalina.core.AprLifecycleListener init

INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: :/opt/mapr/lib

May 09, 2016 4:07:21 PM org.apache.coyote.http11.Http11Protocol init

INFO: Initializing Coyote HTTP/1.1 on http-11000

May 09, 2016 4:07:21 PM org.apache.catalina.startup.Catalina load

INFO: Initialization processed in 536 ms

May 09, 2016 4:07:21 PM org.apache.catalina.core.StandardService start

INFO: Starting service Catalina

May 09, 2016 4:07:21 PM org.apache.catalina.core.StandardEngine start

INFO: Starting Servlet Engine: Apache Tomcat/6.0.41

May 09, 2016 4:07:21 PM org.apache.catalina.startup.HostConfig deployWAR

INFO: Deploying web application archive oozie.war

log4j:WARN No appenders could be found for logger (com.mapr.baseutils.cldbutils.CLDBRpcCommonUtils).

log4j:WARN Please initialize the log4j system properly.

log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.

SLF4J: Class path contains multiple SLF4J bindings.

SLF4J: Found binding in [jar:file:/opt/mapr/oozie/oozie-4.1.0/oozie-server/webapps/oozie/WEB-INF/lib/slf4j-log4j12-1.6.6.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: Found binding in [jar:file:/opt/mapr/oozie/oozie-4.1.0/oozie-server/webapps/oozie/WEB-INF/lib/slf4j-simple-1.6.6.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.

SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]

 

ERROR: Oozie could not be started

 

REASON: org.apache.oozie.service.ServiceException: E0103: Could not load service classes, Cannot create PoolableConnectionFactory (Access denied for user 'oozie'@'osdev7.neterra.moneybookers.net' (using password: YES))

 

Stacktrace:

-----------------------------------------------------------------

org.apache.oozie.service.ServiceException: E0103: Could not load service classes, Cannot create PoolableConnectionFactory (Access denied for user 'oozie'@'osdev7.neterra.moneybookers.net' (using password: YES))

        at org.apache.oozie.service.Services.loadServices(Services.java:306)

        at org.apache.oozie.service.Services.init(Services.java:210)

        at org.apache.oozie.servlet.ServicesLoader.contextInitialized(ServicesLoader.java:45)

        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210)

        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4709)

        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943)

        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)

        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)

        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

        at org.apache.catalina.core.StandardHost.start(StandardHost.java:822)

        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

        at org.apache.catalina.core.StandardService.start(StandardService.java:525)

        at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

        at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:498)

        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

Caused by: <openjpa-2.2.2-r422266:1468616 fatal general error> org.apache.openjpa.persistence.PersistenceException: Cannot create PoolableConnectionFactory (Access denied for user 'oozie'@'osdev7.neterra.moneybookers.net' (using password: YES))

        at org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:102)

        at org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603)

        at org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1518)

        at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:531)

        at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:456)

        at org.apache.openjpa.lib.conf.PluginValue.instantiate(PluginValue.java:120)

        at org.apache.openjpa.conf.MetaDataRepositoryValue.instantiate(MetaDataRepositoryValue.java:68)

        at org.apache.openjpa.lib.conf.ObjectValue.instantiate(ObjectValue.java:83)

        at org.apache.openjpa.conf.OpenJPAConfigurationImpl.newMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:967)

        at org.apache.openjpa.conf.OpenJPAConfigurationImpl.getMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:958)

        at org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:644)

        at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203)

        at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)

        at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227)

        at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154)

        at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)

        at org.apache.oozie.service.JPAService.getEntityManager(JPAService.java:499)

        at org.apache.oozie.service.JPAService.init(JPAService.java:200)

        at org.apache.oozie.service.Services.setServiceInternal(Services.java:383)

        at org.apache.oozie.service.Services.setService(Services.java:369)

        at org.apache.oozie.service.Services.loadServices(Services.java:302)

        ... 26 more

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'oozie'@'osdev7.neterra.moneybookers.net' (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.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:110)

        at org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:87)

        at org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:91)

        ... 46 more

Caused by: java.sql.SQLException: Access denied for user 'oozie'@'osdev7.neterra.moneybookers.net' (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:2483)

        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2516)

        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2301)

        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)

        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

        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:416)

        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)

        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)

        ... 51 more

-----------------------------------------------------------------

Outcomes