Google Agenda : Blank page when using authorize Button in user profile

💬 General Discussion
1

Hello,

I follow the procedure from https://docs.suitecrm.com/admin/administration-panel/google-sync/.
All il good instead for the user authentification. I’ve got en blanck page when i clic on this button.
I test on different browser and idem.
My conf :
Suitecrm 7.11.2
OS: Debian 9
PhP: 7.3

thanks a lot for your help

Modadi

2

Have you checked your logs for any messages when you get the blank screen?

3

Hi,

Here is the last log from suitecrm.log

Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][INFO] Query Execution Time:0.0002741813659668
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][DEBUG] Hook called: Users::after_retrieve
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][DEBUG] FACTOR AUTH: -------------------------------------------------------------
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][DEBUG] FACTOR AUTH: --------------------- CHECK FACTOR AUtH ---------------------
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][DEBUG] FACTOR AUTH: -------------------------------------------------------------
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][DEBUG] FACTOR AUTH: User needs factor auth, request is not Logout
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][DEBUG] FACTOR AUTH: User does`nt need factor auth
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][DEBUG] Current user is: xxxxxxx
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][DEBUG] Current user is: xxxxxxx
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][DEBUG] setting cookie ck_login_id_20 to e944f36c-07cb-368e-85bc-44f1c2fca420
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][DEBUG] setting cookie ck_login_language_20 to fr_FR
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][DEBUG] current_language is: fr_FR
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][INFO] Found language file: en_us.lang.php
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][INFO] Found language file: fr_FR.lang.php
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][INFO] Found extended language file: en_us.lang.ext.php
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][INFO] Found custom language file: en_us.lang.php
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][INFO] Found extended language file: fr_FR.lang.ext.php
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][INFO] Found custom language file: fr_FR.lang.php
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][FATAL] Exception handling in /var/www/suitecrm/include/MVC/Controller/SugarController.php:400
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][FATAL] Exception in Controller: missing the required redirect URI
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][FATAL] backtrace:
#0 /var/www/suitecrm/vendor/google/apiclient/src/Google/Client.php(339): Google\Auth\OAuth2->buildFullAuthorizationUri(Array)
#1 /var/www/suitecrm/modules/Users/GoogleApiKeySaverEntryPoint.php(166): Google_Client->createAuthUrl()
#2 /var/www/suitecrm/modules/Users/GoogleApiKeySaverEntryPoint.php(149): GoogleApiKeySaverEntryPoint->handleRequestGetnew()
#3 /var/www/suitecrm/modules/Users/GoogleApiKeySaverEntryPoint.php(122): GoogleApiKeySaverEntryPoint->handleRequest()
#4 /var/www/suitecrm/modules/Users/GoogleApiKeySaverEntryPoint.php(98): GoogleApiKeySaverEntryPoint->handleEntryPoint()
#5 /var/www/suitecrm/modules/Users/entryPointSaveGoogleApiKey.php(57): GoogleApiKeySaverEntryPoint->__construct(Object(User), Array, Object(Google_Client), Array)
#6 /var/www/suitecrm/include/MVC/Controller/SugarController.php(1020): require_once(’/var/www/suitec…’)
#7 /var/www/suitecrm/include/MVC/Controller/SugarController.php(468): SugarController->handleEntryPoint()
#8 /var/www/suitecrm/include/MVC/Controller/SugarController.php(373): SugarController->process()
#9 /var/www/suitecrm/include/MVC/SugarApplication.php(113): SugarController->execute()
#10 /var/www/suitecrm/index.php(52): SugarApplication->execute()
#11 {main}
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][DEBUG] Hook called: ::handle_exception
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][DEBUG] Hook called: ::server_round_trip
Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][DEBUG] Calling MySQLi::disconnect()

It’s possible that this line : "Fri Mar 8 09:22:06 2019 [4150][e944f36c-07cb-368e-85bc-44f1c2fca420][FATAL] Exception in Controller: missing the required redirect URI " include the error.
So my public URL refereal to an ip + port (ex: http://crm.xxxxxx.xx refer to http://xx.xx.xx.xx:XXXXX) i’m not sure but i could be reason to this failure.
Thanks for your help

Modida

4

Hi,

I change the dns to my crm with a full ip and the Google authorization works fine…

Thank you anyway :cheer: