NEWS
[solved]SQL Adapter plötzlich weg - Installation bringt Fehler
-
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
-
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