Comments (13)
Hey Ferno,
Did you download the pre built binary from the intermediate_fixes branch ? If not please download the latest binary from the same branch which you can find inside the build.zip file. We have fixed this issue already in the latest binary.
from node-ibm_db.
Are you referring to this file: https://github.com/ibmdb/node-ibm_db/blob/intermediate_fixes/build.zip ? If so, what am I supposed to do with it? This is not a Node.js package, so unzipping it to my node_modules directory doesn't work, unlike https://www.ibm.com/developerworks/community/blogs/pd/resource/ibm_db_x64.zip which I was using before.
from node-ibm_db.
Yes, I am referring to the same file (https://github.com/ibmdb/node-ibm_db/blob/intermediate_fixes/build.zip). You can download the entire intermediate_fixes branch and then extract the build.zip into the same folder as the zip file. Replace the ibm_db under your node_modules with the whole intermediate_fixes branch you have downloaded.
from node-ibm_db.
Ah, I am progressing further now. Thank you. Now I see this error on connection:
[IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "SSL". Communication API being used: "SOCKETS". Location where the error was detected: "SOCKETS". Communication function detecting the error: "sqlcctcpconnr". Protocol specific error code(s): "202", "", "". SQLSTATE=08001
My connection string (sanitised) is:
DRIVER={IBM DB2 ODBC DRIVER};DATABASE=BLUDB;HOSTNAME=********;PORT=********;PROTOCOL=TCPIP;UID=********;PWD=********;Security=ssl;SSLClientKeystoredb=dashdb.kdb;SSLClientKeystash=dashdb.sth
This is a strange error to get because SQLSTATE 08001 indicates a communications error and the code 202 indicates an error inside GSKit:
202 - GSK_KEYRING_OPEN_ERROR Unable to open the key file or the Microsoft Certificate Store. Either the path was specified incorrectly or the file permissions did not allow the file to be opened, or the file format is incorrect.
but I am not using a key file, I am using a key database. Does ibm_db
support this form of connection or should I use a key file instead?
from node-ibm_db.
It should work ( i assume you have installed the DB2 Runtime client or installed GSKIT... DS Driver does not ship with the GSKit as of today).
SSLClientKeystoredb=dashdb.kdb;SSLClientKeystash=dashdb.sth
<<
Should those filenames include the fullpath/relative path from current directory in which the process is running ?
I can try to repro locally if the above doesnt solve
from node-ibm_db.
Those filenames do include the relative path. In this example, the key database and stash file are both in the same directory as the Node.js application.
from node-ibm_db.
Hey,
When I tried to repro your issue using DB2 CLI 10.5 FP4 and gskit version 8.0.14.43, it worked for me. Can you tell me which version of DB2 are you working on ?
from node-ibm_db.
I have found that when I use a slightly modified connection string,
DRIVER={IBM DB2 ODBC DRIVER};DATABASE=BLUDB;HOSTNAME=********;PORT=********;PROTOCOL=TCPIP;UID=********;PWD=********;Security=ssl;SSL_Client_Keystoredb=dashdb.kdb;SSL_Client_Keystash=dashdb.sth
, I am able to connect with no problems. Notice how I replaced SSLClientKeystoredb
with SSL_Client_Keystoredb
and SSLClientKeystash
with SSL_Client_Keystash
. It looks like the connection string I was given had missing underscores. (Perhaps some Markdown implementation stripped them out and made the word "Client" italicised instead?)
from node-ibm_db.
The target DB2 server is v10.5.0, fix pack 4.
from node-ibm_db.
From the documentation it seems that these two keywords both changed at some point in the past.
from node-ibm_db.
good to know u are unblocked. What about the DB2 client version (also which client are u using for e.g. Data Server Driver package, runtime client etc), since it is the client that is processing those 'SSLClientKeyxxx' arguments
from node-ibm_db.
According to the Readme file in my "IBM DATA SERVER DRIVER" directory, V9.7.6.
from node-ibm_db.
ok. Any particular reason you are using a v9.7.6 client with a v10.5.4 server? Would suggest using the latest client too and treat this closed
Will pass on to CLI team that without '_' in the keyword, doesnt work in 9.7.6, though doc claim it should, starting that version :-)
from node-ibm_db.
Related Issues (20)
- Error Odbc_binding.node while trying to start node app.js HOT 4
- ibm_db crashes node with OUTPUT parameter of type BINARY and Data of type Buffer HOT 1
- ibm_db crashes node with OUTPUT parameter of type BINARY and Data of type non-Buffer
- Nextjs issue with indexOf HOT 2
- unable to install [email protected] on windows with node v18.16.1 HOT 9
- ibm_db installation fails with error - /bin/sh: node-gyp: command not found HOT 9
- unable to install ibm_db on windows 11 HOT 1
- Error: getaddrinfo ENOTFOUND public.dhe.ibm.com HOT 6
- Error: getaddrinfo ENOTFOUND public.dhe.ibm.com HOT 3
- Outparams is null when using connection pool and previously DB error in the connection HOT 5
- How to set timeout when using connection pool? HOT 2
- SP call failing with error HOT 2
- Not able to run or connect ibm db2 from AWS lambda
- Not able to run or connect ibm db2 from AWS lambda HOT 8
- [TypeScript] Type issue with ODBCStatement? HOT 11
- Incorrect results with XML containing Chinese data on Linux. Same code works on Windows. HOT 12
- await ODBCStatement.executeNonQuery does not work as the callback version does HOT 4
- ibm_db install on z/OS is failing HOT 22
- New Feature/Enhancement Request: Stream data into a blob instead of having entire buffer in memory HOT 1
- New Feature/Enhancement Request: Binary release (and make it small) HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from node-ibm_db.