B2B Integration

 View Only
Expand all | Collapse all

SFTP Remote Profile View/Edit page issue in IBM B2B Sterling integrator 6.x

  • 1.  SFTP Remote Profile View/Edit page issue in IBM B2B Sterling integrator 6.x

    Posted Tue February 11, 2020 10:34 AM
    Hi ,

    For SFTP, I am trying to implement SSH Remote profile functionality with password authentication through API .
    I was able to create remote profile successfulyy.


    However, When Iam viewing created remote profile in IBM SI dashboard, I get the error attached.
    I could not find related information in logs like System.log in SI dashboard/Operations->System->Logs section/System logs.
    2. On edit of the same profile, The Edit page does not show profile name,password details
    and authentication type is shown incorrectly as Public key although in DB table,it is stored as password.
    Could you tell how to resolve this issue.
    It will be helpful if early response is got as I have a client demo shortly.

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

    #B2BIntegration
    #SupplyChain


  • 2.  RE: SFTP Remote Profile View/Edit page issue in IBM B2B Sterling integrator 6.x

    Posted Wed February 12, 2020 05:54 AM
    Hi Justin,

    please check in your install/properties/security.properties  file for   passphrase property, if it is not set,  then add this
    passphrase=password

    restart the server  and then try creating the API,  it should work


    ------------------------------
    Sreedhar Janaswamy
    ------------------------------



  • 3.  RE: SFTP Remote Profile View/Edit page issue in IBM B2B Sterling integrator 6.x

    Posted Wed February 12, 2020 10:58 AM
    Hi Justin,

    I hope you used the IBM provided API interface to create SFTP profile. Can you try to use API to read or update the profile details and see what you get/happen.

    -- Raja

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



  • 4.  RE: SFTP Remote Profile View/Edit page issue in IBM B2B Sterling integrator 6.x

    Posted Tue February 18, 2020 06:57 AM
    Hi
    It got resolved when i gave value for known hosts field.
    Thanks

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



  • 5.  RE: SFTP Remote Profile View/Edit page issue in IBM B2B Sterling integrator 6.x

    Posted Thu February 20, 2020 08:29 AM
      |   view attached
    Hi Raja,
    The issue is existing for new Profiles I create.

    Iam using IBM provided API.
    When i read from API, values are coming properly but when I View from IBM SI dashboard, below error comes:

    [2020-02-20 07:12:11.396] ERROR Exception decrypting passphrase
    [2020-02-20 07:12:11.396] ERROR [1582204331395] Given final block not properly padded
    [2020-02-20 07:12:11.396] ERRORDTL [1582204331395]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)

    Iam not giving different password - it is simple alphanumeric one like si52... 
    Can you please let me know how to resolve this error/issue. PFA full logs.
    Thanks.




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

    Attachment(s)

    txt
    logs.txt   292 KB 1 version


  • 6.  RE: SFTP Remote Profile View/Edit page issue in IBM B2B Sterling integrator 6.x

    Posted Thu February 20, 2020 09:06 AM
    issues seems to be with passphrase.  Do you have the passphrase specified in security.propreties or customer_overrides.properties ?

    ------------------------------
    Sreedhar Janaswamy
    ------------------------------



  • 7.  RE: SFTP Remote Profile View/Edit page issue in IBM B2B Sterling integrator 6.x

    Posted Fri February 21, 2020 05:45 AM
    It was not specified.
    when we specified passphrase as password in customer_overrides.properties file,server did not start and it gave error:

    "The private key cannot be retrieved.

    The system passphrase is probably incorrect.

     Error '1' starting Sterling B2B Integrator"
    So,we gave passphrase as custom password value we had given during installation. Then,server started.

    However,Iam still getting same "javax.crypto.BadPaddingException: Given final block not properly padded" error when i click View on SSH remote profile link in dashboard. kindly help to resolve.
    THanks.



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



  • 8.  RE: SFTP Remote Profile View/Edit page issue in IBM B2B Sterling integrator 6.x

    Posted Fri February 21, 2020 05:57 AM
    Justin,  you need to give the passhrase value  which you must have given during install time.   I just mentioned it as passphrase=password  , so it should be  passphrase=<passphrase password given during install time>

    ------------------------------
    Sreedhar Janaswamy
    ------------------------------



  • 9.  RE: SFTP Remote Profile View/Edit page issue in IBM B2B Sterling integrator 6.x

    Posted Mon March 09, 2020 07:07 AM
    Hi,
    It did not work with password we gave during installation.
    Iam trying to insert record into DB table SFTP_PROF. 
    •  Below statement gives error:Insert into ADMIN.SFTP_PROF (NAME,REMOTE_HOST,REMOTE_PORT,REMOTE_USER"            + ",REMOTE_PASSWORD,RETRY_DELAY,PREFERRED_CIPHER,PREFERRED_MAC,PREFERRED_AUTH) "            + "values(march9-demo,18.235.63.48,22,'JWuser',test,0,blowfish-cbc,hmac-sha1,'password')

    • java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("ADMIN"."SFTP_PROF"."PROFILE_ID")

    • What value to give for PROFILE_ID as it looks to be generated by IBM SI when I make API callbut when I make DB call,it asks for this PROFILE_ID value .
    • Kindly let me know as it is urgent.


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



  • 10.  RE: SFTP Remote Profile View/Edit page issue in IBM B2B Sterling integrator 6.x

    Posted Wed March 18, 2020 08:39 AM
    Justin,

    Please open support case for the above issue.

    Thanks and Regards,
    Sreedhar.

    ------------------------------
    Sreedhar Janaswamy
    ------------------------------