Skip to content
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

PG数据库加密SSL连接后报错连不上 #3590

Open
810123 opened this issue Dec 17, 2024 · 0 comments
Open

PG数据库加密SSL连接后报错连不上 #3590

810123 opened this issue Dec 17, 2024 · 0 comments

Comments

@810123
Copy link

810123 commented Dec 17, 2024

Please answer some questions before submitting your issue. Thanks!

Which version of XXL-JOB do you using?

2.3.0

Expected behavior

阿里云PG数据库设置了客户端加密,提供了证书,在xxl-job上配置了jdbc连接串,加上了ssl的参数。
DB地址:1921/库名?sslmode=verify-full&sslrootcert=/etc/ssl/certs/uat-ca.crt&sslcert=/etc/ssl/certs/uat-client.crt&sslkey=/etc/ssl/certs/uat-client.pk8

Actual behavior

JDBC连接串配置了加密 sslmode=verify-full ,也尝试了sslmode=required,均显示数据库连接不上,无其它SSL验证失败信息。把所有ssl参数移除后,也显示连接不上,无详细信息。把Pg数据库取消加密,就正常了。
但是这个证书用Pg客户端确能够连。怀疑是xxl-job不支持?

Steps to reproduce the behavior

Other information

XXL-JOB是否支持Pg数据库加密,如何显示详细的报错信息?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant