==== Required information ====
- iRedMail version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Linux/BSD distribution name and version:
- Related log if you're reporting an issue:
======== Required information ====
- iRedMail version: 0.8.6
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Debian 7.1
- Related log if you're reporting an issue:
====

Hello Zhang,

some days ago I upgraded the iRedMail version from 0.8.5 to 0.8.6 following your upgrade guide.
Everything worked fine except for one issue:

You tell in your Wiki page that

There's a bug in Postfix MySQL query for domain transport, it doesn't check whether hosted domain is backup mx or not. Please fix it by following below steps.

http://iredmail.org/wiki/index.php?titl … ap_query_2

Historically we have been using the server to relay messages to other email servers.
We had to set "backupmx" in the database manually to 1 to make the relaying work correctly.

Now we have some domains with backupmx set to 1 and which have a relay setting enabled.
After applying the upgrade patch above, the relay does not work anymore - obvious, backupmx is 1 in database.

Now I undid the changes to the postfix file and restarted the service. The messages could now be delivered correctly.

As you have implemented the "Mark as Backup MX" option in iRedAdmin-Pro, it should reflect the actual setting in the database, right?
Unfortunately the checkbox is shown unchecked (with a blue question mark at the right side) even if the backupmx setting is "1" in the record.
It seems the checkbox is disabled and cannot be activated.
Maybe the software checks if a relay server is set and if yes it disables the checkbox?

Well, I have a relay server configured.
If I want to remove it (empty field "Relay/Transport Setting") and click on save, I get following error:

Error: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') WHERE domain='xxxx.de'' at line 1")

Ok, there should be a setting like "dovecot" but please show a warning or default an empty field to "dovecot"

When I set "backupmx" to 0 in the database, I get following error:

Recipient address rejected: User unknown in virtual mailbox table

Now I am confused.

- backupmx is required to accept emails, process and forward to a custom smtp server
- the blue question mark on the right side of the checkbox "Mark as backup MX" in iRedAdmin-Pro does tell "Backup MX does not work with custom relay"
- I cannot remove the relay setting but I can change it

What can I do?

Best regards,

Bernhard