Correct Bubble IP addresses to use for connecting from remote database auth

saeed.t.richardson · 2020-12-27T05:17:28.772Z

Hi, I am using the SQL Database Connector plugin for connecting to a remote PostgreSQL server. Since I’m only allowing access from certain ip’s I figure I do a reverse DNS lookup on my app’s URL to find the two following IP’s for Bubble:

$ host my-app-name.bubbleapps.io
my-app-name.bubbleapps.io has address 104.19.217.48
my-app-name.bubbleapps.io has address 104.19.218.48

The only problem is that those URLs;'s don’t seem to be working. Is anyone else experiencing this or am I just using the incorrect IP addresses (or not all of them)?

johnny · 2020-12-27T05:25:37.355Z

Maybe @peterj will have a thought on this

chris.williamson1996 · 2020-12-27T08:04:01.239Z

Bubble runs on dynamic IPs so it can be a variation of many different IPs, the only way to do IP auth is on a dedicated plan unless someone has found a work around.

saeed.t.richardson · 2021-01-04T07:37:50.282Z

thanks

NigelG · 2021-01-04T08:04:26.068Z

Bubble say that they don’t know the IP addresses, but we know the AWS server it runs on, and Amazon will tell you the range.

Bear in mind that the URL is almost certainly not pointing at the actual backend server, which will be the thing doing the work. You could run something in a test workflow to output that to a log.

In the past people have set up intermediate fixed IP routing services, and called that.

Mieya · 2021-01-04T08:26:56.072Z

if you want ip whitelist to connect mysql, postgresql, I provide a special server to get ip bubble and work dynamically. I’ve tried it using digitalocean and it works as expected.

IP Whitelist for sql database connector Jobs / Freelance

i use manage database from digital ocean. i use bubble only for frontend and middleware. i have a problem getting ip bubble to limit access to mysql database with sql db connector. I tried another way to get ip bubble statically to add to my whitelist ip. and here are some of the results that I can. ip whitelist is always updated. because i have to rent vps to get ip bubble. So it’s not free. If you are interested you can DM me. if my posts blame the rules. Don’t ban me. Please delete my po…

Nono · 2021-05-03T16:41:01.336Z

Hi
I have a dedicated plan.
Do you know how to collect or have a fix ip adress for connecting a remote database, managed on Digital Ocean?

anon38627393 · 2021-05-03T18:19:06.875Z

Your IP on dedicated plan will be exposed in (any) of your app’s settings tab, under the Domain/Email subtab. Plug that IP into DigitalOcean’s whitelisted IP’s.

ambacellar · 2022-12-15T09:51:43.931Z

Hi Nigel,
Would you explain or help me with that?
Thanks in advance
Andre

NigelG · 2022-12-15T13:03:45.503Z

ambacellar:

Would you explain or help me with that?

What is it you need?

ambacellar · 2022-12-15T19:48:21.562Z

I´m using an external database.
But as bubble.io doesn´t has a fixed ip, the database is open to all Ips.
When you said that “Amazon will tell you the range of Ip addresses” I understood that you know how overcome this issue.

NigelG · 2022-12-16T09:29:56.068Z

Potentially you can set your database IP range up to be the range of IP addresses of the Bubble server on AWS.

Not ideal if course, but it does at least reduce risks somewhat.

Amazon publish a list.

ambacellar · 2022-12-16T15:04:04.574Z

Thanks for your attention Nigel.

Would you mind to say where AWS publishs that IP range?

I could not find it.

NigelG · 2022-12-16T15:43:16.049Z

https://docs.aws.amazon.com/general/latest/gr/aws-ip-ranges.html

net-tt · 2023-11-24T20:33:53.526Z

Here is a link to the AWS IP range by region. What region should I use to whitelist the IP ranges?

doc.octoperf.com

IP Ranges - Documentation - OctoPerf

OctoPerf load testing - Amazon Web Services documentation page. List of IP Ranges used by OctoPerf cloud load injectors.