IMPORTANT

If the server is behind a firewall (Destination NAT), then all connections are from the same IP (gateway IP). A service installed, fail2ban, will ban IP if it fails too much login. But then if it bans the IP, it bans all connection.

Disable fail2ban or create white list.

Installation

Very easy to install, just follow instructions.

All How-tos

mysql -u vmailadmin -p

How-to without Pro (paid)

Alias account (SQL)

http://www.iredmail.org/docs/sql.create.mail.alias.html

Create mail alias account with SQL command line

To create an mail alias account, you can simply insert a SQL record in table vmail.alias. For example:

sql> USE vmail; sql> INSERT INTO alias (address, goto, domain, islist) \      VALUES ('original@example.com', \              'user1@example.com,user2@example.com,user1@test.com', \              'example.com', \              1); 

NOTES:

• Please always use lower cases for email addresses.
• Multiple destination addresses must be separated by comma.
• If destination address is a mail user under domain hosted on localhost, it must exist. Otherwise emails sent to alias account will be bounced after expanded to destination addresses.

Allow member to send email as mailing list or mail alias

To allow member of mailing list (or mail alias) account to send email as this mailing list (or mail alias), please follw steps below:

• Remove reject_sender_login_mismatch in Postfix config file /etc/postfix/main.cf.
• Enable iRedAPD plugin reject_sender_login_mismatch in iRedAPD config file /opt/iredapd/settings.py.
• Add new setting in /opt/iredapd/settings.py to allow member to send email as mail list or mail alias:

ALLOWED_LOGIN_MISMATCH_LIST_MEMBER = True 

• Restart both Postfix and iRedAPD services.

SQL backend: Manage per-user alias addresses with SQL command line

Add additional email addresses sales@domain.com, bill@domain.com for existing user john@domain.com:

sql> USE vmail;  sql> INSERT INTO alias (address, goto, alias_to, is_alias, domain)                 VALUES ('sales@domain.com', 'john@domain.com', 'john@domain.com', 1, 'domain.com');  sql> INSERT INTO alias (address, goto, alias_to, is_alias, domain)                 VALUES ('bill@domain.com', 'john@domain.com', 'john@domain.com', 1, 'domain.com'); 

• Account sales@domain.com and bill@domain.com are NOT existing mail user accounts.
• Values of column alias.goto and alias.alias_to must be the same -- email address of the existing mail user.
• In above sample, bill@domain.com could be an email address which belongs to your alias domain.
• You're free to add as many additional email addresses as you want.