topic Re: SSL connection java.sql.SQLException with Redshift in Data Engineering

SSL connection java.sql.SQLException with Redshift

cfregly — Sat, 09 May 2015 21:35:31 GMT

Re: SSL connection java.sql.SQLException with Redshift

cfregly — Sat, 09 May 2015 21:38:30 GMT

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.

Re: SSL connection java.sql.SQLException with Redshift

mbphill — Thu, 25 Aug 2016 17:04:10 GMT

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?

Re: SSL connection java.sql.SQLException with Redshift

TianziCai — Wed, 14 Jun 2017 15:21:59 GMT

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

Re: SSL connection java.sql.SQLException with Redshift

TianziCai — Wed, 14 Jun 2017 21:09:16 GMT

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.