1

Topic: All mail delivered to catchall after upgrade to 0.9.8

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):  0.9.8 MARIADB edition.
- 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? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
I have been running an iredmail server for personal email for a few years, running iredmail 0.9.3.

I needed to move to a new hosting company, so I migrated to a clean install of 0.9.8.

Everything is working, except after following the instructions for setting up a catchall account (https://docs.iredmail.org/sql.create.catch-all.html) and removing the old catchall from the alias table, all mail to the afftected domain is going to the catchall account.  If I remove the record from the forwardings table, addressed mail is delivered normally to all accounts.

The only other thing to mention is that the catchall account is in the same domain as the mon-addressed mail being caught.

The SQL command I used to insert the catchall record was:
MariaDB [vmail]> INSERT INTO forwardings (address, forwarding, domain, dest_domain)    VALUES ('ingenious.co.nz', 'catchall@ingenious.co.nz', 'ingenious.co.nz', 'ingenious.co.nz');

----

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

2

Re: All mail delivered to catchall after upgrade to 0.9.8

Please show us command output for troubleshooting.

postconf virtual_alias_maps

3

Re: All mail delivered to catchall after upgrade to 0.9.8

[root@kereru ~]#
[root@kereru ~]# postconf virtual_alias_maps
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql/virtual_alias_maps.cf proxy:mysql:/etc/postfix/mysql/domain_alias_maps.cf proxy:mysql:/etc/postfix/mysql/catchall_maps.cf proxy:mysql:/etc/postfix/mysql/domain_alias_catchall_maps.cf

4

Re: All mail delivered to catchall after upgrade to 0.9.8

redcar wrote:

I have been running an iredmail server for personal email for a few years, running iredmail 0.9.3.
I needed to move to a new hosting company, so I migrated to a clean install of 0.9.8.

Question: did you upgrade from 0.9.3 to 0.9.4 first, then 0.9.5, ...?

5

Re: All mail delivered to catchall after upgrade to 0.9.8

ZhangHuangbin wrote:
redcar wrote:

I have been running an iredmail server for personal email for a few years, running iredmail 0.9.3.
I needed to move to a new hosting company, so I migrated to a clean install of 0.9.8.

Question: did you upgrade from 0.9.3 to 0.9.4 first, then 0.9.5, ...?

ZhangHuangbin wrote:
redcar wrote:

I have been running an iredmail server for personal email for a few years, running iredmail 0.9.3.
I needed to move to a new hosting company, so I migrated to a clean install of 0.9.8.

Question: did you upgrade from 0.9.3 to 0.9.4 first, then 0.9.5, ...?

Oops...  I somehow forgot that incremental upgrades are necessary.  I apologise for wasting your time.

Can you advise how to manually correct the database and configuration?
I do have the 0.9.3 installation still running on the old server.

Perhaps it would be a good idea for iredmail to detect and warn about database contents where a version seems to have been skipped?

6

Re: All mail delivered to catchall after upgrade to 0.9.8

After thinking about this, I have decided that I should go back to my 0.9.3 installation and apply the upgrades in sequence, then copy the database and postfix configuration across to my new sever (which currently has 0.9.8 installed)

One thing that confuses me slightly is in the 0.9.5-1 upgrade instructions is:

This bug was introduced in iRedMail-0.9.5. If you're upgrading from iRedMail-0.9.4 or earlier release, it's safe to ignore this step.

This implies (for me) that it is not always necessary to perform each upgrade step.  Can you clarify?

My 0.9.3 server uses Apache, but 0.9.8 must use nginx, should I ignore all the nginx related upgrade instructions?

7

Re: All mail delivered to catchall after upgrade to 0.9.8

BTW, I now see why did did not perform the incremental upgrades:  I followed the procedure for migrating to a new server https://docs.iredmail.org/migrate.to.ne … erver.html and it does not mention that the old server needs to be upgraded before the migration.

8

Re: All mail delivered to catchall after upgrade to 0.9.8

Hi,

Since few days my server going to send lots of spam messages. Still troubleshoot the issue but not yet rectified.
See the mailq logs . Pls  help
-------------------------------------------------------------------------
E00F5623192     1841 Wed Sep  5 12:46:18  dhule036@nnsbank.com
(delivery temporarily suspended: lost connection with mta6.am0.yahoodns.net[98.137.159.28] while sending RCPT TO)
                                         salazarfelix96@yahoo.com

E4783623150     1876 Wed Sep  5 12:30:17  pandurana030@nnsbank.com
               (connect to hltmail.com[209.200.154.50]:25: Connection refused)
                                         gotanocturna_17@hltmail.com

EE96F623432     1532 Wed Sep  5 12:36:23  warud023@nnsbank.com
(delivery temporarily suspended: lost connection with mx-apac.mail.gm0.yahoodns.net[106.10.248.84] while sending RCPT TO)
                                         ravikumar00956@yahoo.in

E475C62330F     1790 Wed Sep  5 12:33:51  bhagwannagar041@nnsbank.com
(delivery temporarily suspended: lost connection with mta5.am0.yahoodns.net[98.137.159.25] while sending RCPT TO)
                                         alflex1481@yahoo.com

E5FD8623228     1811 Wed Sep  5 12:32:04  dhule036@nnsbank.com
(delivery temporarily suspended: lost connection with mta5.am0.yahoodns.net[98.137.159.25] while sending RCPT TO)
                                         brunorios002@yahoo.com

E1D06622D98     1846 Wed Sep  5 12:11:39  dhule036@nnsbank.com
(delivery temporarily suspended: lost connection with mta6.am0.yahoodns.net[98.137.159.28] while sending RCPT TO)
                                         poloskypolosky@yahoo.com

E6E4C6230AD     1836 Wed Sep  5 12:28:15  bhagwannagar041@nnsbank.com
(delivery temporarily suspended: lost connection with mta5.am0.yahoodns.net[98.137.159.25] while sending RCPT TO)
                                         rigoacosta76@yahoo.com

E5E2E6230DE     1823 Wed Sep  5 12:28:50  warud023@nnsbank.com
(host mta7.am0.yahoodns.net[98.137.159.27] said: 421 4.7.0 [TSS04] Messages from 115.249.26.78 temporarily deferred due to user complaints - 4.16.55.1; see https://help.yahoo.com/kb/postmaster/SLN3434.html (in reply to MAIL FROM command))
                                         krissun06@yahoo.ca

EE7E9622EF6     1875 Wed Sep  5 12:21:59  manewada017@nnsbank.com
(delivery temporarily suspended: lost connection with mta5.am0.yahoodns.net[98.137.159.25] while sending RCPT TO)
                                         mmmiloveitrough@yahoo.com

E019362347C     1728 Wed Sep  5 12:37:00  khamla042@nnsbank.com
(delivery temporarily suspended: lost connection with mta5.am0.yahoodns.net[67.195.229.59] while sending RCPT TO)
                                         joshuadaugherty@ymail.com

-- 6791 Kbytes in 3899 Requests.
root@mail:/#

9

Re: All mail delivered to catchall after upgrade to 0.9.8

redcar wrote:

BTW, I now see why did did not perform the incremental upgrades:  I followed the procedure for migrating to a new server https://docs.iredmail.org/migrate.to.ne … erver.html and it does not mention that the old server needs to be upgraded before the migration.

This is not true.

The document mentions this:

IMPORTANT NOTE: There might be some changes in SQL structure, please read all upgrade tutorials for your current iRedMail release, then apply SQL structure related changes. Check upgrade tutorials for iRedMail.