Pentaho

 View Only

 email from basic authentication to modern autentication

Albert-Jan Visser's profile image
Albert-Jan Visser posted 08-22-2022 04:35
Hi ,
we are using pentaho pdi 8.0 end retrieving mail from office 365 with basic autentication.

now MS is upgrading to modern autentication, but we can not find a way to make this work , is there a solution for this ?
Andrew Cave's profile image
Andrew Cave posted 08-22-2022 19:41
Hi Albert

You might try the technique here https://www.cdata.com/kb/tech/office365-jdbc-pentaho-report-designer.rst but adjusted for pentaho (tip: use generic database connection so you can define the jdbc string)
Juan Sierra Pons's profile image
Juan Sierra Pons posted 08-24-2022 07:45
Hi,

I have read (I don't remember where) that copying the javax.mail-1.6.1.jar from Pentaho-9.3 to your Pentaho-8.0 works. NOT TESTED

What I am using (TESTED) is creating a tunnel between your Pentaho and the O365 SMTP servers. It is explained here: https://community.spiceworks.com/how_to/50057-mail-relay-to-office-365-using-stunnel

So you send the email in cleartext to the stunnel daemon and then the stunnel daemon does all the SSL/TLS protocol negotiation

Hope it helps

Best regards
Mark Campbell's profile image
Mark Campbell posted 09-28-2022 17:46
Hi Alberyt-Jan Visser.  
I am using pentaho pdi 8.1 and have the same problem.  I am having trouble writing a custom java class to implement microsoft's modern token authentication.  Were you able to solve this issue?
Albert-Jan Visser's profile image
Albert-Jan Visser posted 10-06-2022 03:15
No we were not able to solve this yet

Related Content