So I’ve got access to a postgres database that is fully-managed by aiven.io (located on Google Cloud Platform in Iowa – which I presume is us-central). I am having trouble connecting it to the DB Connector plugin – please bear with me as this is my first time working with Postgres.
(To cut to the chase, I have a hunch that my database requires connections over SSL but currently bubble does not make SSL postgres connections possible – can you comment on whether SSL connections actually are or can be supported?)
"Test"ing yields an error like: no pg_hba.conf entry for host "<some-ip-address>", user "<my-db-user>", database "<my-db>", SSL off
I can connect to the database without issue using psql --version # psql (PostgreSQL) 9.5.1 in my terminal.
The connection string provided by Aiven is generally postgres://<my-db-user>:<my-db-password>@<alpha-numeric-with-hyphens>.<alpha-numeric-with-hyphens>.aivencloud.com:<my-port>/<my-db>?sslmode=require
I get the same error with and without the ?sslmode=require query in bubble. I can connect in the terminal without the query, but I presume that the CLI just eats the error and uses SSL transparently.
I do not have direct access to the pg_hba.conf file (I’m communicating with Aiven to get a copy of it and evaluate whether or not the SSL requirement can be relaxed – which frankly sounds ill-advised to me…) but the Aiven interface gives the option to set comma-delimited admissible IP ranges (currently set to “all IPs” i.e 0.0.0.0/0) and I presume that is driving the contents of pg_hba.conf.
As a follow up, I’ve confirmed with Aiven that the pg_hba.conf has records in this format:
hostssl <database> <user> 0.0.0.0/0 md5
I’m still trying to get them confirm whether or not having non-SSL records in the config would work in theory, but there infrastructure is not really set up to permit that sort of setup. They also mentioned they were able to integrate their database with blockspring – should that information be relevant/helpful (please don’t recommend that I user blockspring as a proxy…).
Hi George, I am trying to post data from input fields into a new row of a specific table in a postgres database. So far I was able to connect the database, retrieve information from it and even setup a call that would allow me to insert a new row. Here is the querry I had setup for reference:
insert into public.invoice
values ($1, $2, $3, $4)
This call was initialized without a problem.
However I can’t access this query. I assumed I would find it under the workflow tab under actions - plugins. Similar to how to write to Zapier, but the SQL plugin doesn’t even show. How can I write to the database? Thanks
Hello, I am Brazilian, with little fluency in English, so I apologize in advance if it is not clear. I was wondering if the opposite is possible. Example I create a web app on the bubble and I create a mobile app with Xamarin and I want to connect to the Bubble bank, is it possible?
getting the following error when I test my connection
Connection issue: SQL Database Connector issue: Connection attempt failed: Client does not support authentication protocol requested by server; consider upgrading MariaDB client
thanks
