IBM Support

IT34453: OPENSHIFT - DEPLOYMENT AGAINST MSSQL TLS1.2 AND SELF-SIGNED CERT NOT WORKING

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • The deployment against an MSSQL Server
    with TLS1.2 and using a self-signed Certificate on MSSQL server
    does not work, when setting these values:
    DB_DATA=SFGDB001
    
    DB_DRIVERS=mssql-jdbc-8.2.0.jre8.jar
    DB_HOST=sm027904.wwg00m.roo
    tdom.net
    DB_KEYSTORE=
    DB_PORT=1433
    DB_SECRET=sfg-db-secret
    DB_TR
    USTSTORE=
    DB_USER=SFGUSER001
    DB_VENDOR=MSSQL
    TLS_VERSION=TLSv1.2
    
    USESSL=true
    MSSQL_TRUST_SERVER_CERTIFICATE=true
    

Local fix

  • B2BISFG-53586
    

Problem summary

  • Users Affected:
    All
    
    Problem Description:
    
    As per documentation the deployment against an MSSQL Server with
    TLS1.2 and using a self-signed Certificate on MSSQL server side
    does not work, when setting these values:
    
    DB_DATA=SFGDB001
    
    DB_DRIVERS=mssql-jdbc-8.2.0.jre8.jar
    
    DB_HOST=<>
    
    DB_KEYSTORE=
    
    DB_PORT=1433
    
    DB_SECRET=sfg-db-secret
    
    DB_TRUSTSTORE=
    
    DB_USER=SFGUSER001
    
    DB_VENDOR=MSSQL
    
    TLS_VERSION=TLSv1.2
    
    USESSL=true
    
    MSSQL_TRUST_SERVER_CERTIFICATE=true
    
    
    
    
    
    OpenShift - deployment against MSSQL TLS1.2 and self-signed cert
    not working.
    
    
    
    
    
    Platforms Affected:
    
    All
    

Problem conclusion

  • Resolution Summary:
    
    A code fix is provided.
    
    
    
    
    
    Delivered in:
    
    6000303
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT34453

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    600

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-10-06

  • Closed date

    2020-11-11

  • Last modified date

    2020-11-13

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    STR B2B INTEGRA

  • Fixed component ID

    5725D0600

Applicable component levels

[{"Line of Business":{"code":"LOB02","label":"AI Applications"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"600"}]

Document Information

Modified date:
16 November 2020