Decrypt object throws error when no passphrase is present

More
2 years 6 months ago - 2 years 6 months ago #20792 by mdspeirs
Windows Server 2012 R2AETLE 6.3.7.12We are decrypting a file using a key with no phase phrase. AELTE is adding "Passphrase" into the command arguments even though the input is empty. The object does actually decrypt the file, but throws an error.
Attachments:
Last edit: 2 years 6 months ago by mdspeirs.
The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

More
2 years 6 months ago #20793 by admin
That should be easy to address we will have a look at it for you.
Thank you for the feedback

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
2 years 6 months ago #20794 by Peter.Jonson
Hello

We have modified the source so when no passphrase is present it is not included in the command.

Please try the latest version and let us know the outcome.

Other changes are:

17/03/2021 - 6.3.7.14

+ Added: Extract Attachments option to IMAP4 and POP3 reader
+ Added: Email footer message
+ Added: Cache option to "Get Excel Cell Value Dynamic" transformation function
+ Improved: When the application starts it will ask the user "Reopen last objects? (It will only happen if reopen tabs option is checked)
- Removed: IP Location, URL Location and Url Shortener transformation functions
- Removed: Transformation type toolbar from the mapping designer
- Fixed: Issue with empty decryption passphrase
- Fixed: Licence management issues
- Fixed: Schedule table backup/restore issues

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
1 year 11 months ago #21348 by ae
I have recently picked up mdspeirs's work after he moved on to another role. There was not a lot of time for handover and AETLE is new to me so please bear with the newbie questions.

I am having issues with other packages that he wrote which decrypt incoming files from a client.
There are daily scheduled processes which run packages that contain GPG objects that decrypt files.

The GPG objects are all configured without a passphrase. When they run via the schedule they all report an error but do succeed in decrypting the file. An example from the logs is attached.



I have tried running some of the packages manually but they always fail - as in they report an error and do not decrypt the file.

I expect that a key is needed to decrypt the files and that the user which runs the schedules has that key. What I can't find is where AETLE has that key stored or how it knows to use it.

The other question I have is why do the processes always report an error but still succeed in decrypting the file?

Thanks

AETLE v 6.3.7.18
Attachments:

Please Log in or Create an account to join the conversation.

More
1 year 11 months ago #21349 by admin
Our software is using GPG for description/encryption (Gpg4Win)
When GPG.exe returns 0 the execution is successful.
Anything else is a failure.
This is standard behaviour on windows.
I assume that you are using an execution agent.
There is a chance that when GPG.exe is executed it prints some warnings/error messages
But you cannot see the message because gpg.exe is executed from the windows service (execution agent).
Can you put > log.txt into the additional parameters box?
It might give you an idea of what is going on.

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
1 year 11 months ago #21350 by ae
Hi Mike

Thanks for getting back to me.
I have tried adding the parameter but it has not made any difference and I can't see any output being produced anywhere.
Can you suggest anything else I can try?


Could you answer my second question from above please? How does AETLE know where to look for the decryption key?

Thanks
Attachments:

Please Log in or Create an account to join the conversation.