1

Topic: Server Migration - no incoming mail

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.3.1
- Deployed with iRedMail Easy or the downloadable installer? Installer
- Linux/BSD distribution name and version: Ubunti 20.02
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MariaDB
- 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.
====

Well I thought it was all working - have migrated old server to new machine using the migration instructions.  Only difference is the nnnnew machine is iRedMail 1.3.1 whilst the old one was 1.3 - but I can see nothing in the changelog that would cause a problem.

Everything work EXCEPT incoming mail from external servers.  All ports are fine but I have this in the mail.log
Oct 10 18:38:55 HDVSa postfix/smtpd[6087]: NOQUEUE: reject: RCPT from mail-ej1-f41.google.com[209.85.218.41]: 450 4.7.1 <xxx@yyy.com>: Recipient address rejected: Temporary internal error; from=<test@gmail.com> to=<xxx@yyy.com> proto=ESMTP helo=<mail-ej1-f41.google.com>

I cannot work out what is wrong or what to do next?  Any ideas?

Thank you - have been at this for hours!

2

Re: Server Migration - no incoming mail

Dovecot log is a mess as well

Oct 10 18:51:17 HDVSa dovecot: quota-status(brewer@xxx.com)<6088><>: Error: auth-master: userdb lookup(brewer@xxx.com): Auth USER lookup failed
Oct 10 18:51:17 HDVSa dovecot: quota-status: Error: Failed to lookup user brewer@xxx.com: Internal error occurred. Refer to server log for more information.
Oct 10 18:51:40 HDVSa dovecot: auth-worker(1774): Warning: sqlpool(mysql): Query failed, retrying: Unknown column 'mailbox.enablequota-status' in 'where clause'

3

Re: Server Migration - no incoming mail

problem seems to be old server was Dovecot v2.2.32.2 (despite always being updated????) - new iRedMail download is 2.3.7.2

Have tried to follow 'Upgrade Dovecot from 2.2.x to 2.3.x'. - doesn't solve the problem.

Still have same error - will post from VM

Been at this for 18 hours - total nightmare

4

Re: Server Migration - no incoming mail

Oct 10 21:36:51 HDVSa dovecot: auth-worker(5411): Warning: sqlpool(mysql): Query failed, retrying: Unknown column 'mailbox.enablequota-status' in 'where clause'
Oct 10 21:36:51 HDVSa dovecot: auth-worker(5411): Error: sql(hannah@xxx.org.uk): User query failed: Unknown column 'mailbox.enablequota-status' in 'where clause'
Oct 10 21:36:51 HDVSa dovecot: quota-status(hannah@xxx.org.uk)<5489><>: Error: auth-master: userdb lookup(hannah@xxxx.org.uk): Auth USER lookup failed
Oct 10 21:36:51 HDVSa dovecot: quota-status: Error: Failed to lookup user hannah@xxx.org.uk: Internal error occurred. Refer to server log for more information.

5

Re: Server Migration - no incoming mail

Strangely one virtual domain on the server works for incoming  - no idea why?

6

Re: Server Migration - no incoming mail

Correction - 1 domain works for incoming from gmail only - small text message so presume no quota lookup?

7

Re: Server Migration - no incoming mail

Found the f''''er

[OPTIONAL] Enable mailbox quota status check in Dovecot and Postfix.

https://docs.iredmail.org/upgrade.iredm … -postfix_1

A discarded optional step = years ago.....  still got some errors but getting there

A note of caution - never run iRedMail on a Virtual machine without very robust backups!  VM disk capsule file had I/o errors which screwed up scheduled backups (the server still runs but mail items were being slowly lost) - capsule file was unrecoverable +> rebuild and migrate iredmail

19 hours and going...

Thank you Zhang for all the great documentation available to fault find and solve this stuff

8

Re: Server Migration - no incoming mail

Thanks for sharing. smile

----

Buy me a cup of coffee ($5) to support iRedMail:

buy me a cup of coffee