> Sorry, I didn't get it. So the proper emails _are_ being piped into
> route_email.php?
Right. I've disabled the .forward, so I'll show you an example
manually:
Here's the complete text that will be fed to route_email.php:
eventum@penguin:~$ cat /var/spool/mail/eventum
From jasone@stripped Mon Apr 19 08:12:02 2004
Return-Path: <jasone@stripped>
Delivered-To: issue_1@stripped
Received: by penguin (Postfix, from userid 1002)
id AF431D347F; Mon, 19 Apr 2004 08:12:02 -0400 (EDT)
Received: from [192.168.0.2] (unknown [66.168.184.244])
by penguin (Postfix) with ESMTP id 38437D347D
for <issue_1@stripped>; Mon, 19 Apr 2004 08:12:02 -0400
(EDT)
Mime-Version: 1.0 (Apple Message framework v613)
Content-Transfer-Encoding: 7bit
Message-Id: <C41EEA8F-91FA-11D8-B7B7-0003938AF64A@stripped>
Content-Type: text/plain; charset=US-ASCII; format=flowed
To: Admin User [] <issue_1@stripped>
From: Jason Etheridge <jasone@stripped>
Subject: route me please
Date: Mon, 19 Apr 2004 08:12:02 -0400
X-Mailer: Apple Mail (2.613)
X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on
penguin.georgialibraries.org
X-Spam-Status: No, hits=-99.9 required=2.5 tests=AWL,USER_IN_WHITELIST
autolearn=ham version=2.63
X-Spam-Level:
-- Jason
No errors below. I never get consistent results. Computers hate me. :D
eventum@penguin:~$ cat /var/spool/mail/eventum | php4 -q
/var/www/penguin.georgialibraries.org/eventum/misc/route_emails.php 1
eventum@penguin:~$
> Which queries are you "getting" ? And how? :)
From the mysql.log for the above command:
040419 8:15:47 789 Connect eventum_user@localhost on
789 Init DB eventum_db
789 Init DB eventum_db
789 Query SHOW TABLES
789 Quit
I seem to remember more activity last week. Hrmph. If I download that
same email from within Eventum, the pertinent SQL seems to be:
802 Query INSERT INTO
eventum_db.eventum_support_email
(
sup_ema_id,
sup_iss_id,
sup_message_id,
sup_date,
sup_from,
sup_to,
sup_cc,
sup_subject,
sup_body,
sup_full_email,
sup_has_attachment
) VALUES (
1,
0,
'<C41EEA8F-91FA-11D8-B7B7-0003938AF64A@stripped>',
'2004-04-19 12:12:02',
'Jason Etheridge <jasone@stripped>',
'Admin@UNKNOWN,UNEXPECTED_DATA_AFTER_ADDRESS@.SYNTAX-ERROR.',
'',
'route me please',
'
-- Jason
',
'Return-Path: <jasone@stripped>
Delivered-To: issue_1@stripped
Received: by penguin (Postfix, from userid 1002)
id AF431D347F; Mon, 19 Apr 2004 08:12:02 -0400 (EDT)
Received: from [192.168.0.2] (unknown [66.168.184.244])
by penguin (Postfix) with ESMTP id 38437D347D
for <issue_1@stripped>; Mon, 19 Apr 2004 08:12:02 -0400
(EDT)
Mime-Version: 1.0 (Apple Message framework v613)
Content-Transfer-Encoding: 7bit
Message-Id: <C41EEA8F-91FA-11D8-B7B7-0003938AF64A@stripped>
Content-Type: text/plain; charset=US-ASCII; format=flowed
To: Admin User [] <issue_1@stripped>
From: Jason Etheridge <jasone@stripped>
Subject: route me please
Date: Mon, 19 Apr 2004 08:12:02 -0400
X-Mailer: Apple Mail (2.613)
X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on
penguin.georgialibraries.org
X-Spam-Status: No, hits=-99.9 required=2.5 tests=AWL,USER_IN_WHITELIST
autolearn=ham version=2.63
X-Spam-Level:
Status:
-- Jason
',
'0'
)
802 Quit
Though of course that didn't get associated with an existing issue.
>> ema_folder is empty, though. Is that important?
> Yes, but only for IMAP servers. I'm guessing that you are using a POP3
> server, right?
Well, I have both POP3 and IMAP running, but neither should come into
play with .forward and route_email.php. I'm not even sure if the email
hits the local mail spool at that point. I have the account configured
as pop3 within Eventum though; I'll try it as IMAP. Same behavior.
I'm going to wipe everything again and do a fresh install.
-- Jason
