Neon.tech with Budibase - ETIMEDOUT
Has anyone been able to connect these two without issue?
Im trying to use Budibase a front went and Neon.tech as the database, but so far i've had no luck with Neon.Tech (or even Supabase), no matter what configuration i try.
I've asked in the Budibase discord, but curious if anyone has had any luck connecting the two with the datasource without this error: "Error creating datasource: Unable to connect: ETIMEDOUT"
Is this a known error on postgres with a solution?
26 Replies
like-goldOP•2y ago
I've installed a local version of budibase, and it connects without issues. so i suspect it's something on budibase's end of SaaS, and not neon.tech. I'll close this and continue here https://github.com/Budibase/budibase/issues/13665
GitHub
Unable to connect to SaaS postgreSQL datasource in cloud, but exact...
Checklist [ X] I have searched budibase discussions and github issues to check if my issue already exists Hosting Self Method: docker cli Budibase Version: 2.25.0 App Version: neon.tech 2024 Cloud ...
harsh-harlequin•2y ago
Does this error occur when trying to set up a connection or afterward?
I was able to connect with this configuration after grabbing the details from the Connection Details widget on my Neon Project Dashboard (following these instructions: https://docs.budibase.com/docs/postgresql)
like-goldOP•2y ago
after hitting connect it swirls and then
like-goldOP•2y ago
in that window
this doesn't happen on the local docker version of budi I installed tonight.
harsh-harlequin•2y ago
I am not sure. It worked here. I enabled ssl.
like-goldOP•2y ago
This is how it should look, but this only worked with the exact same settings, on my local version, so im going to test witha new budi account and browser, it's very odd.
harsh-harlequin•2y ago
That's what I see:
like-goldOP•2y ago
Correct
like-goldOP•2y ago
If i could get this working in the cloud side though, that'd be the goal.
like-goldOP•2y ago
local vs cloud, freshly reset the password and everything
harsh-harlequin•2y ago
I'm using the cloud version. The only difference I see is the region, and I'm using a pooled connection string, but there are no reported issues in that region and the pooled connection string should not make any difference. Can you connect via other means (like from psql with the same connection details)? Maybe there's some error in your connection details? If not, I'm at a loss why the connection would work for your locally installed app vs the cloud app.
like-goldOP•2y ago
Hmm ill try with pooling on
no dice on that either. i'll check with another region, maybe it's something to do with it?
harsh-harlequin•2y ago
Unless there's some unreported issue, that should not matter, but I'll check as well.
like-goldOP•2y ago
like-goldOP•2y ago
hmm, looks like that's the issue, maybe budibase is doing some weird location based white listing.
harsh-harlequin•2y ago
hey, yeah. I got the same.
like-goldOP•2y ago
My main DB is in Sydney, swapped to Oregon and then it worked without issue
harsh-harlequin•2y ago
I'll try the connection from psql to make sure it's not Neon.
like-goldOP•2y ago
Is there a way to swap a project location directly? or do i need to migrate
harsh-harlequin•2y ago
No issue with Neon for that region via psql.
Unfortunately, you need to migrate. We're working on a easier migration path, but for now it's a manual operation. We provide instructions here: https://neon.tech/docs/import/import-from-neon
Neon
Import data from another Neon project - Neon Docs
This guide describes how to migrate a database from one Neon project to another by piping data from pg_dump to pg_restore. Use these instructions to Import a database from a Neon project created in on...
like-goldOP•2y ago
All good, thanks for the help! I do appreciate it! Just having a direction is great, was buidling my VFX library tool frontend in Unreal and Python and was like BLARGH, i just want something that works haha.
Wouldn't have checked the region without your input!
harsh-harlequin•2y ago
Great. Glad I was able to help!
like-goldOP•2y ago
Is there a standard way to mark these posts as complete?
harsh-harlequin•2y ago
I don't think so, but that's a good idea. Pinging @ShinyPokemon (our Discord captain).
conscious-sapphire•2y ago
you could just try to close the post, or add the answered tag
like-goldOP•2y ago
Ah i didn't know i could edit the tags! Thanks!
I'll leave the post up incase anyone else ends up running into a similar issue.