[Mailman-Users] Bug with Postfix + MySQL + Mailman
xaf
xaf at sbird.info
Wed Oct 11 20:32:24 CEST 2006
Hi guys, sorry for my bad english, i'm french.
I haven't found any website or mailing-list that can help me for this problem.
It was any days ago, i want to install postfix, and it runs really, i want to put a mailing-list system, it's ok, but i want to add virtual users to postfix, and it's ok !!
But the problem occurs after : only virtual users runs, mailman lists can't run ...
I have this error :
-----------------
Oct 10 19:51:44 debian postfix/virtual[24698]: B722D1FF20: to=<mylist at dom.ext>, relay=virtual, delay=0, status=bounced (unknown user: "mylist at dom.ext")
-----------------
My main.cf :
-----------------
smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
biff = no
append_dot_mydomain = no
myhostname = dom.ext
alias_maps = hash:/var/lib/mailman/data/aliases, hash:/etc/aliases
alias_database = hash:/etc/aliases
mydestination = debian, localhost.localdomain, localhost
relayhost =
mynetworks = !192.168.0.1, 192.168.0.0/24, 127.0.0.0/8
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
virtual_alias_maps = hash:/var/lib/mailman/data/virtual-mailman, mysql:alias_maps
virtual_uid_maps = static:106
virtual_gid_maps = static:107
virtual_mailbox_base = /var/mail/virtual
virtual_mailbox_domains = mysql:domains_maps
virtual_mailbox_limit = 204800000
virtual_mailbox_maps = mysql:mailbox_maps
virtual_minimum_uid = 100
virtual_transport = virtual
# Additional for quota support
virtual_create_maildirsize = yes
virtual_mailbox_extended = yes
virtual_mailbox_limit_maps = mysql:mailbox_limit_maps
virtual_mailbox_limit_override = yes
virtual_maildir_limit_message = Sorry, the user's maildir has overdrawn his diskspace quota, please try again later.
virtual_overquota_bounce = yes
# [mysql infos]
mysql_user = postfix
mysql_passwd = *******
mysql_host = localhost
mysql_dbname = postfix
# [mysql_relay_domains_maps]
relay_domains_maps_user = $mysql_user
relay_domains_maps_password = $mysql_passwd
relay_domains_maps_hosts = $mysql_host
relay_domains_maps_dbname = $mysql_dbname
relay_domains_maps_table = domain
relay_domains_maps_select_field = domain
relay_domains_maps_where_field = domain
# [mysql_virtual_alias_maps]
alias_maps_user = $mysql_user
alias_maps_password = $mysql_passwd
alias_maps_hosts = $mysql_host
alias_maps_dbname = $mysql_dbname
alias_maps_table = alias
alias_maps_select_field = goto
alias_maps_where_field = address
# [mysql_virtual_domains_maps]
domains_maps_user = $mysql_user
domains_maps_password = $mysql_passwd
domains_maps_hosts = $mysql_host
domains_maps_dbname = $mysql_dbname
domains_maps_table = domain
domains_maps_select_field = description
domains_maps_where_field = domain
# [mysql_virtual_mailbox_limit_maps]
mailbox_limit_maps_user = $mysql_user
mailbox_limit_maps_password = $mysql_passwd
mailbox_limit_maps_hosts = $mysql_host
mailbox_limit_maps_dbname = $mysql_dbname
mailbox_limit_maps_table = mailbox
mailbox_limit_maps_select_field = quota
mailbox_limit_maps_where_field = username
# [mysql_virtual_mailbox_maps]
mailbox_maps_user = $mysql_user
mailbox_maps_password = $mysql_passwd
mailbox_maps_hosts = $mysql_host
mailbox_maps_dbname = $mysql_dbname
mailbox_maps_table = mailbox
mailbox_maps_select_field = maildir
mailbox_maps_where_field = username
#content_filter=smtp-amavis:[127.0.0.1]:10024
-----------------
My /var/lib/mailman/data/virtual-mailman
-----------------
# This file is generated by Mailman, and is kept in sync with the binary hash
# file virtual-mailman.db. YOU SHOULD NOT MANUALLY EDIT THIS FILE unless you
# know what you're doing, and can keep the two files properly in sync. If you
# screw it up, you're on your own.
#
# Note that you should already have this virtual domain set up properly in
# your Postfix installation. See README.POSTFIX for details.
# LOOP ADDRESSES START
mailman-loop at dom.ext mailman-loop
# LOOP ADDRESSES END
# STANZA START: mailman
# CREATED: Thu Oct 5 01:32:34 2006
mailman at dom.ext mylist
mailman-admin at dom.ext mailman-admin
mailman-bounces at dom.ext mailman-bounces
mailman-confirm at dom.ext mailman-confirm
mailman-join at dom.ext mailman-join
mailman-leave at dom.ext mailman-leave
mailman-owner at dom.ext mailman-owner
mailman-request at dom.ext mailman-request
mailman-subscribe at dom.ext mailman-subscribe
mailman-unsubscribe at dom.ext mailman-unsubscribe
# STANZA END: mailman
# STANZA START: mylist
# CREATED: Thu Oct 5 01:47:37 2006
mylist at dom.ext mylist
mylist-admin at dom.ext mylist-admin
mylist-bounces at dom.ext mylist-bounces
mylist-confirm at dom.ext mylist-confirm
mylist-join at dom.ext mylist-join
mylist-leave at dom.ext mylist-leave
mylist-owner at dom.ext mylist-owner
mylist-request at dom.ext mylist-request
mylist-subscribe at dom.ext mylist-subscribe
mylist-unsubscribe at dom.ext mylist-unsubscribe
# STANZA END: mylist
-----------------
Many days left, i found on google a solution : change the directions of the virtual-mailman from mylist* to mylist*@localhost.
I have now this file :
My new /var/lib/mailman/data/virtual-mailman
-----------------
# This file is generated by Mailman, and is kept in sync with the binary hash
# file virtual-mailman.db. YOU SHOULD NOT MANUALLY EDIT THIS FILE unless you
# know what you're doing, and can keep the two files properly in sync. If you
# screw it up, you're on your own.
#
# Note that you should already have this virtual domain set up properly in
# your Postfix installation. See README.POSTFIX for details.
# LOOP ADDRESSES START
mailman-loop at dom.ext mailman-loop
# LOOP ADDRESSES END
# STANZA START: mailman
# CREATED: Thu Oct 5 01:32:34 2006
mailman at dom.ext mylist at localhost
mailman-admin at dom.ext mailman-admin at localhost
mailman-bounces at dom.ext mailman-bounces at localhost
mailman-confirm at dom.ext mailman-confirm at localhost
mailman-join at dom.ext mailman-join at localhost
mailman-leave at dom.ext mailman-leave at localhost
mailman-owner at dom.ext mailman-owner at localhost
mailman-request at dom.ext mailman-request at localhost
mailman-subscribe at dom.ext mailman-subscribe at localhost
mailman-unsubscribe at dom.ext mailman-unsubscribe at localhost
# STANZA END: mailman
# STANZA START: mylist
# CREATED: Thu Oct 5 01:47:37 2006
mylist at dom.ext mylist at localhost
mylist-admin at dom.ext mylist-admin at localhost
mylist-bounces at dom.ext mylist-bounces at localhost
mylist-confirm at dom.ext mylist-confirm at localhost
mylist-join at dom.ext mylist-join at localhost
mylist-leave at dom.ext mylist-leave at localhost
mylist-owner at dom.ext mylist-owner at localhost
mylist-request at dom.ext mylist-request at localhost
mylist-subscribe at dom.ext mylist-subscribe at localhost
mylist-unsubscribe at dom.ext mylist-unsubscribe at localhost
# STANZA END: mylist
-----------------
But now, i have another error :
-----------------
Oct 11 14:00:45 debian postfix/local[8037]: 7E77D1FF20: to=<mylist at localhost>, orig_to=<mylist at dom.ext>, relay=local, delay=0, status=bounced (unknown user: "mylist")
-----------------
If you can help me ... I need you really ... (and I have a very bad english xD)
Thank you !
XaF
More information about the Mailman-Users
mailing list