Great, it's my pleasure to see your steps in deploying kylin4.0 in AWS! I think many users would like to see these steps.
Maybe you can write it on the Apache kylin wiki<https://cwiki.apache.org/confluence/display/KYLIN/Apache+Kylin+Home>. You can create a wiki account, and then we will give you permission to edit the wiki or add new pages. Of course, you can share it in any other way you like! > 在 2020年9月11日，21:47，ShaoFeng Shi <shaofeng...@apache.org> 写道： > > Awesome! Glad to see the first evaluation feedback of Kylin 4! > > Best regards, > > Shaofeng Shi 史少锋 > Apache Kylin PMC > Email: shaofeng...@apache.org > > Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html > Join Kylin user mail group: user-subscr...@kylin.apache.org > Join Kylin dev mail group: dev-subscr...@kylin.apache.org > > > > > hubert stefani <hubert_stef...@yahoo.fr.invalid> 于2020年9月11日周五 下午9:20写道： > >> Thanks for your advice. We succeeded in getting The Web UI running. >> >> We have gathered the different configuration steps in a documentation we >> will share soon if you want. >> It may help to overcome the specific deployment of Kylin on aws >> .Regards,hubert >> >> Le vendredi 11 septembre 2020 à 10:44:26 UTC, Yaqian Zhang < >> yaqian_zh...@126.com> a écrit : >> >> If you wan’t to create a user and database and grant the roles for kylin >> metadata. You can follow the steps below: >> >> 1、Use root user login mysql: mysql -u root -pPassword >> 2、create a user named Kylin and password is kylin: CREATE USER 'kylin'@'%' >> IDENTIFIED BY 'kylin’; >> 3、create database kylin：create database kylin; >> 4、grant roles：GRANT ALL ON kylin.* TO 'kylin'@'%’; >> >> Then you can use >> 'kylin_metadata_test@jdbc,url=jdbc:mysql://master:3306/kylin,username=kylin,password=kylin,maxActive=10,maxIdle=10 >> <mysql://master:3306/kylin,username=kylin,password=kylin,maxActive=10,maxIdle=10'>' >> <mysql://master:3306/kylin,username=kylin,password=kylin,maxActive=10,maxIdle=10'> >> as kylin.metadata.url. >> >>> 在 2020年9月11日，17:59，Yaqian Zhang <yaqian_zh...@126.com> 写道： >>> >>> It seems that mysql have some problem, I find some related webpage >> provide follow method to resolve this error: >>> >>> Add below content in /etc/mysql/my.cnf: >>> >>> wait_timeout=31536000 >>> interactive_timeout=31536000 >>> >>> Then restart mysql. >>> >>> I’m not sure it works, you can try. >>> >>>> 在 2020年9月11日，17:37，hubert stefani <hubert_stef...@yahoo.fr.INVALID> 写道： >>>> >>>> we did so (we found out the jar was actually missing), and then we got >> the error below. (additional information : we try to deploy on aws emr >> 5.30) >>>> >>>> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications >> link failure >>>> >>>> The last packet sent successfully to the server was 0 milliseconds ago. >> The driver has not received any packets from the server. >>>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>>> at >> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) >>>> at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >>>> at java.lang.reflect.Constructor.newInstance(Constructor.java:423) >>>> at com.mysql.jdbc.Util.handleNewInstance(Util.java:408) >>>> at >> com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1137) >>>> at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:356) >>>> at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2504) >>>> >>>> is there a step to create the database, create users and grant roles ? >>>> Hubert >>>> Le vendredi 11 septembre 2020 à 09:30:27 UTC, Yaqian Zhang < >> yaqian_zh...@126.com> a écrit : >>>> >>>> Hi Hubert: >>>> >>>> Have you put mysql-connector-java-xxx.jar into $KYLIN_HOME/ext ? >>>> >>>> You can download the mysql JDBC jar from >> https://downloads.mysql.com/archives/c-j/ < >> https://downloads.mysql.com/archives/c-j/>. >>>> >>>>> 在 2020年9月11日，17:17，hubert stefani <hubert_stef...@yahoo.fr.INVALID> >> 写道： >>>>> >>>>> Hi, >>>>> we encounter the following error when we start the Web UI. it seems >> that mysql-driver is missing. Have we made a misconfiguration ? Is there a >> detailed configuration ? >>>>> >>>>> >>>>> Exception in thread "main" java.lang.IllegalArgumentException: Failed >> to find metadata store by url: kylin_metadata@jdbc >> ,url=jdbc:mysql://localhost:3306/kylin,username=XXXX,password=XXXXXX,maxActive=10,maxIdle=10 >>>>> at >> org.apache.kylin.common.persistence.ResourceStore.createResourceStore(ResourceStore.java:101) >>>>> at >> org.apache.kylin.common.persistence.ResourceStore.getStore(ResourceStore.java:113) >>>>> at >> org.apache.kylin.common.persistence.ResourceTool.copyParallel(ResourceTool.java:153) >>>>> at >> org.apache.kylin.common.persistence.ResourceTool.main(ResourceTool.java:102) >>>>> Caused by: java.lang.reflect.InvocationTargetException >>>>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native >> Method) >>>>> at >> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) >>>>> at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >>>>> at java.lang.reflect.Constructor.newInstance(Constructor.java:423) >>>>> at >> org.apache.kylin.common.persistence.ResourceStore.createResourceStore(ResourceStore.java:94) >>>>> ... 3 more >>>>> Caused by: java.lang.IllegalArgumentException: >> org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class >> 'com.mysql.jdbc.Driver' >>>>> at >> org.apache.kylin.common.persistence.JDBCConnectionManager.<init>(JDBCConnectionManager.java:68) >>>>> at >> org.apache.kylin.common.persistence.JDBCConnectionManager.getConnectionManager(JDBCConnectionManager.java:48) >>>>> >>>>> Regards,Hubert >>> >>
