Can't use MS SQL Server #469

New Issue

OVERLORD · 2026-02-04T19:46:55+03:00

OVERLORD commented

2026-02-04 19:46:55 +03:00

Originally created by @emmguyot-adscom on GitHub (Apr 8, 2024).

I've tried to use MS Sql Server, but I always get an error on db:init :

$ npm run db:init

> db:init
> node db/init.js

tedious deprecated The default value for `config.options.enableArithAbort` will change from `false` to `true` in the next major version of `tedious`. Set the value to `true` or `false` explicitly to silence this message. node_modules\knex\lib\dialects\mssql\index.js:147:26
node:events:496
      throw er; // Unhandled 'error' event
      ^

Error: No event 'socketConnect' in state 'SentPrelogin'
    at Connection.dispatchEvent (D:\Projets\planka\server\node_modules\tedious\lib\connection.js:1281:26)
    at Connection.socketConnect (D:\Projets\planka\server\node_modules\tedious\lib\connection.js:1303:10)
    at D:\Projets\planka\server\node_modules\tedious\lib\connection.js:1145:12
    at Socket.onConnect (D:\Projets\planka\server\node_modules\tedious\lib\connector.js:106:7)
    at Socket.emit (node:events:518:28)
    at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1590:10)
Emitted 'error' event on Connection instance at:
    at Connection.dispatchEvent (D:\Projets\planka\server\node_modules\tedious\lib\connection.js:1281:12)
    at Connection.socketConnect (D:\Projets\planka\server\node_modules\tedious\lib\connection.js:1303:10)
    [... lines matching original stack trace ...]
    at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1590:10)

Node.js v20.12.1

What I've done :

I've tried to install sails-mssql package and then I installed tedious instead
I've changed the adapter in datastore.js to 'sails-mssql'
I've changed knexfile.js to set client, user, password, ...

Originally created by @emmguyot-adscom on GitHub (Apr 8, 2024). I've tried to use MS Sql Server, but I always get an error on db:init : ``` $ npm run db:init > db:init > node db/init.js tedious deprecated The default value for `config.options.enableArithAbort` will change from `false` to `true` in the next major version of `tedious`. Set the value to `true` or `false` explicitly to silence this message. node_modules\knex\lib\dialects\mssql\index.js:147:26 node:events:496 throw er; // Unhandled 'error' event ^ Error: No event 'socketConnect' in state 'SentPrelogin' at Connection.dispatchEvent (D:\Projets\planka\server\node_modules\tedious\lib\connection.js:1281:26) at Connection.socketConnect (D:\Projets\planka\server\node_modules\tedious\lib\connection.js:1303:10) at D:\Projets\planka\server\node_modules\tedious\lib\connection.js:1145:12 at Socket.onConnect (D:\Projets\planka\server\node_modules\tedious\lib\connector.js:106:7) at Socket.emit (node:events:518:28) at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1590:10) Emitted 'error' event on Connection instance at: at Connection.dispatchEvent (D:\Projets\planka\server\node_modules\tedious\lib\connection.js:1281:12) at Connection.socketConnect (D:\Projets\planka\server\node_modules\tedious\lib\connection.js:1303:10) [... lines matching original stack trace ...] at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1590:10) Node.js v20.12.1 ``` What I've done : * I've tried to install sails-mssql package and then I installed tedious instead * I've changed the adapter in datastore.js to 'sails-mssql' * I've changed knexfile.js to set client, user, password, ...

OVERLORD closed this issue

2026-02-04 19:47:00 +03:00

OVERLORD commented

2026-02-04 19:47:17 +03:00

@meltyshev commented on GitHub (Apr 8, 2024):

Hi! Unfortunately, it will be difficult to run Planka with a database other than Postgres, because there are places where we use database functions (e.g. to generate identifiers), also possible incompatibilities with some data types. We have plans to change the framework for the server part and use a different ORM, then it might be possible to use different types of database with Planka, but it won't be soon and definitely after the v2 release.

@meltyshev commented on GitHub (Apr 8, 2024): Hi! Unfortunately, it will be difficult to run Planka with a database other than Postgres, because there are places where we use database functions (e.g. to generate identifiers), also possible incompatibilities with some data types. We have plans to change the framework for the server part and use a different ORM, then it might be possible to use different types of database with Planka, but it won't be soon and definitely after the v2 release.

OVERLORD commented

2026-02-04 19:47:22 +03:00

@emmguyot-adscom commented on GitHub (Apr 9, 2024):

Ok @meltyshev
Thank you for this answer. I'll stay on PostgreSQL

@emmguyot-adscom commented on GitHub (Apr 9, 2024): Ok @meltyshev Thank you for this answer. I'll stay on PostgreSQL

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/planka#469