1 Topic by apalanir

  • apalanir
  • Member
  • Offline
  • Registered: 2023-09-12
  • Posts: 4

Topic: Catch all not working Ubuntu 22.04

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.6.3
- Deployed with iRedMail Easy
- Linux/BSD distribution name and version:  22.04 LTS 64-bit
- 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.
====


Hi everybody.
I am trying to add a universal account for each domain by following this instruction:
$ mysql -u root -p
sql> USE vmail;
sql> INSERT INTO forwardings (address, forwarding, domain, dest_domain)
                      VALUES ('domain.com', 'dest@example.com', 'domain.com', 'example.com');

But as a result, I get a situation in which all emails coming to the domain end up in the mailbox I specified. When viewing the headers of incoming emails, I see an existing mailbox in my domain as a target, but the letter still ends up in the mailbox I specified "for everyone".

Also in my var/log/maillog there is no error for this situation, just redirection.

I have looked through the topics on the forum, I have everything, I have looked through all cases of such an error and everything that helped them in my case already exists and apparently works. I am grateful in advance for any help.

----

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

2 Reply by dejavux

  • dejavux
  • Member
  • Offline
  • Registered: 2018-01-16
  • Posts: 25

Re: Catch all not working Ubuntu 22.04

apalanir wrote:

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.6.3
- Deployed with iRedMail Easy
- Linux/BSD distribution name and version:  22.04 LTS 64-bit
- 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.
====


Hi everybody.
I am trying to add a universal account for each domain by following this instruction:
$ mysql -u root -p
sql> USE vmail;
sql> INSERT INTO forwardings (address, forwarding, domain, dest_domain)
                      VALUES ('domain.com', 'dest@example.com', 'domain.com', 'example.com');

But as a result, I get a situation in which all emails coming to the domain end up in the mailbox I specified. When viewing the headers of incoming emails, I see an existing mailbox in my domain as a target, but the letter still ends up in the mailbox I specified "for everyone".

Also in my var/log/maillog there is no error for this situation, just redirection.

I have looked through the topics on the forum, I have everything, I have looked through all cases of such an error and everything that helped them in my case already exists and apparently works. I am grateful in advance for any help.


I believe you have the wrong table on the insert.  The table is supposed to be alias, not forwardings.

See documentation here:  SQL: Add per-domain catch-all account

3 Reply by apalanir

  • apalanir
  • Member
  • Offline
  • Registered: 2023-09-12
  • Posts: 4

Re: Catch all not working Ubuntu 22.04

