Sending Email using Gmail - Stopped working

rmatt

Hello,

I'm running Apex - 20.1

A couple of weeks ago around the 12th of August, my Apex instance stopped sending emails. The error is ORA-29024: Certificate validation failure. The certificate says it is valid until December but maybe Google changed something. I have tried over 30 certificates at this point and continue to get the same error. Am I missing something?

Around this same time, my organization renewed its Google Workspace contract which did change versions. Given the time frame, I'm thinking Google changed something, I have a ticket in with them but they are playing the finger-pointing game. I thought I would ask and at least see if I'm missing something.

My ACLs have not changed. The email account its self hasn't changed and I do have the "less secure apps" enabled. I have tried with and without an SMTP relay.

Thanks

jariola

Seems others have similar problem

https://community.oracle.com/tech/developers/discussion/4487956/oracle-apex-21-1-patch-set-bundle-3-ora-29024-certificate-validation-failure

Maybe you check wallet certificates

jariola

Seems others have similar problem

https://community.oracle.com/tech/developers/discussion/4487956/oracle-apex-21-1-patch-set-bundle-3-ora-29024-certificate-validation-failure

Maybe you check wallet certificates

rmatt

@jariola Thanks for the quick response. That thread had someone that said to add all the certs from https://pki.goog/repository/. After doing so it worked. I did narrow it down to the cert that works which is GTS ROOT R1. I was 99% certain that I tried that one but if it works it works.

Thanks

gencon

Google has one root certificate which expire in December this year.

So It seems that they are busy updating their servers with a new one, but not all servers have been updated. So sometime you hit a server with the old certificate & sometime you hit a server with new certificate.

Both certificates (+ intermediate) must be in your wallet.