by eVolpe Consulting Group

Are you facing difficulties trying to coordinate efforts between marketing and sales? The Sugar/SuiteCRM & Mautic Integrator by eVolpe is the best solution that will help you solve this issue. TRY IT NOW FOR FREE!

Free 30 day trial
Try it Now

By clicking you consent to share your profile with the developer

#4346 - Unable to complete setup

Closed Installation created by tp 2 years ago

Hi,

I took the trial of your CRM Mautic Integrator.

Followed all steps but in the CRM Plugin section, step 2 - Connector Confgurator, I see the URL to configure in the mautic plugin, which I have done exact. But when I click on the LINK, it goes to Mautic instance and then when it come back to the CRM, I get 404 not found. I also checked the .htaccess and its correctly configured with the following

RewriteRule ^mautic_api/get_token index.php?entryPoint=MauticGetToken [L,QSA]

The URL configured is

https:///mautic_api/get_token

If I just try the URL it too gives the 404.

Mautic version is 2.16.2 and suitecrm is 7.11.13

Also no errors in the logs

Can you please advise.

  1. eVolpe_Consulting_Group member avatar

    eVolpe Consulting Group Provider

    2 years ago

    Hello,

    I forwarded your message to our development team. We will try to assist you as soon as possible.

    In the meantime, what version of PHP?

    Best regards, Maciej Jankiewicz eVolpe Support Team

    • tp member avatar

      tp

      2 years ago

      The version of Mautic PHP is 5.6 and the version for SuiteCRM PHP is 7.4

  2. eVolpe_Consulting_Group member avatar

    eVolpe Consulting Group Provider

    2 years ago

    Well, please check requirements: https://www.sugaroutfitters.com/docs/mautic-sugarcrm-integrator. We don't support PHP 7.4. at the moment.

    However, below you will find a solution that can help.

    Probably you configured wrong URL, for example if your Mautic and CRM instances have URL addresses: https://example.com/mycrm https://example.com/mymautic

    then you should setup following configuration ( https://www.sugaroutfitters.com/docs/mautic-sugarcrm-integrator/configuration-guide ) like this:

    • Step 2: Generate OAuth2 Credentials keys -- Redirect URI:_ http://example.com/mycrm/mautic_api/get_token,https://example.com/mycrm/mautic_api/get_token_

    • Step 3: Configure plugin Authorization -- SugarCRM/SuiteCRM URL: https://example.com/mycrm

    • Step 2: Connector configuration -- Mautic Instance URL: https://example.com/mymautic

    • tp member avatar

      tp

      2 years ago

      Well then your software does not support Suite CRM 7.11.13 as that requires the latest version of php to function properly. If we use older version of PHP, many modules of SuiteCRM don't work. Remove the 7.11.x in your list.

      Technically PHP should not matter unless you are using an deprecated API as its backward compatible.

      Thank you, I will cancel the trial.

  3. eVolpe_Consulting_Group member avatar

    eVolpe Consulting Group Provider

    2 years ago

    Well, I'm sorry to hear that, but you're wrong. Please check: https://docs.suitecrm.com/admin/compatibility-matrix/.

    For SuiteCRM 7.11.x: PHP 5.6, 7.0, 7.1, 7.2, 7.3 (starting from SuiteCRM 7.11.5)

  4. tp member avatar

    tp

    2 years ago

    Ok, so will you be able to solve this problem using 7.4? if you think thats the problem? I am happy to wait. But I need confirmation, else we already have plan B

  5. eVolpe_Consulting_Group member avatar

    eVolpe Consulting Group Provider

    2 years ago

    At this stage, we don't know yet. But we will do our best to provide you with the help and support you need.

    Please check these URL's above. I'm pretty sure that https:///mautic_api/get_token is invalid.

  6. tp member avatar

    tp

    2 years ago

    Ok I downgraded the PHP from php7.4 to php7.3 and did the reinstall once again. But still I get the following error after I click the LINK button in the connector in the CRM.

    Not Found The requested URL was not found on this server. Apache/2.4.18 (Ubuntu) Server at Port 443

    So I decided to uninstall the module and reinstall. After I did that, I went to license management the license key was already present and when I press the validate license I get an error next to the validate button which is as shown in the following image.

    Screenshot 2020-04-23 at 08.29.19.png

    I had also enabled the debug log of suitecrm and it shows the following

    Thu Apr 23 07:26:45 2020 [26834][1][INFO] Query Execution Time:0.00052309036254883 Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] Hook called: Users::after_retrieve Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] FACTOR AUTH: ------------------------------------------------------------- Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] FACTOR AUTH: --------------------- CHECK FACTOR AUtH --------------------- Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] FACTOR AUTH: ------------------------------------------------------------- Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] FACTOR AUTH: User needs factor auth, request is not Logout Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] FACTOR AUTH: User does`nt need factor auth Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] Current user is: admin Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] Current user is: admin Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] setting cookie ck_login_id_20 to 1 Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] setting cookie ck_login_language_20 to en_us Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] current_language is: en_us Thu Apr 23 07:26:45 2020 [26834][1][INFO] Found language file: en_us.lang.php Thu Apr 23 07:26:45 2020 [26834][1][INFO] Found extended language file: en_us.lang.ext.php Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] Module:Administration using file: ev_license_ws Thu Apr 23 07:26:45 2020 [26834][1][DEPRECATED] Array ( )

    Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] get_user_array query: SELECT id, first_name, last_name, user_name from users WHERE status='Active' AND portal_only=0 AND is_group=1 ORDER BY first_name, last_name ASC Thu Apr 23 07:26:45 2020 [26834][1][INFO] Query:SELECT id, first_name, last_name, user_name from users WHERE status='Active' AND portal_only=0 AND is_group=1 ORDER BY first_name, last_name ASC Thu Apr 23 07:26:45 2020 [26834][1][INFO] Query Execution Time:0.00029802322387695 Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] get_user_array query: SELECT id, first_name, last_name, user_name from users WHERE status='Active' AND portal_only=0 AND is_group=0 AND is_admin=1 ORDER BY first_name, last_name ASC Thu Apr 23 07:26:45 2020 [26834][1][INFO] Query:SELECT id, first_name, last_name, user_name from users WHERE status='Active' AND portal_only=0 AND is_group=0 AND is_admin=1 ORDER BY first_name, last_name ASC Thu Apr 23 07:26:45 2020 [26834][1][INFO] Query Execution Time:0.0003809928894043 Thu Apr 23 07:26:45 2020 [26834][1][INFO] Get One: |SELECT version FROM upgrade_history WHERE id_name = 'mautic-sugarcrm-integrator' order by date_entered DESC| Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] Limit Query:SELECT version FROM upgrade_history WHERE id_name = 'mautic-sugarcrm-integrator' order by date_entered DESC Start: 0 count: 1 Thu Apr 23 07:26:45 2020 [26834][1][INFO] Query:SELECT version FROM upgrade_history WHERE id_name = 'mautic-sugarcrm-integrator' order by date_entered DESC LIMIT 0,1 Thu Apr 23 07:26:45 2020 [26834][1][INFO] Query Execution Time:0.00021910667419434 Thu Apr 23 07:26:45 2020 [26834][1][INFO] Query:SELECT user_id FROM ev_users_licenses WHERE supplier_name='Outfitters' AND package_id='mautic-sugarcrm-integrator' AND deleted=0 Thu Apr 23 07:26:45 2020 [26834][1][INFO] Query Execution Time:0.00020885467529297 Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] Hook called: ::server_round_trip Thu Apr 23 07:26:45 2020 [26834][1][DEBUG] Calling MySQLi::disconnect()

  7. eVolpe_Consulting_Group member avatar

    eVolpe Consulting Group Provider

    2 years ago

    Please install (updated manifest version) package: eVolpe_CRM_Mautic_3.11.234.1.zip (I'll sent you file via e-mail directly to you).

    If problems will don't disappear we should organize videoconference.

    • tp member avatar

      tp

      2 years ago

      Hi. I tried this plug in. But its still same. Can we do a video conference today? I am in the UK and can do today at 11AM UK time? I can setup a Gotomeeting if you want.

      Warm regards RS

    • eVolpe_Consulting_Group member avatar

      eVolpe Consulting Group Provider

      2 years ago

      Hi, Today unfortunatly we can't do a videoconference. Can we meet tomorrow at the same time?

    • tp member avatar

      tp

      2 years ago

      Tomorrow 12PM UK time will be better for me. Is that okay for you?

  8. eVolpe_Consulting_Group member avatar

    eVolpe Consulting Group Provider

    2 years ago

    Yes, that's ok. It's also will be good time for us. I will send to you in DM link to the meeting.

    Best regards

  9. eVolpe_Consulting_Group member avatar

    eVolpe Consulting Group Provider

    2 years ago

    Please let me know, did you receive an e-mail with link to the meeting?

    Best regards

    • tp member avatar

      tp

      2 years ago

      Yes thank you I did, will speak to you tomorrow.

  10. tp member avatar

    tp

    2 years ago

    BTW If it helps I can also do anytime today till late. Let me know.

    • eVolpe_Consulting_Group member avatar

      eVolpe Consulting Group Provider

      2 years ago

      Thank you, but tomorrow will be the best term for us :-)

      We will hear each other tomorrow.

      All the best

    • tp member avatar

      tp

      2 years ago

      Ok speak to you tomorrow

  11. eVolpe_Consulting_Group member avatar

    eVolpe Consulting Group Provider

    2 years ago

    Your .htaccess file looks fine. Please check: https://www.sugaroutfitters.com/docs/mautic-sugarcrm-integrator/sugarcrm-mautic-authorization-issues

    • tp member avatar

      tp

      2 years ago

      Hi,

      Thanks for this. I followed the link and all seems to start working now with the Link button. So it was with .htaccess.

      Now that everything is setup, the records are not getting synchronised. I checked the manual and I have done exactly.

      In the log file of SuiteCRM get the following error:

      Wed May 6 12:42:06 2020 [19377][1][FATAL] MAUTIC API ERROR, type: , code: 404, message: Looks like I encountered an error (error #404). If I do it again, please report me to the system administrator! Wed May 6 12:42:06 2020 [19377][1][FATAL] MAUTIC API ERROR, type: , code: 404, message: Looks like I encountered an error (error #404). If I do it again, please report me to the system administrator! Wed May 6 12:42:06 2020 [19377][1][FATAL] MAUTIC API ERROR, type: , code: 404, message: Looks like I encountered an error (error #404). If I do it again, please report me to the system administrator!

      I get this error multiple times for the total count of the record. The Mautic version is 2.16.2

      Warm regards RS

  12. tp member avatar

    tp

    2 years ago

    Ok I did a clear cache and now its working. so thanks, we can close this ticket.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "Works very well. Support has been very respectful and fast, when it was required." - BradLohoar

    Read More Reviews