======== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.7 MYSQL Edition
- Linux/BSD distribution name and version: Ubuntu 16.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL 5.7
- 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.
https://docs.iredmail.org/sql.create.catch-all.html
====

Hi,

Thanks for this great product!

I have a new server set up fresh yesterday.

I want to set up a catchall for one of the domains, but first I wanted to check that I'm understanding the docs correctly.

It says:

With MySQL/MariaDB or PostgreSQL backend, you can add catch-all account for existing domain domain.com in SQL table vmail.alias like below:

// ...
sql> INSERT INTO forwardings (address, forwarding, domain, dest_domain)
                      VALUES ('domain.com', 'dest@example.com', 'domain.com', 'example.com');

I have an empty alias table - does this matter?

mysql> SELECT * FROM alias;
Empty set (0.00 sec)

mysql> SELECT COUNT(*) FROM alias;
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+
1 row in set (0.02 sec)

Can domain and dest_domain be the same? i.e. can I run to set up the catchall:

INSERT INTO forwardings (
  address, forwarding, domain, dest_domain
) VALUES (
  'mydomain.com', 'existing_address@mydomain.com', 'mydomain.com', 'mydomain.com'
);

Thanks in advance for your assistance,

d