HoedjeRo

Forum Replies Created

Viewing 9 replies – 1 through 9 (of 9 total)
  • Author
    Replies
  • in reply to: SFTP upload options #120704
    HoedjeRo
    Participant

      @John-Mercogliano,
      I tried removing the everything left of the colon including the colon but for this particular site it will then result in:
      Error while trying to write Benefit.csv.
      Detailed error:Upload failed: No such file or directory (2/-31)
      Curl errCode:78 Curl error: Remote file not found

      I have set the curl option.

      If I add the username including the colon it works for this site.
      For another site I have the same as in your screenshots and that works fine.
      Just to let you know as some sites are a little weird it seems.

       

      Thanks for your help.

      Roland
      HCA Healthcare UK

      Attachments:
      You must be logged in to view attached files.
      in reply to: SFTP upload options #120697
      HoedjeRo
      Participant

        @John Mercogliano,

        That is very helpful. I have tried something like this in the past but it seems that I must have missed something.
        I have no successfully managed to test 2 different SFTP servers and managed to write to them.
        As you can see in screenshots attached the directories in CL SFTP set up needs to match what is in WinSCP.

        Many thanks,

        Roland
        HCA Healthcare UK

        Attachments:
        You must be logged in to view attached files.
        in reply to: SFTP SSH license #120412
        HoedjeRo
        Participant

          What is the Secure Messenger license option called in the license file?

          How can I check if I have this option?

          in reply to: SFTP upload options #120339
          HoedjeRo
          Participant

            I tried but that’s even worse. I have a thread feeding the SFTP connection but when I add a local binding address it fails (quicker).

            [msg :Msg :DBUG/0:FTP_PERQUISITE:02/23/2023 09:01:01] msgFree 0x0x7fc9dd740d50 refCnt 1
            [pd :pdtd:INFO/0:FTP_PERQUISITE:02/23/2023 09:01:01] [0.0.38559] Writing message to Protocol Driver fileset-ftp
            [fset:init:DBUG/0:FTP_PERQUISITE:02/23/2023 09:01:01] fcDoNetworkStuff: mode=5
            [pd :pdtd:INFO/1:FTP_PERQUISITE:02/23/2023 09:01:01] Set driver status to PD_STATUS_UP
            * Trying 62.32.120.35…
            * TCP_NODELAY set
            * Name ‘uksalqapcl01’ family 2 resolved to ‘127.0.0.1’ family 2
            * Local port: 0
            * Immediate connect fail for 62.32.120.35: Invalid argument
            * Closing connection 0
            [fset:wrte:ERR /0:FTP_PERQUISITE:02/23/2023 09:01:01] Error while trying to write 2023-02-23Benefit.csv.
            [fset:wrte:ERR /0:FTP_PERQUISITE:–/–/—- –:–:–] Detailed error:
            [fset:wrte:ERR /0:FTP_PERQUISITE:–/–/—- –:–:–] Curl errCode:7 Curl error: Couldn’t connect to server

             

            Or:

            [msg :Msg :DBUG/0:FTP_PERQUISITE:02/23/2023 09:09:08] msgFree 0x0x7f907d98ed50 refCnt 1
            [pd :pdtd:INFO/0:FTP_PERQUISITE:02/23/2023 09:09:08] [0.0.38559] Writing message to Protocol Driver fileset-ftp
            [fset:init:DBUG/0:FTP_PERQUISITE:02/23/2023 09:09:08] fcDoNetworkStuff: mode=5
            [pd :pdtd:INFO/1:FTP_PERQUISITE:02/23/2023 09:09:08] Set driver status to PD_STATUS_UP
            * Trying 62.32.120.35…
            * TCP_NODELAY set
            * Name ‘10.96.244.30’ family 2 resolved to ‘10.96.244.30’ family 2
            * Local port: 0
            * Connected to 62.32.120.35 (62.32.120.35) port 22 (#0)
            < SSH-2.0-VShell_4_3_2_1566 VShell
            * server response timeout
            * Closing connection 0
            [fset:wrte:ERR /0:FTP_PERQUISITE:02/23/2023 09:09:38] Error while trying to write 2023-02-23Benefit.csv.
            [fset:wrte:ERR /0:FTP_PERQUISITE:–/–/—- –:–:–] Detailed error:server response timeout
            [fset:wrte:ERR /0:FTP_PERQUISITE:–/–/—- –:–:–] Curl errCode:28 Curl error: Timeout was reached
            [pd :pdtd:INFO/1:FTP_PERQUISITE:02/23/2023 09:09:38] Set driver status to PD_STATUS_OPENING
            [pd :pdtd:INFO/1:FTP_PERQUISITE:02/23/2023 09:09:40] Set driver status to PD_STATUS_ERROR
            [pd :pdtd:INFO/1:FTP_PERQUISITE:02/23/2023 09:09:40] [0.0.38559] Writing message failed

            • This reply was modified 1 year, 10 months ago by HoedjeRo.
            in reply to: SFTP upload options #120333
            HoedjeRo
            Participant

              I have made the changes as suggested (not with a local binding address) and no joy.

              Active mode disabled. Directory and template adjusted accordingly. Removed the SFTP option and left the drop down empty and made sure we’re still connecting to port 22.

              [msg :Msg :DBUG/0:FTP_PERQUISITE:02/22/2023 15:38:52] msgFree 0x0x7f8eafda8f50 refCnt 1
              [pd :pdtd:INFO/0:FTP_PERQUISITE:02/22/2023 15:38:52] [0.0.38559] Writing message to Protocol Driver fileset-ftp
              [fset:init:DBUG/0:FTP_PERQUISITE:02/22/2023 15:38:52] fcDoNetworkStuff: mode=5
              [pd :pdtd:INFO/1:FTP_PERQUISITE:02/22/2023 15:38:52] Set driver status to PD_STATUS_UP
              * Trying 62.32.120.35…
              * TCP_NODELAY set
              * Connected to 62.32.120.35 (62.32.120.35) port 22 (#0)
              < SSH-2.0-VShell_4_3_2_1566 VShell
              * server response timeout
              * Closing connection 0
              [fset:wrte:ERR /0:FTP_PERQUISITE:02/22/2023 15:39:22] Error while trying to write 2023-02-22Benefit.csv.
              [fset:wrte:ERR /0:FTP_PERQUISITE:–/–/—- –:–:–] Detailed error:server response timeout
              [fset:wrte:ERR /0:FTP_PERQUISITE:–/–/—- –:–:–] Curl errCode:28 Curl error: Timeout was reached
              [pd :pdtd:INFO/1:FTP_PERQUISITE:02/22/2023 15:39:22] Set driver status to PD_STATUS_OPENING
              [pd :pdtd:INFO/1:FTP_PERQUISITE:02/22/2023 15:39:24] Set driver status to PD_STATUS_ERROR
              [pd :pdtd:INFO/1:FTP_PERQUISITE:02/22/2023 15:39:24] [0.0.38559] Writing message failed

               

               

              I’m trying to find out if I can authenticate with private and public key instead of username and password.

              Jammer maar helaas.

              in reply to: SFTP upload options #120289
              HoedjeRo
              Participant

                When I have a putty session open to my RHEL CL server and there start stp user@<dest-ip> I get prompted for the password.
                Enter password connect is established.

                do command:
                put HCAEmployeeSpecificBenefit14022023.csv Outbox/
                And the file is transported without issue.

                Still the GUI doesn’t give me the same result. I get:

                [pd :pdtd:INFO/0:FTP_PERQUISITE:02/16/2023 09:57:45] [0.0.38518] Writing message to Protocol Driver fileset-ftp
                [fset:init:INFO/1:FTP_PERQUISITE:02/16/2023 09:57:45] set ACTIVE mode
                [fset:init:DBUG/0:FTP_PERQUISITE:02/16/2023 09:57:45] fcDoNetworkStuff: mode=5
                * Trying 62.32.120.35…
                * TCP_NODELAY set
                * Connected to 62.32.120.35 (62.32.120.35) port 22 (#0)
                < SSH-2.0-VShell_4_3_2_1566 VShell
                * server response timeout
                * Closing connection 0
                [fset:wrte:ERR /0:FTP_PERQUISITE:02/16/2023 09:57:55] Error while trying to write Outbox/2023-02-16Benifit.csv.
                [fset:wrte:ERR /0:FTP_PERQUISITE:–/–/—- –:–:–] Detailed error:server response timeout
                [fset:wrte:ERR /0:FTP_PERQUISITE:–/–/—- –:–:–] Curl errCode:28 Curl error: Timeout was reached
                [pd :pdtd:INFO/1:FTP_PERQUISITE:02/16/2023 09:57:55] Set driver status to PD_STATUS_OPENING
                [pd :pdtd:INFO/1:FTP_PERQUISITE:02/16/2023 09:57:57] Set driver status to PD_STATUS_ERROR
                [pd :pdtd:INFO/1:FTP_PERQUISITE:02/16/2023 09:57:57] [0.0.38518] Writing message failed

                Attachments:
                You must be logged in to view attached files.
                in reply to: SFTP upload options #120288
                HoedjeRo
                Participant

                  Also when I use manual commend from a putty session I can log in on SFTP and put any file in the destination location.
                  I may need to do this with tcl as I can’t make the GUI to do the correct function and put the file there

                  in reply to: SFTP upload options #120283
                  HoedjeRo
                  Participant

                    I’m still getting the error:

                    ===========

                    Error while trying to write /Outbox/2023-02-15Benifit.csv.
                    Detailed error:Upload failed: No such file or directory (2/-31)
                    Curl errCode:78 Curl error: Remote file not found

                     

                    I’m also using “/Outbox/%SYS.DATE%Benifit.csv” as the file template and “/Outbox/Benifit.csv” as the file config.
                    Nothing in the directories item.

                    Confused as I can easily do this using the same credentials with WinSCP

                    HoedjeRo
                    Participant

                      That has worked nicely. Thank you

                    Viewing 9 replies – 1 through 9 (of 9 total)