Forum Academy Marketplace Showcase Pricing Features

Workaround - Fixed IP address for access to external DB's

Hi,

As Bubble has a dynamic IP - has anyone managed a workaround to get access to external DB’s that require the whitelisting of an IP Address to access the data?

You need a proxy. I would build my api request in aws with a static ip and go through that from bubble with a token.
you would need:
Api gateway
nat instance (ec2) or nat gateway
Lambda function in private vpc for routing, connected to the instance\gateway

Price wise nat gateway is more expensive but easier to setup than a nat instance.

4 Likes

Hi @matthew2 did you find a workable solution to this? Having the same issues and really didn’t want to go down the API route.

I can’t see what the workaround should be if a static ip is needed From the endpoint. If the provider support ip ranges you could use Integromat for a simpler setup, but that would quickly become expensive with many calls.

Yep, IP ranges for my use case will work with AWS security group inbound rules. I was just interested to see if Bubble had come back with a solution. It’s just a matter of knowing what hose ranges are, I have tried a few from the comments in older discussions but no joy!

I am calling https://apitest.syna.se/ where they have to set the calling ip for security reasons and it cant be a range, for the same reason, how would you do that then?

Found this article which helped me make an API call that required a whitelist IP address: AWS Lambdas with a static outgoing IP | by Financial Engines TechBlog | Financial Engines TechBlog | Medium

Do you know any tutorial to implement similar workaround with bubble?

Hi @simon7, just came across this thread because I have exactly the same problem as OP. Do you have any resources or guides you could link us to for this workaround with a proxy? How difficult is the setup and maintenance?

Thanks!

Hi @user4879
It does require a little bit of coding in either python/javescript and a bit of setup in AWS, but after that the maintenance is almost zero. There is also a generous free tier on AWS so pricing is minimal (and in most cases free for the first year).
I believe the tutorial @hellodwelling links to describes pretty much what has to be done, but I would recommend NOT using the console on AWS - it quickly gets messy. You need to look at a framework like Serverless Framework (easiest to begin with) or AWS CDK.

If its something you want to go forward with I can provide a base template in CDK in typescript with all the, but im pretty hung up at the moment so am not available for freelancing. You’d need to code the connection to the database yourself.

This exact solution is not no-code unfortunately :slight_smile:

1 Like