Attila Csoma created RANGER-1512:
------------------------------------
Summary: Ranger installer fails if hostname contains upper case
letter
Key: RANGER-1512
URL: https://issues.apache.org/jira/browse/RANGER-1512
Project: Ranger
Issue Type: Bug
Components: Ranger
Affects Versions: 0.6.0
Reporter: Attila Csoma
Priority: Minor
Installing Ranger with Ambari 2.4.2 Web UI fails if hostname contains upper
case letter due to that mysql stores uppercase hostnames in lowercase format.
Traceback:
resource_management.core.exceptions.ExecutionFailed: Execution of
'ambari-python-wrap /usr/hdp/current/ranger-admin/dba_script.py -q'
...
2017-04-12 13:05:46,559 [I] Verifying user rangeradmin for Host
os-r6-EU-253TO255-Kerberized-2.openstacklocal
2017-04-12 13:05:46,559 [JISQL] /usr/jdk64/jdk1.8.0_112/bin/java -cp
/usr/hdp/2.5.3.0-37/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://os-r6-EU-253TO255-Kerberized-2.openstacklocal/mysql -u root2 -p
'********' -noheader -trim -c \; -query "select user from mysql.user where
user='rangeradmin' and host='os-r6-EU-253TO255-Kerberized-2.openstacklocal';"
2017-04-12 13:05:47,225 [I] MySQL user rangeradmin does not exists for host
os-r6-EU-253TO255-Kerberized-2.openstacklocal
2017-04-12 13:05:47,225 [JISQL] /usr/jdk64/jdk1.8.0_112/bin/java -cp
/usr/hdp/2.5.3.0-37/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://os-r6-EU-253TO255-Kerberized-2.openstacklocal/mysql -u root2 -p
'********' -noheader -trim -c \; -query "create user
'rangeradmin'@'os-r6-EU-253TO255-Kerberized-2.openstacklocal' identified by
'********';"
2017-04-12 13:05:47,892 [I] Verifying user rangeradmin for Host
os-r6-EU-253TO255-Kerberized-2.openstacklocal
2017-04-12 13:05:47,893 [JISQL] /usr/jdk64/jdk1.8.0_112/bin/java -cp
/usr/hdp/2.5.3.0-37/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://os-r6-EU-253TO255-Kerberized-2.openstacklocal/mysql -u root2 -p
'********' -noheader -trim -c \; -query "select user from mysql.user where
user='rangeradmin' and host='os-r6-EU-253TO255-Kerberized-2.openstacklocal';"
2017-04-12 13:05:48,563 [E] Creating MySQL user rangeradmin failed..
However in mysql:
mysql> select user, host from mysql.user;
+-------------+-----------------------------------------------+
| user | host |
+-------------+-----------------------------------------------+
...
| rangeradmin | os-r6-eu-253to255-kerberized-2.openstacklocal |
+-------------+-----------------------------------------------+
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
