parou de enviar email após trocar hospedagem do domínio [RESOLVIDO]

elizandromedina
(usa CentOS)

Enviado em 17/02/2011 - 15:19h

Cara,

O primeiro passo é voce acessar o mysql e achar a tabela relacionada ao teu dominio la voce vai ver o status do dominio dentro do postfix.

Porque a lógica é assim, se os emails internos não estão funcionando é que o problema é na hora de localizar a caixa postal e o dominio. Então como te falei ache a base e faça o post do conteudo da tabela aqui para analise.

Elizandro Medina

dafloria
(usa Ubuntu)

Enviado em 17/02/2011 - 15:42h

Será que pode ser esta aqui???

select * from routines;
+---------------+-----------------+----------------+--------------+--------------+----------------------------+--------------+------------------------------------------------------------------------+---------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+----------+-----------------+----------------+
| SPECIFIC_NAME | ROUTINE_CATALOG | ROUTINE_SCHEMA | ROUTINE_NAME | ROUTINE_TYPE | DTD_IDENTIFIER | ROUTINE_BODY | ROUTINE_DEFINITION | EXTERNAL_NAME | EXTERNAL_LANGUAGE | PARAMETER_STYLE | IS_DETERMINISTIC | SQL_DATA_ACCESS | SQL_PATH | SECURITY_TYPE | CREATED | LAST_ALTERED | SQL_MODE | ROUTINE_COMMENT | DEFINER |
+---------------+-----------------+----------------+--------------+--------------+----------------------------+--------------+------------------------------------------------------------------------+---------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+----------+-----------------+----------------+
| dominio | NULL | Staroup | dominio | FUNCTION | varchar(80) CHARSET latin1 | SQL | begin return substring(email, instr(email, '@')+1, length(email)); end | NULL | NULL | SQL | YES | CONTAINS SQL | NULL | DEFINER | 2009-08-08 12:49:19 | 2009-08-08 12:49:19 | | | root@localhost |
+---------------+-----------------+----------------+--------------+--------------+----------------------------+--------------+------------------------------------------------------------------------+---------------+-------------------+-----------------+------------------+-----------------+----------+---------------+---------------------+---------------------+----------+-----------------+----------------+

Foi a única que encontrei que menciona algo sobre o domínio.

elizandromedina
(usa CentOS)

Enviado em 17/02/2011 - 15:45h

Cara,

manda pra mim o conteúdo do arquivo /etc/postfix/virtual.mysql ai vamos ver aonde esta o a base do postfix.

Elizandro Medina

dafloria
(usa Ubuntu)

Enviado em 17/02/2011 - 15:51h

Tá ai...

A base de dados é a Staroup, correto? Já vou procurar melhor alí.

#
# mysql config file for alias lookups on postfix
# comments are ok.
#

# the user name and password to log into the mysql server
hosts=127.0.0.1
user=postfix
password=starpostfix%%%%%

# the database name on the servers
dbname=Staroup

# the table name
table=virtual

#
select_field=email
where_field=alias
additional_conditions=

Cara, te agradeço muito mesmo pela ajuda. Eu tava perdidaço aqui.

elizandromedina
(usa CentOS)

Enviado em 17/02/2011 - 15:54h

Cara,

Então vamos lá, a base mysql do postfix se encontra na tabela Staroup, dentro desta tabela provavelmente terá uma tabela chamada domains.

Verifique o campo status da tabela mencionada.

Elizandro Medina

dafloria
(usa Ubuntu)

Enviado em 17/02/2011 - 15:56h

Olha as porcaria que tem aí dentro:

