status":"500","code":"ESOCKET","message":"Failed to connect

Wappler General
1

Good day all.
I have been working through video tutorials. I am connecting to an existing mssql database using “direct database connection” settings. In the Wappler dap everything hooks up fine. I can connect to the tables, I have no problem seeing the data in the tables. Running in Debug mode. When I run the application in the browser it loads ok, but any attempts to access the database returns the following error. Can you give any suggestions to fix or to troubleshoot further. Thanks in advance

{“status”:“500”,“code”:“ESOCKET”,“message”:“Failed to connect to ACCOUNTSADMIN:1433 - getaddrinfo ENOTFOUND ACCOUNTSADMIN”,“stack”:“ConnectionError: Failed to connect to ACCOUNTSADMIN:1433 - getaddrinfo ENOTFOUND ACCOUNTSADMIN\n at ConnectionError (/opt/node_app/node_modules/tedious/lib/errors.js:13:12)\n at Connection.socketError (/opt/node_app/node_modules/tedious/lib/connection.js:1641:56)\n at /opt/node_app/node_modules/tedious/lib/connection.js:1400:21\n at GetAddrInfoReqWrap.callback (/opt/node_app/node_modules/tedious/lib/connector.js:195:16)\n at GetAddrInfoReqWrap.onlookupall [as oncomplete] (dns.js:74:17)”}

2

Is there a way to test if mssql is running in the docker container hosting my application.

3

I ran code below in Powershell to check if mssql is installed. I got the following error. Any assistance as to if I’m headed in the right direction and possible solution.

docker exec -it a9af34262ea1 /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P password

OCI runtime exec failed: exec failed: container_linux.go:380: starting container process caused: exec: “/opt/mssql-tools/bin/sqlcmd”: stat /opt/mssql-tools/bin/sqlcmd: no such file or directory: unknown

4

It’s not clear from your post whether a Database Connection under Globals has been added for the mssql database. Direct Database Connection settings under Database Manager are required/used if you are managing the remote Databases (Tables/Views) with Wappler’s in-built manager. If you have access to the mssql server, then SQL management studio can be used to manage the database as well.