From: | "Higuchi, Daisuke" <higuchi(dot)daisuke(at)jp(dot)fujitsu(dot)com> |
---|---|
To: | "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Supporting Subject Alternative Names for SSL connections on pgJDBC |
Date: | 2017-02-03 05:47:08 |
Message-ID: | 1803D792815FC24D871C00D17AE95905AC9F19@g01jpexmbkw24 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hello
I re-issue old discussions about "Subject Alternative Names (SANs)".
PostgreSQL can check SANs now [1], so pgJDBC should support this feature too, I think.
Seeing past activity about SANs, I found the patch is contributed by Bruno [2] but no committed.
I want to know developer's opinion about supporting SANs on pgJDBC.
This feature is useful when failover is occurred.
If failover is occurred, a single DNS name may point to different hosts after failover.
Certainly we can use wildcards in the server common name, but this does not work if hosts name are complexed.
On other words, common name "*.db.example.com" only works for names like "master.db.example.com", "slave.db.example.com",
but not for the "example.com" and "db-master.example.com" and "db-slave.example.com" or other more complex naming schemas.
I attached the initial patch (does not include unit test now), this is extracted from the patch created by Bruno and fixed a little.
[1] https://www.postgresql.org/docs/current/static/libpq-ssl.html
[2] https://www.postgresql.org/message-id/ja1a2v%24p2e%241%40dough.gmane.org
Regards,
Daisuke, Higuchi
Attachment | Content-Type | Size |
---|---|---|
subject_alternative_names_v1.patch | application/octet-stream | 1.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2017-02-03 11:59:42 | Re: postgresql-jdbc driver not respecting prepareThreshold=0 |
Previous Message | Malcolm Studd | 2017-02-02 22:22:30 | postgresql-jdbc driver not respecting prepareThreshold=0 |