1

Topic: Need help configuring a Domain Catch-all account that has mailboxes.

==================== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.7
- Linux/BSD distribution name and version: Ubunto 16.04 TLS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySql
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? Bo
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hi

I have upgraded from 0.9.6 to 0.9.7 on a new server and migrated the DB and user mailbox as per the instructions on the Documentation site, including how to set up the Catchall domain records for 0.9.7 which uses the forwarding tables.

My issue is that when I set the record active, it sends all emails to the catchall account including those that are for real users in the domain. 

  • My Alias Table is empty

  • My Alias_domain Table has 1 entry with the Alias_domain and Target_Domain set to the same value (My Domain)

  • My Forwardings Table has 5 entries 4 for specific user forwards and the domain record. Note the Domain record is currently set to not active.

Forwardings Table

|1|postmaster@somedomain.com|ian@somedomain.com|somedomain.com|somedomain.com|0|1|0|1
|3|root@somedomain.com|ian@somedomain.com|somedomain.com|somedomain.com|0|1|0|1
|4|root@smtp.somedomain.com|ian@somedomain.com|somedomain.com|somedomain.com|0|1|0|1
|5|@somedomain.com|ian@somedomain.com|somedomain.com|somedomain.com|0|0|0|0

My Postfix Main.cf Virtual Map sections

#
# Lookup virtual mail accounts
#
transport_maps =
    proxy:mysql:/etc/postfix/mysql/transport_maps_user.cf
    proxy:mysql:/etc/postfix/mysql/transport_maps_domain.cf

sender_dependent_relayhost_maps =
    proxy:mysql:/etc/postfix/mysql/sender_dependent_relayhost_maps.cf

# Lookup table with the SASL login names that own the sender (MAIL FROM) addresses.
smtpd_sender_login_maps =
    proxy:mysql:/etc/postfix/mysql/sender_login_maps.cf

virtual_mailbox_domains =
    proxy:mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf

relay_domains =
    $mydestination
    proxy:mysql:/etc/postfix/mysql/relay_domains.cf

virtual_mailbox_maps =
    proxy:mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf

virtual_alias_maps =
    proxy:mysql:/etc/postfix/mysql/catchall_maps.cf
    proxy:mysql:/etc/postfix/mysql/virtual_alias_maps.cf
    proxy:mysql:/etc/postfix/mysql/domain_alias_maps.cf
    proxy:mysql:/etc/postfix/mysql/domain_alias_catchall_maps.cf

sender_bcc_maps =
    proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf
    proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf

recipient_bcc_maps =
    proxy:mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf
    proxy:mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf

----

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

2

Re: Need help configuring a Domain Catch-all account that has mailboxes.

*) Did you ever create mail users manually with SQL command line?
*) All mail users must have one record in `vmail.mailbox` table, ALSO `vmail.forwardings`. Do you have both of them?

3 (edited by globalit 2017-09-10 16:40:06)

Re: Need help configuring a Domain Catch-all account that has mailboxes.

Ok...

No I haven't created any new users since migrating to 0.9.7 and there were not any entries in the Forwardings table for existing users I migrated over.

I have now created a new user and can see the new user has a record in the Forwarding table... I created matching records for each mailbox and It now works as intended...  Re-Reading the migration document, is this what the migrate_sql_alias_table.py script does....

4

Re: Need help configuring a Domain Catch-all account that has mailboxes.

globalit wrote:

Re-Reading the migration document, is this what the migrate_sql_alias_table.py script does....

Yes.