error: Database Connection Error: ESOCKET undefined:undefined [Wiki.js 2.5.300]

[jamsondu]

Hi,
Im run wiki js in docker using mssql server 2008 connection but when i see the log of the wiki js container present an error in connection.
However, any version prior to wiki:2.5.300 will work.

Loading configuration from /wiki/config.yml... OK
2023-10-11T00:56:54.655Z [MASTER] info: =======================================
2023-10-11T00:56:54.657Z [MASTER] info: = Wiki.js 2.5.300 =====================
2023-10-11T00:56:54.657Z [MASTER] info: =======================================
2023-10-11T00:56:54.657Z [MASTER] info: Initializing...
2023-10-11T00:56:56.285Z [MASTER] info: Using database driver mssql for mssql [ OK ]
2023-10-11T00:56:56.290Z [MASTER] info: Connecting to database...
(node:1) [DEP0123] DeprecationWarning: Setting the TLS ServerName to an IP address is not permitted by RFC 6066. This will be ignored in a future version.
(Use `node --trace-deprecation ...` to show where the warning was created)
2023-10-11T00:56:56.376Z [MASTER] error: Database Connection Error: ESOCKET undefined:undefined
2023-10-11T00:56:56.376Z [MASTER] warn: Will retry in 3 seconds... [Attempt 1 of 10]
2023-10-11T00:56:59.380Z [MASTER] info: Connecting to database...
2023-10-11T00:56:59.388Z [MASTER] error: Database Connection Error: ESOCKET undefined:undefined
2023-10-11T00:56:59.388Z [MASTER] warn: Will retry in 3 seconds... [Attempt 2 of 10]

this is the command to run wiki js in docker
docker run -d -p 80:3000 --name wiki2.5.300 --restart unless-stopped -e "DB_TYPE=mssql" -e "DB_HOST=*****" -e "DB_PORT=1433" -e "DB_USER=wikijs" -e "DB_PASS=*****" -e "DB_NAME=wiki" requarks/wiki:2.5.300

Thanks for your help.

Host Info (please complete the following information):

• OS: Ubuntu 18.04, Docker
• Wiki.js version: Wiki.js 2.5.300
• Database engine:
  Microsoft SQL Server 2008 R2 (SP3-GDR) (KB4057113) - 10.50.6560.0 (X64)
  Dec 28 2017 15:03:48
  Copyright (c) Microsoft Corporation
  Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)

[jamsondu]

Does Wiki.js 2.5.300 not support SQL Server 2008 ?

[jamsondu]

wiki2.5.300 -> error

root@ZSNMS:~# docker run -d -p 88:3000 --name wiki2.5.300 --restart unless-stopped -e "DB_TYPE=mssql" -e "DB_HOST=10.x" -e "DB_PORT=1433" -e "DB_USER=wikijs" -e "DB_PASS=pwd***" -e "DB_NAME=wikiQAS" requarks/wiki:2.5.300
21c28eb40f7ff6b8eb2311fb370d750bdd5ea4e4be9665581e19d1fa39977276
root@ZSNMS:~# docker logs wiki2.5.300 
Loading configuration from /wiki/config.yml... OK
2023-10-25T01:44:35.309Z [MASTER] info: =======================================
2023-10-25T01:44:35.311Z [MASTER] info: = Wiki.js 2.5.300 =====================
2023-10-25T01:44:35.311Z [MASTER] info: =======================================
2023-10-25T01:44:35.311Z [MASTER] info: Initializing...
2023-10-25T01:44:36.255Z [MASTER] info: Using database driver mssql for mssql [ OK ]
2023-10-25T01:44:36.260Z [MASTER] info: Connecting to database...
(node:1) [DEP0123] DeprecationWarning: Setting the TLS ServerName to an IP address is not permitted by RFC 6066. This will be ignored in a future version.
(Use `node --trace-deprecation ...` to show where the warning was created)
2023-10-25T01:44:36.342Z [MASTER] error: Database Connection Error: ESOCKET undefined:undefined
2023-10-25T01:44:36.342Z [MASTER] warn: Will retry in 3 seconds... [Attempt 1 of 10]
2023-10-25T01:44:39.346Z [MASTER] info: Connecting to database...
2023-10-25T01:44:39.354Z [MASTER] error: Database Connection Error: ESOCKET undefined:undefined
2023-10-25T01:44:39.354Z [MASTER] warn: Will retry in 3 seconds... [Attempt 2 of 10]
2023-10-25T01:44:42.358Z [MASTER] info: Connecting to database...
2023-10-25T01:44:42.367Z [MASTER] error: Database Connection Error: ESOCKET undefined:undefined
2023-10-25T01:44:42.368Z [MASTER] warn: Will retry in 3 seconds... [Attempt 3 of 10]
2023-10-25T01:44:45.370Z [MASTER] info: Connecting to database...
2023-10-25T01:44:45.377Z [MASTER] error: Database Connection Error: ESOCKET undefined:undefined
2023-10-25T01:44:45.377Z [MASTER] warn: Will retry in 3 seconds... [Attempt 4 of 10]
2023-10-25T01:44:48.381Z [MASTER] info: Connecting to database...
2023-10-25T01:44:48.388Z [MASTER] error: Database Connection Error: ESOCKET undefined:undefined
2023-10-25T01:44:48.388Z [MASTER] warn: Will retry in 3 seconds... [Attempt 5 of 10]
root@ZSNMS:~# docker stop wiki2.5.300 
wiki2.5.300
root@ZSNMS:~# 
root@ZSNMS:~# docker rm wiki2.5.300 
wiki2.5.300

