[
https://issues.apache.org/jira/browse/RANGER-1111?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15386912#comment-15386912
]
rangerqa commented on RANGER-1111:
----------------------------------
{color:red}-1 overall{color}. Here are the results of testing the latest
attachment
http://issues.apache.org/jira/secure/attachment/12819053/RANGER-1111-1.patch
against master revision 55c55ca.
{color:red}-1 patch{color}. The patch command could not apply the patch.
Console output:
https://builds.apache.org/job/PreCommit-RANGER-Build/298//console
This message is automatically generated.
> Enhancements to the db admin setup scripts.
> -------------------------------------------
>
> Key: RANGER-1111
> URL: https://issues.apache.org/jira/browse/RANGER-1111
> Project: Ranger
> Issue Type: Bug
> Components: Ranger
> Affects Versions: 0.5.0, 0.6.0
> Reporter: Pradeep Agrawal
> Assignee: Pradeep Agrawal
> Fix For: 0.7.0
>
> Attachments: RANGER-1111-1.patch
>
>
> Improve debugging for dba_script.py, print the jisql commands in the console
> without the password. Ranger admin installation logs print ranger admin user
> password when it creates rangeradmin user.
> {code}
> 2016-07-17 06:07:59,156 [JISQL] /usr/jdk64/jdk1.8.0_77/bin/java -cp
> /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://172.22.95.18/mysql -u root -p '********' -noheader -trim -c \;
> -query "SELECT version();"
> 2016-07-17 06:07:59,808 [I] Verifying user rangeradmin for Host %
> 2016-07-17 06:07:59,808 [JISQL] /usr/jdk64/jdk1.8.0_77/bin/java -cp
> /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://172.22.95.18/mysql -u root -p '********' -noheader -trim -c \;
> -query "select user from mysql.user where user='rangeradmin' and host='%';"
> 2016-07-17 06:08:00,469 [I] MySQL user rangeradmin does not exists for host %
> 2016-07-17 06:08:00,469 [JISQL] /usr/jdk64/jdk1.8.0_77/bin/java -cp
> /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://172.22.95.18/mysql -u root -p '********' -noheader -trim -c \;
> -query "create user 'rangeradmin'@'%' identified by 'rangeradmin';"
> 2016-07-17 06:08:01,137 [I] Verifying user rangeradmin for Host %
> 2016-07-17 06:08:01,137 [JISQL] /usr/jdk64/jdk1.8.0_77/bin/java -cp
> /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://172.22.95.18/mysql -u root -p '********' -noheader -trim -c \;
> -query "select user from mysql.user where user='rangeradmin' and host='%';"
> 2016-07-17 06:08:01,762 [I] MySQL user rangeradmin created for host %
> 2016-07-17 06:08:01,762 [I] Verifying user rangeradmin for Host localhost
> 2016-07-17 06:08:01,762 [JISQL] /usr/jdk64/jdk1.8.0_77/bin/java -cp
> /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://172.22.95.18/mysql -u root -p '********' -noheader -trim -c \;
> -query "select user from mysql.user where user='rangeradmin' and
> host='localhost';"
> 2016-07-17 06:08:02,362 [I] MySQL user rangeradmin does not exists for host
> localhost
> 2016-07-17 06:08:02,363 [JISQL] /usr/jdk64/jdk1.8.0_77/bin/java -cp
> /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://172.22.95.18/mysql -u root -p '********' -noheader -trim -c \;
> -query "create user 'rangeradmin'@'localhost' identified by 'rangeradmin';"
> 2016-07-17 06:08:02,964 [I] Verifying user rangeradmin for Host localhost
> 2016-07-17 06:08:02,964 [JISQL] /usr/jdk64/jdk1.8.0_77/bin/java -cp
> /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://172.22.95.18/mysql -u root -p '********' -noheader -trim -c \;
> -query "select user from mysql.user where user='rangeradmin' and
> host='localhost';"
> 2016-07-17 06:08:03,580 [I] MySQL user rangeradmin created for host localhost
> 2016-07-17 06:08:03,581 [I] Verifying user rangeradmin for Host 172.22.95.18
> 2016-07-17 06:08:03,581 [JISQL] /usr/jdk64/jdk1.8.0_77/bin/java -cp
> /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://172.22.95.18/mysql -u root -p '********' -noheader -trim -c \;
> -query "select user from mysql.user where user='rangeradmin' and
> host='172.22.95.18';"
> 2016-07-17 06:08:04,144 [I] MySQL user rangeradmin does not exists for host
> 172.22.95.18
> 2016-07-17 06:08:04,144 [JISQL] /usr/jdk64/jdk1.8.0_77/bin/java -cp
> /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://172.22.95.18/mysql -u root -p '********' -noheader -trim -c \;
> -query "create user 'rangeradmin'@'172.22.95.18' identified by 'rangeradmin';"
> 2016-07-17 06:08:04,721 [I] Verifying user rangeradmin for Host 172.22.95.18
> 2016-07-17 06:08:04,722 [JISQL] /usr/jdk64/jdk1.8.0_77/bin/java -cp
> /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/*
> org.apache.util.sql.Jisql -driver mysqlconj -cstring
> jdbc:mysql://172.22.95.18/mysql -u root -p '********' -noheader -trim -c \;
> -query "select user from mysql.user where user='rangeradmin' and
> host='172.22.95.18';"
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
