Global Data Management Forum

Data Management Global

A hub for collaboration, learning, networking, and cultural exchange, and contributing to positive global engagement

 View Only
  • 1.  SSL errors with DB2 community edition and dotnet client

    Posted 09/23/24 05:03 PM
      |   view attached

    I have a dotnet 8 application using the Net.IBM.Data.Db2 nuget package 8.0.0.300 talking to DB2 community edition v11.5.8.0. Client is running on Windows 11. Server-side certificate, keydb, and stash have been configured according to samples in DB2 documentation. Client-side is passing the certificate (no keydb or stash.) I get intermittent failures; the db2diag.log for a failing run is attached. There are no indications of problems on the server side.



    ------------------------------
    Art Kaufmann
    ------------------------------

    Attachment(s)

    log
    db2diag.log   9 KB 1 version


  • 2.  RE: SSL errors with DB2 community edition and dotnet client

    Posted 10/19/24 03:42 AM

    If this fragment of db2diag.log is from client then it appears that server replied badly:


    2024-09-23-07.21.54.070000-420 I1163F565            LEVEL: Error
    PID     : 11388                TID : 17776          PROC : dotnet.exe
    INSTANCE:                      NODE : 000
    HOSTNAME: ArtTonicIntel
    EDUID   : 17776
    FUNCTION: DB2 UDB, common communication, sqlccMapSSLErrorToDB2Error, probe:30
    MESSAGE : DIA3604E The SSL function "gsk_secure_soc_init" failed with the 
              return code "414" in "sqlccSSLSocketSetup".
    DATA #1 : String, 18 bytes
    GSK_ERROR_BAD_CERT
    DATA #2 : String, 55 bytes
    Incorrectly formatted certificate received from partner


    ------------------------------
    Jan Nelken
    ------------------------------