engine里配置达梦数据源后，在发POST intra/table/create请求时，入参db_type是传mysql吗？

[oaHeZgnoS]

我的gflag配置如下：
--embed_router_conf={"datasources":[{"id":"ds001","name":"u1000","kind":"MYSQL","connection_str":"db=secure_net_temporary;user=root;password=iGw8F6PN11;host=mysql1;port=3306;auto-reconnect=true"},{"id":"ds002","name":"u1000_2","kind":"POSTGRESQL","connection_str":"dbname=postgres user=postgres password=123456 host=192.168.2.185 port=5432"},{"id":"ds003","name":"u1000_3","kind":"MYSQL","connection_str":"user=SYSDBA;password=SYSDBA001;host=192.168.1.117;port=5236;auto-reconnect=true"} ],"rules":[{"db":"*","table":"*","datasource_id":"ds001"},{"db":"public","table":"*","datasource_id":"ds002"} ]}

其中ds003数据源是达梦的。

[tongke6]

是的

[oaHeZgnoS]

是的

经过尝试性的自测，发现还是无法成功运行scql查询任务，在tables表中存储的ref_table值为SYSDBA.Data004_Classifier_Model_Guest_Test_5k，但查询报错：
Table 'SYSDBA.Data004_Classifier_Model_Guest_Test_5k' doesn't exist [mysql_stmt_errno]: 1146

请问是哪里还不对嘛？盼复

[tongke6]

检查下路由规则，目前是路由不到 ds003 的

[oaHeZgnoS]

检查下路由规则，目前是路由不到 ds003 的

最开始配置的路由是"rules":[{"db":"*","table":"*","datasource_id":"ds001"},{"db":"public","table":"*","datasource_id":"ds002"} ,{"db":"*","table":"*","datasource_id":"ds003"} ]，

然后engine会报已存在同样的路由，

所以改成了"rules":[{"db":"*","table":"*","datasource_id":"ds001"},{"db":"public","table":"*","datasource_id":"ds002"} ]

[oaHeZgnoS]

检查下路由规则，目前是路由不到 ds003 的

最开始配的：
--embed_router_conf={"datasources":[{"id":"ds001","name":"u1000","kind":"MYSQL","connection_str":"db=secure_net_temporary_db;user=root;password=fatE168dev;host=192.168.1.242;auto-reconnect=true"},{"id":"ds002","name":"u1000_2","kind":"POSTGRESQL","connection_str":"dbname=postgres user=postgres password=123456 host=192.168.2.195 port=5432"},{"id":"ds003","name":"u1000_3","kind":"MYSQL","connection_str":"user=SYSDBA;password=SYSDBA001;host=192.168.1.17;port=5236;auto-reconnect=true"} ],"rules":[{"db":"*","table":"*","datasource_id":"ds001"},{"db":"public","table":"*","datasource_id":"ds002"},{"db":"*","table":"*","datasource_id":"ds003"}]}

engine会报错：
2025-10-10 08:45:09.534 [error] [main.cc:main:364] [scqlengine] Fail to build engine service, msg=[engine/datasource/embed_router.cc:125] Fail to set default route rule: exists already.

所以改成了"rules":[{"db":"","table":"","datasource_id":"ds001"},{"db":"public","table":"*","datasource_id":"ds002"} ]

[YiAng603]

从介绍来看，为了更精确的匹配，rules中，"db":"","table":""不应都配置为"*"吧？
https://www.secretflow.org.cn/zh-CN/docs/scql/0.9.4b1/reference/engine-config#routing-rules

[oaHeZgnoS]

从介绍来看，为了更精确的匹配，rules中，"db":"","table":""不应都配置为"*"吧？ https://www.secretflow.org.cn/zh-CN/docs/scql/0.9.4b1/reference/engine-config#routing-rules

