Get answers quicker by searching

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

Using Mandrill webhook for Bounces & Complaints
  • 63 Comments
  • Vote Up0Vote Down dralexdralex
    Posts: 1Sendy user

    Well... with this file found here: https://sendy.co/forum/discussion/2192/sendy-mod-mandrill-webhooks-to-track-bounces-and-spam-complaint

    In the php file, I've seen the word "complaint" written as "compliant".

    Was this intended and should we keep the file that way or was this a typo?

    Because compliant is like everywhere in the file.

    I'm not sure which hook works anymore?

    Anyone could tell us which one is flawless right now?

  • Vote Up0Vote Down carsonreedcarsonreed
    Posts: 3Sendy user

    @dralex... that's weird... can anyone post a fully working version of this mod? I tested it and it doesn't seem to track complaints well... only bounces.

    https://sendy.co/forum/discussion/2192/sendy-mod-mandrill-webhooks-to-track-bounces-and-spam-complaint

  • I just bought sendy hoping i can get it to work with mandrill. I installed those files the link above and the its not tracking the bounces.

    My php reads "compliant" also. Should I change that to complaint?

  • The bounces, soft bounces etc are not working for me. When I create the webhook in mandrill it generates a key do i have to put that anywhere on my side? I clicked "send test" from the webhook i created and it says "Successfully posted 5 test events to http://mydomain.com". Im lost right now.

  • Does anybody know how to get this working? Im emailing hello@sendy.co and they arent answering me either.

  • Vote Up0Vote Down BenBen
    Posts: 3,507Sendy support

    Hi @BigEfromDaBx,

    This is a third party integration/plugin with another SMTP provider, you'll need to get support from the original developer of this integration/plugin.

    Or try this integration with Mandrill by Blaine Moore → https://github.com/BlaineMoore/sendy-webhooks (on Github)

    Thanks.

    Best regards,
    Ben

  • Vote Up0Vote Down daihoangdaihoang
    Posts: 1Sendy user

    Hi all,

    I fixed up a few things in the code to get it to work:

    In /includes/db.php:

    Line 79: if($bounce_soft >= $bounce_limit)

    Should be: if($bounce_soft >= $webhooks_bounce_limit)

    The global $var was incorrectly referenced, hence the soft bounce limit was not working.

    In mandrill.php:

    Line 30: case "soft-bounce"

    Should be: case "soft_bounce"

    Mandrill webhook send this with an underscore, not a hyphen.

    I made these 2 changes, and then tested all 3 webhooks separately: 1) Sent hard bounce test, Mandrill correctly changes subscriber to "Bounced" 2) Sent soft bounce with a limit of 3, Mandrill correctly keeps the subscriber until the limit is reached, at which point it changes the subscriber to "Bounced" 3) Sent a spam report, Mandrill correctly changes subscriber to "Marked as spam"

    I hope this helps. If you want to change status to anything other than "Bounced", just modify the SQL statement to update the relevant field.

  • Thank you. I will give it a try. Sorry for the late response.

  • if I setup my webhooks folder in the root of my site (sendy is also in the root of my site) does my mandrill webook point to http:/mysite.com/webhooks/mandrill.php?

  • I tried it again using the above link by Blaine Moore.

    I did the two changes the @daihoang suggested and still cannot get this to work. My webhook is connecting to my site from mandrill when i test it. But its still not updating the emails. I get the following errors from the error_log

    [14-Sep-2015 20:20:21 UTC] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20100525/pdo.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20100525/pdo.so: cannot open shared object file: No such file or directory in Unknown on line 0 [14-Sep-2015 20:20:21 UTC] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20100525/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20100525/pdo_mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0 [14-Sep-2015 16:20:21 America/New_York] PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'mysite'@'localhost' (using password: NO) in /home/mysite/public_html/webhooks/includes/db.php on line 29 [14-Sep-2015 16:20:21 America/New_York] PHP Warning: mysqli_set_charset(): Couldn't fetch mysqli in /home/mysite/public_html/webhooks/includes/db.php on line 36 [14-Sep-2015 16:20:21 America/New_York] PHP Warning: mysqli_query(): Couldn't fetch mysqli in /home/mysite/public_html/webhooks/includes/db.php on line 56 [14-Sep-2015 20:23:39 UTC] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20100525/pdo.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20100525/pdo.so: cannot open shared object file: No such file or directory in Unknown on line 0 [14-Sep-2015 20:23:39 UTC] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20100525/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20100525/pdo_mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0 [14-Sep-2015 16:23:39 America/New_York] PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'mysite'@'localhost' (using password: NO) in /home/mysite/public_html/webhooks/includes/db.php on line 29 [14-Sep-2015 16:23:39 America/New_York] PHP Warning: mysqli_set_charset(): Couldn't fetch mysqli in /home/mysite/public_html/webhooks/includes/db.php on line 36 [14-Sep-2015 16:23:39 America/New_York] PHP Warning: mysqli_query(): Couldn't fetch mysqli in /home/mysite/public_html/webhooks/includes/db.php on line 56

  • Vote Up0Vote Down timosgtimosg
    Posts: 1Sendy user

    I can't get this working.

    Can anyone implement this for a fee? I am ready to pay.

    Send me a pm....

  • Vote Up0Vote Down nqservicesnqservices
    Posts: 11Sendy user

    Hi,

    Im looking for someone that can implement the Mandrill integration with Sendy.

    Im willing to pay for the service. Please send me a PM.

    Thanks

  • Vote Up0Vote Down enzimageenzimage
    Posts: 1Sendy user

    Mandrill is gone brother... Now you need a MailChimp Account to use it. It became pretty expensive. Try SendGrid or other service.

This discussion has been closed.
All Discussions