You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2021/05/18 07:47:35 UTC

[GitHub] [dolphinscheduler] cpbeast opened a new issue #5495: [1.3.6][dolphinscheduler-api] DataSourceController create mysql version 8.0 fail

cpbeast opened a new issue #5495:
URL: https://github.com/apache/dolphinscheduler/issues/5495


   ![image](https://user-images.githubusercontent.com/41602866/118612138-0fcc1880-b7f0-11eb-9bcf-8465a43867bf.png)
   It is only compatible with MySQL version 5.7, but not version 8.0
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [dolphinscheduler] cpbeast commented on issue #5495: [1.3.6][dolphinscheduler-api] DataSourceController create mysql version 8.0 fail

Posted by GitBox <gi...@apache.org>.
cpbeast commented on issue #5495:
URL: https://github.com/apache/dolphinscheduler/issues/5495#issuecomment-843720455


   > Can you describe your operation and provide the error log? I think this can work well with MySQL 8.0.
   > I have tested on MySQL 8.0.22, it will print a warning log, this is caused by ssl, if you also meet this problem, you can try to set `useSSL=false`
   
   ![image](https://user-images.githubusercontent.com/41602866/118751646-3e033400-b894-11eb-9409-a54669ef46c0.png)
   I just started to learn. I used docker compose deployment on MAC, and there was no change. From the log, it was the driver problem of connecting to MySQL. Version 8.0 should be com.mysql.cj.jdbc.driver


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #5495: [1.3.6][dolphinscheduler-api] DataSourceController create mysql version 8.0 fail

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #5495:
URL: https://github.com/apache/dolphinscheduler/issues/5495#issuecomment-842940361


   Hi:
   * Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
   * In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
   * If you haven't received a reply for a long time, you can subscribe to the developer's email,Mail subscription steps reference https://dolphinscheduler.apache.org/zh-cn/community/development/subscribe.html ,Then write the issue URL in the email content and send question to dev@dolphinscheduler.apache.org.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [dolphinscheduler] cpbeast commented on issue #5495: [1.3.6][dolphinscheduler-api] DataSourceController create mysql version 8.0 fail

Posted by GitBox <gi...@apache.org>.
cpbeast commented on issue #5495:
URL: https://github.com/apache/dolphinscheduler/issues/5495#issuecomment-843774644


   > @cpbeast I think you need to download the connector lib
   > ![image](https://user-images.githubusercontent.com/22415594/118758776-42cee480-b8a2-11eb-8793-536547fb1c5e.png)
   > 
   > Of course, you can choose a higher version of the connector, but what I want to say is that the current version can also work. It may be a good idea to provide version options when adding data sources, because sometimes different versions of Driver may not be compatible.
   
   大哥,你是上海的吗,你刚刚说的项目跑起来使用mysql的数据库吧,我是使用postgresql
   ![image](https://user-images.githubusercontent.com/41602866/118764134-98f45580-b8ab-11eb-95f1-9ccaac477e05.png)
   
   在页面 创建数据源,添加mysql数据源的时候,报错,看日志说是驱动的问题
   如果自己修改了源码,然后build镜像,取个自己的tag,然后使用docker-compose部署,应该可以吧


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [dolphinscheduler] ruanwenjun commented on issue #5495: [1.3.6][dolphinscheduler-api] DataSourceController create mysql version 8.0 fail

Posted by GitBox <gi...@apache.org>.
ruanwenjun commented on issue #5495:
URL: https://github.com/apache/dolphinscheduler/issues/5495#issuecomment-843722451


   @cpbeast I think this is caused by the driver missing, have you downloaded the MySQL connector lib? Maybe you can follow the tip in `How to support MySQL` https://dolphinscheduler.apache.org/en-us/docs/latest/user_doc/docker-deployment.html


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [dolphinscheduler] ruanwenjun commented on issue #5495: [1.3.6][dolphinscheduler-api] DataSourceController create mysql version 8.0 fail

Posted by GitBox <gi...@apache.org>.
ruanwenjun commented on issue #5495:
URL: https://github.com/apache/dolphinscheduler/issues/5495#issuecomment-843254113


   @cpbeast  Can you describe your operation and provide the error log?I think this can work well with MySQL 8.0. 
   I have tested on MySQL 8.0.22, it will print a warning log, this is caused by ssl, if you also meet this problem, you can try to set  `useSSL=false`
   https://github.com/apache/dolphinscheduler/blob/bc22ae7c91c9cbd7c971796ba3a45358c2f11864/dolphinscheduler-common/src/main/java/org/apache/dolphinscheduler/common/datasource/mysql/MysqlDatasourceProcessor.java#L54


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [dolphinscheduler] cpbeast commented on issue #5495: [1.3.6][dolphinscheduler-api] DataSourceController create mysql version 8.0 fail

Posted by GitBox <gi...@apache.org>.
cpbeast commented on issue #5495:
URL: https://github.com/apache/dolphinscheduler/issues/5495#issuecomment-843727722


   I understand. After downloading the source code, I should modify < mysql. Connector. Version > 8.0.21 < / MySQL. Connector. Version >. When loading the driver, I should change com.mysql.jdbc.driver to com.mysql.cj.jdbc.driver,then build docker images and deployed using docker compose
   ![image](https://user-images.githubusercontent.com/41602866/118754421-9db00e00-b899-11eb-9b4a-91609debdcfc.png)
   ![image](https://user-images.githubusercontent.com/41602866/118754449-abfe2a00-b899-11eb-9b12-57ea7fe21ea4.png)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [dolphinscheduler] ruanwenjun edited a comment on issue #5495: [1.3.6][dolphinscheduler-api] DataSourceController create mysql version 8.0 fail

Posted by GitBox <gi...@apache.org>.
ruanwenjun edited a comment on issue #5495:
URL: https://github.com/apache/dolphinscheduler/issues/5495#issuecomment-843254113


   @cpbeast  Can you describe your operation and provide the error log? I think this can work well with MySQL 8.0. 
   I have tested on MySQL 8.0.22, it will print a warning log, this is caused by ssl, if you also meet this problem, you can try to set  `useSSL=false`
   https://github.com/apache/dolphinscheduler/blob/bc22ae7c91c9cbd7c971796ba3a45358c2f11864/dolphinscheduler-common/src/main/java/org/apache/dolphinscheduler/common/datasource/mysql/MysqlDatasourceProcessor.java#L54


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [dolphinscheduler] ruanwenjun commented on issue #5495: [1.3.6][dolphinscheduler-api] DataSourceController create mysql version 8.0 fail

Posted by GitBox <gi...@apache.org>.
ruanwenjun commented on issue #5495:
URL: https://github.com/apache/dolphinscheduler/issues/5495#issuecomment-843747602


   @cpbeast I think you need to download the connector lib
   ![image](https://user-images.githubusercontent.com/22415594/118758776-42cee480-b8a2-11eb-8793-536547fb1c5e.png)
   
   Of course, you can choose a higher version of the connector, but what I want to say is that the current version can also work. It may be a good idea to provide version options when adding data sources, because sometimes different versions of Driver may not be compatible. 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [dolphinscheduler] cpbeast closed issue #5495: [1.3.6][dolphinscheduler-api] DataSourceController create mysql version 8.0 fail

Posted by GitBox <gi...@apache.org>.
cpbeast closed issue #5495:
URL: https://github.com/apache/dolphinscheduler/issues/5495


   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org