Cannot Connect to Google

[tobias]

We've setup the "Integration" for Google and the "Scheduled Job" is up and running (no errors in either Espo or the log file).

However, adding and connecting the "External Account" from Google wouldn't work, we receive an error 400 "invalid_scope" in the oauth screen.

Note that your setup guide https://www.espocrm.com/features/google-calendar-sync/ no longer reflects what the Google Developer Console really looks like - check out the attached screenshots.

Please help.

[tanya]

Hello
Through that “Learn More” link, it explains that Google is verifying and authorizing API developers in order to protect users. But Google also explains that there are certain cases where this verification and authorization is not necessary. And for that they have the risky apps group.

https://groups.google.com/forum/#!forum/risky-access-by-unreviewed-apps

[joy11]

I was working on this last week as well. I didn't have time to go through the developer authentication so I thought I'd revisit it later. With this tip, I figured I'd try it again and I'm on the setup sync for users step now. In the user profile>external accounts > Google, I click on connect and it brings up a pop-up window that allows me to select my google account. Then it wants me to give permission so I allow it. The popup says "EspoCRM Rocks" and is blank and the CRM has a "Please Wait" bar. It seems to get stuck at that spot. Is there something else I should try?

[tanya]

Could you open a browser console and check for errors?

[joy11]

This is the error that is coming up in the developer console. It's generating the same error over and over.

VM876:275 Uncaught DOMException: Blocked a frame with origin "https://crm.domain.com" from accessing a cross-origin frame. at eval (eval at _execute (https://crm.domain.com/client/espo.m...57203:16:26553), <anonymous>:275:54)

[tanya]

this error shows while popup is open.
it is interesting, what happens, when you click Allow button

[joy11]

After I click the Allow button the popup goes blank except for the text: EspoCRM Rocks !!!

[tanya]

After the text: EspoCRM Rocks !!!, popup has to be closed and the status on the main window goes to connected. Is not it?

[joy11]

It doesn't connect and the "Please wait..." bar is still on the main screen. I've waited to see if anything happens, but eventually, after quite some time I just left the screen or refreshed the page.

[tanya]

Any records related to the integartion in espocrm log (data/logs)? did you check browser console in the main tab?

[joy11]

Espo log has no errors. The "VM876:275 Uncaught DOMException" error that shows up is in the main console and acts like it is in a loop while I have the popup open. It will keep producing the same error and makes the error counter go up until the popup is closed.

The popup window console view does not show any errors.

When I click on the error in the main console it points to this line 275 in the popup: function (options, callback).

popup = window.open(path, options.windowName, options.windowOptions);
interval = window.setInterval(function () {
if (popup.closed) {
window.clearInterval(interval);
} else {
***** var res = parseUrl(popup.location.href.toString()); *******
if (res) {
callback.call(self, res);
popup.close();
window.clearInterval(interval);
}
}
}, 500);



(I'm on most current version of Espo and Advance Pack)

[tanya]

No errors in espocrm, no errors in javascript.... hard to imagine the reason. Check in browser console Network tab. Which request is loading? Has any response or just hanging? Check also apache error log (if you use apache server)

[joy11]

After looking into it a bit more we noticed that in the integrations section the Redirect URI was set to Http and we're using Https. In the $ESPO_PATH/data/config.php we updated 'siteUrl' to https instead of http. That seemed to fix the issue and we're connected now! Thanks for your help troubleshooting, Tanya.

[lahore]

Hi

I am unable to connect to Google account. Could somebody help ?

get below given error in the data/log file.

[2018-02-07 08:54:36] Espo.ERROR: API [POST]:/:controller/action/:action, Params:Array ( [controller] => ExternalAccount [action] => authorizationCode ) , InputData: {"id":"Google__xxxxxxxxxxxxxxxxxxx","code":"4/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx#"} - Could not resolve host: accounts.google.com [] []

The button is not green "connected". After the popup window is closed, I just get a status bar "Please wait" and then nothing happens. After a while, I get a message "Time out".

How can I make it work ? Please help!

Below is the output from the webserver's access log:

83.92.5.125 - axel [07/Feb/2018:06:39:03 +0100] "GET /api/v1/Activities/action/popupNotifications HTTP/1.1" 200 2
83.92.5.125 - axel [07/Feb/2018:06:39:04 +0100] "GET /api/v1/Activities/action/popupNotifications HTTP/1.1" 200 2
83.92.5.125 - axel [07/Feb/2018:06:39:04 +0100] "GET /api/v1/Notification/action/notReadCount HTTP/1.1" 200 1
83.92.5.125 - axel [07/Feb/2018:06:39:08 +0100] "GET /api/v1/Notification/action/notReadCount HTTP/1.1" 200 1
83.92.5.125 - axel [07/Feb/2018:06:39:10 +0100] "GET /api/v1/Activities/action/popupNotifications HTTP/1.1" 200 2
83.92.5.125 - axel [07/Feb/2018:06:39:15 +0100] "GET /api/v1/Notification/action/notReadCount HTTP/1.1" 200 1
83.92.5.125 - axel [07/Feb/2018:06:39:18 +0100] "GET /api/v1/Notification/action/notReadCount HTTP/1.1" 200 1
83.92.5.125 - - [07/Feb/2018:06:39:18 +0100] "GET /?entryPoint=oauthCallback&code=4/_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx HTTP/1.1" 200 17
83.92.5.125 - axel [07/Feb/2018:06:39:19 +0100] "GET /api/v1/Activities/action/popupNotifications HTTP/1.1" 200 2
83.92.5.125 - axel [07/Feb/2018:06:39:19 +0100] "GET /api/v1/Activities/action/popupNotifications HTTP/1.1" 200 2
83.92.5.125 - axel [07/Feb/2018:06:39:26 +0100] "GET /api/v1/Activities/action/popupNotifications HTTP/1.1" 200 2
83.92.5.125 - axel [07/Feb/2018:06:39:26 +0100] "GET /api/v1/Notification/action/notReadCount HTTP/1.1" 200 1
83.92.5.125 - axel [07/Feb/2018:06:39:28 +0100] "GET /api/v1/Notification/action/notReadCount HTTP/1.1" 200 1
83.92.5.125 - axel [07/Feb/2018:06:39:34 +0100] "GET /api/v1/Activities/action/popupNotifications HTTP/1.1" 200 2
83.92.5.125 - axel [07/Feb/2018:06:39:35 +0100] "GET /api/v1/Activities/action/popupNotifications HTTP/1.1" 200 2

[tanya]

Hello
It looks like the server doesn't have internet access. Is it possible?
I found this https://stackoverflow.com/questions/...vice-not-known

[lahore]

Dear Tanya

Thanks for your comments. But it still not work and I am told from my boss to ask for a refund as it is not working for us... please help if you can, thanks!

[tanya]

Create a case in Customer Portal, please.

[lahore]

Can you send me the link to Customer Portal ? Thanks in advance.

[lahore]

I have enabled IPv6 support with IPv6 configuration but it did not work... I have explicitly dispabled the ipv6 support but it does not work... I have added more nameservers addresses but it still does not work and says
Display Error: Could not resolve host: accounts.google.com, Code: 0 URL: /api/v1/ExternalAccount/action/authorizationCode []

[tanya]

https://stackoverflow.com/questions/24967855/curl-6-could-not-resolve-host-google-com-name-or-service-not-known

Issues were:[LIST=1][*]IPV6 enabled[*]Wrong DNS server[/LIST]