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
<[email protected]> 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 <[email protected]> 写道：
>
> 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 <[email protected]> 写道：
>>
>> 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
>><[email protected]> 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 <[email protected]> 写道：
>>>
>>> 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
>