show tables;
+---------------------------------+
| Tables_in_Staroup |
+---------------------------------+
| mail_traffic_012005 |
| mail_traffic_012006 |
| mail_traffic_012007 |
| mail_traffic_012008 |
| mail_traffic_012009 |
| mail_traffic_022005 |
| mail_traffic_022006 |
| mail_traffic_022007 |
| mail_traffic_022008 |
| mail_traffic_022009 |
| mail_traffic_032005 |
| mail_traffic_032006 |
| mail_traffic_032007 |
| mail_traffic_032008 |
| mail_traffic_032009 |
| mail_traffic_042005 |
| mail_traffic_042006 |
| mail_traffic_042007 |
| mail_traffic_042008 |
| mail_traffic_042009 |
| mail_traffic_052005 |
| mail_traffic_052006 |
| mail_traffic_052007 |
| mail_traffic_052008 |
| mail_traffic_052009 |
| mail_traffic_062005 |
| mail_traffic_062006 |
| mail_traffic_062007 |
| mail_traffic_062008 |
| mail_traffic_062009 |
| mail_traffic_072005 |
| mail_traffic_072006 |
| mail_traffic_072007 |
| mail_traffic_072008 |
| mail_traffic_072009 |
| mail_traffic_082005 |
| mail_traffic_082006 |
| mail_traffic_082007 |
| mail_traffic_082008 |
| mail_traffic_082009 |
| mail_traffic_092004 |
| mail_traffic_092005 |
| mail_traffic_092006 |
| mail_traffic_092007 |
| mail_traffic_092008 |
| mail_traffic_102004 |
| mail_traffic_102005 |
| mail_traffic_102006 |
| mail_traffic_102007 |
| mail_traffic_102008 |
| mail_traffic_111999 |
| mail_traffic_112004 |
| mail_traffic_112005 |
| mail_traffic_112006 |
| mail_traffic_112007 |
| mail_traffic_112008 |
| mail_traffic_122004 |
| mail_traffic_122005 |
| mail_traffic_122006 |
| mail_traffic_122007 |
| mail_traffic_122008 |
| mail_traffic_attachments |
| mail_traffic_attachments_012005 |
| mail_traffic_attachments_012006 |
| mail_traffic_attachments_012007 |
| mail_traffic_attachments_012008 |
| mail_traffic_attachments_012009 |
| mail_traffic_attachments_022005 |
| mail_traffic_attachments_022006 |
| mail_traffic_attachments_022007 |
| mail_traffic_attachments_022008 |
| mail_traffic_attachments_022009 |
| mail_traffic_attachments_032005 |
| mail_traffic_attachments_032006 |
| mail_traffic_attachments_032007 |
| mail_traffic_attachments_032008 |
| mail_traffic_attachments_032009 |
| mail_traffic_attachments_042005 |
| mail_traffic_attachments_042006 |
| mail_traffic_attachments_042007 |
| mail_traffic_attachments_042008 |
| mail_traffic_attachments_042009 |
| mail_traffic_attachments_052005 |
| mail_traffic_attachments_052006 |
| mail_traffic_attachments_052007 |
| mail_traffic_attachments_052008 |
| mail_traffic_attachments_052009 |
| mail_traffic_attachments_062005 |
| mail_traffic_attachments_062006 |
| mail_traffic_attachments_062007 |
| mail_traffic_attachments_062008 |
| mail_traffic_attachments_062009 |
| mail_traffic_attachments_072005 |
| mail_traffic_attachments_072006 |
| mail_traffic_attachments_072007 |
| mail_traffic_attachments_072008 |
| mail_traffic_attachments_072009 |
| mail_traffic_attachments_082005 |
| mail_traffic_attachments_082006 |
| mail_traffic_attachments_082007 |
| mail_traffic_attachments_082008 |
| mail_traffic_attachments_082009 |
| mail_traffic_attachments_092004 |
| mail_traffic_attachments_092005 |
| mail_traffic_attachments_092006 |
| mail_traffic_attachments_092007 |
| mail_traffic_attachments_092008 |
| mail_traffic_attachments_102004 |
| mail_traffic_attachments_102005 |
| mail_traffic_attachments_102006 |
| mail_traffic_attachments_102007 |
| mail_traffic_attachments_102008 |
| mail_traffic_attachments_111999 |
| mail_traffic_attachments_112004 |
| mail_traffic_attachments_112005 |
| mail_traffic_attachments_112006 |
| mail_traffic_attachments_112007 |
| mail_traffic_attachments_112008 |
| mail_traffic_attachments_122004 |
| mail_traffic_attachments_122005 |
| mail_traffic_attachments_122006 |
| mail_traffic_attachments_122007 |
| mail_traffic_attachments_122008 |
| mail_traffic_recipients |
| mail_traffic_recipients_012005 |
| mail_traffic_recipients_012006 |
| mail_traffic_recipients_012007 |
| mail_traffic_recipients_012008 |
| mail_traffic_recipients_012009 |
| mail_traffic_recipients_022005 |
| mail_traffic_recipients_022006 |
| mail_traffic_recipients_022007 |
| mail_traffic_recipients_022008 |
| mail_traffic_recipients_022009 |
| mail_traffic_recipients_032005 |
| mail_traffic_recipients_032006 |
| mail_traffic_recipients_032007 |
| mail_traffic_recipients_032008 |
| mail_traffic_recipients_032009 |
| mail_traffic_recipients_042005 |
| mail_traffic_recipients_042006 |
| mail_traffic_recipients_042007 |
| mail_traffic_recipients_042008 |
| mail_traffic_recipients_042009 |
| mail_traffic_recipients_052005 |
| mail_traffic_recipients_052006 |
| mail_traffic_recipients_052007 |
| mail_traffic_recipients_052008 |
| mail_traffic_recipients_052009 |
| mail_traffic_recipients_062005 |
| mail_traffic_recipients_062006 |
| mail_traffic_recipients_062007 |
| mail_traffic_recipients_062008 |
| mail_traffic_recipients_062009 |
| mail_traffic_recipients_072005 |
| mail_traffic_recipients_072006 |
| mail_traffic_recipients_072007 |
| mail_traffic_recipients_072008 |
| mail_traffic_recipients_072009 |
| mail_traffic_recipients_082005 |
| mail_traffic_recipients_082006 |
| mail_traffic_recipients_082007 |
| mail_traffic_recipients_082008 |
| mail_traffic_recipients_082009 |
| mail_traffic_recipients_092004 |
| mail_traffic_recipients_092005 |
| mail_traffic_recipients_092006 |
| mail_traffic_recipients_092007 |
| mail_traffic_recipients_092008 |
| mail_traffic_recipients_102004 |
| mail_traffic_recipients_102005 |
| mail_traffic_recipients_102006 |
| mail_traffic_recipients_102007 |
| mail_traffic_recipients_102008 |
| mail_traffic_recipients_111999 |
| mail_traffic_recipients_112004 |
| mail_traffic_recipients_112005 |
| mail_traffic_recipients_112006 |
| mail_traffic_recipients_112007 |
| mail_traffic_recipients_112008 |
| mail_traffic_recipients_122004 |
| mail_traffic_recipients_122005 |
| mail_traffic_recipients_122006 |
| mail_traffic_recipients_122007 |
| mail_traffic_recipients_122008 |
| mail_traffic_summary |
| usuarios |
| usuarios_old |
| virtual |
| virtual_bkup |
+---------------------------------+

