You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by "Zsombor Gegesy (JIRA)" <ji...@apache.org> on 2018/03/07 10:03:00 UTC

[jira] [Updated] (RANGER-1512) Ranger installer fails if hostname contains upper case letter

     [ https://issues.apache.org/jira/browse/RANGER-1512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zsombor Gegesy updated RANGER-1512:
-----------------------------------
    Fix Version/s:     (was: master)
                   1.0.0

> 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: 1.0.0
>
>         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
(v7.6.3#76005)