{"action":"created","issue":{"url":"https://api.github.com/repos/oracle/node-oracledb/issues/937","repository_url":"https://api.github.com/repos/oracle/node-oracledb","labels_url":"https://api.github.com/repos/oracle/node-oracledb/issues/937/labels{/name}","comments_url":"https://api.github.com/repos/oracle/node-oracledb/issues/937/comments","events_url":"https://api.github.com/repos/oracle/node-oracledb/issues/937/events","html_url":"https://github.com/oracle/node-oracledb/issues/937","id":337304806,"node_id":"MDU6SXNzdWUzMzczMDQ4MDY=","number":937,"title":"Getting Error: NJS-045 on installation","user":{"login":"GiantSlayer1913","id":33406109,"node_id":"MDQ6VXNlcjMzNDA2MTA5","avatar_url":"https://avatars1.githubusercontent.com/u/33406109?v=4","gravatar_id":"","url":"https://api.github.com/users/GiantSlayer1913","html_url":"https://github.com/GiantSlayer1913","followers_url":"https://api.github.com/users/GiantSlayer1913/followers","following_url":"https://api.github.com/users/GiantSlayer1913/following{/other_user}","gists_url":"https://api.github.com/users/GiantSlayer1913/gists{/gist_id}","starred_url":"https://api.github.com/users/GiantSlayer1913/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GiantSlayer1913/subscriptions","organizations_url":"https://api.github.com/users/GiantSlayer1913/orgs","repos_url":"https://api.github.com/users/GiantSlayer1913/repos","events_url":"https://api.github.com/users/GiantSlayer1913/events{/privacy}","received_events_url":"https://api.github.com/users/GiantSlayer1913/received_events","type":"User","site_admin":false},"labels":[{"id":253930243,"node_id":"MDU6TGFiZWwyNTM5MzAyNDM=","url":"https://api.github.com/repos/oracle/node-oracledb/labels/install%20&%20configuration","name":"install & configuration","color":"fad8c7","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2018-07-01T16:49:39Z","updated_at":"2018-07-02T23:52:02Z","closed_at":null,"author_association":"NONE","body":"### For general questions:\r\n\r\nI am confused by this error and really new at setting up this kind of database, so all help is appreciated. \r\nI have been following the installation setup steps from  ```3.5 Node-oracledb Installation on macOS``` https://oracle.github.io/node-oracledb/INSTALL.html#instosx .\r\n\r\n\r\n\r\n\r\n----------------------------\r\n### For security issues:\r\n\r\nSee https://www.oracle.com/support/assurance/vulnerability-remediation/reporting-security-vulnerabilities.html for how to report security issues.\r\n\r\n### For installation issues:\r\n\r\n- Review the install instructions https://github.com/oracle/node-oracledb/blob/master/INSTALL.md\r\n\r\n- Review the troubleshooting tips https://github.com/oracle/node-oracledb/blob/master/INSTALL.md#troubleshooting\r\n\r\n#### Answer the following questions:\r\n\r\n1. 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\r\n```64-bit```\r\n2. Whatis your node-oracledb version?\r\npackage.json/\r\n```json\r\n\"version\": \"3.0.0-dev\",\r\n```\r\n3. 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?\r\n\r\n```64-bit, installed by unzipping package file within project directory: test-oracle/```\r\n\r\n4. What is your Oracle Database version?\r\npackage-lock.json\r\n```json\r\n{\r\n  \"name\": \"test-oracle\",\r\n  \"version\": \"3.0.0-dev\",\r\n  \"lockfileVersion\": 1,\r\n  \"requires\": true,\r\n  \"dependencies\": {\r\n    \"oracledb\": {\r\n      \"version\": \"github:oracle/node-oracledb#fcd78384727be545d08a96c0d5242902288dafd7\",\r\n      \"from\": \"github:oracle/node-oracledb#v2.3.0\",\r\n      \"requires\": {\r\n        \"nan\": \"~2.10.0\"\r\n      },\r\n      \"dependencies\": {\r\n        \"nan\": {\r\n          \"version\": \"2.10.0\",\r\n          \"resolved\": \"https://registry.npmjs.org/nan/-/nan-2.10.0.tgz\",\r\n          \"integrity\": \"sha512-bAdJv7fBLhWC+/Bls0Oza+mvTaNQtP+1RyhhhvD95pgUJz6XM5IzgmxOkItJ9tkoCiplvAnXI1tNmmUD/eScyA==\"\r\n        }\r\n      }\r\n    }\r\n  }\r\n}\r\n```\r\n5. What is your OS and version?\r\n```macOS High Sierra 10.13.5```\r\n\r\n6. What is your compiler version?  For example, with GCC, run `gcc --version`\r\n```$ gcc --version\r\nConfigured with: --prefix=/Library/Developer/CommandLineTools/usr --with-gxx-include-dir=/usr/include/c++/4.2.1\r\nApple LLVM version 9.1.0 (clang-902.0.39.2)\r\nTarget: x86_64-apple-darwin17.6.0\r\nThread model: posix\r\nInstalledDir: /Library/Developer/CommandLineTools/usr/bin\r\n```\r\n\r\n\r\n7. What Oracle environment variables did you set?  How *exactly* did you set them?\r\n\r\n**(not sure how to answer this question)**\r\n\r\n8. What is the `PATH` environment variable (on Windows) or `LD_LIBRARY_PATH` (on Linux) set to?  On macOS, what is in `~/lib`?\r\n\r\n```/Users/michaelfisch/personal-projects/test-oracle```\r\n\r\n9. What *exact* command caused the problem (e.g. what command did you try to install with)?  Who were you logged in as?\r\n\r\n10. What error(s) you are seeing?\r\n```\r\n~/personal-projects/test-oracle/examples (master)\r\n$ node select1.js \r\n/Users/michaelfisch/personal-projects/test-oracle/node_modules/oracledb/lib/oracledb.js:65\r\n      throw new Error(nodbUtil.getErrorMessage('NJS-045', nodeInfo));\r\n      ^\r\n\r\nError: NJS-045: cannot load the oracledb add-on binary for Node.js 10.5.0 (darwin, x64)\r\nNode.js require() error was: \r\n  DPI-1047: 64-bit Oracle Client library cannot be loaded: \"dlopen(libclntsh.dylib, 1): image not found\". See https://oracle.github.io/odpi/doc/installation.html#macos for help\r\nNode.js require() mapped to /Users/michaelfisch/personal-projects/test-oracle/node_modules/oracledb/build/Release/oracledb.node\r\nNode-oracledb installation instructions: https://oracle.github.io/node-oracledb/INSTALL.html\r\nYou must have the 64-bit Oracle Instant Client Basic or Basic Light package in ~/lib or /usr/local/lib\r\nThey can be downloaded from http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html\r\n    at Object.<anonymous> (/Users/michaelfisch/personal-projects/test-oracle/node_modules/oracledb/lib/oracledb.js:65:13)\r\n    at Module._compile (internal/modules/cjs/loader.js:702:30)\r\n    at Object.Module._extensions..js (internal/modules/cjs/loader.js:713:10)\r\n    at Module.load (internal/modules/cjs/loader.js:612:32)\r\n    at tryModuleLoad (internal/modules/cjs/loader.js:551:12)\r\n    at Function.Module._load (internal/modules/cjs/loader.js:543:3)\r\n    at Module.require (internal/modules/cjs/loader.js:650:17)\r\n    at require (internal/modules/cjs/helpers.js:20:18)\r\n    at Object.<anonymous> (/Users/michaelfisch/personal-projects/test-oracle/node_modules/oracledb/index.js:1:80)\r\n    at Module._compile (internal/modules/cjs/loader.js:702:30)\r\n```"},"comment":{"url":"https://api.github.com/repos/oracle/node-oracledb/issues/comments/401971182","html_url":"https://github.com/oracle/node-oracledb/issues/937#issuecomment-401971182","issue_url":"https://api.github.com/repos/oracle/node-oracledb/issues/937","id":401971182,"node_id":"MDEyOklzc3VlQ29tbWVudDQwMTk3MTE4Mg==","user":{"login":"cjbj","id":200778,"node_id":"MDQ6VXNlcjIwMDc3OA==","avatar_url":"https://avatars1.githubusercontent.com/u/200778?v=4","gravatar_id":"","url":"https://api.github.com/users/cjbj","html_url":"https://github.com/cjbj","followers_url":"https://api.github.com/users/cjbj/followers","following_url":"https://api.github.com/users/cjbj/following{/other_user}","gists_url":"https://api.github.com/users/cjbj/gists{/gist_id}","starred_url":"https://api.github.com/users/cjbj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cjbj/subscriptions","organizations_url":"https://api.github.com/users/cjbj/orgs","repos_url":"https://api.github.com/users/cjbj/repos","events_url":"https://api.github.com/users/cjbj/events{/privacy}","received_events_url":"https://api.github.com/users/cjbj/received_events","type":"User","site_admin":false},"created_at":"2018-07-02T23:52:02Z","updated_at":"2018-07-02T23:52:02Z","author_association":"MEMBER","body":"@GiantSlayer1913 that is progress.  Now you just need to find the correct connect string for your DB.  Do you know where your DB is?  Do you connect to it using other tools like SQL*Plus or SQL Developer? The 'localhost/XE' connect string will work if you have installed the Oracle XE edition DB on the same computer as Node.js.  "}}
{"actor":{"display_login":"cjbj"}}