Mailman Postfix and MySQL
Hi list,
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?
This is the relevant entries in the config file:
DEFAULT_URL_HOST = "www.mydomain.de" DEFAULT_EMAIL_HOST = "mydomain.de"
add_virtualhost(DEFAULT_URL_HOST, DEFAULT_EMAIL_HOST)
MTA = 'Postfix' POSTFIX_STYLE_VIRTUAL_DOMAINS = ['mydomain.de']
Through the PHP-Frontend i?ve created the virtual domain mydomain.de Now when i send a email the mail gets to the mailbox root from another domain. This is probably because the mail gets send to the hostname of the server server.mydomain.de Here i have an catch all alias which points to root@myotherdomain.de Now i got stuck.
Kind regards,
Christian
Info wrote:
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 <msapiro@value.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
Mark Sapiro schrieb:
Mark Sapiro schrieb:
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
Info wrote:
It doesn't look as if you have multiple domains for Mailman so you don't need to reference virtual-mailman, and it appears that you may have added the entire virtual_alias_maps for Mailman. If so, I think you can remove it.
Caveat: I don't know Postfix.
If all your Mailman lists are in the same domain, you don't need any of the things in section 6.1.2 of the installation manual.
-- Mark Sapiro <msapiro@value.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
Info wrote:
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 <msapiro@value.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
Mark Sapiro schrieb:
Mark Sapiro schrieb:
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
Info wrote:
It doesn't look as if you have multiple domains for Mailman so you don't need to reference virtual-mailman, and it appears that you may have added the entire virtual_alias_maps for Mailman. If so, I think you can remove it.
Caveat: I don't know Postfix.
If all your Mailman lists are in the same domain, you don't need any of the things in section 6.1.2 of the installation manual.
-- Mark Sapiro <msapiro@value.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
participants (2)
-
Info -
Mark Sapiro