SQL Adapter - keine Verbindung zum Server
-
Ich habe den IOBroker komplett neu aufgesetzt und bekomme den SQL Adapter nicht mit der SQL Server Express Instanz verbunden.
Mit HeidiSQL kann ich auf den SQL Server problemlos zugreifen. Die Verbindungsdaten habe ich genauso eingegeben wie am PC2 bei dem die IOBroker Installation läuft und dem auch ein SQL Server läuft (Benutzerrechte sind vergeben, Port ist definiert, etc.).Kann mir jemand bei der Interpretation des Fehlerlogs helfen?
FehlerLog:
2024-05-30 18:01:36.053 - info: host.MiniPC instance system.adapter.sql.0 started with pid 3492 2024-05-30 18:01:36.517 - info: sql.0 (3492) starting. Version 2.2.0 in C:/ioBroker/node_modules/iobroker.sql, node: v20.14.0, js-controller: 5.0.19 2024-05-30 18:01:36.526 - error: sql.0 (3492) Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). 2024-05-30 18:01:36.526 - error: sql.0 (3492) unhandled promise rejection: Cannot find module 'mssql' Require stack: - C:\ioBroker\node_modules\iobroker.sql\lib\mssql-client.js - C:\ioBroker\node_modules\iobroker.sql\main.js 2024-05-30 18:01:36.528 - error: sql.0 (3492) Error: Cannot find module 'mssql' Require stack: - C:\ioBroker\node_modules\iobroker.sql\lib\mssql-client.js - C:\ioBroker\node_modules\iobroker.sql\main.js at Function.Module._resolveFilename (node:internal/modules/cjs/loader:1145:15) at Function.Module._load (node:internal/modules/cjs/loader:986:27) at Module.require (node:internal/modules/cjs/loader:1233:19) at require (node:internal/modules/helpers:179:18) at Object. (C:\ioBroker\node_modules\iobroker.sql\lib\mssql-client.js:6:31) at Object. (C:\ioBroker\node_modules\iobroker.sql\lib\mssql-client.js:61:4) at Module._compile (node:internal/modules/cjs/loader:1358:14) at Object.Module._extensions..js (node:internal/modules/cjs/loader:1416:10) at Module.load (node:internal/modules/cjs/loader:1208:32) at Function.Module._load (node:internal/modules/cjs/loader:1024:12) 2024-05-30 18:01:36.528 - error: sql.0 (3492) Exception-Code: MODULE_NOT_FOUND: Cannot find module 'mssql' Require stack: - C:\ioBroker\node_modules\iobroker.sql\lib\mssql-client.js - C:\ioBroker\node_modules\iobroker.sql\main.js 2024-05-30 18:01:37.540 - warn: sql.0 (3492) Terminated (UNCAUGHT_EXCEPTION): Without reason 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[0]: This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). The promise rejected with the reason: 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: Error: Cannot find module 'mssql' 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: Require stack: 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: - C:\ioBroker\node_modules\iobroker.sql\lib\mssql-client.js 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: - C:\ioBroker\node_modules\iobroker.sql\main.js 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Function.Module._resolveFilename (node:internal/modules/cjs/loader:1145:15) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Function.Module._load (node:internal/modules/cjs/loader:986:27) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Module.require (node:internal/modules/cjs/loader:1233:19) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at require (node:internal/modules/helpers:179:18) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Object. (C:\ioBroker\node_modules\iobroker.sql\lib\mssql-client.js:6:31) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Object. (C:\ioBroker\node_modules\iobroker.sql\lib\mssql-client.js:61:4) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Module._compile (node:internal/modules/cjs/loader:1358:14) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Object.Module._extensions..js (node:internal/modules/cjs/loader:1416:10) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Module.load (node:internal/modules/cjs/loader:1208:32) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Function.Module._load (node:internal/modules/cjs/loader:1024:12) 2024-05-30 18:01:38.087 - error: host.MiniPC instance system.adapter.sql.0 terminated with code 6 (UNCAUGHT_EXCEPTION) 2024-05-30 18:01:38.087 - info: host.MiniPC Rebuild for adapter system.adapter.sql.0 not successful in 3 tries. Adapter will not be restarted again. Please execute "npm install --production" in adapter directory manually.MOD-EDIT: Code in code-tags gesetzt!
-
Ich habe den IOBroker komplett neu aufgesetzt und bekomme den SQL Adapter nicht mit der SQL Server Express Instanz verbunden.
Mit HeidiSQL kann ich auf den SQL Server problemlos zugreifen. Die Verbindungsdaten habe ich genauso eingegeben wie am PC2 bei dem die IOBroker Installation läuft und dem auch ein SQL Server läuft (Benutzerrechte sind vergeben, Port ist definiert, etc.).Kann mir jemand bei der Interpretation des Fehlerlogs helfen?
FehlerLog:
2024-05-30 18:01:36.053 - info: host.MiniPC instance system.adapter.sql.0 started with pid 3492 2024-05-30 18:01:36.517 - info: sql.0 (3492) starting. Version 2.2.0 in C:/ioBroker/node_modules/iobroker.sql, node: v20.14.0, js-controller: 5.0.19 2024-05-30 18:01:36.526 - error: sql.0 (3492) Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). 2024-05-30 18:01:36.526 - error: sql.0 (3492) unhandled promise rejection: Cannot find module 'mssql' Require stack: - C:\ioBroker\node_modules\iobroker.sql\lib\mssql-client.js - C:\ioBroker\node_modules\iobroker.sql\main.js 2024-05-30 18:01:36.528 - error: sql.0 (3492) Error: Cannot find module 'mssql' Require stack: - C:\ioBroker\node_modules\iobroker.sql\lib\mssql-client.js - C:\ioBroker\node_modules\iobroker.sql\main.js at Function.Module._resolveFilename (node:internal/modules/cjs/loader:1145:15) at Function.Module._load (node:internal/modules/cjs/loader:986:27) at Module.require (node:internal/modules/cjs/loader:1233:19) at require (node:internal/modules/helpers:179:18) at Object. (C:\ioBroker\node_modules\iobroker.sql\lib\mssql-client.js:6:31) at Object. (C:\ioBroker\node_modules\iobroker.sql\lib\mssql-client.js:61:4) at Module._compile (node:internal/modules/cjs/loader:1358:14) at Object.Module._extensions..js (node:internal/modules/cjs/loader:1416:10) at Module.load (node:internal/modules/cjs/loader:1208:32) at Function.Module._load (node:internal/modules/cjs/loader:1024:12) 2024-05-30 18:01:36.528 - error: sql.0 (3492) Exception-Code: MODULE_NOT_FOUND: Cannot find module 'mssql' Require stack: - C:\ioBroker\node_modules\iobroker.sql\lib\mssql-client.js - C:\ioBroker\node_modules\iobroker.sql\main.js 2024-05-30 18:01:37.540 - warn: sql.0 (3492) Terminated (UNCAUGHT_EXCEPTION): Without reason 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[0]: This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). The promise rejected with the reason: 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: Error: Cannot find module 'mssql' 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: Require stack: 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: - C:\ioBroker\node_modules\iobroker.sql\lib\mssql-client.js 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: - C:\ioBroker\node_modules\iobroker.sql\main.js 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Function.Module._resolveFilename (node:internal/modules/cjs/loader:1145:15) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Function.Module._load (node:internal/modules/cjs/loader:986:27) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Module.require (node:internal/modules/cjs/loader:1233:19) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at require (node:internal/modules/helpers:179:18) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Object. (C:\ioBroker\node_modules\iobroker.sql\lib\mssql-client.js:6:31) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Object. (C:\ioBroker\node_modules\iobroker.sql\lib\mssql-client.js:61:4) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Module._compile (node:internal/modules/cjs/loader:1358:14) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Object.Module._extensions..js (node:internal/modules/cjs/loader:1416:10) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Module.load (node:internal/modules/cjs/loader:1208:32) 2024-05-30 18:01:38.087 - error: host.MiniPC Caught by controller[1]: at Function.Module._load (node:internal/modules/cjs/loader:1024:12) 2024-05-30 18:01:38.087 - error: host.MiniPC instance system.adapter.sql.0 terminated with code 6 (UNCAUGHT_EXCEPTION) 2024-05-30 18:01:38.087 - info: host.MiniPC Rebuild for adapter system.adapter.sql.0 not successful in 3 tries. Adapter will not be restarted again. Please execute "npm install --production" in adapter directory manually.MOD-EDIT: Code in code-tags gesetzt!
Hat keiner einen Hinweis? Welche Fallstricke existieren beim Installieren einer angebotenen Bibliothek? Warum kann das nicht einfach funktionieren - wurde diese Version ausreichend getestet.
IOBroker für Windows von der Homepage geladen - installiert - ging eigentlich problemlos, ohne Fehlermeldung.
Instanz für den SQL Connector installiert, ohne Fehlermeldung.
Verbindung nicht möglich - mit für mich unverständlichen Informationen im Log.So macht das keinen Spaß.
Tom
-
Hat keiner einen Hinweis? Welche Fallstricke existieren beim Installieren einer angebotenen Bibliothek? Warum kann das nicht einfach funktionieren - wurde diese Version ausreichend getestet.
IOBroker für Windows von der Homepage geladen - installiert - ging eigentlich problemlos, ohne Fehlermeldung.
Instanz für den SQL Connector installiert, ohne Fehlermeldung.
Verbindung nicht möglich - mit für mich unverständlichen Informationen im Log.So macht das keinen Spaß.
Tom
@tomlei1 sagte in SQL Adapter - keine Verbindung zum Server:
So macht das keinen Spaß.
Stimmt. Ich würde, damit es Spaß macht, auch auf Linux setzen. ;-)
Hier baut der Adapter jedenfalls:
$ iobroker add sql auto --host chet --debug Installing iobroker.sql@2.2.0... (System call) npm warn While resolving: @iobroker/adapter-core@3.1.4npm warn Found: @iobroker/types@6.0.0npm warn node_modules/iobroker.admin/node_modules/@iobroker/typesnpm warn @iobroker/types@"6.0.0" from iobroker.admin@6.17.14 npm warn node_modules/iobroker.adminnpm warn iobroker.admin@"6.17.14" from the root projectnpm warnnpm warn Could not resolve dependency:npm warn peer @iobroker/types@"^5.0.11" from @iobroker/adapter-core@3.1.4npm warn node_modules/iobroker.admin/node_modules/@iobroker/adapter-corenpm warn @iobroker/adapter-core@"^3.1.4" from iobroker.admin@6.17.14npm warn node_modules/iobroker.adminnpm warnnpm warn Conflicting peer dependency: @iobroker/types@5.0.19npm warn node_modules/@iobroker/typesnpm warn peer @iobroker/types@"^5.0.11" from @iobroker/adapter-core@3.1.4npm warn node_modules/iobroker.admin/node_modules/@iobroker/adapter-corenpm warn @iobroker/adapter-core@"^3.1.4" from iobroker.admin@6.17.14npm warn node_modules/iobroker.admin npm warn deprecated @npmcli/move-file@1.1.2: This functionality has been moved to @npmcli/fs npm warn deprecated are-we-there-yet@3.0.1: This package is no longer supported. npm warn deprecated glob@7.2.3: Glob versions prior to v9 are no longer supported npm warn deprecated npmlog@6.0.2: This package is no longer supported. added 74 packages in 34s 190 packages are looking for funding run `npm fund` for details host.chet install adapter sql upload [13] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/i18n/de/translations.json i18n/de/translations.json application/json upload [12] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/i18n/en/translations.json i18n/en/translations.json application/json upload [11] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/i18n/es/translations.json i18n/es/translations.json application/json upload [10] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/i18n/fr/translations.json i18n/fr/translations.json application/json upload [9] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/i18n/it/translations.json i18n/it/translations.json application/json upload [8] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/i18n/nl/translations.json i18n/nl/translations.json application/json upload [7] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/i18n/pl/translations.json i18n/pl/translations.json application/json upload [6] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/i18n/pt/translations.json i18n/pt/translations.json application/json upload [5] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/i18n/ru/translations.json i18n/ru/translations.json application/json upload [4] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/i18n/zh-cn/translations.json i18n/zh-cn/translations.json application/json upload [3] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/jsonConfig.json jsonConfig.json application/json upload [1] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/sql.png sql.png image/png upload [0] sql.admin /opt/iobroker/node_modules/iobroker.sql/admin/words.js words.js application/javascript host.chet object system.adapter.sql created/updated host.chet create instance sql host.chet object system.adapter.sql.0.alive created host.chet object system.adapter.sql.0.connected created host.chet object system.adapter.sql.0.compactMode created host.chet object system.adapter.sql.0.cpu created host.chet object system.adapter.sql.0.cputime created host.chet object system.adapter.sql.0.memHeapUsed created host.chet object system.adapter.sql.0.memHeapTotal created host.chet object system.adapter.sql.0.memRss created host.chet object system.adapter.sql.0.uptime created host.chet object system.adapter.sql.0.inputCount created host.chet object system.adapter.sql.0.outputCount created host.chet object system.adapter.sql.0.eventLoopLag created host.chet object system.adapter.sql.0.sigKill created host.chet object sql.0.info created host.chet object sql.0.info.connection created host.chet Set default value of sql.0.info.connection: false host.chet object system.adapter.sql.0 created Process exited with code 0
Hey! Du scheinst an dieser Unterhaltung interessiert zu sein, hast aber noch kein Konto.
Hast du es satt, bei jedem Besuch durch die gleichen Beiträge zu scrollen? Wenn du dich für ein Konto anmeldest, kommst du immer genau dorthin zurück, wo du zuvor warst, und kannst dich über neue Antworten benachrichtigen lassen (entweder per E-Mail oder Push-Benachrichtigung). Du kannst auch Lesezeichen speichern und Beiträge positiv bewerten, um anderen Community-Mitgliedern deine Wertschätzung zu zeigen.
Mit deinem Input könnte dieser Beitrag noch besser werden 💗
Registrieren Anmelden601
Online32.8k
Benutzer82.8k
Themen1.3m
Beiträge