-
Notifications
You must be signed in to change notification settings - Fork 45
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
多机部署后,无法查询数据 #109
Comments
从报错上看是SCQLEngine访问MySQL错误,辛苦check下SCQLEngine配置中的连接串相关配置是否正确,以及在该节点内能否访问到对应MySQL |
各个SCQLEngine启动的容器(engine-alice和engine-bob)里,是可以正常查询本节点的数据的 |
mysql监听的是localhost还是具体的ip呢,如果不涉及隐私的话,方便分享下SCQLEngine的具体配置吗? |
各个SCQLEngine监听的是localhost,alice 的gflags.conf: |
感觉可能是host的原因,建议尝试将配置中的host=localhost改为host=127.0.0.1 |
嗯,也辛苦确认下mysql的port是不是默认的3306. |
能否展示下在SCQLEngine的container内部访问mysql的过程? |
确认下:对于SCQLEngine Alice来说,MySQL是个独立的容器,而不是和SCQLEngine在同一个容器中?(确认下我理解的对不对。。) |
确实是这个原因,问题得到解决 |
SCQLEngine能否直接配置本地的mysql,alice_init.sql这种形式限制了我们业务中使用scql |
可以配置的,在SCQLEngine中填正确可访问的host、port即可。 |
是的,只要有可访问的mysql服务,这个就不需要了。 |
我参考https://www.secretflow.org.cn/docs/scql/latest/zh-Hans/getting_started/deployment#create-docker-compose-file
部署了两方的SCQLEngine以及SCDB,但在测试SCQL,使用scdbclient进行两方联合查询时,报错:
容器里可以单独查询数据:
但使用scdbclient就无法执行查询:
The text was updated successfully, but these errors were encountered: