3 messages in com.mysql.lists.eventum-usersRe: Error logs filling up
FromSent OnAttachments
Andrew Hankinson09 Sep 2006 13:55 
Bryan Alsdorf09 Sep 2006 22:14 
Kraer, Joseph11 Sep 2006 11:34 
Subject:Re: Error logs filling up
From:Bryan Alsdorf (bry@mysql.com)
Date:09/09/2006 10:14:36 PM
List:com.mysql.lists.eventum-users

Hi Andrew,

Error #1 seems to be caused by you receiving a malformed email (usually spam). Since it had an invalid from address, your smtp server uses @localhost as the address, which is invalid. Everytime eventum tried to send the email, it added a new error message. I am not sure about error #2, but it is most likely related.

The good news, there is a fix for our next release that will prevent this error log from getting so massive. If you are interested now, I can try to send you the patch.

Best Regards, /bryan

Andrew Hankinson wrote:

Hello all,

I seem to have a runaway error problem that I would appreciate any help with.

I have the cron job set up to check our support e-mail account every 5 minutes, and to process the e-mail queue every 10.

Our Eventum error log grew to almost 300M (!) before I noticed this problem. It was filling up with two errors (sensitive information has been changed):

****Error 1**** [Sat Sep 09 16:30:04 2006] An error was found on line '234' of script '/home/directory/public_html/support/include/class.mail_queue.php'.

The error message passed to us was:

'Failed to add recipient: @localhost [SMTP: Invalid response code received from server (code: 501, response: <@localhost>: no local part)]' A more detailed error message follows: '' A backtrace is available: Array ( [0] => Array ( [file] => /home/directory/public_html/support/include/class.mail_queue.php [line] => 177 [function] => _sendemail [class] => mail_queue [type] => :: [args] => Array ( [0] => [1] => MIME-Version: 1.0 Message-ID: <even@www.website.ca> In-Reply-To: <even@www.website.ca> References: <even@www.website.ca> From: "upda@website.ca " <upda@website.ca> To: Subject: [#18] Issue Created: Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit Date: Tue, 8 Aug 2006 04:20:03 +0000

[2] => Dear @localhost,

This is an automated message sent at your request from Updates.

We received a message from you and for your convenience, we created an issue that will be used by our staff to handle your message.

Date: 1970-01-01 00:00:00 From: Subject: Issue #: 18 Summary: Priority: normal Submitted: Tue, 08 Aug 2006, 04:20:03 UTC ) ) [1] => Array ( [file] => /home/directory/public_html/support/misc/process_mail_queue.php [line] => 70 [function] => send [class] => mail_queue [type] => :: [args] => Array ( [0] => error [1] => 50 ) ) )

****Error 2**** [Sat Sep 09 16:30:04 2006] An error was found on line '234' of script '/home/directory/public_html/support/include/class.mail_queue.php'. The error message passed to us was: 'No From: address has been provided' A more detailed error message follows: '' A backtrace is available:

Array ( [0] => Array ( [file] => /home/directory/public_html/support/include/class.mail_queue.php [line] => 177 [function] => _sendemail [class] => mail_queue [type] => :: [args] => Array ( [0] => "Admin User" <webm@directory.ca> [1] => MIME-Version: 1.0 Message-ID: <even@www.website.ca> In-Reply-To: <even@www.website.ca> References: <even@www.website.ca> Subject: [#18] To: "Admin User" <webm@website.ca> X-Eventum-Category: X-Eventum-Project: Our Project X-Eventum-Type: other_email Date: Tue, 8 Aug 2006 04:20:04 +0000 [2] => ) ) [1] => Array ( [file] => /home/directory/public_html/support/misc/process_mail_queue.php [line] => 70 [function] => send [class] => mail_queue [type] => :: [args] => Array ( [0] => error [1] => 50 ) ) ) *******End Error Logs*****

This went through for every issue that we have in the system, even if it is "closed." I'm not sure what these mean, exactly - I think I have everything set up correctly, and I couldn't see where it was trying to send to "localhost."

Any help would be greatly appreciated.

Are you MySQL certified? www.mysql.com/certification