September 2024 - Page 3 of 4 - File transfer tool from Limagito

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:
Check your FTP client settings to ensure you’re using the correct encryption method (implicit or explicit FTPS).
Verify with your FTP server administrator that FTPS is supported and properly configured.
Try using a different FTP client to rule out client-specific issues.
Ensure your firewall isn’t blocking the necessary ports for FTPS (usually port 990 for implicit FTPS).
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
If you need any help with this question, please let us know.
Best Regards,
Limagito Team
#ftp #managedfiletransfer #filetransfer #filemanagement
By Limagito-Team FTP failed to convert data, TLS
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.
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.
Enable ‘Allow parameters in File Name filter’ (File Filter Setup – Advanced Tab):
Open our 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.
We used a Windows folder as Destination:
Function is set to Copy in our example but also Move is possible
If function is set to Copy and you only want to copy the same files once, then please enable our File Memory option:
RunTime log result:
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:
Add and enable the following: ‘On Rule Begin’ Pascal Script
Do not forget to adjust the CtSearchPath (ctSearchFilter and ctSearchSubFolders) Const
Add and enable the following: ‘On Rule End’ Pascal Script
The pregen files will be deleted only if no errors occurred
If you need any help with this question, please let us know.
Best Regards,
Limagito Team
#managedfiletransfer #filetransfer #filemanagement
By Limagito-Team Filters Pascal Script an other directory, an other source, an other source directory
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?
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.
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 exclude filter