[solved]SQL Adapter plötzlich weg - Installation bringt Fehler

Qlink

Hi Leute,

ich bin etwas ratlos.
Bei mir ist plötzlich der SQL Adapter nicht mehr unter Instanzen aufgelistet.
Ich hätte schon versucht den Adapter zu entfernen und komplett neu zu installieren, aber das bringt leider auch keine Abhilfe.
Wenn ich unter Adapter schaue sehe ich aktuell:

Sieht also so aus als ob 1.9.2 installiert wäre...
Neu Installation über die Admin Oberfläche z.B. 1.9.4 schlägt ebenfalls fehl.

Ich hätte auch versucht manuell über commandline zu installieren bekomme aber haufenweise Fehlermeldungen:

C:\ioBroker>npm install iobroker.sql@1.9.2 --production
npm WARN deprecated node-uuid@1.4.8: Use uuid module instead

> mdns@2.4.0 install C:\ioBroker\node_modules\mdns
> node-gyp rebuild


C:\ioBroker\node_modules\mdns>if not defined npm_config_node_gyp (node "C:\Program Files\nodejs\node_modules\npm\node_modules\npm-lifecycle\node-gyp-bin\\..\..\node_modules\node-gyp\bin\node-gyp.js" rebuild )  else (node "C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" rebuild )
Building the projects in this solution one at a time. To enable parallel build, please add the "/m" switch.
  dns_sd.cpp
  dns_service_browse.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\dns_sd.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_bindings.vcxproj]
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\dns_service_browse.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_bindings.
vcxproj]
  dns_service_enumerate_domains.cpp
  dns_service_get_addr_info.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\dns_service_get_addr_info.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_bi
ndings.vcxproj]
  dns_service_process_result.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\dns_service_enumerate_domains.cpp) [C:\ioBroker\node_modules\mdns\build\dns_s
d_bindings.vcxproj]
  dns_service_ref.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\dns_service_process_result.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_b
indings.vcxproj]
  dns_service_ref_deallocate.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\dns_service_ref.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_bindings.vcx
proj]
  dns_service_ref_sock_fd.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\dns_service_ref_deallocate.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_b
indings.vcxproj]
  dns_service_register.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\dns_service_ref_sock_fd.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_bind
ings.vcxproj]
  dns_service_resolve.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\dns_service_register.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_binding
s.vcxproj]
  dns_service_update_record.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\dns_service_resolve.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_bindings
.vcxproj]
  mdns_utils.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\dns_service_update_record.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_bi
ndings.vcxproj]
  network_interface.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\mdns_utils.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_bindings.vcxproj]
  socket_watcher.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\network_interface.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_bindings.v
cxproj]
  txt_record_ref.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\socket_watcher.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_bindings.vcxp
roj]
  txt_record_create.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\txt_record_ref.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_bindings.vcxp
roj]
  txt_record_deallocate.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\txt_record_create.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_bindings.v
cxproj]
  txt_record_set_value.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\txt_record_deallocate.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_bindin
gs.vcxproj]
  txt_record_get_length.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\txt_record_set_value.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_binding
s.vcxproj]
  txt_record_buffer_to_object.cpp
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\txt_record_get_length.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_bindin
gs.vcxproj]
  win_delay_load_hook.cc
c:\iobroker\node_modules\mdns\src\mdns.hpp(32): fatal error C1083: Cannot open include file: 'dns_sd.h': No such file o
r directory (compiling source file ..\src\txt_record_buffer_to_object.cpp) [C:\ioBroker\node_modules\mdns\build\dns_sd_
bindings.vcxproj]
gyp ERR! build error
gyp ERR! stack Error: `C:\Program Files (x86)\MSBuild\14.0\bin\msbuild.exe` failed with exit code: 1
gyp ERR! stack     at ChildProcess.onExit (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\build.js:258:23)
gyp ERR! stack     at emitTwo (events.js:126:13)
gyp ERR! stack     at ChildProcess.emit (events.js:214:7)
gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:198:12)
gyp ERR! System Windows_NT 10.0.14393
gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "rebuild"
gyp ERR! cwd C:\ioBroker\node_modules\mdns
gyp ERR! node -v v8.11.3
gyp ERR! node-gyp -v v3.6.2
gyp ERR! not ok

> unix-dgram@0.2.3 install C:\ioBroker\node_modules\unix-dgram
> node-gyp rebuild


