Maildrop com suporte a mysql x Erro no envio do email
Pessoal, boa tarde!
Estou com o seguinte problema:
Não estou conseguindo utilizar o smtp para envio de email, configurei uma conta no Microsoft Outlook, porém dá o erro abaixo (no log do mail.log); ele não consegue entregar o email no mailbox para o usuário:
Jul 31 16:57:38 DebianLXTeste02 postfix/smtpd[8876]: connect from srvmsc02.col[172.16.65.3]
Jul 31 16:57:38 DebianLXTeste02 postfix/smtpd[8876]: 92805422AE: client=srvmsc02.col[172.16.65.3]
Jul 31 16:57:38 DebianLXTeste02 postfix/cleanup[8879]: 92805422AE: message-id=<[email protected]>
Jul 31 16:57:38 DebianLXTeste02 postfix/qmgr[8721]: 92805422AE: from=<[email protected]>, size=4668, nrcpt=1 (queue active)
Jul 31 16:57:38 DebianLXTeste02 postfix/pipe[8880]: 92805422AE: to=<[email protected]>, relay=maildrop, delay=0.23, delays=0.1/0.05/0/0.08, dsn=5.1.1, status=bounced (user unknown. Command output: ERR: authdaemon: s_connect() failed: Permission denied Invalid user specified. )
Jul 31 16:57:38 DebianLXTeste02 postfix/cleanup[8879]: BAB5B422B0: message-id=<[email protected]>
Jul 31 16:57:38 DebianLXTeste02 postfix/bounce[8882]: 92805422AE: sender non-delivery notification: BAB5B422B0
Jul 31 16:57:38 DebianLXTeste02 postfix/qmgr[8721]: 92805422AE: removed
Jul 31 16:57:38 DebianLXTeste02 postfix/qmgr[8721]: BAB5B422B0: from=<>, size=6526, nrcpt=1 (queue active)
Jul 31 16:57:38 DebianLXTeste02 postfix/pipe[8880]: BAB5B422B0: to=<[email protected]>, relay=maildrop, delay=0.05, delays=0.02/0/0/0.02, dsn=5.1.1, status=bounced (user unknown. Command output: ERR: authdaemon: s_connect() failed: Permission denied Invalid user specified. )
Jul 31 16:57:38 DebianLXTeste02 postfix/qmgr[8721]: BAB5B422B0: removed
Jul 31 16:57:41 DebianLXTeste02 postfix/smtpd[8876]: disconnect from srvmsc02.col[172.16.65.3]
Informações adicionais:
--Quando envio email através do console (para um dominio fictício em testes), ele entrega o emailcorretamente:
debian:/var/spool/correio/rmoraes.com/rmoraes/Maildir/new# cat /var/www/phpinfo.php |maildrop -d [email protected]
Eu consigo baixar através do cliente de pop3 as mensagens que eu envio localmente.
--O log do envio no mysql:
debian:/# tail -f /var/log/mysql/mysql.log
100731 17:00:25 194 Connect postfix@localhost on
194 Init DB postfix
194 Query SELECT username, password, "", uid, gid, home, maildir, quota, name, "" FROM mailbox WHERE username = "[email protected]" AND (active=1)
--Abaixo eu verifiquei que ela caiu no local correto:
debian:/var/spool/correio/rmoraes.com/rmoraes/Maildir/new# ls
1280605155.M683729P8856V0000000000000306I00042297_0.debian.local.int,S=29
-- O serviço de pop3 está funcionando corretamente, ele conecta e desconecta no servidor normalmente (segue log abaixo):
/var/log/mail.log
Jul 31 17:10:20 DebianLXTeste02 courierpop3login: Connection, ip=[::ffff:172.16.65.3]
Jul 31 17:10:20 DebianLXTeste02 courierpop3login: LOGIN, [email protected], ip=[::ffff:172.16.65.3]
Jul 31 17:10:20 DebianLXTeste02 courierpop3login: LOGOUT, [email protected], ip=[::ffff:172.16.65.3], top=0, retr=0, rcvd=12, sent=39, time=0
--Estou utilizando postfix + Mysql (com 01 domínio virtual criado) + Maildrop + Courier-imap + Courier-pop.
-- Segue o conf do /etc/postfix (e arquivos relacionados):
/etc/postfix/main.cf
# See /usr/share/postfix/main.cf.dist for a commented, more complete version
smtpd_banner = $myhostname ESMTP FATEC
biff = no
# appending .domain is the MUA's job.
append_dot_mydomain = no
# Uncomment the next line to generate "delayed mail" warnings
#delay_warning_time = 4h
myhostname=debian.local.int
alias_maps=hash:/etc/aliases
alias_database=hash:/etc/aliases
myorigin=$mydomain
mydestination = $mydomain, $transport_maps
relayhost = localhost
mynetworks = 127.0.0.0/8 172.16.0.0/16
# mailbox_command = procmail -a "$EXTENSION"
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
#CONFIGURACOES
queue_directory = /var/spool/postfix/
program_directory=/usr/sbin
command_directory = /usr/sbin
daemon_directory = /usr/lib/postfix
mail_owner = postfix
default_privs=nobody
default_transport=smtp
#
readme_directory = no
sample_directory = /etc/postfix
sendmail_path = /usr/sbin/sendmail
setgid_group = postdrop
manpage_directory = /usr/local/man
newaliases_path = /usr/bin/newaliases
mailq_path = /usr/bin/mailq
disable_vrfy_command=yes
home_mailbox=Maildir/
#Nome do dominio
mydomain=fatec.int
#MYSQL
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_mailbox_base = /postfix
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_uid_maps = static:120
virtual_gid_maps = static:120
transport_maps = mysql:/etc/postfix/mysql_transport_maps.cf
#Quota
virtual_mailbox_limit_inbox = no
virtual_mailbox_limit_maps = mysql:/etc/postfix/mysql_virtual_mailbox_limit_maps.cf
virtual_mailbox_limit_override = yes
virtual_maildir_extended = yes
virtual_create_maildirsize = yes
virtual_mailbox_limit = 100000000
virtual_maildir_limit_message = Desculpe, o diretorio de correio do usuario estourou sua quota, por favor tente novamente depois.
virtual_overquota_bounce = yes
#SASL
#smtpd_sasl_auth_enable = yes
#smtpd_sasl_security_options = noanonymous
#broken_sal_auth_clients = yes
#smtpd_recipient_restrictions = permit_sasl_authenticated, permit_mynetworks, check_relay_domains
#MAILDROP
fallback_transport = /usr/bin/maildrop
maildrop_destination_recipient_limit = 1
unknown_local_recipient_reject_code = 450
#Finish
#Para amavis
#content_filter = smtp-amavis:[127.0.0.1]:10024
/etc/postfix/master.cf
smtp inet n - n - - smtpd
#submission inet n - n - - smtpd
# -o smtpd_etrn_restrictions=reject
#628 inet n - n - - qmqpd
pickup fifo n - n 60 1 pickup
cleanup unix n - n - 0 cleanup
qmgr fifo n - n 300 1 qmgr
#qmgr fifo n - n 300 1 oqmgr
rewrite unix - - n - - trivial-rewrite
bounce unix - - n - 0 bounce
defer unix - - n - 0 bounce
trace unix - - n - 0 bounce
verify unix - - n - 1 verify
flush unix n - n 1000? 0 flush
proxymap unix - - n - - proxymap
smtp unix - - n - - smtp
relay unix - - n - - smtp
# -o smtp_helo_timeout=5 -o smtp_connect_timeout=5
showq unix n - n - - showq
error unix - - n - - error
local unix - n n - - local
virtual unix - n n - - virtual
lmtp unix - - n - - lmtp
anvil unix - - n - 1 anvil
maildrop unix - n n - - pipe
flags=DRhu user=maildrop argv=/usr/bin/maildrop -w 90 -d ${recipient}
uucp unix - n n - - pipe
flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - $nexthop!rmail ($recipient)
ifmail unix - n n - - pipe
flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
bsmtp unix - n n - - pipe
flags=Fq. user=bsmtp argv=/usr/lib/bsmtp/bsmtp -d -t$nexthop -f$sender $recipient
scalemail-backend unix - n n - 2 pipe
flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store ${nexthop} ${user} ${extension}
# only used by postfix-tls
#tlsmgr fifo - - n 300 1 tlsmgr
#smtps inet n - n - - smtpd -o smtpd_tls_wrappermode=yes -o smtpd_sasl_auth_enable=yes
#587 inet n - n - - smtpd -o smtpd_enforce_tls=yes -o smtpd_sasl_auth_enable=yes
/etc/ postfix/mysql_virtual_alias_maps.cf
user = postfix
password = alface
dbname = postfix
table = alias
select_field = goto
where_field = address
hosts = localhost
/etc/postfix/mysql_virtual_mailbox_maps.cf
user = postfix
password = alface
dbname = postfix
table = mailbox
select_field = maildir
where_field = username
hosts = localhost
/etc/postfix/mysql_transport_maps.cf
user = postfix
password = alface
dbname = postfix
table = domain
select_field = transport
where_field = domain
hosts = localhost
/etc/postfix/mysql_virtual_mailbox_limit_maps.cf
user = postfix
password = alface
dbname = postfix
table = mailbox
select_field = quota
where_field = username
hosts = localhost
#######
Dúvidas:
- Alguém já passou por este problema?
- Quando o email é enviado localmente ele não loga no /var/log/mail.log, isto está correto?
- Alguém nesta lista tá usando postfix + mysql+ maildrop?
- Se o maildrop está conseguindo enviar os emails localmente significa que ele já está integrado com o myslq, certo?
Agradeço as dicas de todos
