I am using the "Virtual Users And Domains With Postfix" setup (which I really like) and am also trying to get the sympa mailing list working. I have it set up but have run into a roadblock. In the documentation when you set up a new list you have to also setup some aliases (which naturally do not work correctly when all your aliases are abstracted to mysql). The syntax is along these lines #------------------------------ thelist: list alias created thelist: "| /usr/lib/sympa/bin/queue [email protected]" thelist-request: "| /usr/lib/sympa/bin/queue [email protected]" thelist-editor: "| /usr/lib/sympa/bin/queue [email protected]" obviously the aliases file doesn't have a problem running commands but (I assume but haven't actually checked it out) that the mysql db will choke on this. If this is the case, what are your thoughts on the next step?
I think you should try it out with /etc/aliases. Don't forget to run Code: newaliases after your changes (and restart Postfix).
thanks for the response (and for the debian virtual recipe!). I believe I tried this before I posted. After trying again here is what mail.info has to say... Apr 8 06:23:15 server postfix/smtpd[5283]: NOQUEUE: reject: RCPT from dsl-ip[ip]: 550 <[email protected]>: Recipient address rejected: User unknown in virtual mailbox table; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<[192.168.1.103]> which leads me to believe that /etc/aliases.db isn't even getting parsed before it gets rejected. from postconf -n alias_database = hash:/etc/aliases alias_maps = hash:/etc/aliases virtual_alias_domains = virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf virtual_create_maildirsize = yes virtual_gid_maps = static:5000 which should all be exactly from the tutorial. is there a place where the alias_db is named (or an order named)? thanks.
I think you then have to add [email protected] to the users table in the database and use a maildrop recipe for the [email protected] account to pipe the emails through /usr/lib/sympa/bin/queue. Maybe these guides help you: http://www.howtoforge.com/postfix_mailfilter http://www.howtoforge.com/autoresponders_for_virtual_postfix_users
The postfix_mailfilter guide is what ended up working for me. Thanks for the link. In the next few days I'll write up the steps to how I got this all working but I'll just say for now that this site is a real treasure for an admin like me. Your howto's are not out of date and you tend to be solving the same kinds of problems that I am. Cheers. Aragorn!
I never did get around to posting an entire "howto" for this problem but here is my outline (w/ questions that you would need to answer before you move forward). How to Create a new Mail List w/ falko's postfix + maildrop 1. configure sympa (assuming it is installed...) 1. does domain exist? (/etc/sympa & /var/lib/sympa/expl) 2. does list exist (in web interface) 2. configure mysql 1. insert into users table 2. insert into transport table 3. configure mailfilter 4. test w/ one member 5. add rest of members I just ended up fixing a problem I was having with the maildrop lists (as the web interface would direct you incorrectly...) where any email where the "to:" list would be To: joey <[email protected]> would get bitbucketed. The solution was a maildrop line like this if ( /^To:.*list\@domain.tld/) { log "-------------------------------------------------------- joey list " to "|/usr/lib/sympa/bin/queue [email protected]" } Hope that is helpful to someone.