C:\ioBroker\node_modules\unix-dgram>if not defined npm_config_node_gyp (node "C:\Program Files\nodejs\node_modules\npm\node_modules\npm-lifecycle\node-gyp-bin\\..\..\node_modules\node-gyp\bin\node-gyp.js" rebuild )  else (node "C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" rebuild )
Building the projects in this solution one at a time. To enable parallel build, please add the "/m" switch.
  unix_dgram.cc
  win_delay_load_hook.cc
..\src\unix_dgram.cc(9): fatal error C1083: Cannot open include file: 'unistd.h': No such file or directory [C:\ioBroke
r\node_modules\unix-dgram\build\unix_dgram.vcxproj]
gyp ERR! build error
gyp ERR! stack Error: `C:\Program Files (x86)\MSBuild\14.0\bin\msbuild.exe` failed with exit code: 1
gyp ERR! stack     at ChildProcess.onExit (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\build.js:258:23)
gyp ERR! stack     at emitTwo (events.js:126:13)
gyp ERR! stack     at ChildProcess.emit (events.js:214:7)
gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:198:12)
gyp ERR! System Windows_NT 10.0.14393
gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "rebuild"
gyp ERR! cwd C:\ioBroker\node_modules\unix-dgram
gyp ERR! node -v v8.11.3
gyp ERR! node-gyp -v v3.6.2
gyp ERR! not ok

> ursa@0.9.4 install C:\ioBroker\node_modules\ursa
> node-gyp rebuild


C:\ioBroker\node_modules\ursa>if not defined npm_config_node_gyp (node "C:\Program Files\nodejs\node_modules\npm\node_modules\npm-lifecycle\node-gyp-bin\\..\..\node_modules\node-gyp\bin\node-gyp.js" rebuild )  else (node "C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" rebuild )
Building the projects in this solution one at a time. To enable parallel build, please add the "/m" switch.
  ursaNative.cc
  win_delay_load_hook.cc
..\src\ursaNative.cc(157): warning C4244: 'argument': conversion from 'ssize_t' to 'int', possible loss of data [C:\ioB
roker\node_modules\ursa\build\ursaNative.vcxproj]
..\src\ursaNative.cc(172): warning C4244: 'argument': conversion from 'ssize_t' to 'int', possible loss of data [C:\ioB
roker\node_modules\ursa\build\ursaNative.vcxproj]
LINK : fatal error LNK1181: cannot open input file 'C:\OpenSSL-Win64\lib\libeay32.lib' [C:\ioBroker\node_modules\ursa\b
uild\ursaNative.vcxproj]
gyp ERR! build error
gyp ERR! stack Error: `C:\Program Files (x86)\MSBuild\14.0\bin\msbuild.exe` failed with exit code: 1
gyp ERR! stack     at ChildProcess.onExit (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\build.js:258:23)
gyp ERR! stack     at emitTwo (events.js:126:13)
gyp ERR! stack     at ChildProcess.emit (events.js:214:7)
gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:198:12)
gyp ERR! System Windows_NT 10.0.14393
gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "rebuild"
gyp ERR! cwd C:\ioBroker\node_modules\ursa
gyp ERR! node -v v8.11.3
gyp ERR! node-gyp -v v3.6.2
gyp ERR! not ok
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: mdns@2.4.0 (node_modules\mdns):
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: mdns@2.4.0 install: `node-gyp rebuild`
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: Exit status 1
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: unix-dgram@0.2.3 (node_modules\unix-dgram):
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: unix-dgram@0.2.3 install: `node-gyp rebuild`
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: Exit status 1
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: ursa@0.9.4 (node_modules\ursa):
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: ursa@0.9.4 install: `node-gyp rebuild`
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: Exit status 1

+ iobroker.sql@1.9.2
removed 168 packages, updated 5 packages, moved 10 packages and audited 2742 packages in 272.273s
found 100 vulnerabilities (50 low, 37 moderate, 13 high)
  run `npm audit fix` to fix them, or `npm audit` for details

C:\ioBroker>

Hat jemand eine Idee wie ich das hinbiegen kann, oder muss ich einen Restore der kompletten VM machen ?

Danke für eure Hilfe.

Beste Grüße

Qlink

Hab das Problem gestern selbst lösen können.
Nach einem Host Update + NodeJS + NPM Update konnte ich den 1.9.2er SQL Adapter wieder zum Laufen bringen.
Der 1.9.4er geht nach wie vor nicht ...

Beste Grüße

Community Forum

NEWS

[solved]SQL Adapter plötzlich weg - Installation bringt Fehler

Support us

399

32.8k

82.7k

1.3m