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安装的时候没有漏掉这个步骤rpm -ivh mysql-community-libs-compat-5.7.21-1.el7.x86_64.rpm
(compat解决hue数据库连接不上)
运行就不是mysql文件的问题，估计还是Hue自己的小bug
页:
[1]