Supporting Subject Alternative Names for SSL connections on pgJDBC

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

Responses

Browse pgsql-jdbc by date

  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