SSH postgres
I have a bastion server within my AWS VPC with access to our postgres database. I have confirmed that I can SSH from my office (with public IP whitelisted) into the E2C server and then connect to the database. When I try to set up the DOMO connector with the same credentials and settings it is giving me this error:
"Failed to authenticate. Verify the credentials and try again. DOMO is ready but Postgres server returned with an error - Could not connect to Database server"
It's not telling me what the error is, i.e. if it is an issue with the SSH connection or the Database connection. Is there a specific postgres client I should install on the EC2? is there something I'm missing? I've whitelisted all the IP addresses from the list provided by DOMO.
Answers
-
Are you attempting to connect directly to the database via Domo? Did you whitelist the IP address on the Database server or your bastion server?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Yes we are trying to connect directly to the database with the SSH postreSQL connector. We have white-listed the IP addresses on our bastion server. Wouldn't it give me an error message that indicates that the SSH connection the issue? It seems like a two step process and the error message is indicating it is a problem connecting to the database. I'm confused because I'm able to connect manually, so my thought is there is an issue with the connector and the specific way it's trying to connect to the database. Of course, there could be something I'm missing.
0
Categories
- 11K All Categories
- 5 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 43 Domo News
- 9.9K Using Domo
- 2K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 349 Workbench
- 267 Domo Best Practices
- 12 Domo Certification
- 474 Domo Developer
- 51 Domo Everywhere
- 111 Apps
- 728 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 31 お知らせ
- 65 Kowaza
- 303 仲間に相談
- 664 ひらめき共有