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.
    Job Offers and Requests

    Find Developer
    Find Customer

    Comment


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

      Comment


      • #4
        https://forum.espocrm.com/forum/exte...-advanced-pack
        what is in user's access?
        Job Offers and Requests

        Find Developer
        Find Customer

        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
            Job Offers and Requests

            Find Developer
            Find Customer

            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.
                Job Offers and Requests

                Find Developer
                Find Customer

                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
                    Job Offers and Requests

                    Find Developer
                    Find Customer

                    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
                        Job Offers and Requests

                        Find Developer
                        Find Customer

                        Comment

                        Working...
                        X