Client SDK / GSKit on ubuntu

Discussion:

(too old to reply)

Mike Aubury

2013-07-17 09:38:01 UTC

Trying to get a remote connection from .Net into an Informix database
- but getting an errors...

Using the DB2Connection - I get :

IBM Global Security Kit (GSKit) version 7.0.4.27 or higher,
which provides APIs for Secure Sockets Layer (SSL) communication
and for encryption, is not installed.

I tried installing it - but the installgsk script just stops abruptly...
I tried installing the rpms manually, converting to .debs etc - and
installing - and I've now got entries in /usr/local/ibm/gsk8_64/lib64/
But - its still complaining..

Using the old fashioned Informix connection I get :

Error: (-30081): [IBM] SQL30081N A communication error has been
detected. Communication protocol being used: "TCP/IP". Communication
API being used: "SOCKETS". Location where the error was detected:
"192.168.3.184". Communication function detecting the error: "recv".
Protocol specific error code(s): "*", "*", "0". SQLSTATE=08001

with a -408 logged in the online.log file..

Any ideas ?

Alexandre Marini

2013-07-17 11:17:37 UTC

Permalink

Hello, Mike.
If you want to use the recommended way, you must install Data Server Driver, and connect to Informix via drsoctcp protocol, instead of onsoctcp. That should enable you to use the new provider methods, and also integrate you to Linq features, and so on...

http://pic.dhe.ibm.com/infocenter/informix/v121/topic/com.ibm.admin.doc/ids_admin_0206.htm?resultof=%22%2e%6e%65%74%22%20%22%6e%65%74%22%20%22%73%73%6c%22%20

If you are really using ssl connections, you might also check for drsocssl protocol, instead.

Hope it helps.
Regards.

Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10

IBM Information Management Informix Technical Professional

IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant

Date: Wed, 17 Jul 2013 10:38:01 +0100
Subject: Client SDK / GSKit on ubuntu
Trying to get a remote connection from .Net into an Informix database
- but getting an errors...
IBM Global Security Kit (GSKit) version 7.0.4.27 or higher,
which provides APIs for Secure Sockets Layer (SSL) communication
and for encryption, is not installed.
I tried installing it - but the installgsk script just stops abruptly...
I tried installing the rpms manually, converting to .debs etc - and
installing - and I've now got entries in /usr/local/ibm/gsk8_64/lib64/
But - its still complaining..
Error: (-30081): [IBM] SQL30081N A communication error has been
detected. Communication protocol being used: "TCP/IP". Communication
"192.168.3.184". Communication function detecting the error: "recv".
Protocol specific error code(s): "*", "*", "0". SQLSTATE=08001
with a -408 logged in the online.log file..
Any ideas ?
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list

Mike Aubury

2013-07-17 12:23:23 UTC

Permalink

I tried - thats the other error I'm getting :

I dont need ssl connections - but its insisting on loading GSKit on
the server - and I'm getting an error on there :

IBM Global Security Kit (GSKit) version 7.0.4.27 or higher,
which provides APIs for Secure Sockets Layer (SSL) communication
and for encryption, is not installed.
ICC library load failed

Which is throwing an error on the frontend :

A first chance exception of type 'IBM.Data.DB2.DB2Exception' occurred
in IBM.Data.DB2.dll
Error Message: ERROR [58004] [IBM] SQL1042C An unexpected system
error occurred. SQLSTATE=58004

Error: (-1042): [IBM] SQL1042C An unexpected system error occurred.
SQLSTATE=58004

I did try the "installgskit" file - and i do have the libraries installed :

drwxr-xr-x 3 root sys 4096 Jul 17 11:02 /usr/local/ibm/gsk8_64/lib64/C
-rwxr-xr-x 1 root sys 514568 Jul 13 2012
/usr/local/ibm/gsk8_64/lib64/libgsk8acmeidup_64.so
-rwxr-xr-x 1 root sys 3328880 Jul 13 2012
/usr/local/ibm/gsk8_64/lib64/libgsk8cms_64.so
-rwxr-xr-x 1 root sys 369048 Jul 13 2012
/usr/local/ibm/gsk8_64/lib64/libgsk8dbfl_64.so
-rwxr-xr-x 1 root sys 128520 Jul 13 2012
/usr/local/ibm/gsk8_64/lib64/libgsk8drld_64.so
-rwxr-xr-x 1 root sys 391824 Jul 13 2012
/usr/local/ibm/gsk8_64/lib64/libgsk8iccs_64.so
-rwxr-xr-x 1 root sys 523272 Jul 13 2012
/usr/local/ibm/gsk8_64/lib64/libgsk8kicc_64.so
-rwxr-xr-x 1 root sys 714056 Jul 13 2012
/usr/local/ibm/gsk8_64/lib64/libgsk8km_64.so
-rwxr-xr-x 1 root sys 530184 Jul 13 2012
/usr/local/ibm/gsk8_64/lib64/libgsk8ldap_64.so
-rwxr-xr-x 1 root sys 645168 Jul 13 2012
/usr/local/ibm/gsk8_64/lib64/libgsk8p11_64.so
-rwxr-xr-x 1 root sys 1410072 Jul 13 2012
/usr/local/ibm/gsk8_64/lib64/libgsk8ssl_64.so
-rwxr-xr-x 1 root sys 9480 Jul 13 2012
/usr/local/ibm/gsk8_64/lib64/libgsk8sys_64.so
-rwxr-xr-x 1 root sys 460544 Jul 13 2012
/usr/local/ibm/gsk8_64/lib64/libgsk8valn_64.so
drwxr-xr-x 3 root sys 4096 Jul 17 11:02 /usr/local/ibm/gsk8_64/lib64/N

SQLHosts has :

dr_informix1170_1 drsoctcp servername dr_informix1170_1

I've tried with ClientSDK4.10 and 3.70...

Any ideas would be much appreciated...

Post by Alexandre Marini
Hello, Mike.
If you want to use the recommended way, you must install Data Server Driver,
and connect to Informix via drsoctcp protocol, instead of onsoctcp. That
should enable you to use the new provider methods, and also integrate you to
Linq features, and so on...
http://pic.dhe.ibm.com/infocenter/informix/v121/topic/com.ibm.admin.doc/ids_admin_0206.htm?resultof=%22%2e%6e%65%74%22%20%22%6e%65%74%22%20%22%73%73%6c%22%20
If you are really using ssl connections, you might also check for drsocssl
protocol, instead.
Hope it helps.
Regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant

Mike Aubury

2013-07-17 15:59:41 UTC

Permalink

Think I've got it working now

I installed the 3.70 version and added
"PersistSecurityInfo=true;Authentication=server" to the connection
string and that seems to be working for me..

(using the now recommended "DB2Connection" mechaism - grrrr..)