How to add domail alias in iRedMail open source edition?

Question

Looking at the vmail database of the iRedMail installation I see an alias_domain table which is currently empty.

Is it possible to add domain aliases with a MySQL query directly on the vmail.alias_domain table?

Solution

To use my Canadian .ca site as an alias to my .com site I would use something like.

mysql -uroot -p
mysql> USE vmail;
mysql> INSERT INTO alias_domain (alias_domain, target_domain) values ('mysite.ca', 'mysite.com');

Comments

[Amir Ali Akbari]

Did not work for me, any idea why? Mails are rejected with: ` Recipient address rejected: User unknown in virtual mailbox table.`

[jpforte-user227739]

Field active needs to set to 1 as well. INSERT INTO alias_domain (alias_domain, target_domain, active) VALUES ('mysite.ca', 'mysite.com', 1);