by SuiteCRM

Official SuiteCRM Outlook Plugin v4 has arrived - A complete plugin rebuild developed and maintained by SuiteCRM developers entirely from scratch, the addon retains previous functionality while massively improves performance, reliability and stability!

Free 30 day trial
Try it Now

#3097 - Authentification Fail

Closed Installation created by julianwegner 3 months ago

Dear sirs,
after installing the Outlook Plugin for SuiteCRM, I would like to authentificate the Plugin in Outlook. The error message says: An unknown error has occurred, please check input and try again.
Can you give me please a hint where I can get more precise information on this error.
Thank you in advance.
Best regards.

Julian

  1. suitecrm member avatar

    SuiteCRM Provider Affiliate

    3 months ago

    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

  2. julianwegner member avatar

    julianwegner

    3 months ago

    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

    • julianwegner member avatar

      julianwegner

      3 months ago

      Dear team,
      I am still busy on solving the iussue. Unfortunately, I did not get an answer to the question, why I do not find the Folder Accunt in my directory. Can you give me a hint about it?
      SuiteCRM will replace SalesForce in my company, as soon as I get the plugin running.
      Thanks

    • suitecrm member avatar

      SuiteCRM Provider Affiliate

      3 months ago

      the account folder is in modules e.g modules/Accounts but I not sure why you looking for this or what issue your are having with it?

    • julianwegner member avatar

      julianwegner

      3 months ago

      Dear team,
      the reason why I was still looking for this, is because the plugin does not work and I am not sure where to find the error. This was a point which does not correspond to the manual.
      Can you please give me a hint about the entries in the log file, please?
      Plase let me know, if you need more information.
      Thanks a lot.

  3. julianwegner member avatar

    julianwegner

    3 months ago

    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.

    • suitecrm member avatar

      SuiteCRM Provider Affiliate

      3 months ago

      You may wish to check that your database is sync with the CRM, to do this go into 'Admin' the select 'Repair' and then run 'Quick Repair and Rebuild'

      Once this is complete scroll down to the bottom of the screen and it will highlight if there are any database inconsistencies and it will give you opportunity to correct them , if so run that,

      Repeat the step and run the repair again to make sure the database is now in sync and try again on outlook.

  4. julianwegner member avatar

    julianwegner

    3 months ago

    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.

    • suitecrm member avatar

      SuiteCRM Provider Affiliate

      3 months ago

      'Execute' the changes on the screen, it should give you the option

  5. julianwegner member avatar

    julianwegner

    3 months ago

    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

  6. suitecrm member avatar

    SuiteCRM Provider Affiliate

    3 months ago

    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?

    • julianwegner member avatar

      julianwegner

      3 months ago

      Yes, it is loaded. I have added the admin user for testing. How should I go on?

    • julianwegner member avatar

      julianwegner

      3 months ago

      But the authentication is not successful either

  7. suitecrm member avatar

    SuiteCRM Provider Affiliate

    3 months ago

    What error do you get on login now?

    • julianwegner member avatar

      julianwegner

      3 months ago

      An unknown error has occurred, please check input and try again.

    • julianwegner member avatar

      julianwegner

      3 months ago

      Is it correct, that there are no active OAuth2 tokens?

  8. suitecrm member avatar

    SuiteCRM Provider Affiliate

    3 months ago

    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?

    • julianwegner member avatar

      julianwegner

      3 months ago

      I checked once again the keys, but I still get the error: The requested URL was not found on this server.

  9. suitecrm member avatar

    SuiteCRM Provider Affiliate

    3 months ago

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

  10. suitecrm member avatar

    SuiteCRM Provider Affiliate

    3 months ago

    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

    • julianwegner member avatar

      julianwegner

      3 months ago

      Thank you very much. This was the mistake. This case can be closed. :)

  11. julianwegner member avatar

    julianwegner

    3 months ago

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

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

    Is this relevant?

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...