Connection issues to server database

Wappler General Need Help
1

Anyone else having this sort of problems before i report it as a bug

Same servers as I always use, same settings as I always use but just can’t make a database connection even though i have done this 100s of times in the past. Have even deleted and re-created the database (PHP)

image
image631×652 22.7 KB

2

A trailing space in the server address will cause this.

3

Think I have found the issue Ken,
I was trying to use Docker local in place of WAMP as a development platform but deploy to a custom server as a Production environment.

This combination doesn’t seem to work and screws up the connections totally, back to WAMP i guess

4

Hmmm. I just created a new project, added a Dev target (Docker) and then a Production Target Custom and it seems okay, albeit LAMP, rather than WAMP. I was able to create the tables from Dev using the db manager just fine.

Maybe not the same for Docker/WAMP???

5

Not using WAMP, trying to use docker local in place of WAMP the deploy via FTP to a remote linux server. I can get the database connections working OK in the database manager and can manage tables and deploy to remote using direct connections.
My production server uses different connection setting for direct and server connect connections and that is where things seem to go wrong, when i try to create the database connection for a server action the connections fails even though I know the settings are correct, I have verified them by setting up without the local docker target.

If i switch to WAMP for dev, in place of docker everything works fine.

6

Well it seems to me like the php in server connect just can make a connection to your database as specified. Not really docker or wamp related.

Just either server address is incorrect or port is not open

7

I think I have this working now. thanks George
Server address is OK and port is open

Here is what i have found

  1. I create a development server with docker, no problems

  2. I then create a production server as “Own Server”

If i do things in this order it works

  1. Create a server connect Connection first
    This creates the server connection i need for server connect but does not allow me to see/ manipulate tables
    I then create a direct connection (different settings) and I get access to the tables
    This appears to work as expected

HOWEVER

In this order it doesn’t seem to work

  1. Create a direct connection to manage tables first
  2. then create a server connection for server connect
    In this order i have problems connecting to the server using the SA settings

Now i know I have to do the process in a specific order to get it working then there is no problem, i have no idea why this is

1 Like
8

Thanks for the detailed info, I will investigate what is going wrong.

10

Gut feeling is that the server connection is trying to use the direct connection port if it has been previously set but I may be wrong .