Unable to access remote database without SSH

Wappler General Need Help
1

I have a bunch of queries which were previously connected to a remote AWS database and working fine. However, I have recently needed to access a different remote AWS database - via SSH (see connection details below.)

direct-db-connection
direct-db-connection1201×1613 124 KB

This connects successfully and I can fetch the data in the Database Manager.

fetch-data
fetch-data2711×1463 340 KB

I have updated my queries to reference the new database, yet when I deploy my page the data is missing. Here is the error generated:

error
error2543×320 207 KB

I assume I’m missing something quite obvious, but can’t quite work out what to do next. Any help would be appreciated.

Cheers.

2

Hi,
The connection settings in DB Manager have nothing to do with the SA actually.
They are just there to be able to fetch schema and allow you to browse/manage your DB.

The connection actually used in SA comes from Globals in the API/Workflow/ServerAction panel.
Make sure the settings there match exactly as in the DB Manager.

TIP: You can use the “up-down” icon on top right in DB Manager to copy the connection string & then use the same icon in Globals DB Connection to import.

3

Thanks Sid.

So I entered the same details into the Database Connection box within Globals, however it doesn’t allow me to enter my SSH details and private key.

I’ll try to explain why this is an issue.

My site will be deployed by Docker to an EC2 instance on AWS. This needs to communicate with an existing database housed in a remote EC2 instance. This database is accessed via SSH and .pem file key (hence why I could connect to it via the Direct Database Manager!)

Any ideas if my structure is feasible? Would I need to add additional SSH details manually by opening up a particular file?

4

I have never worked with SSH on DB.
So not sure if I can be of mucb help.

Although, in the Wappler UI, I do see all the options as shown in Globals as shown in DB Manager, so it should work out for you.

5

Thanks Again Sid - I appreciate you taking the time to reply. Does anyone else have any understanding of this?

Unfortunately, the Database Connection box within Globals doesn’t contain anywhere for me to enter my SSL credentials. This would not be a problem if the database could be accessed locally beside my target instance. Instead my website needs to access a remote database which can only connect via SSL key.

global-connection-box
global-connection-box1127×1223 77.4 KB

The only alternative might be to regularly duplicate the remote database into a new database which sits next to my website. I would obviously prefer not to do this, especially since my problem can’t be that unusual.

6

Which version of Wappler are you on?
This looks like an old UI.

7

How weird. I was on version 3.9.7, so just updated to 3.9.9… but the interface looks exactly the same. So does your UI show additional fields eg. for SSH?

8

I see the exact same UI as in DB manager. Except there is no Test button.

9

And you’re running the most recent version?

Mine is basically the same as shown in the ‘Using Globals in Server Connect’ tutorial from November last year.

I can’t find any references which indicate the interface has been updated in that time. So even a re-install may not fix the issue.

Thanks for trying to resolve this.

10

Looks like you are on a PHP server model.
In PHP I do see the prompt as you have shared.
On NodeJS its same as in DB manager, so I see the SSH options.

Not sure why. @Teodor or @patrick can explain.

11

We do not support SSH tunneling in PHP for accessing databases as server connect option.

If you really need it you should manually run a SSH tunnel on your server and then just use the local port and connection to connect to the remote server.