Connection to Zapier not working
I followed all the steps and even added the endpoint to the password field but I'm getting this error message:
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 'retool' ERROR: connection is insecure (try using
sslmode=require) (Background on this error at: https://sqlalche.me/e/14/e3q8)17 Replies
xenial-black•2y ago
This error occurs when the postgres client is refusing to use TLS to encrypt the connection. We don't allow any connections without TLS
useful-bronzeOP•2y ago
@Conrad Ludgate Is there a way to do this using Zapier?
I used this but it's still not working: endpoint=<endpoint_id>$<password>
xenial-black•2y ago
Yeah that won't enable TLS, that's to get around the TLS implementation not supporting Server Name Identification (SNI). Ill check the Zapier docs
xenial-black•2y ago
Do you have a configuration option named "Enforce encryption" anywhere?
useful-bronzeOP•2y ago
useful-bronzeOP•2y ago
useful-bronzeOP•2y ago
these are all of the fields
useful-bronzeOP•2y ago
the retool team claimed they were able to make it work on this support thread:
https://community.retool.com/t/connect-retool-database-with-zapier-make/19279/3
Retool Forum
Connect Retool database with Zapier/Make
Hey all, so the connection string just holds all the information for Host, Port, DB etc. Make.com needs these variables individually filled out, it doesn't support connection strings. Copy your connection string and fill out your details as follows: postgresql://production:xxxxxxx@yyyyyyy.retooldb.com/production --- User:
production Pa...useful-bronzeOP•2y ago
the enforce encryption option is there but it's been deprecated
xenial-black•2y ago
Strange. Their error message does have TLS setup, but not SNI. Your error message indicates that it does not even get to the TLS setup.
useful-bronzeOP•2y ago
If i don't use the endpoint in the password field, I'll get the same error message that they have
xenial-black•2y ago
Oh, really?
useful-bronzeOP•2y ago
yah let me try it so i can send you a screenshot
useful-bronzeOP•2y ago
xenial-black•2y ago
Can you DM me your endpoint ID and I can take a look at some logs for you
useful-bronzeOP•2y ago
sure
sent
xenial-black•2y ago
Ok, I see what went wrong here
Resolved in DMs. A mixture of not having the full endpoint ID/wrong password. Not exactly sure why the SSL error shows, but it seems like zapier is trying two connections, one with SSL then it tries again without SSL, showing both errors