File Mover Blog

  • 08 Sep

    Failed to convert data connection to TLS

    Failed to convert data connection

    Q: What could be the reason of this?

    When trying to FTP, This is the error message –

    9/4/2024 3:36:11 PM FTPListDirectory, CK GetDirCount Error: ChilkatLog:
    GetDirCount:
    VerboseLogging: 0
    listPattern: *
    fetchDirListing:
    pattern: *
    supportsMLSD: 0
    fetchDirListing2:
    pbsz_protp:
    simpleCommand:
    sendCommand:
    sendingCommand: PBSZ 0
    –sendCommand
    readCommandResponse:
    replyLineQP: 200 OK.
    –readCommandResponse
    –simpleCommand
    simpleCommand:
    sendCommand:
    sendingCommand: PROT P
    –sendCommand
    readCommandResponse:
    replyLineQP: 200 Data connections set to secure (SSL) mode
    –readCommandResponse
    –simpleCommand
    –pbsz_protp
    setupDataConnection:
    passive transfer mode
    setupPassiveDataSocket:
    sendCommand:
    sendingCommand: PASV
    –sendCommand
    readCommandResponse:
    replyLineQP: 227 Entering Passive Mode (XXX,XXX,XXX,XXX,XXX,XXX)
    –readCommandResponse
    dataConnect:
    hostname: XXX.XXX.XXX.XXX
    port: 49434
    Setting SNI hostname for data connection.
    SNI_hostname: XXXXXXXX
    socketOptions:
    SO_SNDBUF: 262144
    SO_RCVBUF: 4194304
    TCP_NODELAY: 0
    SO_KEEPALIVE: 1
    –socketOptions
    dataConnectSuccess: 1
    –dataConnect
    –setupPassiveDataSocket
    –setupDataConnection
    sendCommand:
    sendingCommand: LIST
    –sendCommand
    readCommandResponse:
    replyLineQP: 125 Secure data connection open; transfer starting.
    –readCommandResponse
    convertDataConnToSsl:
    ConvertToTls: Elapsed time: 0 millisec
    Failed to convert data connection to TLS
    –convertDataConnToSsl
    Failed to convert data connection to TLS.
    –fetchDirListing2
    –fetchDirListing
    Failed to get and cache directory listing…
    N: -1
    Failed.
    –GetDirCount
    –ChilkatLog

    Could you please help in this?

    A: The error indicates that while the initial control connection to the FTP server was established successfully, the client failed to upgrade the data connection to a secure TLS (Transport Layer Security) connection.

    Possible causes:

    • Misconfiguration on the server or client side
    • Incompatible TLS versions between client and server
    • Firewall or network issues blocking the necessary ports
    • Outdated software that doesn’t support the required encryption methods

    Common scenarios:

    • The FTP client is set to use explicit FTPS, but the server doesn’t support it
    • The server requires implicit FTPS, but the client is not configured for it
    • There’s a mismatch in the supported TLS versions between client and server

    To resolve this issue, you could try the following:

    1. Check your FTP client settings to ensure you’re using the correct encryption method (implicit or explicit FTPS).
    2. Verify with your FTP server administrator that FTPS is supported and properly configured.
    3. Try using a different FTP client to rule out client-specific issues.
    4. Ensure your firewall isn’t blocking the necessary ports for FTPS (usually port 990 for implicit FTPS).
    5. Update your FTP client and server software to the latest versions.

    The The reason here was a mismatch in the supported TLS versions between client and server. Somehow the server has an issue with TLS and the only way to transfer the data was to disable our ‘Encrypt Data Channel” option.

    C:\Data\Foto\v2023\FTP\Failed to convert data connection\Failed to convert data connection

    The customer was using Implicit FTPS on port 990

    limagito file mover ftps setup

    If you need any help with this question, please let us know.

    Best Regards,

    Limagito Team

    #ftp #managedfiletransfer #filetransfer #filemanagement

    By Limagito-Team FTP ,
  • 04 Sep

    How to when files arrive, copy files from an other source directory

    How to when files arrive, copy files from an other source directory

    Q: I need some help on a Limagito rule I need to write :

    • Check files into a source directory.
    • When these files arrive, copy files from an other source directory with same filename but different extension.

    ie :

    Check files named 123456.pregen from c:\Test\Search\

    Then copy file c:\Test\In\123456.pdf to c:\dest\

    A: Please have a look at the following screenshots:

    • We are using a Windows folder as source. The goal is to copy files from here to a destination. Which files will depend on the script we are going to add.

    limagito file mover windows folder as source

    • File Filter Setup:
      • Add  %VSA  as include Filename Filter (%VSA = Variable String A)
      • The %VSA will contain the filenames we want to copy. Our Pascal script will add the filenames to this Var.

    limagito file mover file filter setup

    • Enable ‘Allow parameters in File Name filter’ (File Filter Setup – Advanced Tab):

    limagito file mover file filter advanced setup

    • Open our Pascal Script option

    limagito file mover pascal script option

    • Add and enable the following ‘On Rule Begin’ Pascal Script:
      • Do not forget to adjust the CtSearchPath (ctSearchFilter and ctSearchSubFolders) Const

     

    Var
      iList: Integer;
      tmpFilename: String;
      tmpList: TstringList;
    Const
      ctSearchPath = 'C:\Test\Search\'; // Must end with a \
      ctSearchFilter = '*.pregen';
      ctSearchSubFolders = False; // False or True
    Begin
      psExitCode:= 0;
      psVSA := '';
      // ... add your code here
      tmpList := psListFiles(ctSearchPath, ctSearchFilter, ctSearchSubFolders);
      Try
        For iList := 0 to (tmpList.Count-1) Do
        Begin
          tmpFilename := tmpList.Strings[iList];
          tmpFilename := ChangeFileExt(tmpFilename, '.pdf');
          psVSA := psVSA + tmpFilename + ';';    
        End;           
      Finally
        tmpList.Free;
      End;    
      // Debug
      psLogWrite(1, '', 'Filename filter as psVSA: ' + psVSA);
      // Set psExitCode
      If psVSA <> '' Then
        psExitCode := 1;
    End.
    

    limagito file mover copy files from an other source directory

    • We used a Windows folder as Destination:

    limagito file mover windows folder as destination

    • Function is set to Copy in our example but also Move is possible

    limagito file mover function setup

    • If function is set to Copy and you only want to copy the same files once, then please enable our File Memory option:

    limagito file mover file memory option

    • RunTime log result:

    limagito file mover runtime log

    I forgot on line. If I want to delete my pregen file after copy/move, where can I add it on code ?

    In this case some adjustments to the pascal script are needed:

    limagito file mover pascal script option

    limagito file mover pascal script option

    If you need any help with this question, please let us know.

    Best Regards,

    Limagito Team

    #managedfiletransfer #filetransfer #filemanagement

  • 03 Sep

    How to use the database log exclude filter

    How to use the database log exclude filter

    Q: I’m looking to exclude lines that contain SFTPCheckConnected in this Limagito report by using the Log Exclude Filter in the window below. If this is possible, can you provide an example of the syntax that can be used to accomplish this, please?

    limagito file mover database log filter options

    limagito file mover dabase log report

    A: Double click on the ‘Log Exclude Filter’ field and you are able to add different filter items. This filter setup form is available for include and exclude filter on the RunTime, File and Database log setup tab.

    limagito file mover log exclude filter

    If you need any help with this ‘log exclude filter’ question, please let us know.

    Best Regards,

    Limagito Team

    #managedfiletransfer #filetransfer #filemanagement

    By Limagito-Team Logging
1 2 3 4 5 6 142
SEARCH