This option is non-working for versions higher than 0.9.7. I use version 1.6.3 and, accordingly, the instructions for it, but it does not work (

4 Reply by dejavux

  • dejavux
  • Member
  • Offline
  • Registered: 2018-01-16
  • Posts: 25

Re: Catch all not working Ubuntu 22.04

apalanir wrote:

This option is non-working for versions higher than 0.9.7. I use version 1.6.3 and, accordingly, the instructions for it, but it does not work (


My bad, you are correct.

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,055

Re: Catch all not working Ubuntu 22.04

Did you modify any Postfix config in /etc/postfix/main.cf? Please show us full output of command "postconf -n".

6 Reply by apalanir (edited by apalanir 2023-09-20 15:53:13)

  • apalanir
  • Member
  • Offline
  • Registered: 2023-09-12
  • Posts: 4

Re: Catch all not working Ubuntu 22.04

ZhangHuangbin wrote:

Did you modify any Postfix config in /etc/postfix/main.cf? Please show us full output of command "postconf -n".

Didn't make any changes. Here is the output of the postconf -n command


postconf -n
alias_database = hash:/etc/postfix/aliases
alias_maps = hash:/etc/postfix/aliases
allow_min_user = no
allow_percent_hack = no
biff = no
body_checks = pcre:/etc/postfix/body_checks.pcre
command_directory = /usr/sbin
compatibility_level = 2
content_filter = smtp-amavis:[127.0.0.1]:10024
daemon_directory = /usr/lib/postfix/sbin
data_directory = /var/lib/postfix
debug_peer_level = 2
debugger_command = PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin ddd $daemon_directory/$process_name $process_id & sleep 5
disable_vrfy_command = yes
dovecot_destination_recipient_limit = 1
enable_long_queue_ids = yes
enable_original_recipient = no
header_checks = pcre:/etc/postfix/header_checks
inet_interfaces = all
inet_protocols = all
lmtp_tls_mandatory_protocols = !SSLv2 !SSLv3 !TLSv1 !TLSv1.1
lmtp_tls_protocols = !SSLv2 !SSLv3 !TLSv1 !TLSv1.1
mail_owner = postfix
mailq_path = /usr/bin/mailq
message_size_limit = 15728640
milter_default_action = accept
milter_protocol = 6
mlmmj_destination_recipient_limit = 1
mydestination = $myhostname, localhost, localhost.localdomain
mydomain = mail.kapibara.by
myhostname = mail.kapibara.by
mynetworks = 127.0.0.1 [::1]
myorigin = mail.kapibara.by
newaliases_path = /usr/bin/newaliases
non_smtpd_milters = $smtpd_milters
postscreen_access_list = permit_mynetworks cidr:/etc/postfix/postscreen_access.cidr
postscreen_blacklist_action = drop
postscreen_dnsbl_action = drop
postscreen_dnsbl_reply_map = texthash:/etc/postfix/postscreen_dnsbl_reply
postscreen_dnsbl_sites = zen.spamhaus.org=127.0.0.[2..11]*3 b.barracudacentral.org=127.0.0.2*2
postscreen_dnsbl_threshold = 2
postscreen_dnsbl_whitelist_threshold = -2
postscreen_greet_action = drop
proxy_read_maps = $canonical_maps $lmtp_generic_maps $local_recipient_maps $mydestination $mynetworks $recipient_bcc_maps $recipient_canonical_maps $relay_domains $relay_recipient_maps $relocated_maps $sender_bcc_maps $sender_canonical_maps $smtp_generic_maps $smtpd_sender_login_maps $transport_maps $virtual_alias_domains $virtual_alias_maps $virtual_mailbox_domains $virtual_mailbox_maps $smtpd_sender_restrictions $sender_dependent_relayhost_maps
queue_directory = /var/spool/postfix
recipient_bcc_maps = proxy:mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf proxy:mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf
recipient_delimiter = +
relay_domains = $mydestination proxy:mysql:/etc/postfix/mysql/relay_domains.cf
sender_bcc_maps = proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf
sender_dependent_relayhost_maps = proxy:mysql:/etc/postfix/mysql/sender_dependent_relayhost_maps.cf
sendmail_path = /usr/sbin/sendmail
setgid_group = postdrop
show_user_unknown_table_name = no
smtp-amavis_destination_recipient_limit = 1
smtp_tls_CAfile = $smtpd_tls_CAfile
smtp_tls_CApath = /etc/ssl/certs
smtp_tls_loglevel = 1
smtp_tls_mandatory_protocols = !SSLv2 !SSLv3 !TLSv1 !TLSv1.1
smtp_tls_note_starttls_offer = yes
smtp_tls_protocols = !SSLv2 !SSLv3 !TLSv1 !TLSv1.1
smtp_tls_security_level = may
smtpd_command_filter = pcre:/etc/postfix/command_filter.pcre
smtpd_data_restrictions = reject_unauth_pipelining
smtpd_end_of_data_restrictions = check_policy_service inet:127.0.0.1:7777
smtpd_helo_required = yes
smtpd_helo_restrictions = permit_mynetworks permit_sasl_authenticated check_helo_access pcre:/etc/postfix/helo_access.pcre reject_non_fqdn_helo_hostname reject_unknown_helo_hostname
smtpd_milters = local:opendkim/opendkim.sock
smtpd_recipient_restrictions = reject_non_fqdn_recipient reject_unlisted_recipient check_policy_service inet:127.0.0.1:7777 permit_mynetworks permit_sasl_authenticated reject_unauth_destination check_policy_service inet:127.0.0.1:12340
smtpd_reject_unlisted_recipient = yes
smtpd_reject_unlisted_sender = yes
smtpd_sasl_path = private/dovecot-auth
smtpd_sasl_type = dovecot
smtpd_sender_login_maps = proxy:mysql:/etc/postfix/mysql/sender_login_maps.cf
smtpd_sender_restrictions = reject_non_fqdn_sender reject_unlisted_sender permit_mynetworks permit_sasl_authenticated check_sender_access pcre:/etc/postfix/sender_access.pcre reject_unknown_sender_domain
smtpd_tls_CAfile = /etc/ssl/certs/iRedMail.crt
smtpd_tls_CApath = /etc/ssl/certs
smtpd_tls_cert_file = /etc/ssl/certs/iRedMail.crt
smtpd_tls_dh1024_param_file = /etc/ssl/dh2048_param.pem
smtpd_tls_dh512_param_file = /etc/ssl/dh512_param.pem
smtpd_tls_key_file = /etc/ssl/private/iRedMail.key
smtpd_tls_loglevel = 1
smtpd_tls_mandatory_protocols = !SSLv2 !SSLv3 !TLSv1 !TLSv1.1
smtpd_tls_protocols = !SSLv2 !SSLv3 !TLSv1 !TLSv1.1
smtpd_tls_security_level = may
swap_bangpath = no
tls_random_source = dev:/dev/urandom
transport_maps = proxy:mysql:/etc/postfix/mysql/transport_maps_user.cf proxy:mysql:/etc/postfix/mysql/transport_maps_maillist.cf proxy:mysql:/etc/postfix/mysql/transport_maps_domain.cf
unknown_local_recipient_reject_code = 550
virtual_alias_domains =
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
virtual_gid_maps = static:2000
virtual_mailbox_base = /var/vmail
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf
virtual_minimum_uid = 2000
virtual_transport = dovecot
virtual_uid_maps = static:2000

7 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,055

Re: Catch all not working Ubuntu 22.04

This tutorial is still working in iRedMail, no idea why it doesn't work for you:
https://docs.iredmail.org/sql.create.catch-all.html

Did you restore SQL data after iRedMail installation? Or added new accounts by inserting SQL records manually?

8 Reply by apalanir (edited by apalanir 2023-09-20 22:44:30)

  • apalanir
  • Member
  • Offline
  • Registered: 2023-09-12
  • Posts: 4

Re: Catch all not working Ubuntu 22.04

Yes, I added new users from the mysql console. I didn't restore the database. After installing the server, I wrote a script for parsing users from another server belonging to me, and at the end of the script using sql imported new users. Could that be the problem?

9 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,055

Re: Catch all not working Ubuntu 22.04

Could be, and seems it's the problem.
I suggest use the script "create_mail_user_*" shipped in iRedMail package to add new users.
https://github.com/iredmail/iRedMail/tree/master/tools