Hi, I'm trying to pipe messages to a PHP script and although I can test the script on the command line by piping a text file with an email message in it, and it works fine, it's not getting run by DBMail.
My alias is: '[EMAIL PROTECTED]' -> '| /usr/local/bin/php -q /home/raincross-tech/testmail.php' The log seems to indicate that it's successfully piping, but I get no results. It may be my script, but like I said, when I run this command: cat mail.txt | /usr/local/bin/php -q /home/raincross-tech/testmail.php it works great. Any ideas? BTW, it's supposed to forward the mail to a list of recipients in a database table. I've attached a snippet of the log if you're interested. Thanks! -Micah
y 14 12:26:39 raincross-tech postfix/smtpd[14218]: connect from harrier.mail.pas.earthlink.net[207.217.120.12] May 14 12:26:40 raincross-tech postfix/smtpd[14218]: 110385BC11A: client=harrier.mail.pas.earthlink.net[207.217.120.12] May 14 12:26:40 raincross-tech postfix/cleanup[14219]: 110385BC11A: message-id=<[EMAIL PROTECTED]> May 14 12:26:40 raincross-tech postfix/qmgr[28499]: 110385BC11A: from=<[EMAIL PROTECTED]>, size=809, nrcpt=1 (queue active) May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): starting procedure May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): found [DBMAIL] tag May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): no value specified for service item []. May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): item [host] value [raincross-tech.com] added May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): item [user] value [*****] added May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): item [pass] value [******] added May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): item [db] value [dbmail] added May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): no value specified for service item []. May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): item [TRACE_LEVEL] value [1] added May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): service [DBMAIL] added May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): config for [DBMAIL] read, found [5] items May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): starting procedure May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): found [SMTP] tag May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): item [SENDMAIL] value [/usr/sbin/sendmail] added May 14 12:26:40 raincross-tech postfix/smtpd[14218]: disconnect from harrier.mail.pas.earthlink.net[207.217.120.12] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): item [DBMAIL_FROM_ADDRESS] value [EMAIL PROTECTED] added May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): item [POSTMASTER] value [EMAIL PROTECTED] added May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): item [AUTO_NOTIFY] value [no] added May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): item [AUTO_REPLY] value [no] added May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): item [TRACE_LEVEL] value [5] added May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): service [SMTP] added May 14 12:26:40 raincross-tech dbmail/smtp[14243]: ReadConfig(): config for [SMTP] read, found [6] items May 14 12:26:40 raincross-tech dbmail/smtp[14243]: GetConfigValue(): searching value for config item [trace_level] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: GetConfigValue(): found value [5] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: GetConfigValue(): searching value for config item [host] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: GetConfigValue(): found value [raincross-tech.com] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: GetConfigValue(): searching value for config item [db] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: GetConfigValue(): found value [dbmail] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: GetConfigValue(): searching value for config item [user] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: GetConfigValue(): found value [*****] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: GetConfigValue(): searching value for config item [pass] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: GetConfigValue(): found value [****] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: read_header(): readheader start May 14 12:26:40 raincross-tech dbmail/smtp[14243]: read_header(): end header found May 14 12:26:40 raincross-tech dbmail/smtp[14243]: read_header(): readheader done May 14 12:26:40 raincross-tech dbmail/smtp[14243]: read_header(): found header [Return-Path: <[EMAIL PROTECTED]> Received: from harrier.mail.pas.earthlink.net (harrier.mail.pas.earthlink.net [207.217.120.12]) ^Iby raincross-tech.com (raincross-tech.com) with ESMTP id 110385BC11A ^Ifor <[EMAIL PROTECTED]>; Wed, 14 May 2003 12:26:40 -0500 (CDT) Received: from 66-215-208-127.riv-eres.charterpipeline.net ([66.215.208.127]) ^Iby harrier.mail.pas.earthlink.net with esmtp (Exim 3.33 #1) ^Iid 19FzzV-0003vV-00 ^Ifor [EMAIL PROTECTED]; Wed, 14 May 2003 10:24:33 -0700 From: Micah Stevens <[EMAIL PROTECTED]> Organization: 9250x.com To: [EMAIL PROTECTED] Subject: test subject Date: Wed, 14 May 2003 10:16:06 -0700 User-Agent: KMail/1.5.1 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <[EMAIL PROTECTED]> ] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: read_header(): header size [811] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: read_header(): function successfull May 14 12:26:40 raincross-tech dbmail/smtp[14243]: mime_readheader(): entering mime loop May 14 12:26:40 raincross-tech dbmail/smtp[14243]: mime_readheader(): found double newline; header size: 21 lines May 14 12:26:40 raincross-tech dbmail/smtp[14243]: mail_adr_list(): mimelist currently has [14] nodes May 14 12:26:40 raincross-tech dbmail/smtp[14243]: mail_adr_list(): mail address parser starting May 14 12:26:40 raincross-tech dbmail/smtp[14243]: mail_adr_list(): total fields in header 14 May 14 12:26:40 raincross-tech dbmail/smtp[14243]: mail_adr_list(): scanning for Return-Path May 14 12:26:40 raincross-tech last message repeated 13 times May 14 12:26:40 raincross-tech dbmail/smtp[14243]: mail_adr_list(): found [EMAIL PROTECTED], next in list is (null) May 14 12:26:40 raincross-tech dbmail/smtp[14243]: mail_adr_list(): found 1 emailaddresses May 14 12:26:40 raincross-tech dbmail/smtp[14243]: mail_adr_list(): mail address parser finished May 14 12:26:40 raincross-tech dbmail/smtp[14243]: main(): using SPECIAL_DELIVERY to email addresses May 14 12:26:40 raincross-tech dbmail/smtp[14243]: mail_adr_list_special(): gathering info from command line May 14 12:26:40 raincross-tech dbmail/smtp[14243]: mail_adr_list_special(): adding [EMAIL PROTECTED] to userlist May 14 12:26:40 raincross-tech dbmail/smtp[14243]: auth_check_user(): checking user [EMAIL PROTECTED] in alias table May 14 12:26:40 raincross-tech dbmail/smtp[14243]: auth_check_user(): executing query, checks [-1] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: __auth_query(): executing query [SELECT deliver_to FROM aliases WHERE alias="[EMAIL PROTECTED]"] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: auth_check_user(): into checking loop May 14 12:26:40 raincross-tech dbmail/smtp[14243]: auth_check_user(): checking user [EMAIL PROTECTED] to | /usr/local/bin/php -q /home/raincross-tech/testmail.php May 14 12:26:40 raincross-tech dbmail/smtp[14243]: auth_check_user(): checking user [| /usr/local/bin/php -q /home/raincross-tech/testmail.php] in alias table May 14 12:26:40 raincross-tech dbmail/smtp[14243]: auth_check_user(): executing query, checks [1] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: __auth_query(): executing query [SELECT deliver_to FROM aliases WHERE alias="| /usr/local/bin/php -q /home/raincross-tech/testmail.php"] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: auth_check_user(): adding [| /usr/local/bin/php -q /home/raincross-tech/testmail.php] to deliver_to address May 14 12:26:40 raincross-tech dbmail/smtp[14243]: insert_messages(): user [EMAIL PROTECTED] found total of [1] aliases May 14 12:26:40 raincross-tech dbmail/smtp[14243]: insert_messages(): alias deliver_to is [| /usr/local/bin/php -q /home/raincross-tech/testmail.php] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: insert_messages(): no numeric value in deliver_to, calling external_forward May 14 12:26:40 raincross-tech dbmail/smtp[14243]: insert_messages(): we need to deliver [1] messages to external addresses May 14 12:26:40 raincross-tech dbmail/smtp[14243]: insert_messages(): allocating [524288] bytes of memory for readblock May 14 12:26:40 raincross-tech dbmail/smtp[14243]: insert_messages(): delivering to external addresses May 14 12:26:40 raincross-tech dbmail/smtp[14243]: GetConfigValue(): searching value for config item [SENDMAIL] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: GetConfigValue(): found value [/usr/sbin/sendmail] May 14 12:26:40 raincross-tech dbmail/smtp[14243]: pipe_forward(): delivering to 1 external addresses May 14 12:26:40 raincross-tech dbmail/smtp[14243]: pipe_forward(): opening pipe to command /usr/local/bin/php -q /home/raincross-tech/testmail.php May 14 12:26:40 raincross-tech dbmail/smtp[14243]: pipe_forward(): call to popen() successfull opened descriptor 6 May 14 12:26:40 raincross-tech dbmail/smtp[14243]: pipe_forward(): wrote header to pipe May 14 12:26:40 raincross-tech dbmail/smtp[14243]: pipe_forward(): Sending blocksize=8 total=8 (100%) May 14 12:26:40 raincross-tech dbmail/smtp[14243]: pipe_forward(): ferror reports 0, feof reports 0 on descriptor 6 May 14 12:26:40 raincross-tech dbmail/smtp[14243]: pipe_forward(): wrote data to pipe May 14 12:26:40 raincross-tech dbmail/smtp[14243]: pipe_forward(): closing pipes May 14 12:26:40 raincross-tech dbmail/smtp[14243]: pipe_forward(): descriptor_closed May 14 12:26:40 raincross-tech dbmail/smtp[14243]: insert_messages(): Freeing memory blocks May 14 12:26:40 raincross-tech dbmail/smtp[14243]: insert_messages(): header freed May 14 12:26:40 raincross-tech dbmail/smtp[14243]: insert_messages(): uniqueid freed May 14 12:26:40 raincross-tech dbmail/smtp[14243]: insert_messages(): strblock freed May 14 12:26:40 raincross-tech dbmail/smtp[14243]: insert_messages(): insertquery freed May 14 12:26:40 raincross-tech dbmail/smtp[14243]: insert_messages(): updatequery freed May 14 12:26:40 raincross-tech dbmail/smtp[14243]: insert_messages(): End of function May 14 12:26:40 raincross-tech dbmail/smtp[14243]: main(): freeing memory blocks May 14 12:26:40 raincross-tech dbmail/smtp[14243]: main(): they're all free. we're done. May 14 12:26:40 raincross-tech postfix/pipe[14226]: 110385BC11A: to=<[EMAIL PROTECTED]>, relay=dbmail, delay=0, status=sent (9250x.com)
