Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

prompting for Passphrase in the automated job

Hello

 

I'm stuck at a point in my automated job. I have given all the details regarding decryption in the job and its automated. During the scheduled run its asking for a passphrase to enter manually and the job is failing. I've given the passphrase in the context as well. I used kleopatra to generate my public key. I'm not understanding how to stop it from prompting me a passphrase. Please help me out if there is a solution.

 

Thanks,

Surya.

Labels (2)
4 Replies
Anonymous
Not applicable
Author

Hello,

Would you  mind posting your automated job setting screenshots on forum?

Best regards

Sabrina

Anonymous
Not applicable
Author

Hello @xdshi,

 

I've actually found a solution and its not prompting me for a passphrase anymore in the scheduled job.

Instead of using tGPGdecrypt we used tsystem component.

we've created a windows batch file with this below command

gpg --pinentry-mode=loopback --passphrase %1 -o %2 -d %3

where,

%1- "YOUR PASSPHRASE"

%2- DESIRED OUTPUT FILE PATH

%3- ENCRYPTED SOURCE FILE PATH

We call this batch file in tsystem as given below

context.Batch_job + " " +context.v_passphrase + " " + context.Output_file + " " + context.src_file

where context.batch_job- "D:\Code\emp_decrypt.bat"

Hope this helps others.

Wills
Contributor
Contributor

Hi - Thanks, I spent ages trying to find a solution for this and your post geve me the answer I was looking for. 

 

I've found that you don't necessarily need a separate batch job as it is possible to use the tGPGdecrypt component with this solution:

GPG Binary path = "C:/Progs/GnuPG/bin/gpg.exe","--batch", "--pinentry-mode=loopback"

 

Talend OS for BigData 7.0.1

 

 

 

Anonymous
Not applicable
Author

@Wills1 

 

Glad it helped you in some way.