sqle icon indicating copy to clipboard operation
sqle copied to clipboard

pg数据源密码不支持%号

Open taolx0 opened this issue 1 year ago • 0 comments

版本信息(Version)

2.2306-ee main

问题描述(Describe)

创建pg数据源,如果密码带%号,测试数据源连接失败

补充

  • [ ] 社区反映PG数据源密码中同时包含@和#号会连接失败,去掉后能正常连接,未经测试,需要issue处理人验证

截图或日志(Log)

image

返回response信息

{
    "code": 0,
    "message": "ok",
    "data": {
        "is_instance_connectable": false,
        "connect_error_message": "open plugin: rpc error: code = Unknown desc = init config: get database connection failed when new driver: failed to connect to `host=[10.186.62.34](http://10.186.62.34/) user=ops2 database=postgres`: failed SASL auth (FATAL: password authentication failed for user \"ops2\" (SQLSTATE 28P01))"
    }
}

如何复现(To Reproduce)

  1. 创建一个密码带%的账户 image

  2. 打开sqle,创建该数据源,点击测试数据库连通性,连接失败 image

实现方案

变更影响面

受影响的模块或功能

外部引用的潜在问题或风险

版本兼容性

测试建议

taolx0 avatar Apr 26 '24 09:04 taolx0