srinivasabommareddy commented 10 months ago

Unable to install ibm_db on z/os

z/OS 2.4:
DB2 version 12 :

For non-Windows system, output of below commands from terminal:

$ npm install ibm_db npm ERR! code 1 npm ERR! path /u/ttbr/home/bomms/TestDB/node_modules/ibm_db npm ERR! command failed npm ERR! command sh -c node installer/driverInstall.js npm ERR! platform = os390, arch = s390x, node.js version = v18.14.2 npm ERR! Unable to find 'make' in PATH. Installation may fail! npm ERR! npm ERR! Error: Command failed: node-gyp configure build --IS_DOWNLOADED=false --IBM_DB_HOME="$IBM_DB_HOME" npm ERR! gyp info it worked if it ends with ok npm ERR! gyp info using node-gyp@9.3.1 npm ERR! gyp info using node@18.14.2 | os390 | s390x npm ERR! gyp info find Python using Python version 3.10.7 found at "/usr/lpp/ported/road4z/bin/python3" npm ERR! gyp http GET https://nodejs.org/download/release/v18.14.2/node-v18.14.2-headers.tar.gz npm ERR! gyp WARN install got an error, rolling back install npm ERR! gyp ERR! configure error npm ERR! gyp ERR! stack FetchError: request to https://nodejs.org/download/release/v18.14.2/node-v18.14.2-headers.tar.gz faile d, reason: unable to verify the first certificate npm ERR! gyp ERR! stack at ClientRequest. (/CTQ111/usr/lpp/IBM/cnj/v18r0/IBM/node-v18.14.2-os390-s390x-20230323 1340/lib/node_modules/npm/node_modules/node-gyp/node_modules/minipass-fetch/lib/index.js:130:14) npm ERR! gyp ERR! stack at ClientRequest.emit (node:events:513:28) npm ERR! gyp ERR! stack at TLSSocket.socketErrorListener (node:_http_client:502:9) npm ERR! gyp ERR! stack at TLSSocket.emit (node:events:513:28) npm ERR! gyp ERR! stack at emitErrorNT (node:internal/streams/destroy:151:8) npm ERR! gyp ERR! stack at emitErrorCloseNT (node:internal/streams/destroy:116:3) npm ERR! gyp ERR! stack at process.processTicksAndRejections (node:internal/process/task_queues:82:21) npm ERR! gyp ERR! System OS/390 28.00 npm ERR! gyp ERR! command "/CTQ111/usr/lpp/IBM/cnj/v18r0/IBM/node-v18.14.2-os390-s390x-202303231340/bin/node" "/CTQ111/usr/lpp /IBM/cnj/v18r0/IBM/node-v18.14.2-os390-s390x-202303231340/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "configu re" "build" "--IS_DOWNLOADED=false" "--IBM_DB_HOME=SYSDB2.DQA0" npm ERR! gyp ERR! cwd /u/ttbr/home/bomms/TestDB/node_modules/ibm_db npm ERR! gyp ERR! node -v v18.14.2 npm ERR! gyp ERR! node-gyp -v v9.3.1 npm ERR! gyp ERR! not ok npm ERR! npm ERR! at ChildProcess.exithandler (node:child_process:419:12) npm ERR! at ChildProcess.emit (node:events:513:28) npm ERR! at maybeClose (node:internal/child_process:1134:16) npm ERR! at Socket. (node:internal/child_process:492:11) npm ERR! at Socket.emit (node:events:513:28) npm ERR! at Pipe. (node:net:322:12) { npm ERR! code: 1, npm ERR! killed: false, npm ERR! signal: null, npm ERR! cmd: 'node-gyp configure build --IS_DOWNLOADED=false --IBM_DB_HOME="$IBM_DB_HOME"' npm ERR! } npm ERR! make: Error -- FSUM8705 No target npm ERR! oput 'SYSDB2.DQA0.SDSNMACS(DSNAO64C)' '/u/ttbr/home/bomms/TestDB/node_modules/ibm_db/build/dsnao64c.x'

npm ERR! A complete log of this run can be found in: npm ERR! /u/ttbr/home/bomms/.npm/_logs/2023-08-17T13_53_49_862Z-debug-0.log $ node --version v18.14.2

output of below commands from windows command prompt:

$ $ node -v v18.14.2 $

