[
https://issues.apache.org/jira/browse/RANGER-1512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15978267#comment-15978267
]
Attila Csoma edited comment on RANGER-1512 at 4/21/17 8:16 AM:
---------------------------------------------------------------
The error caused by a select which does not ignore case sensitivity in
hostnames.
Based on RFC 1035 (https://tools.ietf.org/html/rfc1035) there is no difference
between uppercase or lowercase domain names. When creating a new user in mysql
with hostname which contains uppercase letter it stores its lowercase version,
however a select with a where clause with the same host will give a 0 line
result because of this difference.
A workaround is to convert hostnames to its lowercase version at the init of
dba_script's mysql module.
was (Author: csomaati):
The error caused by a select which does not ignore case sensitivity in
hostnames.
Based on RFC 1035 (https://tools.ietf.org/html/rfc1035) there is no difference
between uppercase or lowercase domain names. When creating a new user in mysql
with hostname which contains uppercase latter it stores its lowercase version,
however a select with a where clause with the same host will give a 0 line
result because of this difference.
A workaround is to convert hostnames to its lowercase version at the init of
dba_script's mysql module.
> 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: master
> Reporter: Attila Csoma
> Priority: Minor
> Labels: newbie
> Fix For: master
>
> Attachments:
> 0001-RANGER-1512-Convert-hostnames-to-lowercase-when-usin.patch
>
>
> 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)
