Official SuiteCRM Outlook Plugin

Hi Julian

This issue looks like it may be an issue connecting with the API on the CRM side.

Can you try in a browser navigating to {your crm url}/Api/access_token e.g https://mycrm.com/Api/access_token and seeing what response you get.

You should get a response "Method not allowed",

If not and you get a error, you may need to look at configuring the API on your CRM server. if that is the case then the guide here may help you https://docs.suitecrm.com/developer/api/developer-setup-guide/json-api/#_generate_private_and_public_key_for_oauth2

Dear team, thank you for your quick response. Indeed, I cannot open the url. The document is not found. I tried to follow your guide, but I don't get along with the second part "Authentification". I cannot find a folder "Account" in den Folder /Api/V8 and I cannot even find a folder "V8" in the root directory of SuiteCRM. Can you give me a hint how to go on now? Thank you in advance.

Julian

Dear team, I am still in trouble with the add-on. Although I have read your link about the OAuth2 I don't find a solution for the authentification issue. I had a look into the "suitecrm.log", but I don't understand the error message.

Mon Sep 28 11:33:25 2020 [223300][1][FATAL] Mysqli_query failed.
Mon Sep 28 11:33:25 2020 [223300][1][FATAL] Error running count query for User List:  Query Failed: (SELECT count(*) c FROM users WHERE sa_outlook_is_licensed != 0 AND deleted 0): MySQL error 1054: Unknown column 'sa_outlook_is_licensed' in 'where clause'
Mon Sep 28 11:33:25 2020 [223300][1][FATAL] [ListView::processUnionBeans] . Datenbank Fehler. Bitte sehen Sie in der Datei suitecrm.log nach.

Can you tell me, what mistake I make, please? Thank you very much.

Dear team, thanks for the fast answer. After rebuilding the database, I saw the following error message in the browser:

/* Table : users */
/*COLUMNS*/
/*MISSING IN DATABASE - sa_outlook_sync_date -  ROW*/
/*MISSING IN DATABASE - sa_outlook_folders -  ROW*/
/*MISSING IN DATABASE - sa_outlook_enable -  ROW*/
/*MISSING IN DATABASE - sa_outlook_is_licensed -  ROW*/
/* INDEXES */
ALTER TABLE users   add COLUMN sa_outlook_sync_date datetime  NULL ,  add COLUMN sa_outlook_folders text  NULL ,  add COLUMN sa_outlook_enable bool  DEFAULT '0' NULL ,  add COLUMN sa_outlook_is_licensed bool  DEFAULT '0' NULL ;

What do I have to do to eliminate this errors? Thank you in advance.

Dear team, thanks for the help. I was a bit shy to change the database. After adding the columns to the database I rebuilt it, but the login error from outlook still exists. Regarding the "suitecrm.log" file, I see the following logs:

Mon Sep 28 13:15:04 2020 [223809][1][FATAL] Invalid or missing SubPanelDefinition property: subpanel_name
Mon Sep 28 13:15:04 2020 [223809][1][FATAL] Failed to load original or custom subpanel data for outlook_users in
Mon Sep 28 13:16:48 2020 [223303][1][FATAL] SugarBean::populateDefaultValues $field_defs should be an array

What is the meaning? Where can I add the SubPanelDefinition property? Thank you! Best regards

Julian

so if you go into the admin section of your CRM, then go the outlook Plugin admin section, at the bottom of the page there should be a Users sub-panel do you see that, doe sit load successfully?

What error do you get on login now?

have you created the private and public keys like we suggested above https://docs.suitecrm.com/developer/api/developer-setup-guide/json-api/#_generate_private_and_public_key_for_oauth2

Can you try in a browser navigating to {your crm url}/Api/access_token e.g https://mycrm.com/Api/access_token and seeing what response you get.

what result does this give now?

what is you server setup for the CRM are you using Linux? Apache, php-fpm, nginx, windows, something else?

ok it sound like you crm is potentially not setup correctly

I would guess it may be the Apache definition

So I would suggest you check you Apache config for the CRM and it should be setup with something like the example below, with key point AllowOveride set to All, this is required for the Htacess to take effect

<Directory {SuiteCRM directory}>
    Options Indexes FollowSymLinks
    AllowOveride All
    Require all granted
</Directory>

If you need to set AllowOveride to all then restart/reload Apache and try again

When repairing and rebilding the databases, there is a comment:

OAuth2TokensAudit not active...
OAuth2ClientsAudit not active...

Is this relevant?

Did you find a solution ? I have the same problem.