14 messages in com.mysql.lists.eventum-usersRE: Bandwidth overusage
FromSent OnAttachments
Andrew Hankinson21 Sep 2006 22:04 
Andrew Hankinson25 Sep 2006 07:42 
Georger Araujo25 Sep 2006 07:56 
Bryan Alsdorf25 Sep 2006 07:58 
Kipp Grose25 Sep 2006 08:00 
Andrew Hankinson25 Sep 2006 08:05 
Andrew Hankinson26 Sep 2006 08:35 
Harri Porten26 Sep 2006 09:01 
Andrew Hankinson26 Sep 2006 09:06 
Bryan Alsdorf26 Sep 2006 09:15 
Tibor Gellert26 Sep 2006 09:19 
Stephen Allen26 Sep 2006 09:20 
Andrew Hankinson26 Sep 2006 09:38 
Andrew Hankinson30 Oct 2006 21:04 
Subject:RE: Bandwidth overusage
From:Kipp Grose (k.gr@claimsecure.com)
Date:09/25/2006 08:00:35 AM
List:com.mysql.lists.eventum-users

Hi Andrew:

In your first post about the mail issues, it would be your mail server that was generating 7GB of traffic, not the web server / Eventum. If you've really disabled the cron jobs, then there is no way that Eventum can be generating any traffic to the outside world on it's own except for people viewing the webpages. You should take a look at your web server logs. If that doesn't turn anything up, I think you need to start examining the outbound packets to see where they are going to. At this point, I doubt what you are experiencing has anything to do with Eventum.

Kipp Grose ClaimSecure Web Developer k.grose @claimsecure.com <mailto:k.gr@claimsecure.com>

-----Original Message----- From: Sent: None Subject:

h=received:mime-version:to:message-id:content-type:references:from:subject: date:x-mailer;

b=stpUAr+wZcCMavL8bkPHbXv9J3mIX8DulvIs0X/pch6eDMJsXRO9U2RL4oRQRGuxp0sZhaEs5

n3/lMKNluZjk+KuInr/LQgGDcx+TkZj9iVhJgoj6brUGWxPwCHzemSZ5Bm3sejgACoc6krl9+N9 WABtZKVxzgUYn6zKyWGufew= Mime-Version: 1.0 (Apple Message framework v752.2) To: even@lists.mysql.com Message-Id: <4FB6@gmail.com> Content-Type: multipart/alternative; boundary=Apple-Mail-1-499572667 References: <CE49@gmail.com> From: Andrew Hankinson <andr@gmail.com> Subject: Re: Bandwidth overusage Date: Mon, 25 Sep 2006 10:43:19 -0400 X-Mailer: Apple Mail (2.752.2) X-imss-version: 2.042 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:2 M:12 S:5 R:5 X-imss-settings: Baseline:3 C:4 M:4 S:3 R:3 (0.5000 0.5000)

--Apple-Mail-1-499572667 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed

To add an update to this issue, I've completely disabled the cron jobs, and I'm still seeing a huge amount of traffic coming from my eventum installation, so I don't think it's e-mail related, or related to the process_mail_queue

I thought that my site might have been used to send spam e-mail through a vulnerability in the system, but I've put it behind Apache's login mechanism (.htaccess) and that didn't seem to have any effect.

Can someone help here?

From: Andrew Hankinson <andr@gmail.com> Date: 22 September, 2006 1:05:12 AM EDT (CA) To: even@lists.mysql.com Subject: Bandwidth overusage

Hi all,

I have been having an ongoing battle with Eventum and bandwidth usage.

A couple weeks ago, I was seeing massive amounts of traffic being sent from our server (7+ GB/day!) This is for a small (~200 visitors/day) website, so I knew something was not right.

I eventually narrowed it down to Eventum - as best I can tell, it was trying to send out e-mails, the e-mails were bouncing back, creating more e-mails to send, and not having any success... they just kept bouncing around in the system, building and building until they were generating about 7G of traffic!

I went through the database, cleaned out these error e-mails, installed a version of Eventum with the patch that Brian sent around a couple weeks ago, and everything went back to normal.

Except now, I'm starting to see my traffic go up again. I'm at 800MB today, up from 300 yesterday, up from 200 the day before. I removed Eventum from its directory and put it in a 'quarantine' directory, and now my traffic has returned to normal. (~50MB/day) Only this time, I've looked through the database and I can't find any errors or queued messages, no messages in the error logs, nothing.

The only thing I can think of is that sometimes people reply to an issue that aren't on the 'notification' list, so their message is 'blocked' and made into a note. Before, this used to generate a new note every time the mail queue cron job ran. Prior to the new version, I would get an e-mail every time this happened, so I would go in and add the person to the notification list, making their message unblocked. Now, the system just creates one note so I don't bother adding them to the notification list. Is it possible that it's still creating all those notes and e-mailing it out every time the mail_queue is processed, I'm just not seeing it?

Again, no error messages in the database, no error messages in the logs, and nothing showing in the mail queue. I'm stumped.

I'm using a nightly build (because it contained the patch), but I was having this issue before with 1.7.1 Release. It's on a LAMP host. If you need any more detail, I'd be happy to oblige.

Any clues? Thoughts?

Cheers, Andrew

--Apple-Mail-1-499572667--

Visit our website at: http://www.claimsecure.com

********Internet Email Confidentiality******** This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, or believe that you may
have received this communication in error, please notify the sender immediately
by return e-mail, delete this e-mail and destroy any copies. In addition, you
should not print, copy, retransmit, disseminate, or otherwise use the
information contained in this communication. Unless otherwise stated, opinions
expressed in this e-mail are those of the author and are not endorsed by the
author's company. Thank you.