Email Piping From Mandrill

[exception0x876]

Hello!

 

I am trying to setup inbound email piping to blesta from Mandrill. I've created a php script that catches posted data from Mandrill and parses it, then invokes "/usr/bin/php <full_path_here>/plugins/support_manager/pipe.php" and passes mail contents to STDIN. However I do not see new tickets created. I've attached an example of parsed mail contents that is passed to pipe.php.

file.txt

[exception0x876]

Ok, as it turned out it was my fault in setting up Blesta support manager departments. I had to turn off the checkbox "Allow only clients to open or reply to tickets"

 

Thanks everyone for assistance!

[serge]

Why not use SMTP or IMAP at Blesta? with your Mandrill mail box

[exception0x876]

I use SMTP for outgoing mail. However it seems the only way to use it for inbound mail is through inbound webhooks. Could you please link an article explaining how to use IMAP for Mandrill inbound mail if this is possible?

[serge]

I never tested:

http://serverfault.com/questions/594059/is-it-possible-to-receive-inbound-emails-using-mandrill

http://www.murrion.com/2015/01/how-to-send-and-receive-emails-with-mandrill/

http://stackoverflow.com/questions/18196538/mandrill-inbound-email-routing

https://mandrillapp.com/api/docs/inbound.ruby.html

[serge]

Error, I tested but can not really remember me, from memory all was working with blesta:

 

- at mandrill create an email box (or sender) by blesta support department

 

- at your domain name & dns editor add a txt records mandril tell you for allowed sender ip & domain, for me it was like this:

 

mandrill._domainkey

 

v=spf1 a mx ip4:108.161.139.8 include:spf.mandrillapp.com ~all

 

- at your domain name & dns editor add a txt records mandril tell you for DKIM , for me it was like this:

 

v=DKIM1; k=rsa; p=MIGfMA0GCSqGSIb3DQ........................;

[Michael]

You can't use Piping and then mandrill you need to use either Local Mail (PHP mail + Piping) or just SMTP.

[exception0x876]

Thanks for the info serge.

 

Licensecart, I am not sure you understood what I am trying to do and what is not working. Let me explain it a bit more.

 

Here is the script that I have for handling mandrill webhook for inbound mail

<?php

mysql_connect(...);
mysql_select_db(....);
mysql_query('set names "utf8"');

if (isset($_POST['mandrill_events'])) {
        $res = json_decode($_POST['mandrill_events']);
        if (is_array($res))
        foreach ($res as $v) {
                if (is_object($v)) {
                        $p = popen('/usr/bin/php plugins/support_manager/pipe.php', 'w');
                        fwrite($p, $v->msg->raw_msg);
                        fclose($p);
                }
        }
}

The script basically passes the received message as STDIN to /usr/bin/php plugins/support_manager/pipe.php

 

No error is reported from pipe.php, however the ticket is not created in Blesta Support Manager.

[serge]

I can not remember exactly what I did tested with mandrill, but think just SMTP was fine like licensecart said, no custom code, but you just need appropriate dns record to be the allowed sender, and to collect email just use your smtp/mandrill account detail for the given email, and that's it

[exception0x876]

I can not remember exactly what I did tested with mandrill, but think just SMTP was fine like licensecart said, no custom code, but you just need appropriate dns record to be the allowed sender, and to collect email just use your smtp/mandrill account detail for the given email, and that's it

Again I have no problem with sending email from blesta using SMTP, it works fine. What I need is the way to collect incoming emails and convert them to blesta tickets, you know like what is piping is made for. It cannot be done using SMTP as SMTP is for sending mail, not receiving it. The only way to receive email is by using webhooks I described above, and for that I need blesta pipe.php script to actually work instead of silently exiting.

[Michael]

Are you using cPanel if so use /usr/local/bin/php

[exception0x876]

No, I don't use cPanel. I have php binary at /usr/bin/php, I have checked that.

[serge]

maybe check if you have PHP CLI

[Adam]

Typically with popen you want to use pclose and not fclose. However in my test environment I wrote a simple pipe program and simulator and it did not matter.

Things to try, make sure Blesta debugging is enabled (along with PHP's)

(in config/core.php)

Configure::set("System.debug", true);

and that the path to pipe program is correct. You should try using the full path in your code above. You may also want to try and add a shebang to plugins/support_manager/pipe.php. Use something like

#!/bin/env php -q

should do it. Of course, also make sure Blesta department is setup to correctly handle piping.

-Adam

[exception0x876]

Adam, thank you for your advice. I provided the php script just as an example so it is easier to understand what I am trying to achieve. Basically the following does not work

 

cat message.txt | /usr/bin/php plugins/support_manager/pipe.php

 

You can download message.txt in my 1st post attachment.

 

I have set a support department in Blesta and set Email Handling to Piping there.

 

I will try to turn on debug option you mentioned and report the results.

[exception0x876]

As it turns out I had already set System.debug to true in config/core.php