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
