Logging Archives - File transfer tool from Limagito

21 Feb
The target principal name is incorrect
The target principal name is incorrect
Q: I was trying to connect to the DB called ‘XYZ’ and I tried different things with AI’s help. But I must have broken something that Limagito seems not logging new history to the DB. And when I tried to connect to the DB from one rule, I get this message.
Can you help to reestablish the connection to the DB again please?
A: The reason: ODBC 18 was installed on the system where Limagito was running. ODBC Driver 18 enforces encryption by default.
Because this customer is really heavy into AI we added a new ‘DB Connection Parameters’ option so he can try different settings (under the Advanced Tab).
SQL, DB Connection Parameters option (v2026.2.19.0) [+]
In his case he had to Add Encrypt=No to disable encryption again which he was using before he installed ODBC 18.
We added this new connection parameters option also to SQL as Source and Destination (Advanced Tab).
Some extra information:
Our (FireDAC) MSSQL driver internally uses a client library to connect to SQL Server. On modern Windows systems the available options are:
SQL Server Native Client 11.0 (sqlncli11.dll) — old, often no longer installed
MSOLEDBSQL (OLE DB Driver) — modern Microsoft OLE DB
ODBC Driver 17/18 for SQL Server — as fallback
If FireDAC cannot find a Native Client or OLE DB driver, it automatically falls back to ODBC.
Regarding the error message from the cutomer: this is a common SSL/TLS issue with the Microsoft ODBC Driver 18 for SQL Server. Driver 18 changed the default behavior — encryption is now ON by default, unlike Driver 17.
The error “The target principal name is incorrect” means the SSL handshake fails because the server’s certificate doesn’t match the expected hostname.
Quick fixes in your MSSQL connection, add one or both of these parameters to your connection:
Encrypt=no
or if you want to keep encryption but skip certificate validation:
Encrypt=yes;TrustServerCertificate=yes
With ODBC it will be like:
ODBCAdvanced=TrustServerCertificate=Yes;Encrypt=No
The new parameters makes it possible to try different setting without creating a new build.
If you need any help about this ‘target principal name is incorrect’ message, please let us know.
Best Regards,
Limagito Team
#odbc #sql #managedfiletransfer #filetransfer #filemanagement
By Limagito-Team Logging SQL connection parameters, encrypt=no, incorrect, principal
16 Feb
Custom logging feature to feed a Zabbix monitoring system
Q: We are using LimagiTO File Mover’s custom logging feature to feed a Zabbix monitoring system. We currently use the following log format:
%{DATETIME}|%{LEVEL}|%{LEVELINT}|%{THREADID}|%{HOSTNAME}|%{RULEID}|%{RULENAME}|%{MESSAGE}
We are trying to determine whether a complete rule execution succeeded or failed by parsing the log. The challenge we face is that we have no reliable way to group all log lines belonging to the same execution run of a rule:
THREADID changes between runs, which is useful, but we observed that a single rule execution can sometimes involve multiple threads (different THREADIDs writing log entries for the same run).
DATETIME can span several seconds or minutes for a single execution, so timestamp alone is not sufficient.
There is no unique execution/run identifier in the available logging tags.
Could a %{RUNID} tag (or equivalent) be added that would assign a unique identifier to each rule execution cycle? This would allow us to reliably group all log entries from the same run and determine whether that run completed with or without errors.
As a secondary question: is the multi-thread behavior for a single rule execution expected? Under what circumstances does a rule execution produce log entries with different THREADIDs?
Thank you for considering this.
TomBlack007-Nut/zabbix_limagito
A: In version v2026.2.16.0 we added the %{RUNID} tag
$limagito file mover C:\Data\Foto\2026\feed a Zabbix monitoring system\feed a Zabbix monitoring system$
Tags:
********************************************************************************
*** Information about the Limagito File Mover Logging Tag(s) ***
********************************************************************************
The following predefined variables can be used to produce a custom message output format:
APPNAME : Customizable variable (by default set as filename without extension)
APPVERSION : Application file version
APPPATH : Application run path
CPUCORES : Number of CPU cores
DATETIME : Date & time log item occurs
ENVIRONMENT : Customizable variable (normally Production, Test, etc)
DATE : Date log item occurs
HOSTNAME : Computer name
LEVEL : Level or Eventype
LEVELINT : Level as numeric
LOGSOURCE : Description of log source
MESSAGE : Message sent to logger
OSVERSION : OS version
PLATFORM : Customizable variable (normally Desktop, Mobile, etc)
RULEID : RuleID number
RULENAME : RuleName
RUNID : Unique identifier to each rule execution cycle
THREADID : Thread ID log item set
TIME : Time log item occurs
USERNAME : Logged user name

If you need any help about this ‘feed a Zabbix monitoring system’ question, please let us know.
Best Regards,
Limagito Team
#zabbix #managedfiletransfer #filetransfer #filemanagement
By Limagito-Team Logging RUNID, tag, Unique identifier, Zabbix
05 Oct
How to prevent unnecessary log entries
How to prevent unnecessary log entries
Q: For example, Scanning a remote SFTP site to collect a specific file that seldom appears. I see the first half om the log and need to scroll down to se the last entry. I can of course change the scanning interval, but they (a department) expect to have a swift delivery as soon as a file appears. It’s no biggie.
2025-08-14 06:00:00 SFTPCheckConnected, CK Request Path after Login: /
2025-08-14 06:00:00 SFTPCheckConnected, CK Change Path to /
2025-08-14 06:00:00 SFTPCheckConnected, CK Request Path after Change: /
2025-08-14 07:00:00 SFTPCheckConnected, CK Request Path after Login: /
2025-08-14 07:00:00 SFTPCheckConnected, CK Change Path to /
2025-08-14 07:00:00 SFTPCheckConnected, CK Request Path after Change: /
2025-08-14 08:00:00 SFTPCheckConnected, CK Request Path after Login: /
2025-08-14 08:00:00 SFTPCheckConnected, CK Change Path to /
2025-08-14 08:00:00 SFTPCheckConnected, CK Request Path after Change: /
2025-08-14 09:00:00 SFTPCheckConnected, CK Request Path after Login: /
2025-08-14 09:00:00 SFTPCheckConnected, CK Change Path to /
2025-08-14 09:00:00 SFTPCheckConnected, CK Request Path after Change: /
2025-08-14 10:00:00 SFTPCheckConnected, CK Request Path after Login: /
2025-08-14 10:00:00 SFTPCheckConnected, CK Change Path to /
2025-08-14 10:00:00 SFTPCheckConnected, CK Request Path after Change: /
2025-08-14 11:00:00 SFTPCheckConnected, CK Request Path after Login: /
2025-08-14 11:00:00 SFTPCheckConnected, CK Change Path to /
2025-08-14 11:00:01 SFTPCheckConnected, CK Request Path after Change: /
and so on…
A: Yes, you can exclude these entries if you want:
Double click on the ‘Log Exclude Filter’
Feeback customer:
Just want to give kudos for your support. Among the absolute best I’v encountered!
If you need any help about this ‘unnecessary log entries’ request, please let us know.
Best Regards,
Limagito Team
#managedfiletransfer #filetransfer #filemanagement
By Limagito-Team How-to Logging log entries, unnecessary

1 2 3 4 … 7 →

Contact Us Now

Logging

The target principal name is incorrect

Custom logging feature to feed a Zabbix monitoring system

How to prevent unnecessary log entries

SEARCH

CATEGORIES

ARCHIVES

TAGS

DISCOVER OUR SITE