Appsheet to DigitalOcean

[Annie_Thomas]

How can we connect from Appsheet to Digital Ocean postgres database ?

[Steve]

help.appsheet.com

Using Data from PostgreSQL

How to build an AppSheet app with data from PostgreSQL.

[tunasammich]

Hi, I've done everything suggested in that article, including adding every single appsheet IP address to the trusted user list, and I'm still getting a timeout error. I'm really not sure what else to try here. Any help is greatly appreciated, thanks.

Edit: I kinda suspect that it's because the port number digitalocean uses is not 5432, but I tried adding the port at the end like I would with the connection string and it couldn't find the database at all when I did that.

[Jordan_Davis1]

I'm having the same issue.  I reached out to appsheet support who said that it's likely because I need an SSL certificate, however, I have an SSL certificate and have not been able to connect at all.  At this point, I think it's safe to say that Appsheet cannot connect to DigitalOcean Postgres instances.

[Jordan_Davis1]

As a side note, I have successfully connected with an Amazon RDS instance without using SSL, so it is possible to connect postgres just not with digitalocean which requires SSL.

[tunasammich]

I think so too. On other platforms where I can connect to it I have the option of choosing the port, and here you cannot, so I think it must only connect to postgres databases that use the default port.

[Jordan_Davis1]

You can add the port in the host field.  i.e. if your host address is:

foo--user-0002424-1.b.db.ondigitalocean.com

enter it as:

foo--user-0002424-1.b.db.ondigitalocean.com:25060

Now when you try it you'll see a new error message "Error Failed to establish connection. (postgres): The remote certificate is invalid according to the validation procedure."

[Jordan_Davis1]

@tunasammich I finally got it to work. 

Instead of entering the host address i.e. foo--user-0002424-1.b.db.ondigitalocean.com, use the IP address.   If you don't know your host's IP you can get it from your local cli. i.e. if you're on a mac, open up terminal and enter:

ping foo--user-0002424-1.b.db.ondigitalocean.com

You'll see the ip address come up.  Enter that into the Server field followed by a colon followed by the port number 25060. 

i.e. if your server's IP address is 12.34.567.899, enter 12.34.567.899:25060. 

Hit test and it should work.

[SkrOYC]

Good news for you.

SSL haven't worked on my side ever

[tunasammich]

I know it's been forever since I responded to this because I kinda gave up and thought I might just use AWS if I was going to go with appsheet---but I am loathe to try this because I'm fairly certain that digitalocean gives you a leased IP and not static IP. It might persist for a long time, or until you destroy the droplet, but I'm just worried it will cause a headache in the future. I just wish there was a way to enter a different port number with the actual host address