$ $ npm ls ibm_db testdb@1.0.0 /u/ttbr/home/bomms/TestDB `-- (empty)

$

$ echo $IBM_DB_HOME SYSDB2.DQA0 $

$ echo $PATH /bin:/usr/sbin:.:/usr/lpp/ported/road4z/bin:/usr/lpp/java/J8.0_64/bin:/usr/lpp/IBM/cnj/v18r0/IBM/node-latest-os390-s390x/bin:/service/rocket/python/python-2017-04-12-py36/python36/bin:/usr/lpp/ported/openssl/bin:/usr/lpp/IBM/dbb:/usr/lpp/IBM/dbb/migration/bin:/usr/lpp/ported/curl/bin $

$ $ echo $LIB ▒ $

Please provide below problem specific info:

=========================================

For Installation related issue

please share complete output of npm install ibm_db command. 0 verbose cli /CTQ111/usr/lpp/IBM/cnj/v18r0/IBM/node-v18.14.2-os390-s390x-202303231340/bin/node /usr/lpp/IBM/cnj/v18r0/IBM/node-latest-os390-s390x/bin/npm 1 info using npm@9.5.0 2 info using node@v18.14.2 3 timing npm:load:whichnode Completed in 5ms 4 timing config:load:defaults Completed in 2ms 5 timing config:load:file:/CTQ111/usr/lpp/IBM/cnj/v18r0/IBM/node-v18.14.2-os390-s390x-202303231340/lib/node_modules/npm/npmrc Completed in 2ms 6 timing config:load:builtin Completed in 2ms 7 timing config:load:cli Completed in 2ms 8 timing config:load:env Completed in 1ms 9 timing config:load:file:/u/ttbr/home/bomms/TestDB/.npmrc Completed in 1ms 10 timing config:load:project Completed in 7ms 11 timing config:load:file:/u/ttbr/home/bomms/.npmrc Completed in 2ms 12 timing config:load:user Completed in 2ms 13 timing config:load:file:/CTQ111/usr/lpp/IBM/cnj/v18r0/IBM/node-v18.14.2-os390-s390x-202303231340/etc/npmrc Completed in 0ms 14 timing config:load:global Completed in 0ms 15 timing config:load:setEnvs Completed in 2ms 16 timing config:load Completed in 18ms 17 timing npm:load:configload Completed in 19ms 18 timing npm:load:mkdirpcache Completed in 0ms 19 timing npm:load:mkdirplogs Completed in 3ms 20 verbose title npm install ibm_db 21 verbose argv "install" "ibm_db" 22 timing npm:load:setTitle Completed in 2ms 23 timing config:load:flatten Completed in 4ms 24 timing npm:load:display Completed in 5ms 25 verbose logfile logs-max:10 dir:/u/ttbr/home/bomms/.npm/_logs/2023-08-17T13_53_49_862Z- 26 verbose logfile /u/ttbr/home/bomms/.npm/_logs/2023-08-17T13_53_49_862Z-debug-0.log 27 timing npm:load:logFile Completed in 10ms 28 timing npm:load:timers Completed in 0ms 29 timing npm:load:configScope Completed in 0ms 30 timing npm:load Completed in 44ms 31 timing arborist:ctor Completed in 1ms 32 silly logfile start cleaning logs, removing 1 files 33 silly logfile done cleaning log files 34 timing arborist:ctor Completed in 0ms 35 timing idealTree:init Completed in 45ms 36 timing idealTree:userRequests Completed in 7ms 37 silly idealTree buildDeps 38 silly fetch manifest ibm@^0.0.1 39 http fetch GET 200 https://registry.npmjs.org/ibm 1171ms (cache updated) 40 silly fetch manifest ibm_db@ 41 http fetch GET 200 https://registry.npmjs.org/ibm_db 868ms (cache updated) 42 silly placeDep ROOT ibm@0.0.1 OK for: testdb@1.0.0 want: ^0.0.1 43 silly placeDep ROOT ibm_db@3.2.1 OK for: testdb@1.0.0 want: 44 silly fetch manifest adm-zip@^0.5.10 45 silly fetch manifest axios@^0.26.1 46 silly fetch manifest big-integer@^1.6.51 47 silly fetch manifest bindings@^1.5.0 48 silly fetch manifest fs-extra@^8.1.0 49 silly fetch manifest lodash@^4.17.21 50 silly fetch manifest nan@^2.17.0 51 silly fetch manifest q@^1.5.1 52 silly fetch manifest targz@^1.0.1 53 http fetch GET 200 https://registry.npmjs.org/adm-zip 508ms (cache updated) 54 http fetch GET 200 https://registry.npmjs.org/bindings 507ms (cache updated) 55 http fetch GET 200 https://registry.npmjs.org/nan 506ms (cache updated) 56 http fetch GET 200 https://registry.npmjs.org/q 509ms (cache updated) 57 http fetch GET 200 https://registry.npmjs.org/lodash 512ms (cache updated) 58 http fetch GET 200 https://registry.npmjs.org/big-integer 526ms (cache updated) 59 http fetch GET 200 https://registry.npmjs.org/fs-extra 527ms (cache updated) 60 http fetch GET 200 https://registry.npmjs.org/axios 542ms (cache updated) 61 http fetch GET 200 https://registry.npmjs.org/targz 1056ms (cache updated) 62 timing idealTree:#root Completed in 3131ms 63 timing idealTree:node_modules/ibm Completed in 1ms 64 silly placeDep ROOT adm-zip@0.5.10 OK for: ibm_db@3.2.1 want: ^0.5.10 65 silly placeDep ROOT axios@0.26.1 OK for: ibm_db@3.2.1 want: ^0.26.1 66 silly placeDep ROOT big-integer@1.6.51 OK for: ibm_db@3.2.1 want: ^1.6.51 67 silly placeDep ROOT bindings@1.5.0 OK for: ibm_db@3.2.1 want: ^1.5.0 68 silly placeDep ROOT fs-extra@8.1.0 OK for: ibm_db@3.2.1 want: ^8.1.0 69 silly placeDep ROOT lodash@4.17.21 OK for: ibm_db@3.2.1 want: ^4.17.21 70 silly placeDep ROOT nan@2.17.0 OK for: ibm_db@3.2.1 want: ^2.17.0 71 silly placeDep ROOT q@1.5.1 OK for: ibm_db@3.2.1 want: ^1.5.1 72 silly placeDep ROOT targz@1.0.1 OK for: ibm_db@3.2.1 want: ^1.0.1 73 silly fetch manifest follow-redirects@^1.14.8 74 silly fetch manifest file-uri-to-path@1.0.0 75 silly fetch manifest graceful-fs@^4.2.0 76 silly fetch manifest jsonfile@^4.0.0 77 silly fetch manifest universalify@^0.1.0 78 silly fetch manifest tar-fs@^1.8.1 79 http fetch GET 200 https://registry.npmjs.org/file-uri-to-path 357ms (cache updated) 80 http fetch GET 200 https://registry.npmjs.org/tar-fs 356ms (cache updated) 81 http fetch GET 200 https://registry.npmjs.org/jsonfile 381ms (cache updated) 82 http fetch GET 200 https://registry.npmjs.org/universalify 382ms (cache updated) 83 http fetch GET 200 https://registry.npmjs.org/graceful-fs 390ms (cache updated) 84 http fetch GET 200 https://registry.npmjs.org/follow-redirects 406ms (cache updated) 85 timing idealTree:node_modules/ibm_db Completed in 439ms 86 timing idealTree:node_modules/adm-zip Completed in 0ms 87 silly placeDep ROOT follow-redirects@1.15.2 OK for: axios@0.26.1 want: ^1.14.8 88 timing idealTree:node_modules/axios Completed in 3ms 89 timing idealTree:node_modules/big-integer Completed in 0ms 90 silly placeDep ROOT file-uri-to-path@1.0.0 OK for: bindings@1.5.0 want: 1.0.0 91 timing idealTree:node_modules/bindings Completed in 3ms 92 timing idealTree:node_modules/file-uri-to-path Completed in 0ms 93 timing idealTree:node_modules/follow-redirects Completed in 0ms 94 silly placeDep ROOT graceful-fs@4.2.11 OK for: fs-extra@8.1.0 want: ^4.2.0 95 silly placeDep ROOT jsonfile@4.0.0 OK for: fs-extra@8.1.0 want: ^4.0.0 96 silly placeDep ROOT universalify@0.1.2 OK for: fs-extra@8.1.0 want: ^0.1.0 97 timing idealTree:node_modules/fs-extra Completed in 10ms 98 timing idealTree:node_modules/graceful-fs Completed in 0ms 99 timing idealTree:node_modules/jsonfile Completed in 0ms 100 timing idealTree:node_modules/lodash Completed in 0ms 101 timing idealTree:node_modules/nan Completed in 0ms 102 timing idealTree:node_modules/q Completed in 0ms 103 silly placeDep ROOT tar-fs@1.16.3 OK for: targz@1.0.1 want: ^1.8.1 104 silly fetch manifest chownr@^1.0.1 105 silly fetch manifest mkdirp@^0.5.1 106 silly fetch manifest pump@^1.0.0 107 silly fetch manifest tar-stream@^1.1.2 108 http fetch GET 200 https://registry.npmjs.org/pump 247ms (cache updated) 109 http fetch GET 200 https://registry.npmjs.org/tar-stream 313ms (cache updated) 110 http fetch GET 200 https://registry.npmjs.org/chownr 840ms (cache updated) 111 http fetch GET 200 https://registry.npmjs.org/mkdirp 943ms (cache updated) 112 timing idealTree:node_modules/targz Completed in 957ms 113 silly placeDep ROOT chownr@1.1.4 OK for: tar-fs@1.16.3 want: ^1.0.1 114 silly placeDep ROOT mkdirp@0.5.6 OK for: tar-fs@1.16.3 want: ^0.5.1 115 silly placeDep ROOT pump@1.0.3 OK for: tar-fs@1.16.3 want: ^1.0.0 116 silly placeDep ROOT tar-stream@1.6.2 OK for: tar-fs@1.16.3 want: ^1.1.2 117 silly fetch manifest minimist@^1.2.6 118 silly fetch manifest end-of-stream@^1.1.0 119 silly fetch manifest once@^1.3.1 120 silly fetch manifest bl@^1.0.0 121 silly fetch manifest buffer-alloc@^1.2.0 122 silly fetch manifest end-of-stream@^1.0.0 123 silly fetch manifest fs-constants@^1.0.0 124 silly fetch manifest readable-stream@^2.3.0 125 silly fetch manifest to-buffer@^1.1.1 126 silly fetch manifest xtend@^4.0.0 127 http fetch GET 200 https://registry.npmjs.org/fs-constants 373ms (cache updated) 128 http fetch GET 200 https://registry.npmjs.org/end-of-stream 382ms (cache updated) 129 http fetch GET 200 https://registry.npmjs.org/bl 381ms (cache updated) 130 http fetch GET 200 https://registry.npmjs.org/end-of-stream 407ms (cache revalidated) 131 http fetch GET 200 https://registry.npmjs.org/xtend 443ms (cache updated) 132 http fetch GET 200 https://registry.npmjs.org/readable-stream 461ms (cache updated) 133 http fetch GET 200 https://registry.npmjs.org/to-buffer 505ms (cache updated) 134 http fetch GET 200 https://registry.npmjs.org/once 540ms (cache updated) 135 http fetch GET 200 https://registry.npmjs.org/minimist 620ms (cache updated) 136 http fetch GET 200 https://registry.npmjs.org/buffer-alloc 1098ms (cache updated) 137 timing idealTree:node_modules/tar-fs Completed in 1112ms 138 timing idealTree:node_modules/chownr Completed in 0ms 139 silly placeDep ROOT minimist@1.2.8 OK for: mkdirp@0.5.6 want: ^1.2.6 140 timing idealTree:node_modules/mkdirp Completed in 2ms 141 timing idealTree:node_modules/minimist Completed in 0ms 142 silly placeDep ROOT end-of-stream@1.4.4 OK for: pump@1.0.3 want: ^1.1.0 143 silly placeDep ROOT once@1.4.0 OK for: pump@1.0.3 want: ^1.3.1 144 silly fetch manifest wrappy@1 145 http fetch GET 200 https://registry.npmjs.org/wrappy 180ms (cache updated) 146 timing idealTree:node_modules/pump Completed in 185ms 147 timing idealTree:node_modules/end-of-stream Completed in 0ms 148 silly placeDep ROOT wrappy@1.0.2 OK for: once@1.4.0 want: 1 149 timing idealTree:node_modules/once Completed in 3ms 150 silly placeDep ROOT bl@1.2.3 OK for: tar-stream@1.6.2 want: ^1.0.0 151 silly placeDep ROOT buffer-alloc@1.2.0 OK for: tar-stream@1.6.2 want: ^1.2.0 152 silly placeDep ROOT fs-constants@1.0.0 OK for: tar-stream@1.6.2 want: ^1.0.0 153 silly placeDep ROOT readable-stream@2.3.8 OK for: tar-stream@1.6.2 want: ^2.3.0 154 silly placeDep ROOT to-buffer@1.1.1 OK for: tar-stream@1.6.2 want: ^1.1.1 155 silly placeDep ROOT xtend@4.0.2 OK for: tar-stream@1.6.2 want: ^4.0.0 156 silly fetch manifest safe-buffer@^5.1.1 157 silly fetch manifest buffer-alloc-unsafe@^1.1.0 158 silly fetch manifest buffer-fill@^1.0.0 159 silly fetch manifest core-util-is@~1.0.0 160 silly fetch manifest inherits@~2.0.3 161 silly fetch manifest isarray@~1.0.0 162 silly fetch manifest process-nextick-args@~2.0.0 163 silly fetch manifest safe-buffer@~5.1.1 164 silly fetch manifest string_decoder@~1.1.1 165 silly fetch manifest util-deprecate@~1.0.1 166 http fetch GET 200 https://registry.npmjs.org/buffer-alloc-unsafe 426ms (cache updated) 167 http fetch GET 200 https://registry.npmjs.org/isarray 416ms (cache updated) 168 http fetch GET 200 https://registry.npmjs.org/safe-buffer 429ms (cache updated) 169 http fetch GET 200 https://registry.npmjs.org/buffer-fill 427ms (cache updated) 170 http fetch GET 200 https://registry.npmjs.org/process-nextick-args 417ms (cache updated) 171 http fetch GET 200 https://registry.npmjs.org/inherits 423ms (cache updated) 172 http fetch GET 200 https://registry.npmjs.org/core-util-is 468ms (cache updated) 173 http fetch GET 200 https://registry.npmjs.org/string_decoder 475ms (cache updated) 174 http fetch GET 200 https://registry.npmjs.org/safe-buffer 477ms (cache updated) 175 http fetch GET 200 https://registry.npmjs.org/util-deprecate 484ms (cache updated) 176 timing idealTree:node_modules/tar-stream Completed in 515ms 177 silly placeDep ROOT safe-buffer@5.2.1 OK for: bl@1.2.3 want: ^5.1.1 178 timing idealTree:node_modules/bl Completed in 5ms 179 silly placeDep ROOT buffer-alloc-unsafe@1.1.0 OK for: buffer-alloc@1.2.0 want: ^1.1.0 180 silly placeDep ROOT buffer-fill@1.0.0 OK for: buffer-alloc@1.2.0 want: ^1.0.0 181 timing idealTree:node_modules/buffer-alloc Completed in 5ms 182 timing idealTree:node_modules/buffer-alloc-unsafe Completed in 0ms 183 timing idealTree:node_modules/buffer-fill Completed in 0ms 184 timing idealTree:node_modules/fs-constants Completed in 0ms 185 silly placeDep ROOT core-util-is@1.0.3 OK for: readable-stream@2.3.8 want: ~1.0.0 186 silly placeDep ROOT inherits@2.0.4 OK for: readable-stream@2.3.8 want: ~2.0.3 187 silly placeDep ROOT isarray@1.0.0 OK for: readable-stream@2.3.8 want: ~1.0.0 188 silly placeDep ROOT process-nextick-args@2.0.1 OK for: readable-stream@2.3.8 want: ~2.0.0 189 silly placeDep node_modules/readable-stream safe-buffer@5.1.2 OK for: readable-stream@2.3.8 want: ~5.1.1 190 silly placeDep ROOT string_decoder@1.1.1 OK for: readable-stream@2.3.8 want: ~1.1.1 191 silly placeDep ROOT util-deprecate@1.0.2 OK for: readable-stream@2.3.8 want: ~1.0.1 192 silly fetch manifest safe-buffer@~5.1.0 193 timing idealTree:node_modules/readable-stream Completed in 32ms 194 timing idealTree:node_modules/core-util-is Completed in 0ms 195 timing idealTree:node_modules/inherits Completed in 0ms 196 timing idealTree:node_modules/isarray Completed in 0ms 197 timing idealTree:node_modules/process-nextick-args Completed in 0ms 198 timing idealTree:node_modules/safe-buffer Completed in 0ms 199 silly placeDep node_modules/string_decoder safe-buffer@5.1.2 OK for: string_decoder@1.1.1 want: ~5.1.0 200 timing idealTree:node_modules/string_decoder Completed in 1ms 201 timing idealTree:node_modules/to-buffer Completed in 0ms 202 timing idealTree:node_modules/universalify Completed in 0ms 203 timing idealTree:node_modules/util-deprecate Completed in 0ms 204 timing idealTree:node_modules/wrappy Completed in 0ms 205 timing idealTree:node_modules/xtend Completed in 0ms 206 timing idealTree:node_modules/readable-stream/node_modules/safe-buffer Completed in 0ms 207 timing idealTree:node_modules/string_decoder/node_modules/safe-buffer Completed in 0ms 208 timing idealTree:buildDeps Completed in 6412ms 209 timing idealTree:fixDepFlags Completed in 3ms 210 timing idealTree Completed in 6469ms 211 timing reify:loadTrees Completed in 6473ms 212 timing reify:diffTrees Completed in 5ms 213 silly reify moves {} 214 timing reify:retireShallow Completed in 2ms 215 timing reify:createSparse Completed in 13ms 216 timing reify:loadBundles Completed in 0ms 217 silly audit bulk request { 217 silly audit ibm: [ '0.0.1' ], 217 silly audit ibm_db: [ '3.2.1' ], 217 silly audit 'adm-zip': [ '0.5.10' ], 217 silly audit axios: [ '0.26.1' ], 217 silly audit 'big-integer': [ '1.6.51' ], 217 silly audit bindings: [ '1.5.0' ], 217 silly audit 'fs-extra': [ '8.1.0' ], 217 silly audit lodash: [ '4.17.21' ], 217 silly audit nan: [ '2.17.0' ], 217 silly audit q: [ '1.5.1' ], 217 silly audit targz: [ '1.0.1' ], 217 silly audit 'follow-redirects': [ '1.15.2' ], 217 silly audit 'file-uri-to-path': [ '1.0.0' ], 217 silly audit 'graceful-fs': [ '4.2.11' ], 217 silly audit jsonfile: [ '4.0.0' ], 217 silly audit universalify: [ '0.1.2' ], 217 silly audit 'tar-fs': [ '1.16.3' ], 217 silly audit chownr: [ '1.1.4' ], 217 silly audit mkdirp: [ '0.5.6' ], 217 silly audit pump: [ '1.0.3' ], 217 silly audit 'tar-stream': [ '1.6.2' ], 217 silly audit minimist: [ '1.2.8' ], 217 silly audit 'end-of-stream': [ '1.4.4' ], 217 silly audit once: [ '1.4.0' ], 217 silly audit wrappy: [ '1.0.2' ], 217 silly audit bl: [ '1.2.3' ], 217 silly audit 'buffer-alloc': [ '1.2.0' ], 217 silly audit 'fs-constants': [ '1.0.0' ], 217 silly audit 'readable-stream': [ '2.3.8' ], 217 silly audit 'to-buffer': [ '1.1.1' ], 217 silly audit xtend: [ '4.0.2' ], 217 silly audit 'safe-buffer': [ '5.2.1', '5.1.2' ], 217 silly audit 'buffer-alloc-unsafe': [ '1.1.0' ], 217 silly audit 'buffer-fill': [ '1.0.0' ], 217 silly audit 'core-util-is': [ '1.0.3' ], 217 silly audit inherits: [ '2.0.4' ], 217 silly audit isarray: [ '1.0.0' ], 217 silly audit 'process-nextick-args': [ '2.0.1' ], 217 silly audit string_decoder: [ '1.1.1' ], 217 silly audit 'util-deprecate': [ '1.0.2' ] 217 silly audit } 218 timing reifyNode:node_modules/ibm Completed in 869ms 219 timing reifyNode:node_modules/buffer-alloc-unsafe Completed in 875ms 220 timing reifyNode:node_modules/buffer-alloc Completed in 876ms 221 timing reifyNode:node_modules/buffer-fill Completed in 878ms 222 timing reifyNode:node_modules/process-nextick-args Completed in 887ms 223 timing reifyNode:node_modules/end-of-stream Completed in 887ms 224 timing reifyNode:node_modules/once Completed in 888ms 225 timing reifyNode:node_modules/wrappy Completed in 889ms 226 timing reifyNode:node_modules/universalify Completed in 889ms 227 timing reifyNode:node_modules/chownr Completed in 890ms 228 timing reifyNode:node_modules/bindings Completed in 889ms 229 timing reifyNode:node_modules/inherits Completed in 896ms 230 timing reifyNode:node_modules/core-util-is Completed in 896ms 231 timing reifyNode:node_modules/fs-constants Completed in 897ms 232 timing reifyNode:node_modules/util-deprecate Completed in 903ms 233 timing reifyNode:node_modules/to-buffer Completed in 902ms 234 timing reifyNode:node_modules/jsonfile Completed in 902ms 235 timing reifyNode:node_modules/xtend Completed in 906ms 236 timing reifyNode:node_modules/pump Completed in 906ms 237 timing reifyNode:node_modules/graceful-fs Completed in 906ms 238 timing reifyNode:node_modules/mkdirp Completed in 907ms 239 timing reifyNode:node_modules/targz Completed in 907ms 240 timing reifyNode:node_modules/string_decoder/node_modules/safe-buffer Completed in 911ms 241 timing reifyNode:node_modules/readable-stream/node_modules/safe-buffer Completed in 910ms 242 timing reifyNode:node_modules/string_decoder Completed in 913ms 243 timing reifyNode:node_modules/isarray Completed in 912ms 244 timing reifyNode:node_modules/safe-buffer Completed in 912ms 245 timing reifyNode:node_modules/tar-stream Completed in 917ms 246 timing reifyNode:node_modules/bl Completed in 927ms 247 timing reifyNode:node_modules/follow-redirects Completed in 929ms 248 timing reifyNode:node_modules/file-uri-to-path Completed in 932ms 249 timing reifyNode:node_modules/q Completed in 935ms 250 timing reifyNode:node_modules/big-integer Completed in 963ms 251 timing reifyNode:node_modules/adm-zip Completed in 982ms 252 timing reifyNode:node_modules/minimist Completed in 1001ms 253 timing reifyNode:node_modules/readable-stream Completed in 1019ms 254 timing reifyNode:node_modules/tar-fs Completed in 1062ms 255 http fetch POST 200 https://registry.npmjs.org/-/npm/v1/security/advisories/bulk 1134ms 256 timing auditReport:getReport Completed in 1139ms 257 silly audit report {} 258 timing auditReport:init Completed in 0ms 259 timing reify:audit Completed in 1141ms 260 timing reifyNode:node_modules/fs-extra Completed in 1128ms 261 timing reifyNode:node_modules/axios Completed in 1154ms 262 timing reifyNode:node_modules/nan Completed in 1172ms 263 timing reifyNode:node_modules/ibm_db Completed in 1763ms 264 timing reifyNode:node_modules/lodash Completed in 1934ms 265 timing reify:unpack Completed in 1939ms 266 timing reify:unretire Completed in 0ms 267 timing build:queue Completed in 5ms 268 timing build:link:node_modules/mkdirp Completed in 5ms 269 timing build:link Completed in 6ms 270 info run ibm_db@3.2.1 install node_modules/ibm_db node installer/driverInstall.js 271 info run ibm_db@3.2.1 install { code: 1, signal: null } 272 timing reify:rollback:createSparse Completed in 896ms 273 timing reify:rollback:retireShallow Completed in 0ms 274 timing command:install Completed in 17144ms 275 verbose stack Error: command failed 275 verbose stack at ChildProcess. (/CTQ111/usr/lpp/IBM/cnj/v18r0/IBM/node-v18.14.2-os390-s390x-202303231340/lib/node_modules/npm/node_modules/@npmcli/promise-spawn/lib/index.js:53:27) 275 verbose stack at ChildProcess.emit (node:events:513:28) 275 verbose stack at maybeClose (node:internal/child_process:1134:16) 275 verbose stack at Socket. (node:internal/child_process:492:11) 275 verbose stack at Socket.emit (node:events:513:28) 275 verbose stack at Pipe. (node:net:322:12) 276 verbose pkgid ibm_db@3.2.1 277 verbose cwd /u/ttbr/home/bomms/TestDB 278 verbose OS/390 28.00 279 verbose node v18.14.2 280 verbose npm v9.5.0 281 error code 1 282 error path /u/ttbr/home/bomms/TestDB/node_modules/ibm_db 283 error command failed 284 error command sh -c node installer/driverInstall.js 285 error platform = os390, arch = s390x, node.js version = v18.14.2 285 error Unable to find 'make' in PATH. Installation may fail! 285 error 285 error Error: Command failed: node-gyp configure build --IS_DOWNLOADED=false --IBM_DB_HOME="$IBM_DB_HOME" 285 error gyp info it worked if it ends with ok 285 error gyp info using node-gyp@9.3.1 285 error gyp info using node@18.14.2 | os390 | s390x 285 error gyp info find Python using Python version 3.10.7 found at "/usr/lpp/ported/road4z/bin/python3" 285 error gyp http GET https://nodejs.org/download/release/v18.14.2/node-v18.14.2-headers.tar.gz 285 error gyp WARN install got an error, rolling back install 285 error gyp ERR! configure error 285 error gyp ERR! stack FetchError: request to https://nodejs.org/download/release/v18.14.2/node-v18.14.2-headers.tar.gz failed, reason: unable to verify the first certificate 285 error gyp ERR! stack at ClientRequest. (/CTQ111/usr/lpp/IBM/cnj/v18r0/IBM/node-v18.14.2-os390-s390x-202303231340/lib/node_modules/npm/node_modules/node-gyp/node_modules/minipass-fetch/lib/index.js:130:14) 285 error gyp ERR! stack at ClientRequest.emit (node:events:513:28) 285 error gyp ERR! stack at TLSSocket.socketErrorListener (node:_http_client:502:9) 285 error gyp ERR! stack at TLSSocket.emit (node:events:513:28) 285 error gyp ERR! stack at emitErrorNT (node:internal/streams/destroy:151:8) 285 error gyp ERR! stack at emitErrorCloseNT (node:internal/streams/destroy:116:3) 285 error gyp ERR! stack at process.processTicksAndRejections (node:internal/process/task_queues:82:21) 285 error gyp ERR! System OS/390 28.00 285 error gyp ERR! command "/CTQ111/usr/lpp/IBM/cnj/v18r0/IBM/node-v18.14.2-os390-s390x-202303231340/bin/node" "/CTQ111/usr/lpp/IBM/cnj/v18r0/IBM/node-v18.14.2-os390-s390x-202303231340/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "configure" "build" "--IS_DOWNLOADED=false" "--IBM_DB_HOME=SYSDB2.DQA0" 285 error gyp ERR! cwd /u/ttbr/home/bomms/TestDB/node_modules/ibm_db 285 error gyp ERR! node -v v18.14.2 285 error gyp ERR! node-gyp -v v9.3.1 285 error gyp ERR! not ok 285 error 285 error at ChildProcess.exithandler (node:child_process:419:12) 285 error at ChildProcess.emit (node:events:513:28) 285 error at maybeClose (node:internal/child_process:1134:16) 285 error at Socket. (node:internal/child_process:492:11) 285 error at Socket.emit (node:events:513:28) 285 error at Pipe. (node:net:322:12) { 285 error code: 1, 285 error killed: false, 285 error signal: null, 285 error cmd: 'node-gyp configure build --IS_DOWNLOADED=false --IBM_DB_HOME="$IBM_DB_HOME"' 285 error } 286 error make: Error -- FSUM8705 No target 286 error oput 'SYSDB2.DQA0.SDSNMACS(DSNAO64C)' '/u/ttbr/home/bomms/TestDB/node_modules/ibm_db/build/dsnao64c.x' 287 verbose exit 1 288 timing npm Completed in 17245ms 289 verbose unfinished npm timer reify 1692280429956 290 verbose unfinished npm timer reify:build 1692280438431 291 verbose unfinished npm timer build 1692280438433 292 verbose unfinished npm timer build:deps 1692280438433 293 verbose unfinished npm timer build:run:install 1692280438445 294 verbose unfinished npm timer build:run:install:node_modules/ibm_db 1692280438447 295 verbose code 1 296 error A complete log of this run can be found in: 296 error /u/ttbr/home/bomms/.npm/_logs/2023-08-17T13_53_49_862Z-debug-0.log

For Connection related issue

Are you trying SSL connection or non-SSL connection?
For SSL Connection, please read and follow this documentation
For SSL connection, do you have ssl certificate from server?
If you have certificate, are you using SSLServerCertificate keyword in connection string or using your own keystore db?
Share the connection string used for connection by masking password.
update database connection info in ibm_db/test/config.testConnectionStrings.json file and share complete output of below commands:
- cd .../ibm_db
- npm install
- node test/test-basic-test.js
For non-SSL connection, update connection info for db2cli validate command in file ibm_db/installer/testODBCConnection.bat for windows or ibm_db/installer/testODBCConnection.sh for non-Windows. Then execute testODBCConnection.bat from Administrator command prompt on Windows or testODBCConnection.sh script from terminal on non-Windows and share complete output of script along will all generated 1.* files in zip file.
Complete output of db2cli validate command.

Steps to Reproduce:

npm install ibm_db

bimalkjha commented 10 months ago

@srinivasabommareddy Please configure ODBC driver on z/OS as documented here and then try. Thanks.

bimalkjha commented 10 months ago

285 error gyp ERR! stack FetchError: request to https://nodejs.org/download/release/v18.14.2/node-v18.14.2-headers.tar.gz failed, reason: unable to verify the first certificate

It seems download of node.js header files from internet is throwing error due to missing SSL certificate file. Please try to download https://nodejs.org/download/release/v18.14.2/node-v18.14.2-headers.tar.gz manually on this system. Are you able to download? Thanks.

srinivasabommareddy commented 10 months ago

@srinivasabommareddy Please configure ODBC driver on z/OS as documented here and then try. Thanks.

Hello Bimal, Thank you so much for your quick response. ODBC driver on z/OS was configured. We have been using ODBC driver from Python for a while.

Regards, Reddy

srinivasabommareddy commented 10 months ago

285 error gyp ERR! stack FetchError: request to https://nodejs.org/download/release/v18.14.2/node-v18.14.2-headers.tar.gz failed, reason: unable to verify the first certificate

It seems download of node.js header files from internet is throwing error due to missing SSL certificate file. Please try to download https://nodejs.org/download/release/v18.14.2/node-v18.14.2-headers.tar.gz manually on this system. Are you able to download? Thanks.

Hello Bimal

I can access the link and able to download from the link.

request to https://nodejs.org/download/release/v18.14.2/node-v18.14.2-headers.tar.gz failed, reason: unable to verify the first certificate npm ERR! gyp ERR! stack at ClientRequest. (/CTQ111/usr/lpp/IBM/cnj/v18r0/IBM/node-v18.14.2-os390-s390x-202303231340/lib/node_modules/npm/node_modules/node-gyp/node_modules/minipass-fetch/lib/index.js:130:14)

Not sure but looks like some issue with SSL handshake. Did you come across similar issue in the past?

bimalkjha commented 10 months ago

@srinivasabommareddy Yes it is issue with SSL handshake and similar issues has been reported by users in past on different platforms though very less. After correcting the firewall settings or opening nodejs.org in browser and saving certificate have been resolved the issues. Here are few suggestions:

Run below commands in sequence:

export NODE_TLS_REJECT_UNAUTHORIZED=0
npm install ibm_db
export NODE_TLS_REJECT_UNAUTHORIZED=

You can try to change the registry to the http version in config using below command and then try installation:
```
npm config set registry http://registry.npmjs.org/ --global
npm install ibm_db
```

You can try to disable SSL using below command and then install ibm_db:

npm config set strict-ssl false
npm install ibm_db
npm config set strict-ssl true

It may be problem with this version of node.js, so you may try to install ibm_db after installing another version of node.js. Thanks.

srinivasabommareddy commented 10 months ago

@srinivasabommareddy Yes it is issue with SSL handshake and similar issues has been reported by users in past on different platforms though very less. After correcting the firewall settings or opening nodejs.org in browser and saving certificate have been resolved the issues. Here are few suggestions:

Run below commands in sequence:
export NODE_TLS_REJECT_UNAUTHORIZED=0
npm install ibm_db
export NODE_TLS_REJECT_UNAUTHORIZED=
You can try to change the registry to the http version in config using below command and then try installation:
npm config set registry http://registry.npmjs.org/ --global
npm install ibm_db
You can try to disable SSL using below command and then install ibm_db:
npm config set strict-ssl false
npm install ibm_db
npm config set strict-ssl true
It may be problem with this version of node.js, so you may try to install ibm_db after installing another version of node.js. Thanks.

Tried first three options.

Option 1 - Same error Option 2 - Not able to set the registry..

    $ npm config set registry http://registry.npmjs.org/ --global

npm ERR! code ENOENT npm ERR! syscall mkdir npm ERR! path /CTQ111/usr/lpp/IBM/cnj/v18r0/IBM/node-v18.14.2-os390-s390x-202303 231340/etc npm ERR! errno -129 npm ERR! enoent ENOENT: no such file or directory, mkdir '/CTQ111/usr/lpp/IBM/cn j/v18r0/IBM/node-v18.14.2-os390-s390x-202303231340/etc' npm ERR! enoent This is related to npm not being able to find a file. npm ERR! enoent

npm ERR! A complete log of this run can be found in: npm ERR! /u/ttbr/home/bomms/.npm/_logs/2023-08-21T13_35_02_033Z-debug-0.log

Option 3 - I have been using Option 3 all along.

Tried with Node 12:

$ npm install ibm_db (node:84021024) Warning: Setting the NODE_TLS_REJECT_UNAUTHORIZED environment va riable to '0' makes TLS connections and HTTPS requests insecure by disabling cer tificate verification.

ibm_db@3.2.1 install /u/ttbr/home/bomms/node_modules/ibm_db node installer/driverInstall.js

node: --openssl-legacy-provider is not allowed in NODE_OPTIONS npm WARN bomms@1.0.0 No description npm WARN bomms@1.0.0 No repository field.

npm ERR! code ELIFECYCLE npm ERR! errno 9 npm ERR! ibm_db@3.2.1 install: node installer/driverInstall.js npm ERR! Exit status 9 npm ERR! npm ERR! Failed at the ibm_db@3.2.1 install script. npm ERR! This is probably not a problem with npm. There is likely additional log ging output above.

npm ERR! A complete log of this run can be found in: npm ERR! /u/ttbr/home/bomms/.npm/_logs/2023-08-21T14_58_23_504Z-debug.log $

bimalkjha commented 10 months ago

@srinivasabommareddy I see similar issue being discussed here: https://stackoverflow.com/questions/40000952/unable-to-verify-the-first-certificate-when-running-npm-install Please check the solutions if anyone can work for you. You can try to reach z/OS expert if they can suggest any solution to overcome this SSL error. Try using node.js v16.x or v20.x. Thanks.

bimalkjha commented 8 months ago

Wayne Zhang(https://ibm-analytics.slack.com/archives/C11EQ8CVB/p1698345145515419?thread_ts=1698319024.984109&cid=C11EQ8CVB) It looks like there is a GET request being made to https://nodejs.org/download/release/v18.14.2/node-v18.14.2-headers.tar.gz according to the logs you linked. However, this request shouldn't be necessary when npm_config_nodedir and npm_config_zoslib_include_dir are set correctly. Can you ask them to confirm that they performed all the installation steps as documented in https://www.ibm.com/docs/en/sdk-nodejs-zos/18.0?topic=configuring-installing-pax-format ? If they did not perform the . /.env step then the above environment variables would not be set. They can validate whether the environment variables are set correctly or not by running env | grep npmconfig

Setting the environment variables as suggested above has fixed the SSL connection issue. Thanks.

ibmdb / node-ibm_db