Google Settings Error: redirect_uri_mismatch

1

Hey guys,
So I have followed the erpnext documentation on setting up Google Settings for Google Calendar and Google Drive

However, upon authorisation of access the error 400 appears Error: redirect_uri_mismatch

The redirect URI set in google cloud platform is this: http://URL RETRACTED?cmd=frappe.integrations.doctype.google_drive.google_drive.google_callback

The redirect URI appearing in the on the error page however, is very very different: http://URL RETRACTED:8001?cmd=frappe.integrations.doctype.google_drive.google_drive.google_callback, does not match the ones authorized for the OAuth client. To update the authorized redirect URIs, visit: https://console.developers.google.com/apis/credentials/oauthclient/587641976614-tvk20sobndofsk3o39bmpkoqvheci032.apps.googleusercontent.com?project=587641976614

I have retracted the erpnext URL for privacy reasons but please observe the added port :8001 to the URL

This seems to be connected to the concept where any links added in erpnext emails do not work… same port is added automatically although we are not accessing erpnext on that port.

2

Hello ERPNext Team

Hope you are all well!

Having the same problem here too redirects to

  • internal port 8000

when google would be accessing

  • external port 443 or 80

Any fixes for this?

Kind regards Ryder

3

i have the same problem . my erpnext website port is 70 . google drive is directing me to the router page which port is 80 . if i change the redirect website to port 70 in google drive api, it gives me an error :point_down:

“The redirect URI set in google cloud platform is this: http://URL RETRACTED?cmd=frappe.integrations.doctype.google_drive.google_drive.google_callback”

4

I’m noticing this too. I’m not using the built-in Traefik router, but HAProxy at my network edge to proxy connections from web on 443 to ERPNext on 80. The response URLs are being sent to O365 as http:///api/* instead of https:///api*. It’s not immediately obvious to me how to change this configuration. Is there a config for this somewhere, or do I need to somehow rewrite these?

5

set “host_name” key as the base url of site in site_config.json

5 Likes
6

Thank you for pointing me at that! That fixed the issue I was having ! :blush:

7

I’m having the same issue.

I’ve changed the host_name in config but Google is still trying to connect to port 8000.

https://mydomain.com:8000?cmd=frappe.integrations.doctype.google_drive.google_drive.google_callback

I’m running on development mode so perhaps I need to change the default bench port from 8000 to 80???

Thank you for your help.

8

That fixed my issue too. Thanks a lot

9

So simple ! Thanks a lot.

10

don’t understand what to do . can anyone explain ?

11

Hi, I’ve added host_name with https://example.com in site config inside the docker container. But that’s not helped me. So, after half an hour researching on docker compose i’ve found a temporarily solution is add another port mapping (8000:443) in overrides/compose.https.yaml. and add port example.com:8000 to the google api callback uri.

12

Ok, thanks you for pointing to the site_config.json file , typo in the address, it solved partially my problem.

I had to add the following URI to the API credentials to get this totally working

https://MY_SITE/api/method/frappe.integrations.google_oauth.callback

13

thank you it works