Can't connect from osx 10.11.3 neither Ubuntu 14.04.3 LTS to bluemix dashdb service

Valerio Riva

unread,

Feb 5, 2016, 7:36:19 AM2/5/16

to node-ibm_db

Hi everybody!

I'm aware that ibm_db was compatible only with specific version of node prior the 0.0.18 version but i still can't figure out how to use this library.

I tried the ibm_db 0.0.15/0.0.18 on node 0.2.7/0.2.9 on osx 10.11.3 and I obtain this error message when i try to connect to the database:

{ [Error: [IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004
]
errors: [],
error: '[node-odbc] SQL_ERROR',
message: '[IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004\n',
state: 'HY000' }

And i tried to run my project inside a virtual machine running ubuntu 14.04.3 LTS with node 0.2.7/0.2.9 and I can't install the ibm_db 0.0.15/0.0.18 module at all!

vagrant@vagrant-ubuntu-trusty-64:/repos/****/******$ npm install ibm_db
npm WARN package.json *****@0.0.1 No description
/
> ibm...@0.0.18 install /repos/****/****/node_modules/ibm_db
> node installer/driverInstall.js

Downloading DB2 ODBC CLI Driver from http://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/linuxx64_odbc_cli.tar.gz...
Download and extraction of DB2 ODBC CLI Driver completed successfully ...
child_process.js:1163
    throw errnoException(err, 'spawn');
          ^
Error: spawn ENOMEM
    at exports._errnoException (util.js:746:11)
    at ChildProcess.spawn (child_process.js:1163:11)
    at exports.spawn (child_process.js:996:9)
    at Object.exports.execFile (child_process.js:689:15)
    at exports.exec (child_process.js:649:18)
    at buildBinary (/repos/****/****/node_modules/ibm_db/installer/driverInstall.js:260:28)
    at /repos/****/****/node_modules/ibm_db/installer/driverInstall.js:241:21
    at Extract.<anonymous> (/repos/****/****/node_modules/ibm_db/node_modules/tar.gz/lib/targz.js:71:18)
    at Extract.emit (events.js:129:20)
    at DirWriter.<anonymous> (/repos/****/****/node_modules/ibm_db/node_modules/tar.gz/node_modules/tar/lib/extract.js:66:8)
npm ERR! Linux 3.13.0-77-generic
npm ERR! argv "/home/vagrant/.nvm/versions/node/v0.12.9/bin/node" "/home/vagrant/.nvm/versions/node/v0.12.9/bin/npm" "install" "ibm_db"
npm ERR! node v0.12.9
npm ERR! npm v2.14.9
npm ERR! code ELIFECYCLE

npm ERR! ibm...@0.0.18 install: `node installer/driverInstall.js`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the ibm...@0.0.18 install script 'node installer/driverInstall.js'.
npm ERR! This is most likely a problem with the ibm_db package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR!     node installer/driverInstall.js
npm ERR! You can get their info via:
npm ERR!     npm owner ls ibm_db
npm ERR! There is likely additional logging output above.

npm ERR! Please include the following file with any support request:
npm ERR!     /repos/****/****/npm-debug.log

Can anyone figure out why the ibm_db module doesn't install on ubuntu or connect on osx?

shilu

unread,

Feb 5, 2016, 9:07:17 AM2/5/16

to node-ibm_db

https://github.com/ibmdb/node-ibm_db

For MacOS Connectivity Issue

After npm install ibm_db run below command to avoid SQL1042C error: export DYLD_LIBRARY_PATH=<node_modules_dir>/ibm_db/installer/clidriver/lib/icc:$DYLD_LIBRARYPATH

bimaljha

unread,

Feb 5, 2016, 9:09:45 AM2/5/16

to node-ibm_db

For Ubuntu issue, try ibm...@0.0.19 which is the latest version. Thanks.

On Friday, February 5, 2016 at 6:06:19 PM UTC+5:30, Valerio Riva wrote:

Valerio Riva

unread,

Feb 8, 2016, 9:04:29 AM2/8/16

to node-ibm_db

It seems that today it works on osx with 0.0.15 and 0.0.19 also without exporting DYLD_LIBRARY_PATH! I noticed a change made on osx driver listed here http://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/ -> 07 February 2016 09:10.

Still no luck with ubuntu and 0.0.19, but I can finally work without vagrant/docker so i don't care!! :)

Thank you.

Reply all

Reply to author

Forward