B2B Integration

 View Only

  • 1.  Which is the encryption method used for remote password in SFTP_PROF DB table in IBM SI

    Posted Mon March 09, 2020 09:48 AM
    Hi,
    What is the encryption method used for remote_password field in SFTP_PROF DB table in IBM SI.
    Please let me know quickly as i need for engagement .
    Regards,
    Justin.


    ------------------------------
    Justin Prabhu
    ------------------------------

    #SupplyChain
    #B2BIntegration


  • 2.  RE: Which is the encryption method used for remote password in SFTP_PROF DB table in IBM SI

    Posted Tue March 10, 2020 08:51 AM
    Justin,
    Please look at <SI HOME>/bin/decrypt.cmd or /bin/decrypt.sh for decrypting the value in the REMOTE_PASSWORD value from the SFTP_PROF table.

    ------------------------------
    Michael Geier
    IT Engineer 3
    Enterprise Holdings, Inc
    St. Louis MO
    ------------------------------

    Original Message


  • 3.  RE: Which is the encryption method used for remote password in SFTP_PROF DB table in IBM SI

    Posted Wed March 11, 2020 05:07 AM
      |   view attached
    Hi Michael,

    Thanks for your solution.
    However, when i try encrypting the plain password using encrypt_string.sh,encryption is succesful and i get encrypted string.
    and then when i try decrypting the encrypted string,it gives blank output. PFA screenshot.
    Also, when i view this SSH remote profile with this encrypted password, i get error in screen and related error is shown below.
    Can you please tell how to resolve this error. As it is for POC, will appreciate for quick reply.
    Thanks.

    [2020-03-11 03:46:39.472] ERROR 000000000000 GLOBAL_SCOPE Exception decrypting passphrase
    javax.crypto.BadPaddingException: Given final block not properly padded
    at com.ibm.crypto.fips.provider.at.a(Unknown Source)
    at com.ibm.crypto.fips.provider.at.b(Unknown Source)
    at com.ibm.crypto.fips.provider.at.engineDoFinal(Unknown Source)
    at javax.crypto.Cipher.doFinal(Unknown Source)
    at com.sterlingcommerce.security.control.SCISymmetricCipher.doFinal(SCISymmetricCipher.java:701)
    at com.sterlingcommerce.security.provider.SCIPBEWrapper.decrypt(SCIPBEWrapper.java:204)
    at com.sterlingcommerce.security.opsutilities.DBPasswords.decryptPassphrase(DBPasswords.java:149)
    at com.sterlingcommerce.security.opsutilities.DBPasswords.decrypt(DBPasswords.java:215)
    at com.sterlingcommerce.woodstock.ssh.db.SftpProfile.getREMOTE_PASSWORD(SftpProfile.java:171)
    at com.sterlingcommerce.woodstock.ui.jspbean.SFTPKeysListBean.displayKeyInfo(SFTPKeysListBean.java:1172)
    at org.apache.jsp.jsp.sftpkeysinfo_jsp._jspService(sftpkeysinfo_jsp.java:186)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)


    ------------------------------
    Justin Prabhu
    ------------------------------

    Original Message


  • 4.  RE: Which is the encryption method used for remote password in SFTP_PROF DB table in IBM SI

    Posted Wed March 11, 2020 12:15 PM
    Edited by System Wed March 22, 2023 11:53 AM
    For obscured password use it as ./decrypt_string.sh OBSCURED:<PASSWORD> (Use this when encrypted password using encrypt_string.sh/cmd)
    For password like the above case ./decrypt_string.sh <PASSWORD>

    ------------------------------
    Rajasekhar Muthamsetty
    ------------------------------

    Original Message