The mailing list for listmasters using Sympa

[Ashraf Parakkuth Thattasseri <address@concealed>]

Thank You for the fast response Mr  Simone.
What may be the file attributes of mysql-virtual-aliases.cf?


-----Original Message-----
From: Simone Dal Maso [mailto:address@concealed] 
Sent: Monday, August 21, 2017 3:32 PM
To: Ashraf Parakkuth Thattasseri <address@concealed>; 
address@concealed
Subject: Re: [sympa-users] SYMPA+Postfix integration

Sympa and postfix was perhaps the most difficult thing I made in debian.
I use debian Jessie with postfix that use mysql, so you must integrate sympa 
too.


I will make a copy/paste of what I write 1 years ago when it works:

apt-get install sympa
block update with:
apt-mark hold sympa

enable fast CGI in file /etc/sympa/wwsympa.conf:
use_fast_cgi    1
For postfix integration, use alias manager, but it must be modified with:


cd /opt
git clone https://github.com/tribut/sympa-postfix-virtual.git
cd sympa-postfix-virtual && sh make_public.sh
cd /etc/sympa && ln -s 
/opt/sympa-postfix-virtual/templates/list_aliases.tt2 .
In file /etc/sympa/sympa.conf add:
alias_manager /opt/sympa-postfix-virtual/scripts/alias_manager.pl
sendmail_aliases /etc/sympa/sympa-alias.virtual

Creation of file alias.virtual:
umask 077
touch /etc/sympa/sympa-alias.virtual
chown sympa:sympa !!$

For my subdomain liste.spazioausili.net, this file 
/etc/sympa/sympa-alias.virtual should be:

/^liste\.spazioausili\.net$/  xxx
/^(postmaster|sympa-request|sympa-owner)\@.*$/ 
address@concealed. 
 

  /^(sympa|listmaster)\@liste\.spazioausili\.net$/ 
$1+liste.spazioausili.net@sympalist. 
 

  /^(bounce\+.*|abuse-feedback-report)\@liste\.spazioausili\.net$/ 
sympa+liste.spazioausili.net@sympabounce. 
 


In /etc/postfix/master.cf
sympalist        unix  -       n       n       -       -       pipe
   flags=RF user=sympa argv=/usr/lib/sympa/bin/queue ${user}@${extension}
symparequest     unix  -       n       n       -       -       pipe
   flags=RF user=sympa argv=/usr/lib/sympa/bin/queue 
${user}-request@${extension}
sympaeditor      unix  -       n       n       -       -       pipe
   flags=RF user=sympa argv=/usr/lib/sympa/bin/queue 
${user}-editor@${extension}
sympasubscribe   unix  -       n       n       -       -       pipe
   flags=RF user=sympa argv=/usr/lib/sympa/bin/queue 
${user}-subscribe@${extension}
sympaunsubscribe unix  -       n       n       -       -       pipe
   flags=RF user=sympa argv=/usr/lib/sympa/bin/queue 
${user}-unsubscribe@${extension}
sympabounce      unix  -       n       n       -       -       pipe
   flags=RF user=sympa argv=/usr/lib/sympa/bin/bouncequeue 
${user}@${extension}

file /etc/postfix/transport_regexp
/^.*\@sympalist$/         sympalist:
/^.*\@symparequest$/      symparequest:
/^.*\@sympaeditor$/       sympaeditor:
/^.*\@sympasubscribe$/    sympasubscribe:
/^.*\@sympaunsubscribe$/  sympaunsubscribe:
/^.*\@sympaowner$/        sympabounce:

Edit  /etc/postfix/main.cf:
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-aliases.cf, 
regexp:/etc/sympa/sympa-alias.virtual
transport_maps     = regexp:/etc/postfix/transport_regexp
sympalist_destination_recipient_limit        = 1
symparequest_destination_recipient_limit     = 1
sympaeditor_destination_recipient_limit      = 1
sympasubscribe_destination_recipient_limit   = 1
sympaunsubscribe_destination_recipient_limit = 1
sympabounce_destination_recipient_limit      = 1