Roberto! bom dia!
Alterei de localhost para 127.0.0.1 porém continua dando os mesmos erros.
A sua solução está funcionando?
Segue abaixo os logs para referência:
log de erro ao tentar enviar o email de um cliente de email:
Aug 1 09:19:36 DebianLXTeste02 postfix/smtpd[9745]: connect from srvmsc02.col[172.16.65.3]
Aug 1 09:19:36 DebianLXTeste02 postfix/smtpd[9745]: 26D13422A5: client=srvmsc02.col[172.16.65.3]
Aug 1 09:19:36 DebianLXTeste02 postfix/cleanup[9748]: 26D13422A5: message-id=<20100801121936.26D13422A5@debian.local.int>
Aug 1 09:19:36 DebianLXTeste02 postfix/qmgr[9709]: 26D13422A5: from=<aluno@fatec.int>, size=4801, nrcpt=1
(queue active)
Aug 1 09:19:36 DebianLXTeste02 postfix/pipe[9749]: 26D13422A5: to=<aluno@fatec.int>, relay=maildrop, delay=0.07, delays=0.04/0.01/0/0.03, dsn=5.1.1, status=bounced (user unknown. Command output: ERR: authdaemon: s_connect() failed: Permission denied Invalid user specified. )
Aug 1 09:19:36 DebianLXTeste02 postfix/cleanup[9748]: 38559422AA: message-id=<20100801121936.38559422AA@debian.local.int>
Aug 1 09:19:36 DebianLXTeste02 postfix/bounce[9751]: 26D13422A5: sender non-delivery notification: 38559422AA
Aug 1 09:19:36 DebianLXTeste02 postfix/qmgr[9709]: 26D13422A5: removed
Aug 1 09:19:36 DebianLXTeste02 postfix/qmgr[9709]: 38559422AA: from=<>, size=6659, nrcpt=1 (queue active)
Aug 1 09:19:36 DebianLXTeste02 postfix/pipe[9749]: 38559422AA: to=<aluno@fatec.int>, 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. )
Aug 1 09:19:36 DebianLXTeste02 postfix/qmgr[9709]: 38559422AA: removed
Aug 1 09:19:38 DebianLXTeste02 postfix/smtpd[9745]: disconnect from srvmsc02.col[172.16.65.3]
Log do mysql ao tentar enviar o email:
100801 9:23:17 246 Connect postfix@localhost on postfix
246 Query SELECT transport FROM domain WHERE domain='*'
246 Query SELECT transport FROM domain WHERE
domain='*'
247 Connect postfix@localhost on postfix
247 Query SELECT goto FROM alias WHERE address='fatec.int'
248 Connect postfix@localhost on postfix
248 Query SELECT maildir FROM mailbox WHERE username='fatec.int'
246
Query SELECT transport FROM domain WHERE domain='aluno@fatec.int'
246 Query SELECT transport FROM domain WHERE domain='fatec.int'
249 Connect postfix@localhost on postfix
249 Query SELECT goto FROM alias WHERE address='aluno@fatec.int'
249 Query SELECT goto FROM alias WHERE
address='aluno'
249 Query SELECT goto FROM alias WHERE address='@fatec.int'
250 Connect postfix@localhost on postfix
250 Query SELECT goto FROM alias WHERE address='aluno@fatec.int'
250 Query SELECT goto FROM alias WHERE address='aluno'
250
Query SELECT goto FROM alias WHERE address='@fatec.int'
247 Query SELECT goto FROM alias WHERE address='fatec.int'
248 Query SELECT maildir FROM mailbox WHERE username='fatec.int'
246 Query SELECT transport FROM domain WHERE domain='aluno@fatec.int'
246 Query SELECT transport FROM domain WHERE
domain='fatec.int'
250 Query SELECT goto FROM alias WHERE address='aluno@fatec.int'
250 Query SELECT goto FROM alias WHERE address='aluno'
250 Query SELECT goto FROM alias WHERE address='@fatec.int'
247 Query SELECT goto FROM alias WHERE
address='fatec.int'
248 Query SELECT maildir FROM mailbox WHERE username='fatec.int'
246 Query SELECT transport FROM domain WHERE domain='aluno@fatec.int'
246 Query SELECT transport FROM domain WHERE domain='fatec.int'
Grato pela atenção
----- Mensagem original ----
De: Roberto Tikao Tsukamoto Júnior <linuxsroot@yahoo.com.br>
Para: debian-user-portuguese@lists.debian.org
Enviadas:
Terça-feira, 31 de Julho de 2007 17:54:12
Assunto: Re: Maildrop com suporte a mysql x Erro no envio do email
Waltair Santos escreveu:
>
> /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
>
Eu estou essa mesma solução, e tive um problema nos arquivos acima: tive
que trocar LOCALHOST por 127.0.0.1
Atenciosamente,
Roberto Tikao
--
To UNSUBSCRIBE, email to debian-user-portuguese-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org