[
https://issues.apache.org/jira/browse/RANGER-224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14292064#comment-14292064
]
robinlin commented on RANGER-224:
---------------------------------
Hi
Thanks for reply.
I have check the three commands, and I paste my result here...
For (a), I got
root@rangerDev:/etc/ranger/admin/conf# mysql -u rangeradmin -p -h localhost
Enter password: <MY PASSWORD IN "install.properties">
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 13756
Server version: 5.5.40-MariaDB-0ubuntu0.14.04.1 (Ubuntu)
Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
========================================
For (B), I got
root@rangerDev:/etc/ranger/admin/conf# ps -ef | grep mysql
root 1909 1 0 Jan26 pts/0 00:00:00 /bin/bash /usr/bin/mysqld_safe
root 1910 1 0 Jan26 pts/0 00:00:00 logger -p daemon.err -t
/etc/init.d/mysql -i
mysql 2342 1909 0 Jan26 pts/0 00:00:09 /usr/sbin/mysqld --basedir=/usr
--datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql
--log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid
--socket=/var/run/mysqld/mysqld.sock --port=3306
root 3764 1758 0 00:50 pts/0 00:00:00 grep --color=auto mysql
========================================
For (C), I got
MariaDB [mysql]> select user, host from user where user like 'ranger%' ;
+--------------+-----------+
| user | host |
+--------------+-----------+
| rangeradmin | % |
| rangerlogger | % |
| rangeradmin | localhost |
| rangerlogger | localhost |
+--------------+-----------+
> 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)
