[ https://issues.apache.org/jira/browse/RANGER-1512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15978296#comment-15978296 ]
Attila Csoma commented on RANGER-1512: -------------------------------------- Review link: https://reviews.apache.org/r/58606/ > 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)