[
https://issues.apache.org/jira/browse/RANGER-224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14362975#comment-14362975
]
saikant gajula edited comment on RANGER-224 at 3/16/15 9:29 AM:
----------------------------------------------------------------
Hi Robin,
Thanks 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.So my
default java version got set to 1.6. I think due to this installation was
failing.
I preformed below steps to resolve this issue.
{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
{noformat}
After this i ran ./setup.sh and ./set_globals.sh and performed rest of steps
and mentioned in wiki and its now working for me.
{noformat}
[root@gw ranger-admin]# ./setup.sh
[2015/03/16 14:44:57]: --------- Running XASecure PolicyManager Web
Application Install Script ---------
[2015/03/16 14:44:57]: [I] uname=Linux
[2015/03/16 14:44:57]: [I] hostname=gw
[2015/03/16 14:44:57]: [I] DB_FLAVOR=MYSQL
[2015/03/16 14:44:57]: [I] Checking distribution name..
[2015/03/16 14:44:57]: [I] Found distribution : Red
[2015/03/16 14:44:57]: [I] check if command /usr/java/jdk1.7.0_67//bin/java
exists
[2015/03/16 14:44:57]: [I] '/usr/java/jdk1.7.0_67//bin/java' command found
[2015/03/16 14:44:57]: [I] check if command mysql exists
[2015/03/16 14:44:57]: [I] 'mysql' command found
[2015/03/16 14:44:57]: [I] Checking MYSQL CONNECTOR FILE :
/usr/share/java/mysql-connector-java.jar
[2015/03/16 14:44:57]: [I] MYSQL CONNECTOR FILE :
/usr/share/java/mysql-connector-java.jar file found
[2015/03/16 14:44:57]: [I] Setting up UNIX user : ranger and group: ranger
groupadd: group 'ranger' already exists
[2015/03/16 14:44:57]: [I] User already exists, adding it to group
usermod: no changes
[2015/03/16 14:44:57]: [I] Setting up UNIX user : ranger and group: ranger DONE
[2015/03/16 14:44:57]: [I] Setting up installation files and directory
[2015/03/16 14:44:57]: [I] Copying
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf.dist
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf
[2015/03/16 14:44:57]: [I] Creating
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/ranger_jaas
[2015/03/16 14:44:57]: [I] Creating
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/lib
[2015/03/16 14:44:57]: [I] /usr/local/ranger-admin/ews/logs folder
[2015/03/16 14:44:57]: [I] Setting up installation files and directory DONE
[2015/03/16 14:44:57]: [I] /usr/local/ranger-admin/ews/webapp folder found
[2015/03/16 14:44:57]: [I] /usr/local/ranger-admin/db/xa_core_db.sql file found
[2015/03/16 14:44:57]: [I] Checking MYSQL root password
[2015/03/16 14:44:57]: [I] Checking DB password DONE
[2015/03/16 14:44:57]: [I] Creating MYSQL user 'rangeradmin'
[2015/03/16 14:44:57]: [I] Creating user 'rangeradmin' for host % done
[2015/03/16 14:44:57]: [I] Creating user 'rangeradmin' for host localhost done
[2015/03/16 14:44:57]: [I] Creating MYSQL user 'rangeradmin' DONE
[2015/03/16 14:44:57]: [I] Copying MYSQL Connector to
/usr/local/ranger-admin/ews/webapp/WEB-INF/lib
[2015/03/16 14:44:57]: [I] Copying MYSQL Connector to
/usr/local/ranger-admin/ews/webapp/WEB-INF/lib DONE
[2015/03/16 14:44:57]: [I] Verifying Database: ranger
[2015/03/16 14:44:57]: [I] Creating Database: ranger
[2015/03/16 14:44:57]: [I] Importing Core Database file:
/usr/local/ranger-admin/db/xa_core_db.sql
[2015/03/16 14:44:57]: [I] Importing Database file :
/usr/local/ranger-admin/db/xa_core_db.sql DONE
[2015/03/16 14:44:57]: [I] Granting MYSQL user 'rangeradmin' for host % DONE
[2015/03/16 14:44:57]: [I] Granting MYSQL user 'rangeradmin' for host
localhost DONE
[2015/03/16 14:44:57]: [I] - starting upgradedb ...
[2015/03/16 14:44:57]: [I] Verifying database version catalog table ....
[2015/03/16 14:44:57]: [I] - patch [001] is being applied.
[2015/03/16 14:44:57]: [I] - patch [002] is being applied.
[2015/03/16 14:44:57]: [I] - patch [003] is being applied.
[2015/03/16 14:44:58]: [I] - patch [004] is being applied.
[2015/03/16 14:44:58]: [I] - patch [005] is being applied.
[2015/03/16 14:44:58]: [I] - patch [006] is being applied.
[2015/03/16 14:44:58]: [I] - patch [007] is being applied.
[2015/03/16 14:44:58]: [I] - patch [008] is being applied.
[2015/03/16 14:44:58]: [I] - upgradedb completed.
[2015/03/16 14:44:58]: [I] Verifying Database: ranger_audit
[2015/03/16 14:44:58]: [I] Creating Database: ranger_audit
[2015/03/16 14:44:58]: [I] Verifying Audit User: rangerlogger
[2015/03/16 14:44:58]: [I] Creating MYSQL user 'rangerlogger'@'%'
[2015/03/16 14:44:58]: [I] 'MYSQL' revoke all privileges from user
'rangerlogger'@'%' DONE
[2015/03/16 14:44:58]: [I] Creating MYSQL user 'rangerlogger'@'localhost'
[2015/03/16 14:44:58]: [I] 'MYSQL' revoke all privileges from user
'rangerlogger'@'localhost' DONE
[2015/03/16 14:44:58]: [I] Verifying table xa_access_audit in audit database
ranger_audit
[2015/03/16 14:44:58]: [I] Importing Audit Database file:
/usr/local/ranger-admin/db/xa_audit_db.sql...
[2015/03/16 14:44:58]: [I] Importing Audit Database file :
/usr/local/ranger-admin/db/xa_audit_db.sql DONE
[2015/03/16 14:44:58]: [I] Granting Privileges to User: rangerlogger
[2015/03/16 14:44:58]: [I] Creating MYSQL user 'rangerlogger' for host % DONE
[2015/03/16 14:44:58]: [I] 'MYSQL' grant INSERT privileges to user
'rangerlogger'@'%' on xa_access_audit DONE
[2015/03/16 14:44:58]: [I] Creating MYSQL user 'rangerlogger' for host
localhost DONE
[2015/03/16 14:44:58]: [I] 'MYSQL' grant INSERT privileges to user
'rangerlogger'@'localhost' on xa_access_audit DONE
[2015/03/16 14:44:58]: [I]
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
file found
[2015/03/16 14:44:58]: [I] File
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
Updated successfully : {'jdbc.url'}
[2015/03/16 14:44:58]: [I] File
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
Updated successfully : {'auditDB.jdbc.url'}
[2015/03/16 14:44:58]: [I] File
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
Updated successfully : {'jdbc.dialect'}
[2015/03/16 14:44:58]: [I] File
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
Updated successfully : {'auditDB.jdbc.dialect'}
[2015/03/16 14:44:58]: [I] File
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
Updated successfully : {'jdbc.driver'}
[2015/03/16 14:44:58]: [I] File
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
Updated successfully : {'auditDB.jdbc.driver'}
[2015/03/16 14:44:58]: [I] File
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
Updated successfully : {'xa.webapp.url.root'}
[2015/03/16 14:44:58]: [I] File
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
Updated successfully : {'http.enabled'}
[2015/03/16 14:44:58]: [I] File
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
Updated successfully : {'jdbc.user'}
[2015/03/16 14:44:58]: [I] File
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
Updated successfully : {'auditDB.jdbc.user'}
Starting configuration for XA DB credentials:
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
details.
Mar 16, 2015 2:44:59 PM org.apache.hadoop.util.NativeCodeLoader <clinit>
WARNING: Unable to load native-hadoop library for your platform... using
builtin-java classes where applicable
policyDB.jdbc.password has been successfully created.
org.apache.hadoop.security.alias.JavaKeyStoreProvider has been updated.
[2015/03/16 14:44:59]: [I] File
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
Updated successfully : {'xaDB.jdbc.credential.alias'}
[2015/03/16 14:44:59]: [I] File
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
Updated successfully : {'xaDB.jdbc.credential.provider.path'}
[2015/03/16 14:44:59]: [I] File
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
Updated successfully : {'jdbc.password'}
Starting configuration for Audit DB credentials:
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
details.
Mar 16, 2015 2:45:00 PM org.apache.hadoop.util.NativeCodeLoader <clinit>
WARNING: Unable to load native-hadoop library for your platform... using
builtin-java classes where applicable
auditDB.jdbc.password has been successfully created.
org.apache.hadoop.security.alias.JavaKeyStoreProvider has been updated.
[2015/03/16 14:45:00]: [I] File
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
Updated successfully : {'auditDB.jdbc.credential.alias'}
[2015/03/16 14:45:00]: [I] File
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
Updated successfully : {'auditDB.jdbc.credential.provider.path'}
[2015/03/16 14:45:00]: [I] File
/usr/local/ranger-admin/ews/webapp/WEB-INF/classes/conf/xa_system.properties
Updated successfully : {'auditDB.jdbc.password'}
[2015/03/16 14:45:00]: [I] Starting setup based on user authentication
method=NONE
/usr/local/ranger-admin/ews/webapp
[2015/03/16 14:45:00]: [I] Finished setup based on user authentication
method=NONE
[2015/03/16 14:45:00]: [I] patch PatchPasswordEncryption_J10001.class is being
applied..
[2015/03/16 14:45:13]: [I] patch PatchPasswordEncryption_J10001.class has been
applied!!
Installation of XASecure PolicyManager Web Application is completed.
[root@gw ranger-admin]# clear
[root@gw ranger-admin]#
[root@gw ranger-admin]#
[root@gw ranger-admin]# ./set_globals.sh
groupadd: group 'ranger' already exists
usermod: no changes
[2015/03/16 14:45:33]: [I] Soft linking /etc/ranger/admin/conf to
ews/webapp/WEB-INF/classes/conf
[root@gw ranger-admin]# ln -sf
/usr/local/ranger-admin/ews/start-ranger-admin.sh ranger-admin-start
[root@gw ranger-admin]# ln -sf
/usr/local/ranger-admin/ews/stop-ranger-admin.sh ranger-admin-stop
[root@gw ranger-admin]# service ranger-admin start
Apache Ranger Admin has started
[root@gw ranger-admin]#
{noformat}
Thanks,
Saikant
was (Author: saikant1983):
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)
