E-Mail Filtering

[crookedgoomba]

I set up my email filter so that $header_to: begins "inq" filters to |/home/bandso2/email.php. I CHMOD the file to 755 and added the header #!/usr/bin/php. I then set up the script to insert a row into a MySQL table. I tested the script in my web browser and there are no flaws in the PHP, however when I test the email in the cPanel, the script does not run. Below is a copy of the code:

#!/usr/local/bin/php 
<? 
$hd = mysql_connect(localhost, "******", "******") 
        or die ("Unable to connect"); 

mysql_select_db ("******", $hd) 
        or die ("Unable to select database"); 

mysql_query("INSERT INTO lists VALUES('test','worked')",$hd); 
?>	

i asked lunarpages (my host) about this and their response was:

The filter itself is working. It is catching "inquiry" for me. This appears to be a script error. Please use our forums at http://lunarforums for help with scripting. We do not provide support for 3rd party scripts.

any thoughts??

[AstroTeg]

Try setting this up as a forwarder under CPanel. Then send a mail to it. I have a script setup as a forwarder and if there's PHP errors, it returns them back to me. If you're having a script problem, the server should return the errors to you by email. But since you're not getting that, there may be a problem with the filter itself.

[crookedgoomba]

i did just that and received no email. the filtering did not work. looks like a certain support representative is getting a bad review.... thanks for the suggestion!

[AstroTeg]

You received no email? Did your record get inserted into the DB?

[crookedgoomba]

no, sir. im pretty sure its the filter that is the problem. i ran the same code through my browser and it was successful. i contacted support about the problem. i may just read up on setting up my own filter.

[Sgarissta]

Have you tried modifying the filter to something like $header_to = '[e-mail]'? I have several filters setup that way (that don't even point to valid email addresses) that all fork off to PHP scripts.

[crookedgoomba]

just tried it with no luck. i know this is going to end up being something really silly and stupid. lunar pages has been of no help so far.

[crookedgoomba]

i found the filter file and it looks like this

$header_to: begins "inq"[e-mail]
$header_to: begins "inq"+++++++|/home/bandso2/email.php

[noimad1]

Originally posted by crookedgoomba
i found the filter file and it looks like this

$header_to: begins "inq"[e-mail]
$header_to: begins "inq"+++++++|/home/bandso2/email.php

[/B]

Sounds like you need to find yourself a new host!

I am assuming that is the filter file create by cpanel? It looks like it is setup correctly.

What lunar pages could do if they really wanted to help is pause exim (we usually do this by putting a bad character in the antivirus.exim file), then have the user send the mail which will make it get stuck in the mail que. Then you can remove the letter from the antivirus.exim file, go into the web host manager and manually deliver the mail. Then you can follow its exact path and see where the mail is going...It may just be getting dumped right away.

[crookedgoomba]

Originally posted by noimad1
Sounds like you need to find yourself a new host!

haha, well they have been great up until now. i do,however, have an issue with them regarding how long it takes to send mail through php. first thing's first, though. im waiting for a reply from them (they're usually prompt). i will suggest your test to them if they are once again not helpful.

ME:
the code works fine. it has been properly tested. i did, however test the filtering by setting up another filter and having it simply forward to another pop account. i got nothing. the 'test filter' message on cpanel said it was recognized, however the action was not taken. please help. thanks.

THEM:
Hello,

Have you tried setting the script to chmod 666 or 777. Since the emails will be written to the file, the file will need to be writable.

Best regards,

ME:
yes, i have. it still didn't work, and it also doesn't explain why the other filter i set up (the forwarder) didn't work. also, am i incorrect in assuming the email will be sent to php://stdin??

PS: I originally had the CHMOD at 755

[crookedgoomba]

ok, good times. the filter works and the code is fine. i have it reading and processing emails.

one last issue... this is returned to the sender:

This message was created automatically by mail delivery software.


A message that you sent could not be delivered to one or more of its
recipients. This is a permanent error. The following address(es) failed:


  pipe to |/home/bandso2/email.php
    generated by [email][e-mail][/email]


The following text was generated during the delivery attempt:


------ pipe to |/home/bandso2/email.php
       generated by [email][e-mail][/email] ------


Content-type: text/html
X-Powered-By: PHP/4.3.4