Cannot connect Retool Database to Zapier

Queries and Resources
1

We have tried following the instructions here: Connect Retool database with Zapier/Make and here: Connection errors - Neon Docs

We are passing the endpoint in the password field, but Zapier keeps returning this error:

authentication failed: Could not connect with (insert our string username) and provided password. The response we got from the server is included below for debugging purposes. (psycopg2.OperationalError) ERROR: password authentication failed for user 'insert our string username' (Background on this error at: Error Messages — SQLAlchemy 1.4 Documentation)

Has anyone else connected to Zapier recently? We just had support migrate our database as we were missing the connection tab a few days ago. We also tried resetting the password for the connection string, but that didn't help.

Here's how we're entering the details to Zapier (replacing our info with "string"):

Host: string.retooldb.com
Port: 5432
Database: string?sslmode=require
Schema: public
Username: string
Password: endpoint=$ (we've also tried formatting this with ; instead of $ and [] instead of <>.
Enforce Encryption: true (though Zapier says it doesn't matter)

Thanks for any help or tips!

2

Without using the string ?sslmode=require I get this error:

authentication failed: Could not connect with retool and provided password. The response we got from the server is included below for debugging purposes. (psycopg2.OperationalError) ERROR: password authentication failed for user 'string' ERROR: connection is insecure (try using sslmode=require) (Background on this error at: Error Messages — SQLAlchemy 1.4 Documentation)

1 Like
3

Setting this up again on my end, will let you know ASAP

4

Can you share the syntax you used for the password field? Feel free to change the endpoint and password.

5

I used: endpoint=[ep-something-something-something]$[password]

6

can you try without the []around the endpoint and password

7

That worked! Thank you so much!

1 Like