Hi folks, need help with postgres data source. I g...
# gooddata-cloud
v
Hi folks, need help with postgres data source. I get the following error. I have whitelisted ELB IPs after running
nslookup
j
Hi Vijay, Could you please confirm the url you are trying to connect to, and make sure it is in the correct format as mentioned here? https://www.gooddata.com/docs/cloud/connect-data/create-data-sources/postgresql/ Please double-check the user rights and all the other steps in the documentation as well.
v
The database is AWS RDS. I have verified that it is correct as I'm able to access the database from my database client
j
May I know where exactly are you receiving this error? Is it in modeller while trying to connect to the datasource? Or you were not able to connect to datasource at all? Even testing the connection doesn’t work for you?
v
I'm receiving the error here
j
Hi Vijay, This is what I can see in our logs: ``"message=Cannot reach the URL,<no detail>"`` Unfortunately I cannot see much more so it’s rather hard to tell where is the issue from our end. I would definitely double-check the below: • ensure the host, port, username, and password in your data source settings are correct. • If using SSL, verify that the correct SSL certificates are in place. • If the PostgreSQL database is hosted on-premise or behind a VPN, GoodData must be allowed to connect. • Whitelist GoodData’s IP ranges in your database’s network settings. • If your database is in AWS, ensure security groups allow inbound connections from GoodData. In case there is an incorrect connection settings in GoodData: • Re-enter credentials to rule out typos. • Test Connection in the UI. • If needed, delete and re-add the data source.