CDH5.11.0 HUE 连接mysql 测试连接失败

   小弟初来报道。根据教程安装CDH5.11.0时，在安装hue，测试连接mysql发现如下报错。在网上查找攻略，说是JDK文件夹权限问题，但JDK文件夹权限已经设置成777了，还是不行。求大佬解答，万般感激。


-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2018-08-08 09:51:43,365 INFO CommandPusher:com.cloudera.cmf.service.AbstractOneOffHostCommand: Unsuccessful 'HueTestDatabaseConnection'
2018-08-08 09:51:43,365 INFO CommandPusher:com.cloudera.cmf.service.AbstractDbConnectionTestCommand: Command exited with code: 1
2018-08-08 09:51:43,365 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.7/site-packages/Django-1.6.10-py2.7.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.7/site-packages/Django-1.6.10-py2.7.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.7/site-packages/Django-1.6.10-py2.7.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/cm-5.11.0/run/cloudera-scm-agent/process/91-HUE-test-db-connection/altscript.sh sec-2-password' returned non-zero exit status 126

2018-08-08 09:51:43,365 INFO CommandPusher:com.cloudera.cmf.model.DbCommand: Command 129(HueTestDatabaseConnection) has completed. finalstate:FINISHED, success:false, msg:Unexpected error. Unable to verify database connection.

-----------------------------------------------------------------------------------------------------------------------------------------------------------

sstutu 发表于 2018-8-8 21:17
跟这个问题类似
CDH安装hue测试数据库连接报错
http://www.aboutyun.com/forum.php?mod=viewthread&tid=2 ...

谢谢解答。请问是要下载libmysqlclient_r.so.16 吗？/usr/lib64/mysql目录下面已经有了libmysqlclient_r.so.18和libmysqlclient_r.so.20

跟这个问题类似
CDH安装hue测试数据库连接报错
http://www.aboutyun.com/forum.php?mod=viewthread&tid=21142

跟你一样的问题想问你解决了没有

我的解决办法是，先自定义组件安装，去掉hue，然后安装成功后在回头在cluster1—>操作—>添加服务—>添加hue，按照之前的操作就能够连接上了，应该不会是libmysqlclient_r.so.16文件的问题，我们的版本与之替代的应该是libmysqlclient_r.so.18和libmysqlclient_r.so.20，16只是之前的版本，只要mysql安装的时候没有漏掉这个步骤[mw_shl_code=applescript,true]rpm -ivh mysql-community-libs-compat-5.7.21-1.el7.x86_64.rpm
(compat解决hue数据库连接不上)
[/mw_shl_code]运行就不是mysql文件的问题，估计还是Hue自己的小bug