vou procurar nessas ou crio uma domain?

elizandromedina
(usa CentOS)

Enviado em 17/02/2011 - 15:59h

Cara,

Verifique a tabela virtua e posta aqui.

Elizandro Medina

dafloria
(usa Ubuntu)

Enviado em 17/02/2011 - 16:04h

É a tabela de redirecionamento de e-mails.

+----------------------------------+-------------------------------+-------------+
| alias | email | observacoes |
+----------------------------------+-------------------------------+-------------+
| ana.guerreiro@staroup.com.br | carlos.duque@staroup.com.br | |
| cesar.figueiredo@staroup.com.br | carlos.duque@staroup.com.br | |
| cesar.figueiredo@staroup.com.br | | |
| | | |
| mariana.zucari@staroup.com.br | carlos.duque@staroup.com.br | |
| neuza@staroup.com.br | daniela.santos@staroup.com.br | |
| postmaster.@staroup.com.br | suporte@scale.com.br | |
| vinicius.oliveira@staroup.com.br | | |
+----------------------------------+-------------------------------+-------------+

elizandromedina
(usa CentOS)

Enviado em 17/02/2011 - 16:10h

Muito esquisito nesta tabela deveria ter um campo status, de qualquer forma manda a tabela usuarios para eu dar uma olhada.

Elizandro Medina

dafloria
(usa Ubuntu)

Enviado em 17/02/2011 - 16:15h

Ta aí. Mas aparentemente, também não tem nada.

+ -------------- + -------------- -+ --------------------------------------- + ---------------------------------------- + --------------- -+ ----------- -+ ----------- -+
| username | password | nome | email | maildir | admin_flag | squid_flag |
+ -------------- + -------------- -+ --------------------------------------- + ---------------------------------------- + --------------- -+ ----------- -+ ----------- -+
| acabamen | xxxxxxxxxxxxxx | acabamento1 | acabamento1@staroup.com.br | /var/mail/imap | 0 | 0 |

elizandromedina
(usa CentOS)

Enviado em 17/02/2011 - 16:25h

Cara, faça uma mudança na diretiva smtpd_recipient_restrictions: deixe da forma abaixo

Altere e reinicie o serviço

Elizandro Medina

smtpd_recipient_restrictions =
permit_mynetworks,
permit_sasl_authenticated,
reject_invalid_hostname,
reject_non_fqdn_sender,
reject_non_fqdn_recipient,
reject_unauth_pipelining,
# reject_unverified_recipient,
check_sender_access hash:/etc/postfix/sender_access
reject_unverified_sender,
check_client_access pcre:/etc/postfix/access_pcre_dsl,
check_client_access pcre:/etc/postfix/access_pcre2,
check_client_access pcre:/etc/postfix/access_pcre3,
check_client_access pcre:/etc/postfix/access_pcre4,
check_client_access pcre:/etc/postfix/access_pcre_paises,
reject_rbl_client blackholes.wirehub.net,
reject_rbl_client relays.mail-abuse.org,
reject_rbl_client rbl-plus.mail-abuse.org,
reject_rbl_client sbl-xbl.spamhaus.org,
reject_rbl_client bl.spamcop.net,
reject_unauth_destination,
check_policy_service unix:private/policyd-spf,
check_policy_service inet:127.0.0.1:10031,
permit

dafloria
(usa Ubuntu)

Enviado em 17/02/2011 - 16:27h

Essa é a configuração que eu deixei no superdns:

TTL: 1800

Host Tipo Destino
*.staroup.com.br   Address (A) 200.232.94.146
@.staroup.com.br   Address (A) 200.232.94.146
@.staroup.com.br   MX (Correio) linux.bt.staroup.com.br
linux.bt.staroup.com.br Address (A)  200.232.94.146

Mas já tentei várias outras, principalmente na parte de correio.
só staroup.com.br, bt.staroup.com.br, mail.staroup.com.br, mx.staroup.com.br e por aí afora...

Não sei se pode ajudar alguma coisa?!?!?!