List:Eventum General Discussion« Previous MessageNext Message »
From:Jason Etheridge Date:April 19 2004 1:14pm
Subject:Re: auto-associate incoming email with issue
View as plain text  
> 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

Thread
FW: auto-associate incoming email with issueJoao Prado Maia15 Apr
  • RE: auto-associate incoming email with issueJoao Prado Maia16 Apr
    • Re: auto-associate incoming email with issueJason Etheridge16 Apr
      • RE: auto-associate incoming email with issueJoao Prado Maia16 Apr
        • Re: auto-associate incoming email with issueJason Etheridge16 Apr
          • RE: auto-associate incoming email with issueJoao Prado Maia16 Apr
            • Re: auto-associate incoming email with issueJason Etheridge19 Apr
              • RE: auto-associate incoming email with issueJoao Prado Maia7 May
                • Re: auto-associate incoming email with issueJason Etheridge8 May
                  • RE: auto-associate incoming email with issueJoao Prado Maia10 May
                    • Re: auto-associate incoming email with issueJason Etheridge11 May
                      • RE: auto-associate incoming email with issueJoao Prado Maia11 May