Announcement

Collapse
No announcement yet.

Google Calendar Sync - New Users Not Connecting

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Google Calendar Sync - New Users Not Connecting

    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.

  • #2
    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.

    Comment


    • #3
      The URLs match, both with https:




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

      Comment


      • #4
        I am running EspoCRM 5.0.5, with the advanced pack 1.30.7, and cannot get the google calendar sync to work. All appears to be installed correctly with OAuth2.0

        what is in user's access?

        Comment


        • #5
          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.

          Comment


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

            Comment


            • #7
              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
              Last edited by showard; 05-16-2018, 07:41 PM.

              Comment


              • #8
                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
                Last edited by tanya; 05-16-2018, 11:20 AM.

                Comment


                • #9
                  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.

                  Comment


                  • #10
                    Press Disconnect -> refresh the page and try connect again

                    Comment


                    • #11
                      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.
                      Last edited by showard; 05-16-2018, 07:42 PM.

                      Comment


                      • #12
                        Nice to read, that everything is ok

                        Comment

                        Working...
                        X