If you are using remote data sources your database server is likely protected by a firewall. To allow Budibase to connect to your data source you may need to whitelist IP addresses in your firewall.
The following IP addresses are used by Budibase Cloud to connect to your data source. You should whitelist these IP addresses on your firewall to allow Budibase Cloud to access your Database Server. Your organisation Database Administrator should be able to help with this.
Note that the IP addresses above are subject to change. We will notify registered users prior to any change to give advance notice for firewall amendments. If you notice that a previously working connection has stopped working check back here.
If you are self-hosting Budibase on your own hardware or using a third-party provider you will need to ensure that the IP address used by your Budibase installation is whitelisted on any firewalls between Budibase and the data source.
If you have set up the connection to your data source within a self-hosted Budibase installation and you are experiencing difficulties connecting and you have terminal access to your Budibase instance you could try:
Can you make contact from the Budibase container or host using telnet?
apt install telnet telnet 184.108.40.206 3306
Attempting a telnet connection to the IP address of your datasource and the port used by the data source (e.g. 3306 for MySQL, 5432 for Postgres, 1431 for MSSQL). If a connection is not made you should check if there is a firewall protecting your data source.
Is your database server listening for remote connections?
For security reasons many database servers will listen only for local connections by default. To allow connections from external servers your database server may need to be configured to listen for remote connections. As an example MySQL would need a configuration parameter as shown below:
bind-address = 0.0.0.0
You can also check your database server is listening for remote connections by analysing the output from the
Does your data source force particular security settings?
Some data sources will only allow encrypted connections. Some may require valid certificates for connecting. If you are having difficulties should should check with your Database Administrator for the correct settings to use.
Updated 5 months ago