ibmdb / node-ibm_db

IBM DB2 and IBM Informix bindings for node
MIT License
192 stars 150 forks source link

Getting SQL1598N when installing ibm_db #438

Closed RabeaWahab closed 6 years ago

RabeaWahab commented 6 years ago

Current version running/built on production is 2.0.0, I was trying to install the npm module and build the cli-driver as usual on a dev environemnt, I have an automated process that copies the licenses inside of it, and I am sure it is in the right place. Currently I am getting the error SQL1598N. No change on licenses, and I am using the ones I am currently running on production.

[IBM][CLI Driver] SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968

Any help is appreciated.

Note: The only thing I noticed changing is a new CLI driver was uploaded 10 days ago.

Also when I take the already built module to the dev server and add the licenses to it, it works with no issues. Also installed it on Mac with no issues.

Node Version: 8.10 NPM: 5.6.0 Ubuntu: 16.04

> ibm_db@2.0.0 install /data/node_modules/ibm_db
> node installer/driverInstall.js

Downloading DB2 ODBC CLI Driver from https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/linuxx64_odbc_cli.tar.gz...

100.00% | 21040638 bytes downloaded out of 21040638 bytes.

****************************************
You are downloading a package which includes the Node.js module for IBM DB2/Informix.  The module is licensed under the Apache License 2.0. The package also includes IBM ODBC and CLI Driver from IBM, which is automatically downloaded as the node module is installed on your system/device. The license agreement to the IBM ODBC and CLI Driver is available in /data/node_modules/ibm_db/installer   Check for additional dependencies, which may come with their own license agreement(s). Your use of the components of the package and dependencies constitutes your acceptance of their respective license agreements. If you do not accept the terms of any license agreement(s), then delete the relevant component(s) from your device.
****************************************

Downloading and extraction of DB2 ODBC CLI Driver completed successfully ...
make: Entering directory '/data/node_modules/ibm_db/build'
  CXX(target) Release/obj.target/odbc_bindings/src/odbc.o
  CXX(target) Release/obj.target/odbc_bindings/src/odbc_connection.o
  CXX(target) Release/obj.target/odbc_bindings/src/odbc_statement.o
  CXX(target) Release/obj.target/odbc_bindings/src/odbc_result.o
  SOLINK_MODULE(target) Release/obj.target/odbc_bindings.node
  COPY Release/odbc_bindings.node
make: Leaving directory '/data/node_modules/ibm_db/build'
bimalkjha commented 6 years ago

@RabeaWahab Since CLI driver is updated from DB2 V10.5 to DB2 V11.1, you need a DB2 V11.1 db2 connect license file now. Existing license file will not work. Thanks.

RabeaWahab commented 6 years ago

thanks @bimaljha , yes the solution was to reissue the license again, thank again for your response.