配置改成了：
--embed_router_conf={"datasources":[{"id":"ds001","name":"u1000","kind":"MYSQL","connection_str":"db=secure_net_temporary_db;user=root;password=fatE168dev;host=192.168.1.242;auto-reconnect=true"},{"id":"ds002","name":"u1000_2","kind":"POSTGRESQL","connection_str":"dbname=postgres user=postgres password=123456 host=192.168.2.195 port=5432"},{"id":"ds003","name":"u1000_3","kind":"MYSQL","connection_str":"user=SYSDBA;password=SYSDBA001;host=192.168.1.17;port=5236;auto-reconnect=true"} ],"rules":[{"db":"*","table":"*","datasource_id":"ds001"},{"db":"public","table":"*","datasource_id":"ds002"},{"db":"SYSDBA","table":"*","datasource_id":"ds003"}]}

报错：
ERROR: RunExecutionPlan run jobs(dd06fb7b-a5b7-11f0-aca9-0242ac140017) failed, catch std::exception=[engine/datasource/odbc_adaptor.cc:56] catch unexpected Poco::Data::DataException: Connection attempt failed: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 ; (peer: 10000004, code: 320, msg: RunExecutionPlan run jobs(dd06fb7b-a5b7-11f0-aca9-0242ac140017) failed, catch std::exception=[engine/datasource/odbc_adaptor.cc:56] catch unexpected Poco::Data::DataException: Connection attempt failed: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 )

日志：

2025-10-10 09:00:53.430 [error] [engine_service_impl.cc:RunPlanSync:364] [scqlengine] RunExecutionPlan run jobs(8d9cbda3-a5b7-11f0-aca9-0242ac140017) failed, catch std::exception=[engine/datasource/odbc_adaptor.cc:56] catch unexpected Poco::Data::DataException: Connection attempt failed: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 

2025-10-10 09:00:53.432 [info] [engine_service_impl.cc:ReportResult:257] [scqlengine] session(8d9cbda3-a5b7-11f0-aca9-0242ac140017) send rpc request to driver, callback_url=http://192.168.1.242:8011/intra/cb/engine
2025-10-10 09:00:53.434 [info] [engine_service_impl.cc:ReportResult:268] [scqlengine] session(8d9cbda3-a5b7-11f0-aca9-0242ac140017) report success, get response ({}), used(2ms)```

[tongke6]

可以先排查下连接串或者数据库配置是否有问题。排查方法：进入到 engine 容器里，使用配置的连接串，用 mysql client 看是否可以连上。

[oaHeZgnoS]

使用配置的连接串，用 mysql client 看

未进入容器之前，telnet达梦端口是通的；进入容器之后，没有发现mysql client，需要自己映射进去一个吗？

[tongke6]

可以在容器里装一个

[tongke6]

不要只是 telnet，需要用 mysql client 连，连上后也执行下 query 看看

[oaHeZgnoS]

不要只是 telnet，需要用 mysql client 连，连上后也执行下 query 看看

试了一下，我们达梦配置文件里已经是mysql兼容模式了：
COMPATIBLE_MODE = 4 #Server compatible mode, 0:none, 1:SQL92, 2:Oracle, 3:MS SQL Server, 4:MySQL, 5:DM6, 6:Teradata, 7:PG

然后用mysql client连接会超时报错：

root@1a4f9b4ab2ce:/home/admin# mysql -h 192.168.1.36 -P 5237 -u SYSDBA -p
Enter password: 
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 2

排查后，应该是需要再加个MYSQL_PORT或COMPAT_MYSQL_PORT，作为mysql协议的端口，两个都分别添加并重启dm8后，都不生效，端口（配的5238）未占用。请问是哪里不对吗？

[tongke6]

建议咨询达梦数据库或者网上找下资料

[oaHeZgnoS]

建议咨询达梦数据库或者网上找下资料

经与达梦官方确认，https://eco.dameng.com/community/question/e1cba35018c0392eb14a4e7f8adfed79

达梦不支持所谓mysql协议去连接，所以是不是scql就不支持达梦呢？

[YiAng603]

咨询了一下社区用户@Handikang，得到了一些回复，您可以尝试一下。