r2dbc-postgresql icon indicating copy to clipboard operation
r2dbc-postgresql copied to clipboard

#653 SNIHostName is going to throw an exception when hostname has a traili…

Open seanmcnealy opened this issue 1 year ago • 2 comments
trafficstars

…ng dot

Make sure that:

  • [X] You have read the contribution guidelines.
  • [X] You have created a feature request first to discuss your contribution intent. Please reference the feature request ticket number in the pull request.
  • [X] You use the code formatters provided here and have them applied to your changes. Don't submit any formatting related changes.
  • [X] You submit test cases (unit or integration tests) that back your changes.

Issue description

SSL SNI hostname with trailing dot unable to connect

New Public APIs

Additional context

Minor issue, as there is an easy workaround to disable SNI through configuration that avoids the issue entirely. The underlying library throws an error when there is a trailing dot on an SNI hostname. Looks easy enough to match that library's validation in the SSLConfig validation.

seanmcnealy avatar Jun 06 '24 01:06 seanmcnealy

How come that a host name returned from InetSocketAddress ends with a dot?

mp911de avatar Jun 06 '24 07:06 mp911de

Looks like some DNS clients support adding a trailing dot which signifies to not use a search domain when resolving a name. I'm not an expert on this, I just have a coworker who used this convention when setting some environment variables.

I've tested 1.0.4 (works) and 1.0.5 (throws validation exception) with the following code:


import io.r2dbc.postgresql.PostgresqlConnectionConfiguration
import io.r2dbc.postgresql.PostgresqlConnectionFactory
import io.r2dbc.postgresql.client.SSLMode

val config =
    PostgresqlConnectionConfiguration.builder()
        .host("database.internal.")
        .port(5432)
        .database("reporting")
        .username("user")
        .password("xxxx")
        .sslMode(SSLMode.REQUIRE)
        .build()
val factory = PostgresqlConnectionFactory(config)

factory.create().block()

I could also see trimming trailing dots before sending to the SNIHostName constructor as valid. That would support SNI better, I think. Unless changing hostnames at all can cause more surprising results.

seanmcnealy avatar Jun 06 '24 16:06 seanmcnealy

Thank you for your contribution. That's merged, polished, and backported now.

mp911de avatar Oct 02 '24 08:10 mp911de