SSL connection java.sql.SQLException with Redshift

[cfregly]

If you see the following error without SSL:

java.sql.SQLException: [Amazon](500150) Error setting/closing connection: no pg_hba.conf entry for host "x.x.x.x", user "user", database "database", SSL off.

then the following error with SSL enabled:

java.sql.SQLException: [Amazon](500150) Error setting/closing connection: General SSLEngine problem.

You can try appending

sslfactory=org.postgresql.ssl.NonValidatingFactory

to the connection URL to fix the problem.

[mbphill]

I am having the same issue. That did not work for me I am still getting the same error. Did you get your issue resolved?

[TianziCai]

I also have the same issue. The suggested solution did not work. Also as a side note, everything had been working until last Friday...

[TianziCai]

sample = (spark.read
          .format("com.databricks.spark.redshift")
          .option("url", jdbcUrl)
          .option("dbtable", "xx.xxx") # schema, table
          .option("forward_spark_s3_credentials", True)
          .option("tempdir", tempDir)
          .option("autoenablessl", "false") # disable SSL. 
          .load())

The above suggested solution didn't work for me, but disabling SSL did. I wish there was a better solution.