Postgres Source Setup Error with SSL Configuration

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

User encounters a FileNotFoundException when attempting to connect to a Postgres source using SSL mode ‘require’. The error indicates that the specified SSL certificate file ‘/sqoop/client.crt’ cannot be found, despite being mounted as a volume in the Airbyte containers.


Question

Getting Following error when setting up a Postgres Source. The crt and pk8 file are mounted as volumes and are visible from inside the airbyte-server, airbyte-worker and airbyte-temporal containers.
I’m using sslmode: require with following jdbc parameters : sslcert=/sqoop/client.crt&sslkey=/sqoop/client.pk8

	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:263)
	at org.postgresql.Driver.makeConnection(Driver.java:443)
	at org.postgresql.Driver.connect(Driver.java:297)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
	at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:733)
	at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
	at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: java.io.FileNotFoundException: /sqoop/client.crt (No such file or directory)
	at java.base/java.io.FileInputStream.open0(Native Method)
	at java.base/java.io.FileInputStream.open(FileInputStream.java:216)
	at java.base/java.io.FileInputStream.<init>(FileInputStream.java:157)
	at java.base/java.io.FileInputStream.<init>(FileInputStream.java:111)
	at org.postgresql.ssl.LazyKeyManager.getCertificateChain(LazyKeyManager.java:159)
	... 38 more```


<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1703147203087049) if you want
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
['postgres-source', 'ssl-configuration', 'file-not-found', 'jdbc-parameters']
</sub>