Quick question: what's meant to happen to a person's record when an email hard / soft bounces?

I can see that the webhook is creating entries in the mailing_event_bounce table. But that seems to be it. Should Civi also be setting 'On Hold' on their record at this point? Appreciate this isn't to do with your code - just checking what's meant to be happening :-)

Cheers,

Andrew

I'm running into several issues. Would like to have a sense of whether this my config and would appreciate contacting / discussing with people who have gotten this to work. If this is working for you and you have a couple of mins to discuss, please contact me.

I see that there is a version 2.0 released, but nothing shows up in CiviCRM Extensions. I have installed version 1.5 with CiviCRM 4.6.3 and Joomla 3.4.1 on Apache 2.6.xxxx

• Installed version 1.5 doesn't list CiviCRM 4.6 (really minor but perhaps means it won't upgrade?)
• It isn't showing version 2.0 as available

Also, there's no instructions on the readme for updating/upgrading. Hopefully that's because it's supposed to be a simple "click to update"?

This consistently occurs with a paypal registration transaction. Full message below. I have seen this happen in the past with crawlers, but this was a legit registration.
Notice: Undefined index: html in mte_civicrm_alterMailParams() (line 243 of /home/xxxxxx/public_html/drupal/sites/default/files/civicrm/extensions/biz.jmaconsulting.mte-1.5/mte.php).

Note that following this, I get a civicrm failure and backtrace. I do not know if the MTE is causing this or it is related to a different issue, but the trace (following this error) is:
$Fatal Error Details = Array ( [message] => Could not find valid value for id [code] => )
https://xxxxx.com/civicrm/event/register?_qf_Confirm_display=1&rfp=1&qfKey=aaaaaa&token=aaaaa&PayerID=aaaaaaa
Referrer https://www.paypal.com//cgi-bin/webscr?cmd=_express-checkout&token=aaaaaa (link is external)
Message $backTrace = #0 /home/xxxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Core/Error.php(387): CRM_Core_Error::backtrace("backTrace", TRUE) #1 /home/xxxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Utils/Request.php(105): CRM_Core_Error::fatal("Could not find valid value for id") #2 /home/xxxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Event/StateMachine/Registration.php(53): CRM_Utils_Request::retrieve("id", "Positive", Object(CRM_Event_Controller_Registration), TRUE) #3 /home/xxxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Event/Controller/Registration.php(43): CRM_Event_StateMachine_Registration->__construct(Object(CRM_Event_Controller_Registration), TRUE) #4 /home/xxxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(326): CRM_Event_Controller_Registration->__construct("Event Registration", TRUE, "null", NULL, "false") #5 /home/xxxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(75): CRM_Core_Invoke::runItem((Array:15)) #6 /home/xxxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3)) #7 /home/xxxxx/public_html/drupal/sites/all/modules/civicrm/drupal/civicrm.module(457): CRM_Core_Invoke::invoke((Array:3)) #8 internal function: civicrm_invoke("event", "register") #9 /home/xxxxx/public_html/drupal/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2)) #10 /home/xxxxx/public_html/drupal/index.php(21): menu_execute_active_handler() #11 {main}

There seems to be an issue with installing Mandrill Transactional Emails on the latest Wordpress 3.8.1 / CiviCRM 4.4.4. And it seems that I'm not the only one: http://forum.civicrm.org/index.php/topic,31468.0.html

After hitting the 'Install' button, it returns this rather unhelpful error message:

Sorry but we are not able to provide this at the moment.
DB Error: unknown error

I've tried both installing through CiviCRM and manually via file upload, but neither works.

My set-up is:

• Wordpress 3.8.1
• CiviCRM 4.4.4
• PHP 5.3.27
• MySQL: 5.1.72-cll

Although I've created a webhook following the directions, when I click on the "send test" button on the MandrillApp website (https://mandrillapp.com/settings/webhooks), it always returns an error. The error has a DIFFERENT url than what is in the webhook.

For that reason, I'm starting here to report, since it looks like the Mandrill Email extension might be changing the URL? I apologize if this isn't the correct place to report the issue.

