Google Calendar Sync - New Users Not Connecting

[showard]

We have Google Calendar sync up and running beautifully for one admin user, but now find that we can't get any new users to connect with the calendar sync. We have spent a couple of months testing EspoCRM (and really liking it) with just the admin user and two other users who do not need calendar sync. Now that we are adding new users who need calendar sync, it is not working.

For a new user, we go through all the connect processes, and ultimately get to the "EspoCRM rocks!" page. But the red "Connect" button stays red, never changing to the green "Connected" button. Also, a wait message pops up at the top of the screen, and never goes away.

I tried adding in a new user as an admin (since the current admin user is syncing just fine). But that does nothing. All of the access permissions and settings seem to be correct, but it is still only the one admin user that can sync his calendar.

Checked the log files, and found the following:

[2018-05-14 21:36:01] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [2002] No such file or directory" at /opt/bitnami/apps/espocrm/htdocs/application/Espo/ORM/EntityManager.php line 157 {"exception":"[object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory at /opt/bitnami/apps/espocrm/htdocs/application/Espo/ORM/EntityManager.php:157)"} []
[2018-05-14 21:37:01] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [2002] No such file or directory" at /opt/bitnami/apps/espocrm/htdocs/application/Espo/ORM/EntityManager.php line 157 {"exception":"[object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory at /opt/bitnami/apps/espocrm/htdocs/application/Espo/ORM/EntityManager.php:157)"} []
[2018-05-14 21:38:01] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [2002] No such file or directory" at /opt/bitnami/apps/espocrm/htdocs/application/Espo/ORM/EntityManager.php line 157 {"exception":"[object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory at /opt/bitnami/apps/espocrm/htdocs/application/Espo/ORM/EntityManager.php:157)"} []
[2018-05-14 21:39:01] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [2002] No such file or directory" at /opt/bitnami/apps/espocrm/htdocs/application/Espo/ORM/EntityManager.php line 157 {"exception":"[object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory at /opt/bitnami/apps/espocrm/htdocs/application/Espo/ORM/EntityManager.php:157)"} []
[2018-05-14 21:40:02] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [2002] No such file or directory" at /opt/bitnami/apps/espocrm/htdocs/application/Espo/ORM/EntityManager.php line 157 {"exception":"[object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory at /opt/bitnami/apps/espocrm/htdocs/application/Espo/ORM/EntityManager.php:157)"} []

Any thoughts, advice, or assistance would be much appreciated.

[tanya]

Hi,
check the url, you use. Is it the same as in Google console? Is it public?
the most often problem is mixed using http and https and using local IP address.

[showard]

The URLs match, both with https:

https://mydomain.com/espocrm?entryPoint=oauthCallback

https://mydomain.com/espocrm?entryPoint=oauthCallback

Calendar sync is working great for the original admin user. But none of the new users can get it to connect.

[tanya]

https://forum.espocrm.com/forum/extensions/35189-google-calendar-sync-not-working-advanced-pack

what is in user's access?

[showard]

Access for both the individual user and the user's assigned role includes Calendar, External Accounts, and Google Calendar.

I also tried reassigning one of the new users as an admin, but that still didn't let the user connect to calendar sync.

[tanya]

The problem is - administrators have no prohibits with the Roles. And it's weird, that roles modification helped you before

[showard]

I just tried creating a brand new user as an admin, with the same results - new users still can't sync. (Original admin still syncing fine.)

In the Firefox developer's console, it shows the following errors that just keep repeating:

SecurityError: Permission denied to access property "href" on cross-origin object
espo.min.js:277
unreachable code after return statement[Learn More]
espo.min.js:206:12
SecurityError: Permission denied to access property "href" on cross-origin object
espo.min.js:277

[tanya]

Do users use the same url for crm access, as is set in site url parameter in settings?

Similar topics and solutions

https://forum.espocrm.com/forum/exte...nect-to-google
https://forum.espocrm.com/forum/deve...ssues-question

If nothing helps, try to create a new Credentials and change the integration settings and reconnect for you Admin

[showard]

All users use the same URL for CRM access.

I tried creating a new set of Credentials, changed the integration settings in Espo. Neither new users nor the original admin account could sync using the new credentials.

I then tried reseting the Espo integration settings to the original Google Credentials, and the original admin account can't sync with those credentials either.

So now, nobody can use calendar sync at all.

[tanya]

Press Disconnect -> refresh the page and try connect again

[showard]

Tanya,

I finally figured it out - thanks to your question about whether users are all accessing the CRM from the same URL. I thought they were. But it turns out a www. was being added in front of mydomain.com.

The www made all the difference. It was what was causing the cross-origin errors.

Once Espo is connected to Google, then the system doesn't seem to care whether the www is included in the URL - it seems to sync just fine. But it has to be an exact match when initially connecting a new user.

Thank you so much for walking me through this.

[tanya]

Nice to read, that everything is ok