Problème Postfix + MySQL + Mailman

Bonjour à tous !

Je viens à vous dans un espoir de grace, après avoir bataillé plusieurs heures avec ma machine pour n’arriver à rien au final … Je m’explique : voilà quelques jours j’installe postfix + courier-imap + courier-pop sur debian via les paquets apt-get simplement, je configure le tout et tout fonctionne. Tout content de mon affaire, j’installe Mailman, et encore une fois, tout fonctionne …

Mais voilà que me vient l’idée des utilisateurs virtuels pour faire des comptes mails à mes proches et amis, j’installe donc courier-authmysql et paramêtre tout, encore une fois, tout fonctionne !! (après maint et maint combat, mais ça fonctionne, c’est l’essentiel, non ? :p)

Mais voilà qu’en testant Mailman à nouveau, plus moyen de le faire marcher, il me répond simplement :

(ou maliste@dom.ext est l’adresse d’envoie de la liste de diffusion)

Pourtant, tout a été paramêtré dans les règles, de mailman à postfix

main.cf

[code]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[/code]

/var/lib/mailman/data/virtual-mailman

[code]# 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@dom.ext mailman-loop

LOOP ADDRESSES END

STANZA START: mailman

CREATED: Thu Oct 5 01:32:34 2006

mailman@dom.ext maliste
mailman-admin@dom.ext mailman-admin
mailman-bounces@dom.ext mailman-bounces
mailman-confirm@dom.ext mailman-confirm
mailman-join@dom.ext mailman-join
mailman-leave@dom.ext mailman-leave
mailman-owner@dom.ext mailman-owner
mailman-request@dom.ext mailman-request
mailman-subscribe@dom.ext mailman-subscribe
mailman-unsubscribe@dom.ext mailman-unsubscribe

STANZA END: mailman

STANZA START: maliste

CREATED: Thu Oct 5 01:47:37 2006

maliste@dom.ext maliste
maliste-admin@dom.ext maliste-admin
maliste-bounces@dom.ext maliste-bounces
maliste-confirm@dom.ext maliste-confirm
maliste-join@dom.ext maliste-join
maliste-leave@dom.ext maliste-leave
maliste-owner@dom.ext maliste-owner
maliste-request@dom.ext maliste-request
maliste-subscribe@dom.ext maliste-subscribe
maliste-unsubscribe@dom.ext maliste-unsubscribe

STANZA END: maliste[/code]

J’ai tenté une dernière solution trouvée en cherchant sur google, remplacer toutes les occurences maliste* du virtual-mailman par maliste*@localhost, ce qui donnerait dans mon fichier :

/var/lib/mailman/data/virtual-mailman

[code]# 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@dom.ext mailman-loop

LOOP ADDRESSES END

STANZA START: mailman

CREATED: Thu Oct 5 01:32:34 2006

mailman@dom.ext maliste@localhost
mailman-admin@dom.ext mailman-admin@localhost
mailman-bounces@dom.ext mailman-bounces@localhost
mailman-confirm@dom.ext mailman-confirm@localhost
mailman-join@dom.ext mailman-join@localhost
mailman-leave@dom.ext mailman-leave@localhost
mailman-owner@dom.ext mailman-owner@localhost
mailman-request@dom.ext mailman-request@localhost
mailman-subscribe@dom.ext mailman-subscribe@localhost
mailman-unsubscribe@dom.ext mailman-unsubscribe@localhost

STANZA END: mailman

STANZA START: maliste

CREATED: Thu Oct 5 01:47:37 2006

maliste@dom.ext maliste@localhost
maliste-admin@dom.ext maliste-admin@localhost
maliste-bounces@dom.ext maliste-bounces@localhost
maliste-confirm@dom.ext maliste-confirm@localhost
maliste-join@dom.ext maliste-join@localhost
maliste-leave@dom.ext maliste-leave@localhost
maliste-owner@dom.ext maliste-owner@localhost
maliste-request@dom.ext maliste-request@localhost
maliste-subscribe@dom.ext maliste-subscribe@localhost
maliste-unsubscribe@dom.ext maliste-unsubscribe@localhost

STANZA END: maliste[/code]

J’obtiens au final une erreur différente …

Je m’en remets donc désormais à vous … en espérant que vous aurez la solution à mon problème …

Merci d’avance.

XaF

Vraiment personne n’a d’idée pour me filer un coup de main ?