Topic: Huge delay in mail delivery!!

I have just migrated from a Sendmail server to a new iRedmail server setup. Mail is flowing, however, I am seeing about a 30 min delay on all message delivery. I've played with the greylisting a bit to deal with several Black Listed friendly IP/Hosts. Any idea what I might have going on?

Re: Huge delay in mail delivery!!

I don't know if this is related as I'm not sure what I'm seeing here, but it would appear the messages are getting queued and not released. I've got 1600 customers breathing fire and I could sure use some help here. I'm about ready to go back to the pos Sendmail server.... It worked...

Re: Huge delay in mail delivery!!

*) Delay of receiving emails is caused by greylisting, enabled in Policyd or Cluebringer.*) If you configure Amavisd to store basic info of in/out emails in SQL server, Amavisd will insert records into SQL database "amavisd". You should use script provided by iRedAdmin-Pro (iRedAdmin-Pro-x.y.z/tools/cleanup_amavisd_db.py) to remove old records this database. Please open this file, read comments on top of this file, you will know how to use it. You can execute it manually, but please setup a daily cron job to execute it.

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

Re: Huge delay in mail delivery!!

ZhangHuangbin wrote:

*) Delay of receiving emails is caused by greylisting, enabled in Policyd or Cluebringer.*) If you configure Amavisd to store basic info of in/out emails in SQL server, Amavisd will insert records into SQL database "amavisd". You should use script provided by iRedAdmin-Pro (iRedAdmin-Pro-x.y.z/tools/cleanup_amavisd_db.py) to remove old records this database. Please open this file, read comments on top of this file, you will know how to use it. You can execute it manually, but please setup a daily cron job to execute it.

Hi Zhang,

I didn't configure amavisd to store x,y, or z, this was a product of the iRedMail install and configuration. I'm struggling for an explanation of the relationship of these files in the db and in the mail queue. Do I understand that 1) mail in queue can be delivered, but fail to get removed from mysql tables?, 2) removing the messages via the script does no harm with respect to msgs in the mail queue? I have read and ran the script, but again, nowhere do I find a clear explanation of how these tables do or do not relate to the mail queue leaving room for confusion.

Re: Huge delay in mail delivery!!

Do I understand that 1) mail in queue can be delivered, but fail to get removed from mysql tables?

Yes, records in SQL db won't be removed automatically. but iRedAdmin-Pro provides a script (iRedAdmin-Pro-x.y.z/tools/cleanup_amavisd_db.py) to help you remove old records.

tonyd wrote:

2) removing the messages via the script does no harm with respect to msgs in the mail queue?

Yes, records in Amavisd SQL db is just a log, not real email messages.

tonyd wrote:

I have read and ran the script, but again, nowhere do I find a clear explanation of how these tables do or do not relate to the mail queue leaving room for confusion.

This records were inserted by Amavisd, used to help track in/out emails, but they're not real email messages like the ones in Postfix mail queues (/var/spool/postfix/). You can delete records in Amavisd SQL db anytime you want, but please don't delete messages in Postfix mail queues.

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?