Note that the website starts in a subdirectory "http://ahymsin.org/main/" in case that might be significant.
Joomla 3.4.1
CiviCRM 4.6.3
Mandrill Mail Ext v 2.0

Error message returned (secret zeroed out)

Webhook failed with error: POST to http://ahymsin.org/main/component/civicrm/?lang=en&mandrillSecret=0000000000000000&task=civicrm/ajax/mte/callback failed with 500: 0 -

Full screen shot of error returned

I'm using wordpress and can't get the webhook to save in mandrill. It keeps saying

"We can't verify that the URL exists."

This is the Mandrill Post URL I'm given after setting up the Outbound Mail:

https://domain.org/page?page=CiviCRM&q=civicrm/ajax/mte/callback&mandrillSecret=************

I noticed #7 has the same issue but it was closed by @JoeMurray with no explanation. Any insight would be great!

Hello, I had to disable this extension for now as I noticed it caused a fatal error in my CiviCRM quick search box. I would search for a name in the CiviCRM top toolbar search, and would get this erorr, disabling the extension got rid of the error:

Fatal error: Cannot redeclare class CRM_Utils_Hook in /home/mysite/www/www/sites/all/civicrm_extensions/biz.jmaconsulting.mte/CRM/Utils/Hook.php on line 36

CiviCRM 4.2.0
Drupal 7.14

Hi. I have configured the Mandrill extension to be used in a 4.3.4. In all cases I can see, it is functioning well inside of CiviCRM. I have sent some test messages to myself, and have tested the "open" and "click" tracking. It is properly being recorded in Mandrill, but not sent back to CiviCRM. The webhook I created matches exactly what's in the Mandrill settings in CiviCRM.

FWIW, I have two different CiviCRM installations with webhooks installed in this Mandrill account. Could that be backing a difference?

I have a brand new installation of Drupal and CiviCRM 4.5.0. New Mandrill account as well. I have followed the directions in the readme.md. When I get to the point of saving the Mandrill info and sending a test email, I get a white screen.

Mandrill is configured for regular SMTP already and it works fine.

Suggestions?

Hi Joe,

I just want to confirm that this extension handles both CiviMail bulk email sending/processing as well as non-CiviMail transactions (other Civi emails)? I had heard it may only do non-civimail transactions, but I think your documentation suggests otherwise.

I'll be using this with a Pantheon server and just trying to clarify exactly what it does before moving forward. Looking at what you do have in the docs, it looks like it should handle both, correct? https://github.com/JMAConsulting/biz.jmaconsulting.mte/blob/master/README.md

Thanks! Emily

@JoeMurray pls remove if this is not appropriate, but wanted to help the community get some clarity on current and planned bulk mail support. In #76 there was reference to support for bounce processing in bulk mail in a version that needed testing. Was that branch 1.5? Are there plans to integrate enhancements for bulk mail?

I think that there is enough interest that we can get some contributors ($$$, code, testing) but would think we need to better understand current support, planed enhancements and feature requests.

I may have just convinced a client to migrate from icontact and civicrm 4.6 is focused on email enhancements so I'd like to strike while the iron is hot :)

Received the following error in Civi 4.5.5 / J 3.4.0 when trying to send a test message. It does seem to be related more to Civi core, but would still affect the extension as well.

An error occurred when CiviCRM attempted to send an email (via SMTP). If you received this error after submitting on online contribution or event registration - the transaction was completed, but we were unable to send the email receipt.
The mail library returned the following error message:
Failed to connect to smtp.mandrillapp.com:587 [SMTP: Failed to connect socket: Connection timed out (code: -1, response: )]
This is probably related to a problem in your Outbound Email Settings (Administer CiviCRM » System Settings » Outbound Email), OR the FROM email address specifically configured for your contribution page or event. Possible causes are:
Your SMTP Username or Password are incorrect.
Your SMTP Server (machine) name is incorrect.
You need to use a Port other than the default port 25 in your environment.
Your SMTP server is just not responding right now (it is down for some reason).
The FROM Email Address configured for this feature may not be a valid sender based on your email service provider rules.

See http://screencast.com/t/Qe36c8X1dJcg

