Hi,
I've been using ‘social sign-in’ for a few years, using Google for single sign-in to my application and its been working perfectly. Within the past day or so it stopped working and when I tracked it down, i'm getting a certificate validation error.
I've renewed all of my certificates in my Oracle Wallet but i'm still getting certificate validation error. I even get the error if I use apex_webservice.make_rest_request('https://google.com','GET').
I've tried adding the all the certificates in this chain; adding just the root; adding just the lowest level and can't seem to get it working again.
# openssl s_client -showcerts -connect google.com:443
CONNECTED(00000003)
depth=3 C = BE, O = GlobalSign nv-sa, OU = Root CA, CN = GlobalSign Root CA
verify return:1
depth=2 C = US, O = Google Trust Services LLC, CN = GTS Root R1
verify return:1
depth=1 C = US, O = Google Trust Services, CN = WR2
verify return:1
depth=0 CN = *.google.com
verify return:1
I tried adding the certificate for microsoft.com and used make_rest_request and that worked fine.
Is anyone else having any SSO issues with Google that maybe started in the past few days?
I'm running Apex v20 in Oracle 18 express edition.
Thanks,
Paul.