[
https://issues.apache.org/jira/browse/RANGER-224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14362975#comment-14362975
]
saikant gajula commented on RANGER-224:
---------------------------------------
Hi,
Thanks all for your prompt reply.
I think i have figure out this. Issue appeared due to wrong version of java.
I did install java 1.7 as per instruction in installation link. But when i ran
./setup.sh it failed to due to missing "mysql-connector-java" connector.
when i installed "mysql-connector-java" it installed older version of java 1.6
with it and when i used to run "java -version" it pointed to java 1.6.
{noformat}
[root@gw bin]# ls -l /etc/alternatives/java
lrwxrwxrwx 1 root root 46 Mar 16 14:41 /etc/alternatives/java ->
/usr/lib/jvm/jre-1.6.0-openjdk.x86_64/bin/java
{noformat}
I removed this soft link and re-created soft link to java1.7 version.
{noformat}
[root@gw bin]# rm /etc/alternatives/java
rm: remove symbolic link `/etc/alternatives/java'? y
[root@gw bin]# ln -s /usr/java/jdk1.7.0_67/jre/bin/java /etc/alternatives/java
I think i figure out the issue.
> Ranger admin can not access to mysql?
> --------------------------------------
>
> Key: RANGER-224
> URL: https://issues.apache.org/jira/browse/RANGER-224
> Project: Ranger
> Issue Type: Bug
> Affects Versions: 0.4.1
> Environment: OS: Ubuntu14.04 server 64bit
> DB: 5.5.40-MariaDB-0ubuntu0.14.04.1
> Reporter: robinlin
> Priority: Blocker
>
> Hi :
> I installed Ranger by following steps in
> https://cwiki.apache.org/confluence/display/RANGER/Ranger+Installation+Guide
> but there is a exception when I am trying to login via the web page.
> And the exception message is...
> java.sql.SQLException: Access denied for user 'rangeradmin'@'localhost'
> (using password: YES)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:926)
> at
> com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1748)
> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1288)
> at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2508)
> at
> com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2541)
> at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2323)
> at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)
> at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
> at sun.reflect.GeneratedConstructorAccessor49.newInstance(Unknown
> Source)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
> at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
> at net.sf.log4jdbc.DriverSpy.connect(DriverSpy.java:728)
> at
> com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
> at
> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
> at
> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
> at
> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
> at
> com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
> at
> com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
> at
> com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
> at
> com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
> Please help me with this, thanks in advance.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