shawnholt sent this to me, but indicated that permission issues may have caused it. Seems plausible if we cannot replicate, as he had been editing files in the extension and that may have caused permissions issues for the web server being unable to overwrite those files. Normal server permissions would cause this error I'm pretty sure. If so, please close.

Env:
civicrm 4.4.6 Drupal 7
PHP: 5.4.30

Status:
Mandrill sends email fine.
The webhook address in Mandrill matches the site (I have tried both http: and https:)
I added debug code to verify that the hook is called and seen it in the apache logs.
I tested on several contacts, but sending direct mail and in event confirmation emails.
specific test to contact:[email protected] fails.

Issue:
I do not see any bounce / mandrill activities for the return channel.
Do not contact is not updated
No error messages

Does the extension do any logging / status? Any debug suggestions? I'm at the point of abandoning but would really like to see this work! I had hoped that I could use this for both transactional email and bounce processing (do-not-mail at least) of bulk mail (since it should trigger the webhook)

Have solicited funding for full bulk support but given these problems, not sure how to proceed.

Is there a change log for version 2.0 somewhere? I'd like to know what's different.

I am trying to configure my first Drupal and CiviCRM site.

I followed the instructions in the README.md file down to the "Save and Send Test Email" with no problems.

When I "Save and Send Test Email", I get the following error popup:
Mail Not Sent
Sending test email. From:[the email address for the mandrill account] TO: [my email address]
Oops. Your SMTP settings are incorrect. Not test mail has been sent.
...
Failed to connect to smtp.mandrillapp.com:587 [SMTP: Failed to connect socket: Connection timed out (code -1, response: )]

The following message appears at the top of the page:

• Strict warning: Non-static method PEAR::raiseError() should not be called statically, assuming $this from incompatible context in Net_SMTP->connect() (line 453 of /home/dd/public_html/sare-drupal/sites/all/modules/civicrm/packages/Net/SMTP.php).
• Strict warning: Non-static method PEAR::raiseError() should not be called statically, assuming $this from incompatible context in Mail_smtp->getSMTPObject() (line 375 of /home/dd/public_html/sare-drupal/sites/all/modules/civicrm/packages/Mail/smtp.php).

