{"action":"created","issue":{"url":"https://api.github.com/repos/oracle/node-oracledb/issues/904","repository_url":"https://api.github.com/repos/oracle/node-oracledb","labels_url":"https://api.github.com/repos/oracle/node-oracledb/issues/904/labels{/name}","comments_url":"https://api.github.com/repos/oracle/node-oracledb/issues/904/comments","events_url":"https://api.github.com/repos/oracle/node-oracledb/issues/904/events","html_url":"https://github.com/oracle/node-oracledb/issues/904","id":319309059,"number":904,"title":"issue running .js file that requires oracledb from crontab","user":{"login":"mrai1234","id":35754764,"avatar_url":"https://avatars1.githubusercontent.com/u/35754764?v=4","gravatar_id":"","url":"https://api.github.com/users/mrai1234","html_url":"https://github.com/mrai1234","followers_url":"https://api.github.com/users/mrai1234/followers","following_url":"https://api.github.com/users/mrai1234/following{/other_user}","gists_url":"https://api.github.com/users/mrai1234/gists{/gist_id}","starred_url":"https://api.github.com/users/mrai1234/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mrai1234/subscriptions","organizations_url":"https://api.github.com/users/mrai1234/orgs","repos_url":"https://api.github.com/users/mrai1234/repos","events_url":"https://api.github.com/users/mrai1234/events{/privacy}","received_events_url":"https://api.github.com/users/mrai1234/received_events","type":"User","site_admin":false},"labels":[{"id":161714391,"url":"https://api.github.com/repos/oracle/node-oracledb/labels/question","name":"question","color":"cc317c","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-05-01T20:03:13Z","updated_at":"2018-05-01T20:47:45Z","closed_at":null,"author_association":"NONE","body":"Node's Version: v8.11.1\r\nOS:  Oracle Linux 7.5\r\n\r\nI am getting the following error when I try to run a .js file from user's crontab:\r\n/home/mrai/node/node_modules/oracledb/lib/oracledb.js:68\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 8.11.1 (linux, x64)\r\nCannot load /home/mrai/node/node_modules/oracledb/build/Release/oracledb.node\r\nError while trying to retrieve text for error ORA-01804\r\n\r\nNode-oracledb installation instructions: https://oracle.github.io/node-oracledb/INSTALL.html\r\nYou must have 64-bit Oracle client libraries in LD_LIBRARY_PATH, or configured with ldconfig.\r\nIf you do not have Oracle Database on this computer, then install the Instant Client Basic or Basic Light package from \r\nhttp://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html\r\n\r\n    at Object.<anonymous> (/home/mrai/node/node_modules/oracledb/lib/oracledb.js:68:13)\r\n    at Module._compile (module.js:652:30)\r\n    at Object.Module._extensions..js (module.js:663:10)\r\n    at Module.load (module.js:565:32)\r\n    at tryModuleLoad (module.js:505:12)\r\n    at Function.Module._load (module.js:497:3)\r\n    at Module.require (module.js:596:17)\r\n    at require (internal/module.js:11:18)\r\n    at Object.<anonymous> (/home/mrai/node/node_modules/oracledb/index.js:1:80)\r\n    at Module._compile (module.js:652:30)\r\n\r\ncrontab -l has:\r\n0 * * * * /usr/bin/sh /home/mrai/rss.sh\r\n\r\nrss.sh has:\r\n#!/bin/bash\r\ncd /home/mrai/node\r\nnode rss.js &> /home/mrai/rss.log\r\n\r\nOn terminal, following works OK without any issues:\r\ncd /home/mrai/node\r\nnode rss.js &> /home/mrai/rss.log\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/oracle/node-oracledb/issues/comments/385785275","html_url":"https://github.com/oracle/node-oracledb/issues/904#issuecomment-385785275","issue_url":"https://api.github.com/repos/oracle/node-oracledb/issues/904","id":385785275,"user":{"login":"mrai1234","id":35754764,"avatar_url":"https://avatars1.githubusercontent.com/u/35754764?v=4","gravatar_id":"","url":"https://api.github.com/users/mrai1234","html_url":"https://github.com/mrai1234","followers_url":"https://api.github.com/users/mrai1234/followers","following_url":"https://api.github.com/users/mrai1234/following{/other_user}","gists_url":"https://api.github.com/users/mrai1234/gists{/gist_id}","starred_url":"https://api.github.com/users/mrai1234/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mrai1234/subscriptions","organizations_url":"https://api.github.com/users/mrai1234/orgs","repos_url":"https://api.github.com/users/mrai1234/repos","events_url":"https://api.github.com/users/mrai1234/events{/privacy}","received_events_url":"https://api.github.com/users/mrai1234/received_events","type":"User","site_admin":false},"created_at":"2018-05-01T20:47:45Z","updated_at":"2018-05-01T20:47:45Z","author_association":"NONE","body":"I have already configured ldconfig (and also tried adding LD_LIBRARY_PATH in crontab).\r\nBut, still getting this error.\r\n\r\n$ ldconfig -v\r\n....\r\n/u01/app/oracle/product/11.2.0/xe/lib:\r\n\tlibxdb.so -> libxdb.so\r\n\tlibuini11.so -> libuini11.so\r\n\tlibsqora.so.11.1 -> libsqora.so.11.1\r\n\tlibsqlplus.so -> libsqlplus.so\r\n\tlibskgxp11.so -> libskgxp11.so\r\n\tlibskgxns.so -> libskgxns.so\r\n\tlibskgxn2.so -> libskgxn2.so\r\n\tlibqsmashr.so -> libqsmashr.so\r\n\tlibons.so -> libons.so\r\n\tlibodmd11.so -> libodmd11.so\r\n\tlibodm11.so -> libodm11.so\r\n\tlibocrutl11.so -> libocrutl11.so\r\n\tlibocrb11.so -> libocrb11.so\r\n\tlibocr11.so -> libocr11.so\r\n\tlibocijdbc11.so -> libocijdbc11.so\r\n\tlibocci.so.11.1 -> libocci.so.11.1\r\n\tlibntcpaio11.so -> libntcpaio11.so\r\n\tlibnque11.so -> libnque11.so\r\n\tlibnnz11.so -> libnnz11.so\r\n\tlibnjni11.so -> libnjni11.so\r\n\tlibldapjclnt11.so -> libldapjclnt11.so\r\n\tlibhgotrace11.so -> libhgotrace11.so\r\n\tlibheteroxa11.so -> libheteroxa11.so\r\n\tlibhasgen11.so -> libhasgen11.so\r\n\tlibemmas11.so -> libemmas11.so\r\n\tlibdbcfg11.so -> libdbcfg11.so\r\n\tlibcorejava.so -> libcorejava.so\r\n\tlibclsra11.so -> libclsra11.so\r\n\tlibclntsh.so.11.1 -> libclntsh.so.11.1\r\n\tlibcell11.so -> libcell11.so\r\n\tlibagtsh.so -> libagtsh.so.1.0\r\n......\r\n\r\n"}}
{"actor":{"display_login":"mrai1234"}}