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=<[EMAIL PROTECTED]>
Aug 1 09:19:36 DebianLXTeste02 postfix/qmgr[9709]: 26D13422A5: from=<[EMAIL
PROTECTED]>, size=4801, nrcpt=1 (queue active)
Aug 1 09:19:36 DebianLXTeste02 postfix/pipe[9749]: 26D13422A5: to=<[EMAIL
PROTECTED]>, 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=<[EMAIL PROTECTED]>
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=<[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. )
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 [EMAIL PROTECTED] on postfix
246 Query SELECT transport FROM domain WHERE
domain='*'
246 Query SELECT transport FROM domain WHERE
domain='*'
247 Connect [EMAIL PROTECTED] on postfix
247 Query SELECT goto FROM alias WHERE
address='fatec.int'
248 Connect [EMAIL PROTECTED] on postfix
248 Query SELECT maildir FROM mailbox WHERE
username='fatec.int'
246 Query SELECT transport FROM domain WHERE
domain='[EMAIL PROTECTED]'
246 Query SELECT transport FROM domain WHERE
domain='fatec.int'
249 Connect [EMAIL PROTECTED] on postfix
249 Query SELECT goto FROM alias WHERE
address='[EMAIL PROTECTED]'
249 Query SELECT goto FROM alias WHERE address='aluno'
249 Query SELECT goto FROM alias WHERE
address='@fatec.int'
250 Connect [EMAIL PROTECTED] on postfix
250 Query SELECT goto FROM alias WHERE
address='[EMAIL PROTECTED]'
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='[EMAIL PROTECTED]'
246 Query SELECT transport FROM domain WHERE
domain='fatec.int'
250 Query SELECT goto FROM alias WHERE
address='[EMAIL PROTECTED]'
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='[EMAIL PROTECTED]'
246 Query SELECT transport FROM domain WHERE
domain='fatec.int'
Grato pela atenção
----- Mensagem original ----
De: Roberto Tikao Tsukamoto Júnior <[EMAIL PROTECTED]>
Para: [email protected]
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 [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Alertas do Yahoo! Mail em seu celular. Saiba mais em
http://br.mobile.yahoo.com/mailalertas/
