List:Eventum General Discussion« Previous MessageNext Message »
From:Joao Prado Maia Date:May 6 2004 10:03pm
Subject:RE: auto-associate incoming email with issue
View as plain text  
Jason,

Were you ever able to fix these problems? I would be curious to see whether
you have the correct configuration for the email routing, since the To:
header in the example email seems correct to me.

--Joao


> -----Original Message-----
> From: Jason Etheridge [mailto:jasone@stripped]
> Sent: Monday, April 19, 2004 8:15 AM
> To: eventum-users
> Subject: Re: auto-associate incoming email with issue
>
>
> > 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
>
>
> --
> Eventum Users Mailing List
> For list archives: http://lists.mysql.com/eventum-users
> To unsubscribe:
http://lists.mysql.com/eventum-users?unsub=1

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