Node-red-contrib-oracledb cannot be installed

Hi,

I try to install oracledb via:

npm install node-red-contrib-oracledb

But get the appended error file. I din't find any helpful solution in the web.

What can I do. (Win 7 System)

Sorry, I'm not allowed to upload the logfile, so I write it here (furthermore *.log files cannot be uploaded?!):

0 info it worked if it ends with ok
1 verbose cli [
1 verbose cli 'D:\bin\node-red\node.exe',
1 verbose cli 'D:\bin\node-red\node_modules\npm\bin\npm-cli.js',
1 verbose cli 'install',
1 verbose cli 'node-red-contrib-oracledb'
1 verbose cli ]
2 info using npm@6.13.4
3 info using node@v12.14.1
4 verbose npm-session 6374790d2eeb0222
5 silly install loadCurrentTree
6 silly install readGlobalPackageData
7 http fetch GET 304 https://registry.npmjs.org/node-red-contrib-oracledb 288ms (from cache)
8 silly pacote tag manifest for node-red-contrib-oracledb@latest fetched in 314ms
9 timing stage:loadCurrentTree Completed in 340ms
10 silly install loadIdealTree
11 silly install cloneCurrentTreeToIdealTree
12 timing stage:loadIdealTree:cloneCurrentTree Completed in 1ms
13 silly install loadShrinkwrap
14 timing stage:loadIdealTree:loadShrinkwrap Completed in 6ms
15 silly install loadAllDepsIntoIdealTree
16 silly resolveWithNewModule node-red-contrib-oracledb@0.5.1 checking installable status
17 http fetch GET 304 https_://registry.npmjs.org/oracledb 96ms (from cache)
18 silly pacote range manifest for oracledb@^1.9.3 fetched in 100ms
19 warn deprecated oracledb@1.13.1: Update to node-oracledb 4
20 silly resolveWithNewModule oracledb@1.13.1 checking installable status
21 http fetch GET 304 https_://registry.npmjs.org/object-resolve-path 108ms (from cache)
22 silly pacote range manifest for object-resolve-path@^1.1.0 fetched in 111ms
23 silly resolveWithNewModule object-resolve-path@1.1.1 checking installable status
24 http fetch GET 304 https_://registry.npmjs.org/nan 105ms (from cache)
25 silly pacote range manifest for nan@~2.5.0 fetched in 112ms
26 silly resolveWithNewModule nan@2.5.1 checking installable status
27 timing stage:loadIdealTree:loadAllDepsIntoIdealTree Completed in 235ms
28 timing stage:loadIdealTree Completed in 246ms
29 silly currentTree node-red
30 silly idealTree node-red
30 silly idealTree -- node-red-contrib-oracledb@0.5.1 30 silly idealTree +-- nan@2.5.1 30 silly idealTree +-- object-resolve-path@1.1.1 30 silly idealTree -- oracledb@1.13.1
31 silly install generateActionsToTake
32 timing stage:generateActionsToTake Completed in 10ms
33 silly diffTrees action count 4
34 silly diffTrees add nan@2.5.1
35 silly diffTrees add object-resolve-path@1.1.1
36 silly diffTrees add oracledb@1.13.1
37 silly diffTrees add node-red-contrib-oracledb@0.5.1
38 silly decomposeActions action count 32
39 silly decomposeActions fetch nan@2.5.1
40 silly decomposeActions extract nan@2.5.1
41 silly decomposeActions preinstall nan@2.5.1
42 silly decomposeActions build nan@2.5.1
43 silly decomposeActions install nan@2.5.1
44 silly decomposeActions postinstall nan@2.5.1
45 silly decomposeActions finalize nan@2.5.1
46 silly decomposeActions refresh-package-json nan@2.5.1
47 silly decomposeActions fetch object-resolve-path@1.1.1
48 silly decomposeActions extract object-resolve-path@1.1.1
49 silly decomposeActions preinstall object-resolve-path@1.1.1
50 silly decomposeActions build object-resolve-path@1.1.1
51 silly decomposeActions install object-resolve-path@1.1.1
52 silly decomposeActions postinstall object-resolve-path@1.1.1
53 silly decomposeActions finalize object-resolve-path@1.1.1
54 silly decomposeActions refresh-package-json object-resolve-path@1.1.1
55 silly decomposeActions fetch oracledb@1.13.1
56 silly decomposeActions extract oracledb@1.13.1
57 silly decomposeActions preinstall oracledb@1.13.1
58 silly decomposeActions build oracledb@1.13.1
59 silly decomposeActions install oracledb@1.13.1
60 silly decomposeActions postinstall oracledb@1.13.1
61 silly decomposeActions finalize oracledb@1.13.1
62 silly decomposeActions refresh-package-json oracledb@1.13.1
63 silly decomposeActions fetch node-red-contrib-oracledb@0.5.1
64 silly decomposeActions extract node-red-contrib-oracledb@0.5.1
65 silly decomposeActions preinstall node-red-contrib-oracledb@0.5.1
66 silly decomposeActions build node-red-contrib-oracledb@0.5.1
67 silly decomposeActions install node-red-contrib-oracledb@0.5.1
68 silly decomposeActions postinstall node-red-contrib-oracledb@0.5.1
69 silly decomposeActions finalize node-red-contrib-oracledb@0.5.1
70 silly decomposeActions refresh-package-json node-red-contrib-oracledb@0.5.1
71 silly install executeActions
72 silly doSerial global-install 32
73 verbose correctMkdir C:\Users...\AppData\Roaming\npm-cache_locks correctMkdir not in flight; initializing
74 verbose makeCacheDir UID & GID are irrelevant on win32
75 verbose lock using C:\Users...\AppData\Roaming\npm-cache_locks\staging-96f55fe515a345de.lock for D:\bin\node-red\node_modules.staging
76 silly doParallel extract 4
77 silly extract nan@2.5.1
78 silly extract object-resolve-path@1.1.1
79 silly extract oracledb@1.13.1
80 silly extract node-red-contrib-oracledb@0.5.1
81 silly tarball trying nan@~2.5.0 by hash: sha1-1bAWkSUzJql6K77p5hxV2NYDUeI=
82 silly tarball trying oracledb@^1.9.3 by hash: sha1-kjFktcGSztoBWQ41Jou3AX4krYk=
83 silly tarball trying object-resolve-path@^1.1.0 by hash: sha1-p/j5Poogr4DkQhe6fbVDFtnRIjI=
84 silly tarball trying node-red-contrib-oracledb@latest by hash: sha512-qb5OScM3QntI6Zp0iMMgMkw5WNWPYKwKRHeKQFXlEynJiDQ5RzUuckUp0IbeUPDteIIuGSIOr254gi5D0P203A==
85 silly extract object-resolve-path@^1.1.0 extracted to D:\bin\node-red\node_modules.staging\object-resolve-path-8294f31e (83ms)
86 silly extract nan@~2.5.0 extracted to D:\bin\node-red\node_modules.staging\nan-12fe1b00 (123ms)
87 silly extract node-red-contrib-oracledb@latest extracted to D:\bin\node-red\node_modules.staging\node-red-contrib-oracledb-f4764253 (131ms)
88 silly extract oracledb@^1.9.3 extracted to D:\bin\node-red\node_modules.staging\oracledb-80490462 (136ms)
89 timing action:extract Completed in 140ms
90 silly doReverseSerial unbuild 32
91 silly doSerial remove 32
92 silly doSerial move 32
93 silly doSerial finalize 32
94 silly finalize D:\bin\node-red\node_modules\node-red-contrib-oracledb\node_modules\nan
95 silly finalize D:\bin\node-red\node_modules\node-red-contrib-oracledb\node_modules\object-resolve-path
96 silly finalize D:\bin\node-red\node_modules\node-red-contrib-oracledb\node_modules\oracledb
97 silly finalize D:\bin\node-red\node_modules\node-red-contrib-oracledb
98 timing action:finalize Completed in 20ms
99 silly doParallel refresh-package-json 4
100 silly refresh-package-json D:\bin\node-red\node_modules\node-red-contrib-oracledb\node_modules\nan
101 silly refresh-package-json D:\bin\node-red\node_modules\node-red-contrib-oracledb\node_modules\object-resolve-path
102 silly refresh-package-json D:\bin\node-red\node_modules\node-red-contrib-oracledb\node_modules\oracledb
103 silly refresh-package-json D:\bin\node-red\node_modules\node-red-contrib-oracledb
104 timing action:refresh-package-json Completed in 153ms
105 silly doParallel preinstall 4
106 silly preinstall nan@2.5.1
107 info lifecycle nan@2.5.1~preinstall: nan@2.5.1
108 silly preinstall object-resolve-path@1.1.1
109 info lifecycle object-resolve-path@1.1.1~preinstall: object-resolve-path@1.1.1
110 silly preinstall oracledb@1.13.1
111 info lifecycle oracledb@1.13.1~preinstall: oracledb@1.13.1
112 silly preinstall node-red-contrib-oracledb@0.5.1
113 info lifecycle node-red-contrib-oracledb@0.5.1~preinstall: node-red-contrib-oracledb@0.5.1
114 timing action:preinstall Completed in 5ms
115 silly doSerial build 32
116 silly build nan@2.5.1
117 info linkStuff nan@2.5.1
118 silly linkStuff nan@2.5.1 has D:\bin\node-red\node_modules\node-red-contrib-oracledb\node_modules as its parent node_modules
119 silly linkStuff nan@2.5.1 is part of a global install
120 silly linkStuff nan@2.5.1 is installed into a global node_modules
121 silly build object-resolve-path@1.1.1
122 info linkStuff object-resolve-path@1.1.1
123 silly linkStuff object-resolve-path@1.1.1 has D:\bin\node-red\node_modules\node-red-contrib-oracledb\node_modules as its parent node_modules
124 silly linkStuff object-resolve-path@1.1.1 is part of a global install
125 silly linkStuff object-resolve-path@1.1.1 is installed into a global node_modules
126 silly build oracledb@1.13.1
127 info linkStuff oracledb@1.13.1
128 silly linkStuff oracledb@1.13.1 has D:\bin\node-red\node_modules\node-red-contrib-oracledb\node_modules as its parent node_modules
129 silly linkStuff oracledb@1.13.1 is part of a global install
130 silly linkStuff oracledb@1.13.1 is installed into a global node_modules
131 silly build node-red-contrib-oracledb@0.5.1
132 info linkStuff node-red-contrib-oracledb@0.5.1
133 silly linkStuff node-red-contrib-oracledb@0.5.1 has D:\bin\node-red\node_modules as its parent node_modules
134 silly linkStuff node-red-contrib-oracledb@0.5.1 is part of a global install
135 silly linkStuff node-red-contrib-oracledb@0.5.1 is installed into a global node_modules
136 silly linkStuff node-red-contrib-oracledb@0.5.1 is installed into the top-level global node_modules
137 timing action:build Completed in 2ms
138 silly doSerial global-link 32
139 silly doParallel update-linked 0
140 silly doSerial install 32
141 silly install nan@2.5.1
142 info lifecycle nan@2.5.1~install: nan@2.5.1
143 silly install object-resolve-path@1.1.1
144 info lifecycle object-resolve-path@1.1.1~install: object-resolve-path@1.1.1
145 silly install oracledb@1.13.1
146 info lifecycle oracledb@1.13.1~install: oracledb@1.13.1
147 verbose lifecycle oracledb@1.13.1~install: unsafe-perm in lifecycle true
148 verbose lifecycle oracledb@1.13.1~install: PATH: ...
149 verbose lifecycle oracledb@1.13.1~install: CWD: D:\bin\node-red\node_modules\node-red-contrib-oracledb\node_modules\oracledb
150 silly lifecycle oracledb@1.13.1~install: Args: [ '/d /s /c', 'node-gyp rebuild' ]
151 silly lifecycle oracledb@1.13.1~install: Returned: code: 1 signal: null
152 info lifecycle oracledb@1.13.1~install: Failed to exec install script
153 timing action:install Completed in 35ms
154 verbose unlock done using C:\Users...\AppData\Roaming\npm-cache_locks\staging-96f55fe515a345de.lock for D:\bin\node-red\node_modules.staging
155 timing stage:rollbackFailedOptional Completed in 156ms
156 timing stage:runTopLevelLifecycles Completed in 1125ms
157 verbose stack Error: oracledb@1.13.1 install: node-gyp rebuild
157 verbose stack Exit status 1
157 verbose stack at EventEmitter. (D:\bin\node-red\node_modules\npm\node_modules\npm-lifecycle\index.js:332:16)
157 verbose stack at EventEmitter.emit (events.js:223:5)
157 verbose stack at ChildProcess. (D:\bin\node-red\node_modules\npm\node_modules\npm-lifecycle\lib\spawn.js:55:14)
157 verbose stack at ChildProcess.emit (events.js:223:5)
157 verbose stack at maybeClose (internal/child_process.js:1021:16)
157 verbose stack at Process.ChildProcess._handle.onexit (internal/child_process.js:283:5)
158 verbose pkgid oracledb@1.13.1
159 verbose cwd D:\bin\node-red
160 verbose Windows_NT 6.1.7601
161 verbose argv "D:\bin\node-red\node.exe" "D:\bin\node-red\node_modules\npm\bin\npm-cli.js" "install" "node-red-contrib-oracledb"
162 verbose node v12.14.1
163 verbose npm v6.13.4
164 error code ELIFECYCLE
165 error errno 1
166 error oracledb@1.13.1 install: node-gyp rebuild
166 error Exit status 1
167 error Failed at the oracledb@1.13.1 install script.
167 error This is probably not a problem with npm. There is likely additional logging output above.
168 verbose exit [ 1, true ]

Did you switch to your .node-red directory before running the install command?

No,

I directly install from Node.js base directory where npm.exe and node.exe are (I just called the directory node-red, since I use Node.js only for node-red). From here I installed mysql, postgres, influxdb, s7 support without any problems, but oracledb and opcua fail, starting with the message (from German) "command 'node' is written wrong or could not be found ...". The PATH variable contains the local directory.

You need the Windows build tools installed so that node-gyp can recompile some native bindings

1 Like

OH NO ... SORRY!!! The PATH variable had ".;" but not the "D:\bin\node-red" entry ...

Now I get another problem with building oracledb which I have to analyze first.

opc-ua could now be installed.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.