You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Once2012 (via GitHub)" <gi...@apache.org> on 2023/06/28 09:24:49 UTC

[GitHub] [doris] Once2012 opened a new issue, #21291: [Bug] 配置MySQL JDBC Catalog时include_database_list无效

Once2012 opened a new issue, #21291:
URL: https://github.com/apache/doris/issues/21291

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   OS: Ubuntu 20.04
   JDK: openjdk-11
   Doris: 1.2.4.1
   MySQL: 5.7
   MySQL Driver: 8.0.27
   MySQL Driver Class: com.mysql.cj.jdbc.Driver
   部署方式: 单机，1FE + 1BE
   
   ### What's Wrong?
   
   我使用如下语句创建一个MySQL JDBC Catalog:
   CREATE CATALOG jdbc_mysql_35 PROPERTIES (
       "type"="jdbc",
       "user"="user1",
       "password"="xxxxxxx",
       "jdbc_url" = "jdbc:mysql://xxxxxx:3306/testdb1?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8",
       "driver_url" = "mysql-connector-java-8.0.27.jar",
       "driver_class" = "com.mysql.cj.jdbc.Driver",
       "only_specified_database" = "true",
       "include_database_list" = "testdb1,testdb2"
   );
   
   注：
   1）user1用户拥有testdb1和testdb2的所有权限
   2）驱动jar已按要求放在be和fe的 jdbc_drivers目录下
   
   当创建Catalog完毕后，可以访问testdb1下的表，但不能访问testdb2下的表，报错如下：
   1049 - errCode = 2, detailMessage = Unknown database 'default_cluster:testdb2'
   
   ### What You Expected?
   
   我想知道如何能使include_database_list这个参数生效
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   曾经做过的尝试：
   1）将MySQL驱动类从com.mysql.cj.jdbc.Driver改为com.mysql.jdbc.Driver，问题依旧
   2）将MySQL驱动版本从8.0.27降为5.1.49，两个库都无法访问
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] zy-kkk commented on issue #21291: [Bug] 配置MySQL JDBC Catalog时include_database_list无效

Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk commented on issue #21291:
URL: https://github.com/apache/doris/issues/21291#issuecomment-1611590770

   #19589 fix it ,will release in 2.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.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] Once2012 commented on issue #21291: [Bug] 配置MySQL JDBC Catalog时include_database_list无效

Posted by "Once2012 (via GitHub)" <gi...@apache.org>.
Once2012 commented on issue #21291:
URL: https://github.com/apache/doris/issues/21291#issuecomment-1612532172

   > You can use 2.0 doris, this problem has been fixed above 2.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.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] hechao-ustc commented on issue #21291: [Bug] 配置MySQL JDBC Catalog时include_database_list无效

Posted by "hechao-ustc (via GitHub)" <gi...@apache.org>.
hechao-ustc commented on issue #21291:
URL: https://github.com/apache/doris/issues/21291#issuecomment-1611267920

   You can use 2.0 doris, this problem has been fixed above 2.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.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org