Unable to Create Database Connection in NodeJS in Server Action

Wappler General How To
,
#1

Hi,

I updated my Wappler to 3.4.0, created a fresh new NodeJS project, added GitLab as per the new stuff, published my NodeJS app to dev server - and everything was working fine so far.

Next, I created a new server action and tried adding a new database connection. But this what I see:

image
image437×609 6.01 KB

The two buttons - “folder” & “link” are not visible.

I tried creating a connection in the DB Manager UI, and clicked the “server connection” button, and it returned a completely blank popup with just a save button.

Please help. Need an urgent fix. I am unable to proceed on my project without this.

P.S. Don’t know if this is a bug since this is the first time I am trying DB connection with NodeJS.

#2

Well you need to define your database connection in the database manager. Then it will become available…

#3

Has this been the way in NodeJS always or only in 3.4.0?
Because in PHP/ASP, I have never used DB Manager.

#4

image
image425×632 8.96 KB

Added in DB Manager.

image
image585×603 6.04 KB

This is what I see on click of “Server Connect Connection”.

image
image396×693 10.1 KB

No change in the server action.

#5

@Teodor Were you able to replicate this?

#6

@patrick / @George please help.

#7

This is how you set up database connections for NodeJS since its been introduced in Wappler.
For PHP/ASP it’s different.

You need to click Server Connect connection and set it up:

Screenshot_8
Screenshot_81188×888 155 KB

Then it appears in your server action:

Screenshot_9
Screenshot_9521×888 88.3 KB

Also, there is no need to make a new post every hour tagging different people. It’s Friday evening here in Europe, after our working hours, we are not 24/7 available in front of our computers. Please be patient, we will answer your requests …

2 Likes
#8

Clicking server connect connection kept showing me blank pop-up, as I shared in above post.

Its even late here. 2200hrs IST. But when work’s important, I like to try everything I can.
And I replied to you within 2 minutes, so was waiting for an answer. Maybe you got busy in those 2 :sweat_smile:

Trying “Server Connect Connection” worked this time and was able to setup my server action correctly.
Although, I got a 500 error saying db_dev.json not found in modules folder. So had yo upload that manually. Is there a step I missed here?

Is there a help doc for this… I could not find anything. Can you please share a link?

#9

I was walking down the streets of Sofia, heading home actually :slight_smile:

Never seen such an error before. Maybe you can share some screenshot?
So is everything working fine now?

#10

Will have to delete the db json file from server. Let me try.

Yes. :smiley:

#11

Remote File Structure:
image

Error in browser:
image

Uploading manually from local, gets rid of it and fetches data correctly.

#12

Has the ‘Server Connect Connection’ been removed from 3.7.2 as can’t find it and can not connect to the database in Node…?

The application is running fine. Can connect to the database in other Projects no problem but in Node it keeps timing out?

Any advice appreciated.

#13

Server connect database connections are managed in server connect globals / database connections, where they belong. This is for some time now since the new globals.

In database manager you manage only the direct connection to your database so Wappler can access it.

#14

Yes this is how the connection is set-up under globals / database connections. Yet when I hit refresh schema nothing happens? And there is no way to test the connection?

Problems with NodeJS in Database Manager
#15

There is actually nothing changed in that area. The same connections are just being edited now under globals with exact same dialog.

If you are on PHP you can test the connect if on node you can’t. Just test the direct connection in the database manager.

Schema refreshing is just refresh in the database manager.