Hi,
1. As example, my metadata url is
"kylin.metadata.url=kylin_test@jdbc,url=jdbc:mysql://localhost:3306/kylin,username=root,password=xxxx,maxActive=10,maxIdle=10",
and please make sure that your "hostname" is a correct host to the DB! Not the
string "hostname" only.
2. what is the version of mysql-connector-java.jar? As a normal jar of the
connector, I use the jar "mysql-connector-java-5.1.40.jar".
--
Best regards.
Tengting Xu
在 2022-05-18 11:53:12，"Gao Michael" <[email protected]> 写道：
Hi all
My cluster env is:
Ubuntu server 20.4
Hadoop3.3.2
Hive3.1.2
Hbase2.4.11
Spark3.2.1
mysql Ver 8.0.29-0ubuntu0.20.04.3 for Linux on x86_64
My kylin version is: kylin-4.0.1-bin-spark3.tar.gz
I created user kylin in mysql and create databases both kylin and
kylin_metastore
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| hive_metastore |
| information_schema |
| kylin |
| kylin_metastore |
| mysql |
| performance_schema |
| sys |
+--------------------+
7 rows in set (0.00 sec)
I created ext fold:
michael@hadoop-cluster-001:~/opt/modules/kylin/apache-kylin-4.0.1-bin-spark3$
ls ext/
mysql-connector-java.jar
And I also set kylin.metadata.url in conf/kylin.properties:
kylin.metadata.url=kylin_metadata@jdbc,url=jdbc:mysql://hostname:3306/kylin,username=kylin,password=kylin,maxActive=10,maxIdle=10
But when I start kylin, I got error below:
2022-05-18 11:37:31,706 INFO [localhost-startStop-1]
persistence.JDBCConnectionManager:92 : Connecting to Jdbc with
url:jdbc:mysql://hostname:3306/kylin by user kylin
2022-05-18 11:37:31,937 WARN [localhost-startStop-1]
support.XmlWebApplicationContext:550 : 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:/home/michael/opt/modules/kylin/apache-kylin-4.0.1-bin-spark3/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:/home/michael/opt/modules/kylin/apache-kylin-4.0.1-bin-spark3/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:3306/kylin,username=kylin,password=kylin,maxActive=10,maxIdle=10
2022-05-18 11:37:31,941 ERROR [localhost-startStop-1] context.ContextLoader:350
: Context initialization failed
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:/home/michael/opt/modules/kylin/apache-kylin-4.0.1-bin-spark3/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:/home/michael/opt/modules/kylin/apache-kylin-4.0.1-bin-spark3/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:3306/kylin,username=kylin,password=kylin,maxActive=10,maxIdle=10
How can I solve this problem? Thanks!
