https://linen.dev logo
Join Slack
Powered by
Hi guys, I want to connect to my google cloud post...
# ask-community-for-troubleshooting
q
Hi guys, I want to connect to my google cloud postgres instance, but have had no luck so far, i think I would need to whitelist airbyte's IP addresses to allow connections, can anyone help me with this?
✅ 1
c
where is your airbyte instance deployed?
q
on my local machine
c
are you able to connect to it from your local machine using a standard sql client?
q
yes
c
is that using SSL?
how do you connect to it?
then you probably don’t need to whitelist airbyte’s IP address… (it’s going to be your local machine IP address)
q
no i connected to my instance without ssl on datagrip currently, using the standard postgres jdbc url
ah got it
but @Chris (deprecated profile) is using my local machine's ip address to set up a connector feasible, won't the address keep changing?
c
are you required to whitelist your IP address to connect with datagrip?
q
no
so airbyte will work as well?
c
then similarly to datagrip, you shouldn’t have to whitelist your ip for airbyte then
I was just saying that since airbyte is running on your local machine, as long as you are able to access and connect to your instance from local machine, it should work within airbyte too
q
getting this, can you help me configure this
c
can you have a look at your server logs to get more details?
(maybe there is a log button at the bottom of the page to expand, or you can run 
docker logs server
) it’ll be helpful to have a better view on the exception stacktrace
q
message has been deleted
c
can you scroll up please? or copy paste more
q
c
it seems to try to connect to 
localhost:5433
is that correct?
q
yes
c
can you try 
host.docker.internal
instead of 
localhost
?
I am guessting you have something running that redirects from 
localhost
to your google cloud instance, right?
q
yes
thank you so much, it worked!
🎉 1
Ran into the same issue while setting up a new connector and needed some help, I keep getting this: "Could not connect with provided configuration. Error: Cannot create PoolableConnectionFactory (The connection attempt failed.)" Used host.docker.internal but still cant connect to my google cloud postgres instance
logs-88bcd86a-4a8b-4738-ba81-0b260e91e962-.txt
d
if you are connecting to your google cloud postgres instance, you should put in the google cloud postgres ip
the localhost/host.docker.internal settings are for dbs on your machine
q
Google cloud postgres ip isnt working as well @Davin Chia (Airbyte)
d
is the ip public? maybe there are some firewall rules blocking connections?
q
yes but cannot be connected without an ssl connection
d
you should be able to turn on SSL when setting up the connection
message has been deleted
q
yes that isnt working as well
3 Views
Open in Slack
PreviousNext
Powered by