退订 发件人: Gao Michael <michael.ga...@hotmail.com> 发送时间: 2022年5月18日 11:53 收件人: user@kylin.apache.org 主题: mysql connect string
注意：此邮件来自组织外部，不要轻易点击链接或打开附件。 除非您认识该邮件发送者，并且确认内容是安全的。 CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender, and know the content is safe. 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$<mailto: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<mailto: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! 免责声明：本邮件所包含信息发给指定个人或机构，邮件可能包含保密或专属信息。未经接收者许可，不得阅读、转发或传播邮件内容，或根据邮件内容采取任何相关行动。如果错误地收到了此邮件，请与收件人联系并自行删除邮件内容。 Disclaimer：The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error , please contact the sender and delete the material from any computer .
