topic Re: Problem tSendMail Office365 in Talend Studio

Problem tSendMail Office365

gcurato82 — Fri, 15 Nov 2024 23:11:06 GMT

hello to all,

I use "Talend Open Studio for Data Integration Version: 7.3.1" and am experiencing a problem with the tSendMail component using my Office365 account.

I have already modified, as indicated in other posts, the file java.security deleting the values TLSv1, TLSv1.1 from the line jdk.tls.disabledAlgorithms, I still receive the error message: "javax.mail.AuthenticationFailedException".

I have already verified the account settings and also the user and password, I have no problems in authentication, the problem is when I try to use the Talend component.

Does anyone know how I can fix this?

Re: Problem tSendMail Office365

Anonymous — Tue, 22 Feb 2022 18:32:54 GMT

Can you show your connection config on the component please? No need to for passwords or email addresses, but I'd like to see the host and port configuration as well as the other settings.

Re: Problem tSendMail Office365

gcurato82 — Wed, 23 Feb 2022 08:39:25 GMT

Thanks for getting back to me.

the configuration parameters, were taken from the microsoft site, I attach image.

I have already verified username and password

Re: Problem tSendMail Office365

Anonymous — Wed, 23 Feb 2022 09:55:28 GMT

Can you try ....

smpt.outlook.office365.com

....as the host?

Re: Problem tSendMail Office365

gcurato82 — Wed, 23 Feb 2022 09:59:36 GMT

this is the message that is given to me if I try to run with the suggested host:

Exception in component tSendMail_1 (testSendMail)

javax.mail.MessagingException: Unknown SMTP host: smpt.outlook.office365.com;

Re: Problem tSendMail Office365

Anonymous — Wed, 23 Feb 2022 10:27:46 GMT

Sorry, typing error. I meant....

smtp.outlook.office365.com

Re: Problem tSendMail Office365

gcurato82 — Wed, 23 Feb 2022 11:41:19 GMT

always...

Exception in component tSendMail_1 (testSendMail)

javax.mail.AuthenticationFailedException

Re: Problem tSendMail Office365

Anonymous — Wed, 23 Feb 2022 14:19:14 GMT

Sorry about the time taken to respond, I thought this would do it for you. I am using the tSendMail in exactly the same way as you (but with the host I mentioned above) and it works perfectly for me.

The one thing I did noticed when I was playing around to try and recreate your issue was that if I am on a VPN I do have some issues with this configuration. But I don't get the authentication error you speak of.

The only other thing I can think of is this KB article....

https://community.talend.com/s/article/Issue-with-tSendMail-and-TLS-version-ElVmA

Now I have not had to do this, but this *might* help.

Re: Problem tSendMail Office365

gcurato82 — Wed, 23 Feb 2022 14:23:38 GMT

Thank you for your help.

can you attach photos of the settings? so you can compare them with mine

Re: Problem tSendMail Office365

Anonymous — Wed, 23 Feb 2022 15:09:47 GMT

Here are my settings. I generally use Context variables, so I have shared my Context variables as well.

Re: Problem tSendMail Office365

gcurato82 — Wed, 23 Feb 2022 15:17:11 GMT

thanks for sharing your settings with me. I don’t understand where the problem may be, the settings are the same

Re: Problem tSendMail Office365

Anonymous — Wed, 23 Feb 2022 16:03:41 GMT

I agree. Did you follow the Knowledge Base article I shared with you?

I can't see your username. Is it essentially your email address? If it is, then we are definitely the same.

Re: Problem tSendMail Office365

gcurato82 — Wed, 23 Feb 2022 20:56:53 GMT

which article are you referring to? my nickname is _GC82_ ...

Re: Problem tSendMail Office365

Anonymous — Wed, 23 Feb 2022 21:06:31 GMT

This article @Giuseppe Curato ....

https://community.talend.com/s/article/Issue-with-tSendMail-and-TLS-version-ElVmA

When I said "I can't see your username" I meant on your screenshot 😂 I meant I cannot see whether we are using the same method for providing usernames for authentication. Sorry, when I look at that again, I wasn't terribly clear 🙂

Re: Problem tSendMail Office365

gcurato82 — Thu, 24 Feb 2022 08:22:51 GMT

Hi, I followed the instructions of the link you gave me.

But I can’t figure out what to do about step 9 "Make sure the Job runs with the property -Dmail.smtp.ssl.protocols=TLSv1.2."

Can you give me some details?

Re: Problem tSendMail Office365

Anonymous — Thu, 24 Feb 2022 10:01:03 GMT

You can find out how to set JVM settings for the job here....

https://help.talend.com/r/en-US/8.0/loqate-address-standardization/tloqateaddressrow-tfixedflowinput-tfileoutputexcel-tfileoutputexcel-setting-jvm-argument-and-finalizing-job-standard-component-enterprise

Re: Problem tSendMail Office365

gcurato82 — Sat, 26 Feb 2022 09:41:03 GMT

hello, I’m sorry I didn’t answer you, I was busy. thanks to your tips I managed to solve, the main problem was the java library, replaced that, it was only necessary to enable SMTP AUTH my user office365 as described in this link:

https://docs.microsoft.com/en-us/exchange/clients-and-mobile-in-exchange-online/authenticated-client-smtp-submission

thanks again

Re: Problem tSendMail Office365

Anonymous — Sat, 26 Feb 2022 14:29:07 GMT

Glad you got it sorted. Thanks for coming back and explaining how you did it 👍

Re: Problem tSendMail Office365

Hakim_Benmessaoud — Thu, 13 Oct 2022 14:12:23 GMT

Bonjour

Essaye d'importer un nouveau jar de javax