DO: Cloud Server Database timeout

Wappler General Need Help
1

Hello,
I am trying to deploy the project to a DigitalOcean server using remote target.
I have added the server to my resource manager, Installed Traefik and portainer service on the server.
And then deployed the project using target: “Production”, which is my remote config.

My deployment setup is pretty straightforward.

image
image794×563 15.4 KB

image
image812×408 7.96 KB

Now, everything gets deployed properly.
image

But, whenever i try to open the database in Database Manager,
I get following error.

image
image465×575 13.6 KB

Please advise.

PS: I have not changed any settings, not tinkered around with anything.
I also created the server itself using Wappler.

2

Make sure you enable the “Over SSH” option on the target database setting to allow direct secure connection for Wappler.

In recent updates we made it more secure and are not exposing any ports directly, so you should go for best security over ssh.

I will check why this isn’t the default.

4

I did try that last night, I was getting error connection to port 19906. (Not sure from where the 1 was coming).
But today it’s working fine. I think it needed a restart.

Thanks!

5

The issue is back

image
image759×438 14 KB

image

6

Hmm seems the : sign is lost in your docker compose file.

You can find it under:

.wappler/targets/your_target/docker_compose.yml

It is a hidden folder so make sure you enable the hidden files from the context menu in the file manager.

The ports there for the database service should be 127.0.0.1:9906

7

I did what you asked. Now I am getting this error.
image

Every single time I save “Target”, my docker.compose changes to

ports:
  - '127.0.0.19906:5432'
8

Seems there is a big on this when saving the target options. Which Wappler version are you on?

9

Found the problem and it will be fixed in the next update

10

I am happy to hear that!
Any quick fix or workaround which I can implement for now?

Also, can you tell me how to pass environment variables for servers which are created and managed within Wappler?

11

The quick around fix is mentioned above:

12

I tried this. It doesnt work. I get the other error I posted.

14

Fixed in Wappler 6 RC1