CpVES Mailinglist feature

file: /etc/postfix/mysql-list-map.cf

user = mail
password = 
dbname = mail_system
hosts = 127.0.0.1
table = lists
select_field = address
where_field = address
additional_conditions = AND access = '1'

file: /etc/postfix/mysql-list-transport.cf

user = mail
password = 
dbname = mail_system
hosts = 127.0.0.1
table = lists
select_field = 'listsys:'
where_field = address
additional_conditions = AND access = '1'

file: /etc/postfix/master.cf

listsys   unix  -       n       n       -       -       pipe
  user=vmail argv=/usr/local/cpves/listMailer.pl $recipient

file: /etc/postfix/main.cf

transport_maps = mysql:/etc/postfix/mysql-list-transport.cf
listsys_destination_recipient_limit = 1
listsys_destination_concurrency_limit = 1
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_forwardings.cf mysql:/etc/postfix/mysql-virtual_email2email.cf mysql:/etc/postfix/mysql-list-map.cf