Hello everyone,
I am new to Node-RED, and for the past two days, I have been trying to install Unified-RED without success.
- After installing Unified-RED and restarting the server (Node-RED), I get Error 1 and notice that the Unified-RED database is not created.
- When I manually create the database and restart the server, I get Error 2.
Could someone help me understand how to install Unified-RED with SQL Server?
Does anyone have the SQL script to manually create the database tables?
Thank you for your help!
======================== Error 1 =========================
C:\Users\User01>node-red
24 Feb 17:24:21 - [info]
Welcome to Node-RED
24 Feb 17:24:21 - [info] Node-RED version: v4.0.9
24 Feb 17:24:21 - [info] Node.js version: v22.14.0
24 Feb 17:24:21 - [info] Windows_NT 10.0.19045 x64 LE
24 Feb 17:24:22 - [info] Loading palette nodes
24 Feb 17:24:24 - [info] Unified-RED Dashboard version 2.5.2 started at /ui
24 Feb 17:24:24 - [info] Dashboard version 3.6.5 started at /ui
AccessDeniedError [SequelizeAccessDeniedError]: Login failed for user 'password000@001'.
at ConnectionManager.connect (C:\Users\User01.node-red\node_modules\sequelize\lib\dialects\mssql\connection-manager.js:115:17)
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
at async ConnectionManager._connect (C:\Users\User01.node-red\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:222:24)
at async C:\Users\User01.node-red\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:174:32 {
parent: ConnectionError: Login failed for user 'password000@001'.
at Login7TokenHandler.onErrorMessage (C:\Users\User01\node_modules\tedious\lib\token\handler.js:186:19)
at Readable. (C:\Users\User01\node_modules\tedious\lib\token\token-stream-parser.js:19:33)
at Readable.emit (node:events:518:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushObjectMode (node:internal/streams/readable:538:3)
at Readable.push (node:internal/streams/readable:393:5)
at nextAsync (node:internal/streams/from:194:22)
at process.processTicksAndRejections (node:internal/process/task_queues:105:5) {
code: 'ELOGIN'
},
original: ConnectionError: Login failed for user 'password000@001'.
at Login7TokenHandler.onErrorMessage (C:\Users\User01\node_modules\tedious\lib\token\handler.js:186:19)
at Readable. (C:\Users\User01\node_modules\tedious\lib\token\token-stream-parser.js:19:33)
at Readable.emit (node:events:518:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushObjectMode (node:internal/streams/readable:538:3)
at Readable.push (node:internal/streams/readable:393:5)
at nextAsync (node:internal/streams/from:194:22)
at process.processTicksAndRejections (node:internal/process/task_queues:105:5) {
code: 'ELOGIN'
}
}
24 Feb 17:24:24 - [red] Uncaught Exception:
24 Feb 17:24:24 - [error] SequelizeAccessDeniedError: Login failed for user 'password000@001'.
at ConnectionManager.connect (C:\Users\User01.node-red\node_modules\sequelize\lib\dialects\mssql\connection-manager.js:115:17)
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
at async ConnectionManager._connect (C:\Users\User01.node-red\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:222:24)
at async C:\Users\User01.node-red\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:174:32
======================== Error 2 =========================
C:\Users\User01>node-red
24 Feb 17:25:15 - [info]
Welcome to Node-RED
24 Feb 17:25:15 - [info] Node-RED version: v4.0.9
24 Feb 17:25:15 - [info] Node.js version: v22.14.0
24 Feb 17:25:15 - [info] Windows_NT 10.0.19045 x64 LE
24 Feb 17:25:16 - [info] Loading palette nodes
24 Feb 17:25:18 - [info] Unified-RED Dashboard version 2.5.2 started at /ui
24 Feb 17:25:18 - [info] Dashboard version 3.6.5 started at /ui
24 Feb 17:25:18 - [info] Settings file : C:\Users\User01.node-red\settings.js
24 Feb 17:25:18 - [info] Context store : 'default' [module=memory]
24 Feb 17:25:18 - [info] User directory : \Users\User01.node-red
24 Feb 17:25:18 - [warn] Projects disabled : editorTheme.projects.enabled=false
24 Feb 17:25:18 - [info] Flows file : \Users\User01.node-red\flows.json
24 Feb 17:25:18 - [warn]
Your flow credentials file is encrypted using a system-generated key.
If the system-generated key is lost for any reason, your credentials
file will not be recoverable, you will have to delete it and re-enter
your credentials.
You should set your own key using the 'credentialSecret' option in
your settings file. Node-RED will then re-encrypt your credentials
file using your chosen key the next time you deploy a change.
24 Feb 17:25:18 - [warn] Encrypted credentials not found
24 Feb 17:25:18 - [info] Server now running at http://127.0.0.1:1880/
24 Feb 17:25:18 - [info] Starting flows
24 Feb 17:25:18 - [info] Started flows
24 Feb 17:25:18 - [red] Uncaught Exception:
24 Feb 17:25:18 - [error] Error
at Query.run (C:\Users\User01.node-red\node_modules\sequelize\lib\dialects\mssql\query.js:107:25)
at C:\Users\User01.node-red\node_modules\sequelize\lib\sequelize.js:315:28
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
at async MSSqlQueryInterface.select (C:\Users\User01.node-red\node_modules\sequelize\lib\dialects\abstract\query-interface.js:407:12)
at async Role.findAll (C:\Users\User01.node-red\node_modules\sequelize\lib\model.js:1140:21)
at async Role.findOne (C:\Users\User01.node-red\node_modules\sequelize\lib\model.js:1240:12)
at async init (C:\Users\User01.node-red\node_modules\unified-red\api\users\role.service.js:10:11)
