Mark Sapiro schrieb: > Info wrote: >> well, i have a problem integrating mailman with postfix. I manage my >> virtual domains and aliases through mysql and a PHP-Frontend. >> Mailman is running and i could create the global list "mailman" >> So far so good, but how can i use the generated aliases with mysql? > > > You can use a hash for the Mailman aliases even though you use mysql. > > See <http://www.list.org/mailman-install/node12.html> - in particular, > subsections 6.1.1 and 6.1.2. >
Mark Sapiro schrieb: > Info wrote: >> well, i have a problem integrating mailman with postfix. I manage my >> virtual domains and aliases through mysql and a PHP-Frontend. >> Mailman is running and i could create the global list "mailman" >> So far so good, but how can i use the generated aliases with mysql? > > > You can use a hash for the Mailman aliases even though you use mysql. > > See <http://www.list.org/mailman-install/node12.html> - in particular, > subsections 6.1.1 and 6.1.2. > Hi Mark, thank you for your reply. I´ve poked around with the options and now i think i´m a step further. These are the relevant options from main.cf: alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf, hash:/etc/mailman/aliases broken_sasl_auth_clients = yes command_directory = /usr/sbin config_directory = /etc/postfix daemon_directory = /usr/libexec/postfix debug_peer_level = 7 fallback_transport = virtual home_mailbox = /home/vmail/ html_directory = no inet_interfaces = all local_destination_concurrency_limit = 5 local_destination_recipient_limit = 300 local_recipient_maps = $alias_maps, mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf, unix:passwd.byname mail_owner = postfix mailbox_command = /usr/bin/maildrop -d "$USER" mailq_path = /usr/bin/mailq manpage_directory = /usr/share/man mydestination = centos.exampledomain.de, localhost.$mydomain, localhost mydomain = exampledomain.de myhostname = centos.exampledomain.de mynetworks = 10.10.1.0/27, 127.0.0.0/8 myorigin = $mydomain newaliases_path = /usr/bin/newaliases owner_request_special = no queue_directory = /var/spool/postfix readme_directory = /usr/share/doc/postfix-2.2.10/README_FILES recipient_delimiter = + sample_directory = /usr/share/doc/postfix-2.2.10/samples sendmail_path = /usr/sbin/sendmail setgid_group = postdrop smtp_tls_note_starttls_offer = yes smtp_use_tls = yes smtpd_enforce_tls = no smtpd_etrn_restrictions = reject smtpd_helo_required = yes smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_non_fqdn_hostname, reject_non_fqdn_sender, reject_non_fqdn_recipient, reject_unauth_destination, reject_unauth_pipelining, reject_invalid_hostname, reject_rbl_client opm.blitzed.org, reject_rbl_client list.dsbl.org, reject_rbl_client bl.spamcop.net, reject_rbl_client sbl-xbl.spamhaus.org smtpd_sasl_auth_enable = yes smtpd_sasl_local_domain = $myhostname smtpd_sasl_security_options = noanonymous smtpd_tls_CAfile = /etc/postfix/ssl/cacert.pem smtpd_tls_auth_only = no smtpd_tls_cert_file = /etc/postfix/ssl/smtpd.crt smtpd_tls_key_file = /etc/postfix/ssl/smtpd.key smtpd_tls_loglevel = 2 smtpd_tls_received_header = yes smtpd_tls_session_cache_timeout = 3600s smtpd_use_tls = yes tls_random_source = dev:/dev/urandom unknown_local_recipient_reject_code = 550 virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf, hash:/etc/mailman/virtual-mailman virtual_destination_recipient_limit = 1 virtual_gid_maps = static:1001 virtual_mailbox_base = /home/vmail/ virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf virtual_mailbox_limit = 51200000 virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf virtual_minimum_uid = 1000 virtual_transport = maildrop virtual_uid_maps = static:1001 and this one from mailman: DEFAULT_URL_HOST = "www.exampledomain2.de" DEFAULT_EMAIL_HOST = "exampledomain2.de" When i try to send an email i get the error: Recipient address rejected:User unknown in virtual mailbox table The domain exampledomain2.de is already in the mysql table When i add the following line to main.cf mydestination = centos.exampledomain.de, exampledomain2.de, localhost.$mydomain, localhost the message gets send but the following error is logged: postfix/trivial-rewrite[18195]: warning: do not list domain exampledomain2.de in BOTH mydestination and virtual_mailbox_domains postfix/virtual[18269]: fatal: open /etc/postfix/mysql_virtual_mailbox_maps.cf: Permission denied Mar 27 20:25:37 centos postfix/master[15551]: warning: process /usr/libexec/postfix/virtual pid 18269 exit status 1 now i´m stucked. Can someone give me a hint? Thank you Christian ------------------------------------------------------ Mailman-Users mailing list Mailman-Users@python.org http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/ Unsubscribe: http://mail.python.org/mailman/options/mailman-users/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=show&file=faq01.027.htp