Eu tenho um erro de pesquisa intermitente no meu postfix / mysql / dovecot / debian ao procurar aliases virtuais ... isso acontece em 10% dos emails de saída
Log do Revelant de uma solicitação com falha:
Aug 28 12:17:43 ns212713 postfix/smtpd[17354]: connect from localhost.localdomain[127.0.0.1]
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: connection established fd 128
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: master_notify: status 0
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: proxymap socket: wanted attribute: request
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: input attribute name: request
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: input attribute value: lookup
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: proxymap socket: wanted attribute: table
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: input attribute name: table
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: input attribute value: mysql:/etc/postfix/mysql_virtual_alias_maps.cf
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: proxymap socket: wanted attribute: flags
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: input attribute name: flags
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: input attribute value: 16448
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: proxymap socket: wanted attribute: key
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: input attribute name: key
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: input attribute value: [email protected]
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: proxymap socket: wanted attribute: (list terminator)
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: input attribute name: (end)
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: proxy_map_find: mysql:/etc/postfix/mysql_virtual_alias_maps.cf:
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: dict_mysql_get_active: found active connection to host 127.0.0.1
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: warning: mysql query failed: Lost connection to MySQL server during query
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: send attr status = 2
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: send attr value =
Aug 28 12:17:43 ns212713 postfix/proxymap[17349]: master_notify: status 1
Aug 28 12:17:43 ns212713 postfix/smtpd[17354]: warning: proxy:mysql:/etc/postfix/mysql_virtual_alias_maps.cf lookup error for "[email protected]"
Aug 28 12:17:43 ns212713 postfix/smtpd[17354]: NOQUEUE: reject: RCPT from localhost.localdomain[127.0.0.1]: 451 4.3.0 <[email protected]>: Temporary lookup failure; from=<[email protected]> to=<[email protected]> proto=ESMTP helo=<trois-six.com>
Aug 28 12:17:43 ns212713 postfix/smtpd[17354]: lost connection after RCPT from localhost.localdomain[127.0.0.1]
Aug 28 12:17:43 ns212713 postfix/smtpd[17354]: disconnect from localhost.localdomain[127.0.0.1]
Aug 28 12:17:48 ns212713 postfix/proxymap[17349]: connection closed fd 128
Postconf:
alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
append_dot_mydomain = no
biff = no
config_directory = /etc/postfix
dovecot_destination_recipient_limit = 1
inet_interfaces = all
mailbox_command = procmail -a "$EXTENSION"
mailbox_size_limit = 0
message_size_limit = 52428800
mydestination = $myhostname, localhost.com, localhost
myhostname = mailserverroot.com
mynetworks = 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128
myorigin = /etc/mailname
readme_directory = no
recipient_delimiter = +
relay_domains = proxy:mysql:/etc/postfix/mysql_relay_domains.cf
relayhost =
smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache
smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
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
smtpd_sasl_auth_enable = yes
smtpd_sasl_authenticated_header = yes
smtpd_sasl_path = private/auth
smtpd_sasl_security_options = noanonymous
smtpd_sasl_type = dovecot
smtpd_tls_cert_file = /etc/ssl/certs/ssl-cert-snakeoil.pem
smtpd_tls_key_file = /etc/ssl/private/ssl-cert-snakeoil.key
smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
smtpd_use_tls = yes
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:3000
virtual_mailbox_base = /home/facteur
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql_virtual_mailbox_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_transport = dovecot
virtual_uid_maps = static:3000
O MySQL está rodando bem, sem grandes cargas no mesmo momento, a consulta manual está funcionando bem, e 90% dos e-mails externos funcionam ...
Eu já tentei alguma solução mas não tive sorte (127.0.0.1/localhost, conexões mysql, chroot ...)
Por favor, ajude!