CDH 5.11.0 Hue 无法连接数据库

大家好！我在安装CDH5.11.0的过程中，Hue测试连接数据库失败，如下

下面是cloudera-scm-server.log的内容

2017-06-19 23:05:03,938 INFO CommandPusher:com.cloudera.cmf.service.AbstractOneOffHostCommand: Unsuccessful 'HueTestDatabaseConnection'
2017-06-19 23:05:03,938 INFO CommandPusher:com.cloudera.cmf.service.AbstractDbConnectionTestCommand: Command exited with code: 1
2017-06-19 23:05:03,938 INFO CommandPusher:com.cloudera.cmf.service.AbstractDbConnectionTestCommand:     self._setup(name)
  File "/opt/cloudera/parcels/CDH-5.11.0-1.cdh5.11.0.p0.34/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/conf/__init__.py", line 49, in _setup
    self._wrapped = Settings(settings_module)
  File "/opt/cloudera/parcels/CDH-5.11.0-1.cdh5.11.0.p0.34/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/conf/__init__.py", line 128, in __init__
    mod = importlib.import_module(self.SETTINGS_MODULE)
  File "/opt/cloudera/parcels/CDH-5.11.0-1.cdh5.11.0.p0.34/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/utils/importlib.py", line 40, in import_module
    __import__(name)
  File "/opt/cloudera/parcels/CDH-5.11.0-1.cdh5.11.0.p0.34/lib/hue/desktop/core/src/desktop/settings.py", line 325, in <module>
    "PASSWORD" : desktop.conf.get_database_password(),
  File "/opt/cloudera/parcels/CDH-5.11.0-1.cdh5.11.0.p0.34/lib/hue/desktop/core/src/desktop/conf.py", line 1474, in get_database_password
    password = DATABASE.PASSWORD_SCRIPT.get()
  File "/opt/cloudera/parcels/CDH-5.11.0-1.cdh5.11.0.p0.34/lib/hue/desktop/core/src/desktop/lib/conf.py", line 147, in get
    return self.config.get_value(data, present=present, prefix=self.prefix, coerce_type=True)
  File "/opt/cloudera/parcels/CDH-5.11.0-1.cdh5.11.0.p0.34/lib/hue/desktop/core/src/desktop/lib/conf.py", line 263, in get_value
    return self._coerce_type(raw_val, prefix)
  File "/opt/cloudera/parcels/CDH-5.11.0-1.cdh5.11.0.p0.34/lib/hue/desktop/core/src/desktop/lib/conf.py", line 283, in _coerce_type
    return self.type(raw)
  File "/opt/cloudera/parcels/CDH-5.11.0-1.cdh5.11.0.p0.34/lib/hue/desktop/core/src/desktop/lib/conf.py", line 714, in coerce_password_from_script
    raise subprocess.CalledProcessError(p.returncode, script)
subprocess.CalledProcessError: Command '/opt/cloudera-manager/cm-5.11.0/run/cloudera-scm-agent/process/11-HUE-test-db-connection/altscript.sh sec-2-password' returned non-zero exit status 126

2017-06-19 23:05:03,938 INFO CommandPusher:com.cloudera.cmf.model.DbCommand: Command 27(HueTestDatabaseConnection) has completed. finalstate:FINISHED, success:false, msg:Unexpected error. Unable to verify da
tabase connection.




大家帮我看一下问题到底处在哪儿？ 这个问题纠缠我一个星期了，尝试过各种办法，搜遍了各种网站后解决无果。
先谢谢了

junmingliu 发表于 2017-8-25 23:36
楼主，上线了麻烦告诉一下解决方法  先谢过了。

是因为权限问题，我是在日志里看到的，把你的JAVA安装目录的java.exe chmod 777就可以了，777权限有点大，但是自己学习用可以了，希望对你有帮助

File "/opt/cloudera/parcels/CDH-5.11.0-1.cdh5.11.0.p0.34/lib/hue/desktop/core/src/desktop/lib/conf.py", line 714, in coerce_password_from_script raise subprocess.CalledProcessError(p.returncode, script)
subprocess.CalledProcessError: Command '/opt/cloudera-manager/cm-5.11.0/run/cloudera-scm-agent/process/11-HUE-test-db-connection/altscript.sh sec-2-password' returned non-zero exit status 126

2017-06-19 23:05:03,938 INFO CommandPusher:com.cloudera.cmf.model.DbCommand: Command 27(HueTestDatabaseConnection) has completed. finalstate:FINISHED, success:false, msg:Unexpected error. Unable to verify database connection.

关键在这几行，大概意思是密码问题，但不知道如何处理。

qwerty 发表于 2017-6-19 23:18
File "/opt/cloudera/parcels/CDH-5.11.0-1.cdh5.11.0.p0.34/lib/hue/desktop/core/src/desktop/lib/conf.p ...

用hue的用户名和密码，到mysql里面看看，是否有这个数据库

easthome001 发表于 2017-6-20 07:02
用hue的用户名和密码，到mysql里面看看，是否有这个数据库

有的，网上google了一下，最后两三行log的意思大概是hue无法从cloudera manager中拿到密码。但是不知道咋处理了

哪位有遇到相同问题的？一起讨论一下

qwerty 发表于 2017-6-20 14:00
哪位有遇到相同问题的？一起讨论一下

Centos是否最小安装，可能是缺组件，执行下面命令
[mw_shl_code=bash,true]yum install -y python-lxml[/mw_shl_code]

nextuser 发表于 2017-6-20 17:47
Centos是否最小安装，可能是缺组件，执行下面命令
[mw_shl_code=bash,true]yum install -y python-lxml[ ...

Package python-lxml-2.2.3-1.1.el6.x86_64 already installed and latest version
Nothing to do

可能不是这个问题，已经安装过了

这个问题太折磨人了，至今没找到原因

qwerty 发表于 2017-6-21 01:15
这个问题太折磨人了，至今没找到原因

看下这个跟你的问题类似
[求助]Unexpected error. Unable to verify database connection.
http://www.aboutyun.com/forum.php?mod=viewthread&tid=20455

哪位大神碰到过这个问题，求指教