Problems with Database Query

[Marzio]

I have a problem for which I cannot find the cause
I have a Cloud Nodejs with Docker only for the local
In the targets (locate and remote) I have not chosen any database; I instead used Database Manager to connect a database (created in the Cloud on Ubuntu) valid for both the local and the remote
If I check the database from Wappler it seems perfectly accessible both locally and remotely, but then I created an API action (product list) with a very simple query, which, however, clicking on the test button gives no results.
Is there anything that has changed with the latest versions that I haven’t understood?

[Marc]

Just as a thought maybe check out this post it may help.

Edit Database connection not saving properly

Wappler Version : 4.0.3 Operating System : Windows 10 Server Model: nodejs Database Type: MariaDB Hosting Type: local Expected behavior What do you think should happen? When editing database connections to point to say eg: a different database that it connects successfully to the new db Actual behavior What actually happens? The updated db connection updates for database manager correctly, but not for api’s How to reproduce I duplicated a Wappler project that uses a mariaDB databas…

[Marzio]

Thank you, but this doesn’t seem to be the problem. The DB_CONN.JSON file seems correct, but the problem remains
I need to emphasize that the differences with your file is that host is an IP address and serverType is “node”
Also they are not in Windows but in MacOS

[Marzio]

[Marzio]

If possible I would like to know what is happening, because I can no longer create a simple table with the product list and often Wappler closes with this message

[Teodor]

Marzio,
Can you please keep separate issues/questions in separate topics?
It’s hard to follow you and it’s a bit hard to understand what your issue is.

From the little i understand from your initial post - you need to setup a database connection per each of your targets, as explained here:

Define Database Connection Settings per Target

[Marzio]

Sorry Teodor but I let myself take the discomfort.
Maybe my mistake is this and I ask you if the problem can be here
I state that the site is cloud ubuntu docker nodejs, although this should not be important at this stage.
I have a database that was created remotely on Ubuntu and also works with Navicat.
I have not configured no Docker database in the Development Target (local) tab and no databases in the Target Production (Remote) tab
I therefore created a connection to the remote database using the Database Manager, and this connection is used for the local and remotely. Maybe this is the mistake?

[Teodor]

You need to setup the database connection per target in Server Connect as explained in the docs i shared. Follow it steps by step.

[Marzio]

Ok so this is the mistake
I proceed with your tutorial

[Marzio]

Teodor I followed the instructions, but I can’t make it work
I selected development and created db_conn with LocalHost setting.
Then I selected production and using the same connection I changed from Localhost to the database IP address
However, the result is that controlling the settings are always identical both for development and for production.
Furthermore the database is not read and presents error

[Teodor]

Marzio, the database connection defined in Server Connect and in Database Manager are different.
The database manager expects a direct connection to be made.
You setup the database manager separately than the one defined in server connect. If you see such a problem in the database manager, then something is not correctly set up.

[Marzio]

Teodor
For the first part with the development section, after I created the connection from the following error

Registrazione schermo 2021-09-06 alle 18.11.10

[Teodor]

Your database manager connection needs to be edited and you need to enter the REMOTE credentials Marzio.
Database manager expects a DIRECT connection to the database. Localhost won’t work …

[Marzio]

Do I need to select direct connection to remote even for the connection created for development?

[Teodor]

Database manager always expects a direct connection.
It’s something totally different and independent of targets. Database manager -> always a direct connection.

Server connect connections -> always per target.

[Marzio]

Ok I configured the direct connection to the connection created locally and read the database perfectly
Now step to the remote section (production and select the connection in Global and change the settings on remote?

[Teodor]

@Marzio

Now step to the remote section (production and select the connection in Global and change the settings on remote?

Define Database Connection Settings per Target

[Marzio]

Ok I configured the direct connection to the connection created locally and read the database perfectly
Now step to the remote section (production and select the connection in Global and change the settings on remote?

[Marzio]

Registrazione schermo 2021-09-06 alle 19.02.37

[Teodor]

Debugging Server Connect Errors

You can easily debug issues related to server-side processing such as - form not sending email, record not inserting or updating, query not showing data etc. The first thing you need to do is to open the server connect settings: [image] And enable the Debug Mode: [image] Click Save: [image] In your browser, open the Developer tools. If you don’t know how to open them please refer to your browser’s documentation. Then open the Network tab(1) and select XHR(2): [image] Now with the de…