Ambari2.7.5+HDP3.1.5集成Kylin4.0.1所遇到的问题

网上已存在不少集成所遇到的问题，这里记录一下个人所遇到的三个问题。

1. 问题一

KeyError: u'kylin'
Error: Error: Unable to run the custom hook script ['/usr/bin/python', '/var/lib/ambari-agent/cache/stack-hooks/before-ANY/scripts/hook.py', 'ANY', '/var/lib/ambari-agent/data/command-604.json', '/var/lib/ambari-agent/cache/stack-hooks/before-ANY', '/var/lib/ambari-agent/data/structured-out-604.json', 'INFO', '/var/lib/ambari-agent/tmp', 'PROTOCOL_TLSv1_2', '']

解决方法：

cd /var/lib/ambari-server/resources/scripts
python configs.py -u username -p password -n clusterName -l hostname -t 8080 -a set -c cluster-env -k ignore_groupsusers_create -v ture

# username：ambari用户名
# password：ambari密码
# clusterName：ambari集群名称
# hostname：ambari-server所在机器名称

2. 问题二

# kylin集成完成后，无法访问Web页面（404），查看日志，定位到异常信息（mysql版本为8.0.26）：
Unable to load authentication plugin 'caching_sha2_password'

解决方法：

-- 用户名为kylin配置文件中的mysql用户名
alter user 'root'@'%' identified by '123456' password expire never;
alter user 'root'@'%' identified with mysql_native_password by '123456';
flush privileges;

-- 或者降低到8.0以下版本

3. 问题三

# 同样是kylin集成完成后，无法访问Web页面（404），查看日志，定位到异常信息：
context.ContextLoader:350 : Context initialization failed
Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'diagnosisService': Unsatisfied dependency expressed through field 'aclEvaluate'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'aclEvaluate': Unsatisfied dependency expressed through field 'aclUtil'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'aclUtil' defined in URL [jar:file:/opt/soft/kylin/tomcat/webapps/kylin/WEB-INF/lib/kylin-server-base-4.0.1.jar!/org/apache/kylin/rest/util/AclUtil.class]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'expressionHandler' defined in class path resource [kylinSecurity.xml]: Cannot resolve reference to bean 'permissionEvaluator' while setting bean property 'permissionEvaluator'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'permissionEvaluator' defined in class path resource [kylinSecurity.xml]: Cannot resolve reference to bean 'aclService' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'aclService' defined in URL [jar:file:/opt/soft/kylin/tomcat/webapps/kylin/WEB-INF/lib/kylin-server-base-4.0.1.jar!/org/apache/kylin/rest/service/AclService.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.kylin.rest.service.AclService]: Constructor threw exception; nested exception is java.lang.IllegalArgumentException: Failed to find metadata store by url: kylin_metadata@jdbc,url=jdbc:mysql://hostname:port/kylin,username=root,password=123456,maxActive=10,maxIdle=10

解决方法：

# 查看KYLIN_HOME/ext目录下的mysql驱动包，尽量保证版本一致。
原驱动包：mysql-connector-java.jar
修改为：mysql-connector-java-8.0.26.jar