I have the Drupal Mail System Settings set to use MandrillMailSystem (via the Mandrill module - https://www.drupal.org/project/mandrill) and am able to successfully send mail from Drupal's Configuration -> Web Services -> Mandrill -> Send test email

Any pointers on where I should look for the solution would be greatly appreciated.
TIA!
John

This may be something specific to my hosting environment, but I can't get the webhook connected. The URL path to the file keeps coming back with a 404 error. Any advice?

For 4.5 version, add support for multisite by changing hardcoded domain_id=1 to retrieved domain_id for instance.

To Whom It May Concern,
I have CiviCRM 4.4.4 / Drupal 7.26 installed. When I tried to install Mandrill Transactionals Email 1.2, it throws me a DB error message with the following information in the logfile. I also try to install it on a clean installation with the same result. There are couple more people experiencing the same thing, and one of the CiviCRM forum members say this may be due to the recent changes in CiviCRM, so the installer fails at some point (http://forum.civicrm.org/index.php/topic,31468.0.html).

Thank you for writing the extension, and we're hoping to use your extension with CiviCRM. Please let us know if you need me to provide any further information.

Sincerely,

Aaron

[info] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)

[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => ALTER TABLE `civicrm_mailing_event_queue` 

ADD activity_id INT UNSIGNED NULL DEFAULT NULL COMMENT 'Activity id of activity type email and bulk mail.' [nativecode=1060 ** Duplicate column name 'activity_id']
[type] => DB_Error
[user_info] => ALTER TABLE civicrm_mailing_event_queue
ADD activity_id INT UNSIGNED NULL DEFAULT NULL COMMENT 'Activity id of activity type email and bulk mail.' [nativecode=1060 ** Duplicate column name 'activity_id']
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE civicrm_mailing_event_queue
ADD activity_id INT UNSIGNED NULL DEFAULT NULL COMMENT 'Activity id of activity type email and bulk mail.' [nativecode=1060 ** Duplicate column name 'activity_id']"]
)

[info] $backTrace = #0 /path_to_my_website/sites/all/modules/civicrm/CRM/Core/Error.php(197): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 internal function: CRM_Core_Error::handle(Object(DB_Error))
#2 /path_to_my_website/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /path_to_my_website/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "ALTER TABLE civicrm_mailing_event_queue \n ADD activity_id INT UNSIGNED ...")
#4 /path_to_my_website/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "ALTER TABLE civicrm_mailing_event_queue \n ADD activity_id INT UNSIGNED ...")
#5 /path_to_my_website/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "ALTER TABLE civicrm_mailing_event_queue \n ADD activity_id INT UNSIGNED ...", "DB_Error", TRUE)
#6 /path_to_my_website/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-1, NULL, NULL, NULL, "1060 ** Duplicate column name 'activity_id'")
#7 /path_to_my_website/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /path_to_my_website/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("ALTER TABLE civicrm_mailing_event_queue \n ADD activity_id INT UNSIGNED ...")
#9 /path_to_my_website/sites/all/modules/civicrm/CRM/Utils/File.php(284): DB_common->query("ALTER TABLE civicrm_mailing_event_queue \n ADD activity_id INT UNSIGNED ...")
#10 /path_to_my_website/civi.custom/extensions/biz.jmaconsulting.mte-1.2/CRM/Mte/Upgrader/Base.php(285): CRM_Utils_File::sourceSQLFile("mysql://database_name:######@localhost/datebase_name?new_link=true", "/**\n * Mandrill Transactional Email extension integrates CiviCRM's non-bulk ...", NULL, TRUE)
#11 /path_to_my_website/civi.custom/extensions/biz.jmaconsulting.mte-1.2/mte.civix.php(72): CRM_Mte_Upgrader_Base->onInstall()
#12 /path_to_my_website/civi.custom/extensions/biz.jmaconsulting.mte-1.2/mte.php(55): _mte_civix_civicrm_install()
#13 /path_to_my_website/sites/all/modules/civicrm/CRM/Extension/Manager/Module.php(64): mte_civicrm_install()
#14 /path_to_my_website/sites/all/modules/civicrm/CRM/Extension/Manager/Module.php(44): CRM_Extension_Manager_Module->callHook(Object(CRM_Extension_Info), "install")
#15 /path_to_my_website/sites/all/modules/civicrm/CRM/Extension/Manager.php(220): CRM_Extension_Manager_Module->onPreInstall(Object(CRM_Extension_Info))
#16 /path_to_my_website/sites/all/modules/civicrm/CRM/Admin/Form/Extensions.php(188): CRM_Extension_Manager->install((Array:1))
#17 /path_to_my_website/sites/all/modules/civicrm/CRM/Core/Form.php(261): CRM_Admin_Form_Extensions->postProcess()
#18 /path_to_my_website/sites/all/modules/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
#19 /path_to_my_website/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Admin_Form_Extensions), "next", "Next")
#20 /path_to_my_website/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Admin_Form_Extensions), "next")
#21 /path_to_my_website/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Admin_Form_Extensions), "next")
#22 /path_to_my_website/sites/all/modules/civicrm/CRM/Core/Controller.php(345): HTML_QuickForm_Page->handle("next")
#23 /path_to_my_website/sites/all/modules/civicrm/CRM/Core/Page/Basic.php(381): CRM_Core_Controller->run()
#24 /path_to_my_website/sites/all/modules/civicrm/CRM/Core/Page/Basic.php(178): CRM_Core_Page_Basic->edit(1, NULL)
#25 /path_to_my_website/sites/all/modules/civicrm/CRM/Admin/Page/Extensions.php(127): CRM_Core_Page_Basic->run()
#26 /path_to_my_website/sites/all/modules/civicrm/CRM/Core/Invoke.php(323): CRM_Admin_Page_Extensions->run((Array:3), NULL)
#27 /path_to_my_website/sites/all/modules/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:13))
#28 /path_to_my_website/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#29 /path_to_my_website/sites/all/modules/civicrm/drupal/civicrm.module(456): CRM_Core_Invoke::invoke((Array:3))
#30 internal function: civicrm_invoke("admin", "extensions")
#31 /path_to_my_website/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2))
#32 /path_to_my_website/index.php(21): menu_execute_active_handler()
#33 {main}

Joomla 3.4.1
Mandrill Transactional Emails v2.0
Php 5.5.25
Apache

Getting many errors from MandrillApp

This is one of them.

[message] => implode(): Invalid arguments passed
[file] => /home/ahymsinc/public_html/main/administrator/components/com_civicrm/civicrm/CRM/Core/IDS.php
[line] => 256

Note secret zeroed out

SCRIPT_NAME: /main/index.php
REQUEST_URI: /main/component/civicrm/?lang=en&mandrillSecret=0000000000000000&task=civicrm/ajax/mte/callback
QUERY_STRING: lang=en&mandrillSecret=00000000000000000&task=civicrm/ajax/mte/callback
HTTP_USER_AGENT: Mandrill-Webhook/1.0

Please let me know at least if this is an issue with the MandrilApp extension or a general CiviCRM error

When I toggle enable it always shows that it is checked.

I have discovered that the webhook on one of my clients site (running Civi 4.5.6 and Joomla 3.3.6) has begun erroring out on every attempt starting on Feb. 13th. The error is the standard IDS error, "There is a validation error with your HTML input. Your activity is a bit suspicious, hence aborting". Skipping the IDS check for the public user group resolved the issue, although that is only useful to confirm that the problem indeed lies with the IDS check. The problem occurs on all event payloads, even ones that only contain a single event. I believe Feb 13th is when I did the upgrade from Civi 4.5.5 to Civi 4.5.6 so that might be the cause, but I'm not positive.

Reading the instruction:

Post to URL, enter the resource URL from 5 above, followed by biz.jmaconsulting.mte/CRM/Mte/Page/callback.php. For example:
http://yourorg.org/civicrm/mte/callback?name=username&pass=password&key=civicrm-site-key

Isn't handling the name+pass as get param and do the authentication something drupal specific? have you tried on WP or J! ?

moreover, I didn't see where you test for the key.

Wouldn't it make sense to move all the page logic into a custom api mte.callback and so you can rely on the sites/all/modules/extern/rest.php?action=callnback&entity=mte&api_key=&key= ? So you are sure that it works as well for all the CMS,

I have read previous posts that suggest bounce processing is performing correctly using version 1.5 of the CivicCRM extension with the latest versions of CiviCRM in Drupal. I can see a number of hard bounces on the Mandrill website. However they are not being picked up in CiviCRM so that the email addresses are placed 'on hold'. This is critical functionality for us. Unsubscribes are working correctly but not bounces. We have not received any soft bounces so I am not sure how they are managed.

I would really appreciate some help with this matter because I am unsure where I might be going wrong.

Cheers
Martin Fuggle

Intrusion detection rules are triggering webhook calls. I can disable IDS for anon users, but that is probably a bad idea. investigating how to make an exception in a way that supports upgrade.

From within the mandrill config screen I get the following:
Error: POST to http://yourorg.org/civicrm/ajax/mte/callback?mandrillSecret=108d3af8a77fc502 failed with 500
Is there anything that I need to change in my htaccess to make this work?
I use drupal 7.37 / civicrm 4.6.3

So if I understood it, you both create a separate activity and put it into a "generic transactional" emailing (nice hack IMO).

What is the point of having the two? isn't the mailing enough?

https://github.com/JMAConsulting/biz.jmaconsulting.mte/blob/master/CRM/Mte/Page/callback.php

Version 1.5 installed on Joomla 2.5.28 with CiviCRM 4.6 (also had blank page under 4.5.current but didn't confirm the actual error messages).

Full message (with Show Development Error): Undefined index: html in /home//public_html/main/media/civicrm/custom_ext/biz.jmaconsulting.mte/mte.php on line 243

The "Search Contacts" menu item suddenly has started showing a blank screen when selected. Custom search using the same criteria (a last name, for example) works correctly.

Turning off GZip compression and then enabling either Maximum or Development error reporting gave the following messages:

Strict Standards: Declaration of JCacheControllerPage::store() should be compatible with JCacheController::store($data, $id, $group = NULL) in /home//public_html/main/libraries/joomla/cache/controller/page.php on line 199

Notice: Undefined index: html in /home//public_html/main/media/civicrm/custom_ext/biz.jmaconsulting.mte/mte.php on line 243

Strict Standards: Non-static method PEAR::raiseError() should not be called statically, assuming $this from incompatible context in /home//public_html/main/administrator/components/com_civicrm/civicrm/packages/Net/SMTP.php on line 375

Strict Standards: Non-static method PEAR::raiseError() should not be called statically, assuming $this from incompatible context in /home//public_html/main/administrator/components/com_civicrm/civicrm/packages/Mail/smtp.php on line 389

Current Joomla 2.5.27 (been running Mandril for a long time without problems). Upgraded CiviCRM to 4.5.2 and Mandrill extension to current 1.4

Scheduled jobs in CiviCRM are not running anymore. I finally found a reference to "error_log" in the /.../civicrm/ folder. It lists the following (website name changed to SITE). The following repeats for every iteration of the cron job. I have also logged in with the CiviCRM user linked to the cron job to be sure that it's password hash has been updated.

I've also just now disabled the extension and it looks like the scheduled jobs are starting to run again.

[03-Nov-2014 12:40:01 UTC] PHP Fatal error: Call to a member function get() on a non-object in /home/SITE/public_html/main/media/civicrm/custom_ext/biz.jmaconsulting.mte/mte.php on line 37
[03-Nov-2014 12:48:02 UTC] PHP Notice: Trying to get property of non-object in /home/SITE/public_html/main/libraries/joomla/application/application.php on line 173
[03-Nov-2014 12:48:02 UTC] PHP Notice: Undefined property: JException::$input in /home/SITE/public_html/main/media/civicrm/custom_ext/biz.jmaconsulting.mte/mte.php on line 37

Got a chance to do some testing today. I am uncertain that any of the things I found are "issues", but if they are we can start new issues with them.

The "On Hold" feature works! I tested both with bulk mail as well as an email activity. Thank you. This is the biggest issue for us.

Bulk mail tracking of opens, clicks and replies (still) works. Although I am uncertain that this extension was intended to have any effect on this.

For email sent as an Activity, there doesn't appear to be any tracking recorded of opens or clicks. I may have misunderstood the intent, but I believe I read somewhere that this was supported. I looked in the Activities tab for the contact, I looked in the Opened Email report, and I tried searching for Activities, "Mandrill Email Open" with no result. Mandrill itself (at mandrillapp.com) reports that the email activity was both clicked and opened.

Hi Joe, we're looking at installing this for a client who are using Civi 4.2.6 but have a couple of questions mainly around the bulk mail bounce handling. How have you managed to get the two to coexist?

1. Do you set up the CiviCRM bulk mail bounce handling in the normal way - does mandrill leave the verp return path for bulk emails? From looking at the message source it looks as if this gets rewritten by Mandrills bounce handler as well as the transactional emails...
2. I don't see how the extension can coexist with another service as it uses the SMTP settings... am I missing something? ref issue #9

If better to have a chat over the phone then let me know,

Best

Jamie

Hello, I've had some other CiviCRM payment processing problems so I've had CiviCRM debug enabled, and I've been watching my Drupal log today with drush watchdog-show --tail, I'm seeing these messages.

260057  18/Sep 14:48  debug   civicrm  $IDS Detector Details = Array
(
    [0] => Array
        (
            [name] => mandrill_events
            [value] => [{"event":"open","ts":1347650218,"msg":{"opens":[{"ts":1347650218}],
 260058  18/Sep 14:48  error   php      PEAR_Exception: DB Error: constraint violation in CRM_Core_Error::exceptionHandler() (line 676 of /home/fppoa/www/www/sites/all/modules/civicrm/CRM/Core/Error.php).

This morning I upgraded to CiviCRM 4.2.1, I see there has been fresh activity here on this github project, should I update to the latest version of this extension to fix these errors?

Hello,

I got a notice from our webhost that our space was almost completely used up. On further investigation, it looks like the culprit is the civicrm_activity table, taking up over 2GB of disk space. Looking into the rows in there, the majority are activity_type_id 55, 56, and 57, which I figured out were: "Mandrill Email Sent", "Mandrill Email Open"
and "Mandrill Email Click" respectively. Looks like what is really adding up is the details column, which stores a copy of the entire email every time. Is there anyway to either avoid logging an activity for each of these events or avoid storing the details for these events?

Using:
Drupal 7.25
CiviCRM 4.3.5
Mandrill Transactional Emails v1.2

Thanks!
Matt

On line 164 of mte.php, the $session->get('userID') is used as the source_contact_id. In the event that an Anonymous user triggers the email activity (e.g., a webform_civicrm submission), the session user ID does not exist and the activity is not created (the email is sent, though).

What are your thoughts on the best approach to configuring and using a default contact ID in the event of Anonymous activity invocation? Add a config file to the mte extension which includes the default user ID? Modify the CRM_Utils_Mail::send function to accept a source_contact_id and pass it along to hooks?

Thanks

Hi,

Since you published the extension, I think there is a new tag
https://github.com/JMAConsulting/biz.jmaconsulting.mte/issues
to add

for the zip, did you upload the file?

Tim suggested me an easier approach: tag a commit and github creates a downloadable zip automatically:

http://wiki.civicrm.org/confluence/display/CRMDOC42/Publish+an+Extension

Hello, similar to this issue - /issues/7, but I am using version 1.4 of the extension.

I'm getting the webhook 404 error as well with Drupal & CiviCRM. I am sure I just don't have the path typed correctly, but I'm honestly quite confused on what the resource URL should be, as well as exactly what the callback "Post to URL" Mandrill dashboard is supposed to be:

Error: POST to https://www.fppoa.org/civicrm/ajax/mte/callback?mandrillSecret=123mysecretwhatever12
![fppoa-civicrm-mandrill-wtf](https://cloud.githubusercontent.com/assets/914143/5347329/fe2012d2-7eec-11e4-8c46-f660dcbb0847.png)
 failed with 404: <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> <html><head> <title>404 Not Found</title> </head><body> <h1>Not Found</h1> <p>The requested URL /civicrm/ajax/mte/callback was not found on this server.</p> <p>Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.</p> </body></html> 

I'm sure it's a simple fix if someone can guide me please. I just don't understand if the "Post To URL" is supposed to point to the civicrm extension directory, or the /civicrm URL path. The URL is mysite.com/civicrm/ but the path is http://mysite.com/sites/all/modules/civicrm (or in my case) http://mysite.com/sites/all/modules/civicrm.

The message is on the page is somewhat confusing to me as well - it says "this should match the CiviCRM extension directoy", so then it shows the full path to the root of the file system. So should it be http://mysite.com/sites/all/modules/civicrm_extensions? I have tried all of the combinations I can think of, and it either returns a 404 or we can't verify that URL exists from the Mandrill dashboard, so that's why I have to ask for help at this point.

Thank you,
--Tony

I'm not sure if this is a bug, documentation issue or my own stupidity. I have tried to set up click tracking but it doesn't seem to be working.

In readme.md, line 59, it says:

In Post to URL, enter the resource URL that you saved in the previous step above. For example: http://yourorg.org//civicrm/ajax/mte/callback?mandrillSecret=108d3af8a77fc502

However that URL doesn't correlate to any of the steps above. In a previous step, we put in the directory of Resource URLs, but that doesn't match the example above.

In any case, I set up in Mandrill a webhook using the URL above, substituting my domain name and my mandril secret found on option groups. However the click isn't tracked.

Hi,

If a profile has a notification email address in its Advanced Settings, but that email address isn't an existing contact record, bad things happen. The email gets sent, but the data from the profile never actually makes it into Civi - it just silently fails. But it works ok with this extension disabled.

At least, that's happening on our setup...I'm pretty it only started happening with 4.4.4, too - that's when data from emails stopped appearing in Civi.

Cheers,

Andrew

So Joe ... thanks for your hard work ... I don't know if anyone has seen this phenomena before ... I'm on a shared server pushing php 5.3,27 and database mysqli of 5.5.34-cll

maybe a simple pathing issue, if I knew where the error originated I would stand a chance. I don't want to install mandrill until I can research this error. The install modules menu w/ all its various downloadable modules appears after 20xml error on my admin screen in civi crm's manage extensions menu

I understand that there was an issue opened for this particular problem already, and that it was closed with a solution, but I am unable to follow the instructions and it does not appear to work.

The formatting and phrasing of the solution are a little difficult to follow. Would appreciate any pointers on how to get the extension to work.

Cheers,

Conor

A l l i s o n W o o l b e r t emailed:

I’m having some trouble with the installation of the extension. I’m using Wordpress with Civicrm 4.5.0 at this point. I keep getting a DB Error when trying to install. I’ve used the uninstall sql script but it seems to still be having issues.

The extension never reaches a full installation. Do you have a manual removal instruction so I can try again?

Hello, I installed this extension today and wanted to check the url to see if it worked, I'm not sure if this is supposed to happen or not. I setup the extension per the README file, and went to the URL to check if it works just in a web browser. Should this be throwing an error when I go straight to the URL? Or do I have something misconfigured? Is it perhaps only accessible via the mandrillapp when mandrill calls the page? Just trying to understand and make sure I've gotten everything setup correctly.

webhook url:
http://www.mysite.org/sites/all/civicrm_extensions/biz.jmaconsulting.mte/CRM/Mte/Page/callback.php

Fatal error: Class 'CRM_Core_Page' not found in /home/mysite/www/www/sites/all/civicrm_extensions/biz.jmaconsulting.mte/CRM/Mte/Page/callback.php on line 31

I put my CiviCRM extensions in sites/all/civicrm_extensions, should I have put it in sites/all/modules/Extensions/?

Thank you,
--Tony

How is the module supposed to manage bounced/rejected mails when performing a bulk mail?

When performing a bulk mail it is not updating the report if there are any bounces.

I have taken a look through the module and it does appear that the events are being captured, and entries are being made in the database, but for whatever reason the events are not associated with the bulk mail report.

Is this intentional in the design? Or could this be a bug.

Conor

Been getting these emails periodically from Madrill with this error:

Your Mandrill webhook at URL https://www.mydomain.ca/en/civicrm/ajax/mte/callback?mandrillSecret=55458e1ad5e8c55a has failed with the following error: POST to https://www.broadbentinstitute.ca/en/civicrm/ajax/mte/callback?mandrillSecret=55458e1ad5e8c55a failed: connect() timed out!.

Has anyone else been getting these, does anyone know what causes them or what can be done to fix it?

Using:
Drupal 7.25
CiviCRM 4.3.5
Mandrill Transactional Emails v1.2

Thanks,
Matt

Not sure if this is something I should worry about. Recently upgraded to civicrm 4.5 and 1.2 of extension.
Notice: Undefined index: Mandrill Hard in CRM_Mte_Page_callback->run() (line 127 of /home/xxxx/public_html/drupal/sites/default/files/civicrm/extensions/biz.jmaconsulting.mte/CRM/Mte/Page/callback.php)

info="INSERT INTO civicrm_mandrill_activity (mailing_queue_id ) VALUES ( 15 ) [nativecode=1146 ** Table 'jxxx_civi.log_civicrm_mandrill_activity' doesn't exist]"] )

We send roughly 4 newsletter to 10K subscribers. These could be considered "transactional" in that they are personalized, but essentially they are bulk. Is there any reason that we can't use this for bulk emails too?

Although there's a "disable" button, I don't know if that's sufficient to disconnect the extension from the Joomla CiviCrm mailing settings and operation? A statement about this or checklist or steps to do it would be useful.

Hi,

I've got the latest mte running on D7/Civi4.4.4. The mandrill webhook works and creates activities for opens etc. But these aren't listed or used in the Mailing Report.

Is this something separate that needs to be written or added to the module? I'm happy to have a go if you can point me in the right direction.

Cheers
Owen