1

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

2

Re: suggestion : mysql mailling list

Am i right that what you want to achieve is creating alias 'all@' with members 'said@' and 'postmaster@'? if so, you can try this:

sql> INSERT INTO alias (address, goto, domain) VALUES ('all@domain.ltd', 'said@domain.ltd,postmaster@domain.ltd', 'domain.ltd');

3

Re: suggestion : mysql mailling list

ZhangHuangbin wrote:

Am i right that what you want to achieve is creating alias 'all@' with members 'said@' and 'postmaster@'? if so, you can try this:

sql> INSERT INTO alias (address, goto, domain) VALUES ('all@domain.ltd', 'said@domain.ltd,postmaster@domain.ltd', 'domain.ltd');

Ok,

i didn't know i can put multiple entries in the goto field