Topic: suggestion : mysql mailling list
==== Required information ====
- iRedMail version: 0.8.6
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): Mysql
- Linux/BSD distribution name and version: Centos 6 64bits
- Related log if you're reporting an issue:
====
Hi,
using mysql version , aliases are unique, here is a change to allow multiple destination :
1. change the alias table structure as follow : run sql below
use vmail;
ALTER TABLE alias DROP PRIMARY KEY;
ALTER TABLE `alias` ADD `ID` INT NULL ;
ALTER TABLE `alias` ADD PRIMARY KEY(`ID`);
2. add the records for each destination (goto):
address : Distribution List Email
ex : All@domain.ltd
goto : real email address
domain : related domain
Note : this is a quick and dirty solution without having to touch any configuration files
ex :
address goto name moderators accesspolicy domain created modified expired active ID
all@domain.ltd said@domain.ltd NULL domain.ltd 0000-00-00 00:00:00 0000-00-00 00:00:00 31/12/99 00:00 1 3
all@domain.ltd postmaster@domain.ltd NULL domain.ltd 0000-00-00 00:00:00 0000-00-00 00:00:00 31/12/99 00:00 1 4
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.