DB Connector cannot reach Postgres when secure/hostssl

Bugs
1

Continuing the discussion from [New Feature] Database connector:

I thought it might best to formally report this as a bug.

I can’t seem to connect my postgres database – provided by aiven.io – to the database connector plugin. All indications point to hostssl/secure connection requirements in the pg_hba.conf but accordingly no support for SSL connections on bubble’s side. The behavior I expect is for bubble to connect to databases over SSL when possible (or, at the very least, when necessary).

For your testing purposes I’ve prepared a database for you to use as reference.

postgres://bubble:wbuze5nnesaxb0vo@pg-1704f6a0-shq.prj-t5lw11.aivencloud.com:27777/d9l1h5z5?sslmode=require

As of the time of this writing, there is no data on the database.
The database will be available for a limited time (< 2 weeks) and will be destroyed thereafter.
The provided password was created using a random generator.

Thanks in advance and let me know if there’s anything else I can do to help get proper SSL support,
Justin

2

I realize this is from a while ago, but I had the same problem and found the solution: Add ssl=true to the end of the DSN. So it would be postgres://user_name:password@host_name:port/database?ssl=true

4 Likes
3

You are a god :pray:

4

Thannnnks

1 Like