1

Topic: Migrated Server -- got mass rejections

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.1 MARIADB edition.
- Deployed with iRedMail Easy or the downloadable installer?  Downloadable
- Linux/BSD distribution name and version:  CentOS 7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx):  Nginx
- Manage mail accounts with iRedAdmin-Pro?  Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Good evening.  I had to swap back to my old email server after creating a brand new one.  I went from 0.9.9 MARIADB edition, to 1.1 MARIADB edition and all databases were updated and correct.  I've been searching all around the forum to find answers but found nothing to help.  Here is the log file message... there are hundreds for each of my clients.

postfix/smtpd[26840]: NOQUEUE: reject: RCPT from mta119b.pmx1.epsl1.com[142.54.244.119]: 450 4.7.1 <this@that.com>: Recipient address rejected: Internal error occurred. Refer to server log for more information.

I can't find the log file that would tell me the exact reason why I'm getting the message.  I got this one from the maillog.  I copied the var/vmail/ directory from the old server using:

sudo rsync -avzp --progress root@<IP address>:/var/vmail/ /var/vmail/

I also updated the SQL database using mysql -u root -p database < database.sql

My certbot certs were checked and good to go, and my DKIM entries were copied over accordingly.  This is the fourth time I've created a brand new server and moved everything over... but it's the first time I've ever lost any incoming emails due to this error.

What can I do to build a new server and trust that it will not reject all of the messages?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: Migrated Server -- got mass rejections

usafitz wrote:

postfix/smtpd[26840]: NOQUEUE: reject: RCPT from mta119b.pmx1.epsl1.com[142.54.244.119]: 450 4.7.1 <this@that.com>: Recipient address rejected: Internal error occurred. Refer to server log for more information.

Check extra log files:

/var/log/dovecot/*.log (or /var/log/dovecot*)
/var/log/iredapd/iredapd.log

3

Re: Migrated Server -- got mass rejections

consolidating log files (deleting old replies to this post):

DOVECOT LOG:
Feb 19 00:17:27 mail dovecot: auth-worker(6999): Warning: mysql: Query failed, retrying: Unknown column 'mailbox.enablequota-status' in 'where clause'
Feb 19 00:17:27 mail dovecot: auth-worker(6999): Error: sql(email): User query failed: Unknown column 'mailbox.enablequota-status' in 'where clause'
Feb 19 00:17:27 mail dovecot: quota-status(email): Error: user email: Auth USER lookup failed


IREDAPD LOG:
Feb 19 00:11:03 mail journal: iredapd [40.107.91.120] Client network is whitelisted: cidr=40.107.0.0/16
Feb 19 00:11:03 mail journal: iredapd [40.107.91.120] RCPT, email -> email, DUNNO [sasl_username=, sender=email, client_name=mail-dm3gcc02on2120.outbound.protection.outlook.com, reverse_client_name=mail-dm3gcc02on2120.outbound.protection.outlook.com, helo=GCC02-DM3-obe.outbound.protection.outlook.com, encryption_protocol=TLSv1.2, encryption_cipher=ECDHE-RSA-AES256-GCM-SHA384, server_port=, process_time=0.0195s]
Feb 19 00:11:03 mail journal: iredapd [40.107.91.120] Client network is whitelisted: cidr=40.107.0.0/16
Feb 19 00:11:03 mail journal: iredapd [40.107.91.120] RCPT, email -> email, DUNNO [sasl_username=, sender=email, client_name=mail-dm3gcc02on2120.outbound.protection.outlook.com, reverse_client_name=mail-dm3gcc02on2120.outbound.protection.outlook.com, helo=GCC02-DM3-obe.outbound.protection.outlook.com, encryption_protocol=TLSv1.2, encryption_cipher=ECDHE-RSA-AES256-GCM-SHA384, server_port=, process_time=0.0210s]

4

Re: Migrated Server -- got mass rejections

If I run the SQL commands again from the upgrade link, will that screw up anything?

cd /root/
wget -O iredmail.mysql https://github.com/iredmail/iRedMail/ra … mail.mysql
mysql vmail < /root/iredmail.mysql

It looks to me like 'where clause' refers to some SQL lookup.  Thoughts?

5

Re: Migrated Server -- got mass rejections

usafitz wrote:

Feb 19 00:17:27 mail dovecot: auth-worker(6999): Error: sql(email): User query failed: Unknown column 'mailbox.enablequota-status' in 'where clause'

Please follow our tutorial to fix it:
https://docs.iredmail.org/upgrade.iredm … -postfix_1