wiki2.5.299 -> successful

root@ZSNMS:~# docker run -d -p 88:3000 --name wiki2.5.299 --restart unless-stopped -e "DB_TYPE=mssql" -e "DB_HOST=10.x" -e "DB_PORT=1433" -e "DB_USER=wikijs" -e "DB_PASS=pwd***" -e "DB_NAME=wikiQAS" requarks/wiki:2.5.299
d0e4e2469ac2f567ebf7788f9db45357bbb4f31871b702c7c072bf5f8602f5c9
root@ZSNMS:~# 
root@ZSNMS:~# docker logs wiki2.5.299
Loading configuration from /wiki/config.yml... OK
2023-10-25T01:45:54.599Z [MASTER] info: =======================================
2023-10-25T01:45:54.602Z [MASTER] info: = Wiki.js 2.5.299 =====================
2023-10-25T01:45:54.602Z [MASTER] info: =======================================
2023-10-25T01:45:54.602Z [MASTER] info: Initializing...
2023-10-25T01:45:57.537Z [MASTER] info: Using database driver mssql for mssql [ OK ]
2023-10-25T01:45:57.542Z [MASTER] info: Connecting to database...
(node:1) [DEP0123] DeprecationWarning: Setting the TLS ServerName to an IP address is not permitted by RFC 6066. This will be ignored in a future version.
(Use `node --trace-deprecation ...` to show where the warning was created)
2023-10-25T01:45:57.670Z [MASTER] info: Database Connection Successful [ OK ]
root@ZSNMS:~# 

[jamsondu]

issue:
v2.5.299
e1d282a - warn and exit on unsupported node version (commit by @NGPixel)

maybe it is caused by node.js
I tried using hostname instead of IP, but another error was reported, perhaps due to the TLS configuration of my server.

2024-04-26T03:22:57.230Z [MASTER] error: Database Initialization Error: Failed to connect to myhostname.com:1433 - socket hang up
Loading configuration from /wiki/config.yml... OK
2024-04-26T03:22:58.312Z [MASTER] info: =======================================
2024-04-26T03:22:58.314Z [MASTER] info: = Wiki.js 2.5.302 =====================
2024-04-26T03:22:58.315Z [MASTER] info: =======================================
2024-04-26T03:22:58.315Z [MASTER] info: Initializing...
2024-04-26T03:22:59.355Z [MASTER] info: Using database driver mssql for mssql [ OK ]
2024-04-26T03:22:59.360Z [MASTER] info: Connecting to database...
2024-04-26T03:22:59.443Z [MASTER] error: Database Connection Error: ESOCKET undefined:undefined
2024-04-26T03:22:59.443Z [MASTER] warn: Will retry in 3 seconds... [Attempt 1 of 10]