IBM / nodejs-idb-connector

A JavaScript (Node.js) library for communicating with Db2 for IBM i, with support for queries, procedures, and much more. Uses traditional callback-style syntax
MIT License
37 stars 23 forks source link

dbconn.conn() Fails when Credentials Are Passed (ABI v48 Node 6) #53

Closed abmusse closed 5 years ago

abmusse commented 5 years ago

Original report by David Russo (Bitbucket: DavidRusso, GitHub: DavidRusso).


Using idb-connector 1.1.6 with Node 6, the following code fails:

#!javascript

const db2i = require("idb-connector");
const dbconn = new db2i.dbconn();
dbconn.conn("*LOCAL", "myusrprf", "mypass");

It throws with authorization failure, even with correct credentials. This problem seems similar to one that I reported before for Node 8:

https://bitbucket.org/litmis/nodejs-idb-connector/issues/41/dbconnconn-fails-when-4-arguments-are

It seems that the problem was fixed for Node 8 and Node 10 builds, but not for Node 6.

abmusse commented 5 years ago

Original comment by David Russo (Bitbucket: DavidRusso, GitHub: DavidRusso).


v1.1.7 resolves the problem.

abmusse commented 5 years ago

Original comment by David Russo (Bitbucket: DavidRusso, GitHub: DavidRusso).


Problem solved, thanks!

abmusse commented 5 years ago

Original comment by Xu Meng (Bitbucket: mengxumx, GitHub: dmabupt).


This issue is introduced by the N-API versions (1.1.0+). The NAPI string seems to be incompatibility with DB2 CLI.

I have upgraded idb-connector to v1.1.7 to fix the issue.

For more details please refer to commit --> https://bitbucket.org/litmis/nodejs-idb-connector/commits/c20f37c#Lsrc/db2ia/dbconn.ccT229