Node-oracledb: NJS-054: Binary build/Release/oracledb.node was not installed.

[edward12186]

1. What is your Node.js version? Is it 64-bit or 32-bit? Run version.js from https://github.com/oracle/node-oracledb/blob/master/examples/version.js
   Node.js v10.13.0 (64-bit )

2. What is your node-oracledb version?
   I'm not specifying a version when running the npm install command. I am running:
   npm i oracledb --save

3. What exact command caused the problem (e.g. what command did you try to install with)? Who were you logged in as?
   The command that fails is the installation command:
   npm install oracledb --save

I am logged in using an AD account. I've tried the installation both as my regular user and by elevating to an account with Administrator access on the machine.

1. What error(s) you are seeing?
   NJS-054: Binary build/Release/oracledb.node was not installed.

2. What OS (and version) is Node.js executing on?
   Windows 10 Enterprise

3. What is your Oracle client (e.g. Instant Client) version? Is it 64-bit or 32-bit? How was it installed? Where is it installed?

There are two versions of the Oracle client installed on my machine. I see two install paths C:\Oracle\ and C:\Oracle11g\ I believe these correspond to the Oracle 12 and 11g clients. I'm not sure what features were installed, whether they include the instant client or not.

1. What is your Oracle Database version?
   Oracle 12c

2. What is the PATH environment variable (on Windows) or LD_LIBRARY_PATH (on Linux) set to? On macOS, what is in ~/lib?

C:\ProgramData\Boxstarter;C:\Oracle\ora11g\Software\bin;C:\Oracle;C:\Program Files\Java\jre1.8.0_74\bin;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\PuTTY\;C:\Program Files (x86)\Attachmate\Reflection\;C:\Program Files (x86)\Brackets\command;C:\Program Files (x86)\Microsoft VS Code\bin;C:\Program Files\Git\cmd;C:\Program Files\nodejs\;C:\ProgramData\chocolatey\bin;C:\Python27;C:\Users\eddie\AppData\Local\atom\bin;

1. What Oracle environment variables did you set? How exactly did you set them?
   I haven't set any Oracle environment variables.

2. Do you have a small, single Node.js script that immediately runs to show us the problem?
   No, I'm just running the install command on my command prompt on my Windows 10 machine.

[cjbj]

Can you give all the install messages that lead to the NJS-054?

[edward12186]

This is the entire text of the error messages I get.

node package/oracledbinstall.js

oracledb Beginning installation
oracledb Verifying installation
oracledb Continuing installation
oracledb ERR! NJS-054: Binary build/Release/oracledb.node was not installed.
oracledb ERR! Failed to install binary package oracledb-v3.0.0-node-abi64-win32-x64.gz
oracledb ERR! Error: HTTPS request for https://github-production-release-asset-2e65be.s3.amazonaws.com/28612154/c156b500-c618-11e8-8660-cd375b6f8b90?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20181107%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20181107T212332Z&X-Amz-Expires=300&X-Amz-Signature=28edb732b91ab652cbcac5ca60163fa4cb991c9fcb85e656ba8e35fbb95cc60b&X-Amz-SignedHeaders=host&actor_id=0&response-content-disposition=attachment%3B%20filename%3Doracledb-v3.0.0-node-abi64-win32-x64.gz&response-content-type=application%2Foctet-stream failed with code 403
oracledb ERR! For help see https://oracle.github.io/node-oracledb/INSTALL.html#troubleshooting

npm WARN [email protected] No repository field.

npm ERR! code ELIFECYCLE
npm ERR! errno 87
npm ERR! [email protected] install: node package/oracledbinstall.js
npm ERR! Exit status 87
npm ERR!
npm ERR! Failed at the [email protected] install script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

[shamseertk]

I am also getting similar error. I set the corp proxy and export NODE_TLS_REJECT_UNAUTHORIZED=0 strict-ssl false etc. Any help would be really appreciated.

[edward12186]

Yeah, I'm not sure why it's happening. I tried the npm install with different versions. I also made sure the Oracle client was installed properly and that the system PATH environment variable was set. Any ideas on what could be causing this issue.

[cjbj]

Does your proxy need authentication? How are you setting your proxy? Have you googled 'npm 403'? Maybe try one of the other install methods https://oracle.github.io/node-oracledb/INSTALL.html

[edward12186]

I set my proxy using the npm config set command. The following shows the contents of my .npmrc file:

strict-ssl=false
proxy=http://username:[email protected]:8000/
https-proxy=https://username:[email protected]:8000/
registry=https://registry.npmjs.org/

Even after having setup my configuration like this I still get the same error. The HTTP 403 method specifies that the resource is forbidden: https://www.restapitutorial.com/httpstatuscodes.html

I know I can download and install other modules via npm using my current proxy configuration. If it is a proxy issue then I don't know what it is I need to change for the install to complete successfully. Does the install depend on the exact version of the Oracle client being correct or any other environment settings?

[dmcghan]

@edward12186 Try setting the environment variable NODE_ORACLEDB_TRACE_INSTALL to true and have a look at the output for clues.

export NODE_ORACLEDB_TRACE_INSTALL=TRUE
npm install oracledb

[edward12186]

Okay, I figured out the issue. I did some research on npm 403 as @cjbj suggested and found that setting the proxy, https-proxy and registry npm config variables fixed the issue. After running the npm config set commands my .npmrc file looked like this:

strict-ssl=false
proxy=http://username:[email protected]:8000/
https-proxy=http://username:[email protected]:8000/
registry=https://registry.npmjs.org/

One caveat though, this worked when I tried it on my laptop (running Node v10.13.0). When I tried it on my test server it still fails. I'm running Node.js v8.11.2 on the server. I am getting a different error on the server though so I'm just gonna go ahead and close this issue. Thanks to @cjbj and everyone else on this thread for their suggestions and comments. I'm going to try fixing the installation issue on my test server and if unsuccessful I'll open a new issue. I'm gonna to set the NODE_ORACLEDB_TRACE_INSTALL environment variable as @dmcghan suggested.

[cjbj]

If you let us know the current error, we can try to help.

For the record, I can't recommend setting strict-ssl=false outside a sandboxed environment.