Ubuntu-fr

Dragondark

[Résolu] Problème envoie de mail (serveur postfix + mysql + dovecot)

Bonjour,

dans l'idée de me créer un serveur mail complet, j'ai modifier mon installation et j'ai reconfigurer postfix suivant ce tuto :
http://doc.ubuntu-fr.org/utilisateurs/m … stfixadmin

j'ai chercher un peu partout sur le net mais a chaque fois la solution proposé ne convient pas

Pour résumé mon problème c'est que depuis que j'ai essayer de mettre postfix avec mysql et dovecot les mails ne partent plus en local (j'ai pas encore tester depuis le distant, (prochain problème peut être).

Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: BC15A44808: message-id=<20130930172548.BC15A44808@terres-de-feu.com>
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: warning: mysql:/etc/postfix/mysql_virtual_alias_maps.cf lookup error for "nom@hotmail.fr"
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: warning: BC15A44808: virtual_alias_maps map lookup problem for nom@hotmail.fr -- deferring delivery
Sep 30 19:25:48 ns355553 postfix/pickup[10476]: warning: BC28C44808: message has been queued for 1 days
Sep 30 19:25:48 ns355553 postfix/pickup[10476]: BC28C44808: uid=0 from=<root>
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: BC28C44808: message-id=<20130930172548.BC28C44808@terres-de-feu.com>
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: warning: mysql:/etc/postfix/mysql_virtual_alias_maps.cf lookup error for "nom@hotmail.fr"
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: warning: BC28C44808: virtual_alias_maps map lookup problem for nom@hotmail.fr -- deferring delivery
Sep 30 19:25:48 ns355553 postfix/pickup[10476]: BC40444808: uid=33 from=<www-data>
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: BC40444808: message-id=<3c195c0c9031159efa1d44421fe17123@team-sdg.com>
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: warning: mysql:/etc/postfix/mysql_virtual_alias_maps.cf lookup error for "nom@hazarderer.waw.pl"
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: warning: BC40444808: virtual_alias_maps map lookup problem for nom@hazarderer.waw.pl -- deferring delivery
Sep 30 19:25:48 ns355553 postfix/pickup[10476]: BC59644808: uid=0 from=<root>
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: BC59644808: message-id=<20130930172548.BC59644808@terres-de-feu.com>
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: warning: mysql:/etc/postfix/mysql_virtual_alias_maps.cf lookup error for "root@com"
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: warning: BC59644808: virtual_alias_maps map lookup problem for root@com -- deferring delivery
Sep 30 19:25:48 ns355553 postfix/pickup[10476]: BC6F344808: uid=33 from=<www-data>
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: BC6F344808: message-id=<d8b0cb149f9438c46b0cfab74a03e0f5@www.realitycraft.fr>
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: warning: mysql:/etc/postfix/mysql_virtual_alias_maps.cf lookup error for "nom@laposte.net"
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: warning: BC6F344808: virtual_alias_maps map lookup problem for nom@laposte.net -- deferring delivery
Sep 30 19:25:48 ns355553 postfix/pickup[10476]: warning: BC84544808: message has been queued for 1 days
Sep 30 19:25:48 ns355553 postfix/pickup[10476]: BC84544808: uid=0 from=<root>
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: BC84544808: message-id=<20130930172548.BC84544808@terres-de-feu.com>
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: warning: mysql:/etc/postfix/mysql_virtual_alias_maps.cf lookup error for "nom@hotmail.fr"
Sep 30 19:25:48 ns355553 postfix/cleanup[10479]: warning: BC84544808: virtual_alias_maps map lookup problem for nom@hotmail.fr -- deferring delivery

Ma config :

root@ns355553:/etc/postfix# postconf -n
append_dot_mydomain = no
biff = no
broken_sasl_auth_clients = yes
config_directory = /etc/postfix
content_filter = amavis:[127.0.0.1]:10024
disable_vrfy_command = yes
dovecot_destination_recipient_limit = 1
enable_original_recipient = no
header_checks = regexp:/etc/postfix/header_checks
inet_interfaces = all
mailbox_size_limit = 0
maximal_backoff_time = 8000s
maximal_queue_lifetime = 7d
minimal_backoff_time = 1000s
myhostname = terres-de-feu.com
mynetworks = 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128
mynetworks_style = host
myorigin = $mydomain
readme_directory = no
recipient_delimiter = +
smtp_helo_timeout = 60s
smtp_tls_note_starttls_offer = yes
smtp_tls_security_level = may
smtpd_banner = $myhostname ESMTP $mail_name
smtpd_client_restrictions = reject_rbl_client sbl.spamhaus.org, reject_rbl_client blackholes.easynet.nl, reject_rbl_client dnsbl.njabl.org
smtpd_data_restrictions = reject_unauth_pipelining
smtpd_delay_reject = yes
smtpd_hard_error_limit = 12
smtpd_helo_required = yes
smtpd_helo_restrictions = permit_mynetworks, warn_if_reject reject_non_fqdn_hostname, reject_invalid_hostname, permit
smtpd_recipient_limit = 16
smtpd_recipient_restrictions = reject_unauth_pipelining, permit_mynetworks, permit_sasl_authenticated, reject_non_fqdn_recipient, reject_unknown_recipient_domain, reject_unauth_destination, check_policy_service inet:127.0.0.1:10023, permit
smtpd_sasl_auth_enable = yes
smtpd_sasl_authenticated_header = yes
smtpd_sasl_local_domain =
smtpd_sasl_path = private/auth
smtpd_sasl_security_options = noanonymous
smtpd_sasl_type = dovecot
smtpd_sender_restrictions = permit_sasl_authenticated, permit_mynetworks, warn_if_reject reject_non_fqdn_sender, reject_unknown_sender_domain, reject_unauth_pipelining, permit
smtpd_soft_error_limit = 3
smtpd_tls_cert_file = /etc/ssl/certs/ssl-cert-snakeoil.pem
smtpd_tls_key_file = /etc/ssl/private/ssl-cert-snakeoil.key
smtpd_tls_loglevel = 1
smtpd_tls_received_header = yes
smtpd_tls_security_level = may
smtpd_tls_session_cache_timeout = 3600s
smtpd_use_tls = yes
tls_random_source = dev:/dev/urandom
unknown_local_recipient_reject_code = 450
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf, mysql:/etc/postfix/mysql_virtual_alias_domainaliases_maps.cf
virtual_gid_maps = static:8
virtual_mailbox_base = /home/vmail
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf, mysql:/etc/postfix/mysql_virtual_mailbox_domainaliases_maps.cf
virtual_transport = dovecot
virtual_uid_maps = static:150

root@ns355553:/etc/postfix# tail  *virtual*
==> mysql_virtual_alias_domainaliases_maps.cf <==
user = postfixadmin
password = password
hosts = 127.0.0.1
dbname = postfixadmin
query = SELECT goto FROM alias,alias_domain
  WHERE alias_domain.alias_domain = '%d'
  AND alias.address=concat('%u', '@', alias_domain.target_domain)
  AND alias.active = 1

==> mysql_virtual_alias_maps.cf <==
user            = postfixadmin
password        = password
hosts           = localhost
dbname          = postfixadmin
table           = alias
select_field    = goto
where_field     = address
additional_conditions = and active = '1'
#query = SELECT goto FROM alias WHERE address = CONVERT(‘%s’ USING latin1) AND active = '1'

==> mysql_virtual_domains_maps.cf <==
user = postfixadmin
password = password
hosts = 127.0.0.1
dbname = postfixadmin
table = domain
select_field = domain
where_field = domain
additional_conditions = and backupmx = '0' and active = '1'

==> mysql_virtual_mailbox_domainaliases_maps.cf <==
user = postfixadmin
password = password
hosts = 127.0.0.1
dbname = postfixadmin
query = SELECT maildir FROM mailbox, alias_domain
  WHERE alias_domain.alias_domain = '%d'
  AND mailbox.username=concat('%u', '@', alias_domain.target_domain )
  AND mailbox.active = 1

==> mysql_virtual_mailbox_maps.cf <==
user            = postfixadmin
password        = password
hosts           = localhost
dbname          = postfixadmin
table           = mailbox
select_field    = CONCAT(domain, '/', local_part)
where_field     = username
additional_conditions = and active = '1'

donc voila je suis perdu ça fais 2 jours que je regarde sr le net, maintenant je demande l'aide des personnes qui s'y connaissent et pourront m'aider à debuger.

pour info :
j'ai donc des sites web qui envoie des mails (genre forum)
et je souhaitait me faire des boites au lettres en local pour d'autre utilités.

Dernière modification par Dragondark (Le 30/09/2013, à 22:25)

Dragondark

Re : [Résolu] Problème envoie de mail (serveur postfix + mysql + dovecot)

Résolu,

semblerait que mon problème ai été d'avoir mis localhost au lieu de 127.0.0.1 dans mes virtual .cf
une erreur de copié collé

Dernière modification par Dragondark (Le 30/09/2013, à 22:26)

webwatson

Re : [Résolu] Problème envoie de mail (serveur postfix + mysql + dovecot)

Salut a la communauté, j'ai besoin de votre aide.
lorsque je lance ces command :
sudo postconf -e 'smtpd_sasl_local_domain ='
sudo  postconf -e 'smtpd_sasl_auth_enable = yes'
sudo  postconf -e 'smtpd_sasl_security_options = noanonymous'
sudo  postconf -e 'broken_sasl_auth_clients = yes'
sudo   postconf -e 'smtpd_recipient_restrictions = permit_sasl_authenticated,permit_mynetworks,reject_unauth_destination'
sudo  postconf -e 'inet_interfaces = all'

Je recois des erreurs suivantes:

sudo: unable to resolve host drefusjunior-HP-ProBook-4530s

Aidez moi...

Dernière modification par webwatson (Le 23/10/2016, à 23:32)