• 30 Sep

    How to send signed emails using PFX File

    In version v2023.9.30.0 we added an option to send signed emails.

    • Open the SMTP as Destination option. The “Sign / Encrypt” tab is only available when our second API vendor CK is selected.  This option is also available in the Rule Events Email option.

    limagito file mover smtp as destination

    • Select “Sign / Encrypt” tab:
      • Signature PFX File: The PFX file to be used as source for locating the certificate and private key required for signing.
      • Signature Password: The PFX file’s password
      • Find Cert By Subject (optional): Finds a certificate where one of the Subject properties (SubjectCN, SubjectE, SubjectO, SubjectOU, SubjectL, SubjectST, SubjectC) matches exactly (but case insensitive) with the passed string. A match in SubjectCN will be tried first, followed by SubjectE, and SubjectO. After that, the first match found in SubjectOU, SubjectL, SubjectST, or SubjectC, but in no guaranteed order, is returned. All matches are case insensitive.
      • Signature Algorithm (optional): Selects the signature algorithm to be used when sending signed (PKCS7) email. The default value is  PKCS1-v1_5  . This can be set to  RSASSA-PSS  (or simply  pss  ) to use the RSASSA-PSS signature scheme. Note: This property only applies when signing with an RSA private key. It does not apply for ECC or DSA private keys.
      • Sign Hash Algorithm (optional): Selects the underlying hash algorithm used when sending signed (PKCS7) email. Possible values are  sha1  ,  sha256  ,  sha384  ,  sha512  ,  md5  , and  md2  .
      • Use Opaque Signing:  When enabled, a signed email is generated as signed-data. When disabled, a signed email is generated as multipart/signed. A multipart/signed email is such that the signature is contained in a separate MIME body part and the original content of the email is not encapsulated within the signature. A signed-data email is such that it’s non-multipart MIME (content type is “application/pkcs7-signature”) and the original email is encapsulated within the signature.

    limagito file mover send signed email

    If you need any info about this ‘send signed emails’ option, please let us know.

    #email #smtp #filetransfer #filemanagement

    Best regards,

    Limagito Team

     

    By Limagito-Team Email SMTP ,
  • 25 Sep

    Sending Mails (SMTP) via an SSH tunnel

    In version v2023.9.25.0 we added an option that allows you sending emails using SMTP via an SSH tunnel.

    • Important is to use our second API vendor – CK

    limagito file mover smtp as destination

    • Select the SSH Tab for your setup:

    This option let us connect to an SSH server and creates a tunnel for SMTP. The ‘Host’ is the hostname (or IP address) of the SSH server. The ‘Port’ is typically 22, which is the standard SSH port number. At this moment only SSH authentication using username and password is possible.

    limagito file mover smtp over a ssh tunnel

    • In version v2023.9.30.0 we added “SSH Public-Key Authentication”:

    – Authenticates with the SSH server using public-key authentication. The corresponding public key must have been installed on the SSH server. Authentication will succeed if the matching “Username” is provided.

    limagito file mover smtp via an SSH tunnel

    If you need any info about this option, please let us know.

    #smtp #ssh #filetransfer #filemanagement

    Best regards,

    Limagito Team

    By Limagito-Team Email SMTP ,
  • 24 Sep

    How to exit rule when SQL record count is 0

    How to exit rule when SQL record count is 0

    Q: We have an SQL as source job that emails the results of the SQL statement as a file. The problem is that we do not want the results/email sent when there are no records. I see that the variable %QSC contains the record count. How can I use that variable to exit the rule and not email the empty results file?

    A: So I guess you have SMTP as Destination?
    Please add the following SQL ‘On Destination’ script and try once more:

    limagito file mover paascal script option

    Begin
      psExitCode:= 1;
      // ... add your code here
      If psQSC = 0 Then
        psExitCode:= 0;
    End.

    limagito file mover pascal script setup

    • Feedback customer: Yes, it is a SMTP destination. Based off what you sent below I added the Pascal script with the addition of some logging:

    limagito file mover pascal script setup

    This works as expected and what we want, but it also creates the temp file. Is there a way the temp file can be suppressed? If not, I can add a rule to delete them.

    8/9/2023 5:07:43 PM RecordCount: 0

    8/9/2023 5:07:43 PM FieldDefs: “contributor_system”,”logged_datetime”,”mrn”,”patient_name”,”fin”,”error_status”,”error_text”,”message_text”

    8/9/2023 5:07:43 PM Copied Cerner_ESI_log_other_2023-08-09.csv to C:\Users\SVCFIL~1\AppData\Local\Temp\LimagitoX\LimagitoX.165\Cerner_ESI_log_other_2023-08-09.csv;110

    8/9/2023 5:07:43 PM Backup Successful C:\Users\SVCFIL~1\AppData\Local\Temp\LimagitoX\LimagitoX.165\Cerner_ESI_log_other_2023-08-09.csv to C:\Data\SourceFileBackups\Prod\2023\08\09\Cerner_ESI_log_other_2023-08-09.csv

    8/9/2023 5:07:43 PM Compiling..

    8/9/2023 5:07:43 PM Compiled Succesfully

    8/9/2023 5:07:43 PM psQSC (SQL record count) = 0. Exiting rule.

    8/9/2023 5:07:43 PM Total Files Redo, Count: 1 & Size: 110

    • Reply to customer:

    Please try to add

    DeleteFile(psFilePath + psFileName);

    to the script.

    Begin
      psExitCode:= 1;
      // ... add your code here
      If psQSC = 0 Then
      Begin
        DeleteFile(psFilePath + psFileName);
        psExitCode:= 0;
      End;
    End.

    It seems you are using our Backup option. In your case, we would add the ‘backup’ as a second WIN destination because otherwise you still get the temporary file in your backup folder (instead of using our BACKUP option).

    • Feedback customer: That got it! Thanks you for your help. We are all good now and the rule is working as we want it to.

    If you need any info about this ‘exit rule when SQL record count is 0’ question, please let us know.

    #sql #filetransfer #filemanagement

    Best regards,

    Limagito Team

    By Limagito-Team SQL ,
1 2 3
SEARCH