How 2 Guru

SugarCRM unable connect gmail

Recently working on the SugarCRM open source software. Due to some user requirement, I need to setup an inbound email (an email feature inside the SugarCRM) connect to gmail for downloading email using pop3.

After try few times, I found that the test setting is connecting successfully. But when the scheduler job try to establish the connection to gmail, it always fail. Finally, I found the problem is due to the invalid ssl cert and causing the connection failure. Below is the error that imap_open return to me

ERROR Certificate failure for pop.gmail.com: unable to get local issuer certificate: /C=US/O=Google Inc/CN=Google Internet Authority

I try to fix the problem by updating some of the inbound email setting to force the connection to use /novalidate-cert and it works. Below is the update statement.

UPDATE inbound_email 
SET service = "::::ssl::pop3::novalidate-cert::::::" 
WHERE id = '[INBOUND EMAIL ID]';