Медленно отправляються письма!

balamut · Непрочитанное сообщение **balamut** » 2011-12-01 16:08:33

Добрый вечер, всем!не могу понять почему при отправлении письма клиент почтовый как бы висит, проходит секунд 15-25 и письмо отправляется!
Причем такая муть не у каждого пользователя.
До этого полгода работало нормально!
В логах проскакивает

Код: Выделить всё

 auth_plain authenticator failed for ([192.168.0.2]) [192.168.0.2]:4972 I=[192.168.0.239]:25: 535 Incorrect authentication data (set_id=support@domain.ru)

в отладке такая фигня

Код: Выделить всё

sender_fullhost = [192.168.0.2]:4993
16:52:49  7385 sender_rcvhost = [192.168.0.2] (port=4993)
16:52:49  7385 Process 7385 is handling incoming connection from [192.168.0.2]:4993
16:52:49  7385 host in host_lookup? no (option unset)
16:52:49  7385 set_process_info:  7385 handling incoming connection from [192.168.0.2]:4993 I=[192.168.0.239]:25
16:52:49  7385 host in host_reject_connection? no (option unset)
16:52:49  7385 host in sender_unqualified_hosts? no (option unset)
16:52:49  7385 host in recipient_unqualified_hosts? no (option unset)
16:52:49  7385 host in helo_verify_hosts? no (option unset)
16:52:49  7385 host in helo_try_verify_hosts? no (option unset)
16:52:49  7385 host in helo_accept_junk_hosts? yes (matched "192.168.0.0/24")
16:52:49  7385 expanding: $primary_hostname, ESMTP EXIM $version_number
16:52:49  7385    result: domain.ru, ESMTP EXIM 4.74
16:52:49  7385 SMTP>> 220 domain.ru, ESMTP EXIM 4.74
16:52:49  7385 Process 7385 is ready for new message
16:52:49  7385 smtp_setup_msg entered
16:52:49  7385 SMTP<< EHLO [192.168.0.2]
16:52:49  7385 Actual local interface address is 192.168.0.239 (re0)
16:52:49  7385 Actual local interface address is fe80:3::1 (lo0)
16:52:49  7385 Actual local interface address is ::1 (lo0)
16:52:49  7385 Actual local interface address is 127.0.0.1 (lo0)
16:52:49  7385 [192.168.0.2] in helo_lookup_domains? no (end of list)
16:52:49  7385 sender_fullhost = ([192.168.0.2]) [192.168.0.2]:4993
16:52:49  7385 sender_rcvhost = [192.168.0.2] (port=4993)
16:52:49  7385 set_process_info:  7385 handling incoming connection from ([192.168.0.2]) [192.168.0.2]:4993 I=[192.168.0.239]:25
16:52:49  7385 host in pipelining_advertise_hosts? yes (matched "*")
16:52:49  7385 host in auth_advertise_hosts? yes (matched "*")
16:52:49  7385 host in tls_advertise_hosts? no (option unset)
16:52:49  7385 SMTP>> 250-domain.ru Hello [192.168.0.2] [192.168.0.2]
16:52:49  7385 250-SIZE 104857600
16:52:49  7385 250-PIPELINING
16:52:49  7385 250-AUTH PLAIN LOGIN CRAM-MD5
16:52:49  7385 250 HELP
16:52:49  7385 SMTP<< AUTH PLAIN AHN1cHBvcnRAbW9udGJsYW5jLnJ1ADA3MDQ5MA==
16:52:49  7385 auth_plain authenticator:
16:52:49  7385   $auth1 =
16:52:49  7385   $auth2 = support@domain.ru
16:52:49  7385   $auth3 = 070490
16:52:49  7385   $1 =
16:52:49  7385   $2 = support@domain.ru
16:52:49  7385   $3 = 070490
16:52:49  7385 expanding: $1
16:52:49  7385    result:
16:52:49  7385 expanding: $2
16:52:49  7385    result: support@domain.ru
16:52:49  7385 expanding: SELECT `username` FROM `mailbox` WHERE `username` = '${quote_mysql:$1}' AND `password` = '${quote_mysql:$2}'
16:52:49  7385    result: SELECT `username` FROM `mailbox` WHERE `username` = '' AND `password` = 'support@domain.ru'
16:52:49  7385 search_open: mysql "NULL"
16:52:49  7385 search_find: file="NULL"
16:52:49  7385   key="SELECT `username` FROM `mailbox` WHERE `username` = '' AND `password` = 'support@domain.ru'" partial=-1 affix=NULL starflags=0
16:52:49  7385 LRU list:
16:52:49  7385 internal_search_find: file="NULL"
16:52:49  7385   type=mysql key="SELECT `username` FROM `mailbox` WHERE `username` = '' AND `password` = 'support@domain.ru'"
16:52:49  7385 database lookup required for SELECT `username` FROM `mailbox` WHERE `username` = '' AND `password` = 'support@domain.ru'
16:52:49  7385 MySQL query: SELECT `username` FROM `mailbox` WHERE `username` = '' AND `password` = 'support@domain.ru'
16:52:49  7385 MYSQL new connection: host=localhost port=0 socket=NULL database=exim user=exim
16:52:49  7385 MYSQL: no data found
16:52:49  7385 lookup failed
16:52:49  7385 expanding: yes
16:52:49  7385    result: yes
16:52:49  7385 skipping: result is not used
16:52:49  7385 expanding: no
16:52:49  7385    result: no
16:52:49  7385 expanding: ${lookup mysql{SELECT `username` FROM `mailbox` WHERE `username` = '${quote_mysql:$1}' AND `password` = '${quote_mysql:$2}'}{yes}{no}}
16:52:49  7385    result: no
16:52:49  7385 expanded string: no
16:52:49  7385 expanding: $2
16:52:49  7385    result: support@domain.ru
16:52:49  7385 SMTP>> 535 Incorrect authentication data
16:52:49  7385 LOG: MAIN REJECT
16:52:49  7385   auth_plain authenticator failed for ([192.168.0.2]) [192.168.0.2]:4993 I=[192.168.0.239]:25: 535 Incorrect authentication data (set_id=support@domain.ru)
16:52:49  7385 SMTP<< AUTH LOGIN
16:52:49  7385 host in smtp_accept_max_nonmail_hosts? yes (matched "*")
16:52:49  7385 SMTP>> 334 VXNlcm5hbWU6
16:52:49  7385 SMTP<< c3VwcG9ydEBtb250YmxhbmMucnU=
16:52:49  7385 SMTP>> 334 UGFzc3dvcmQ6
16:52:49  7385 SMTP<< MDcwNDkw
16:52:49  7385 auth_login authenticator:
16:52:49  7385   $auth1 = support@domain.ru
16:52:49  7385   $auth2 = 070490
16:52:49  7385   $1 = support@domain.ru
16:52:49  7385   $2 = 070490
16:52:49  7385 expanding: $1
16:52:49  7385    result: support@domain.ru
16:52:49  7385 expanding: $2
16:52:49  7385    result: 070490
16:52:49  7385 expanding: SELECT `username` FROM `mailbox` WHERE `username` = '${quote_mysql:$1}' AND `password` = '${quote_mysql:$2}'
16:52:49  7385    result: SELECT `username` FROM `mailbox` WHERE `username` = 'support@domain.ru' AND `password` = '070490'
16:52:49  7385 search_open: mysql "NULL"
16:52:49  7385   cached open
16:52:49  7385 search_find: file="NULL"
16:52:49  7385   key="SELECT `username` FROM `mailbox` WHERE `username` = 'support@domain.ru' AND `password` = '070490'" partial=-1 affix=NULL starflags=0
16:52:49  7385 LRU list:
16:52:49  7385 internal_search_find: file="NULL"
16:52:49  7385   type=mysql key="SELECT `username` FROM `mailbox` WHERE `username` = 'support@domain.ru' AND `password` = '070490'"
16:52:49  7385 database lookup required for SELECT `username` FROM `mailbox` WHERE `username` = 'support@domain' AND `password` = '070490'
16:52:49  7385 MySQL query: SELECT `username` FROM `mailbox` WHERE `username` = 'support@domain.ru' AND `password` = '070490'
16:52:49  7385 MYSQL using cached connection for localhost/exim/exim
16:52:49  7385 lookup yielded: support@domain.ru
16:52:49  7385 expanding: yes
16:52:49  7385    result: yes
16:52:49  7385 expanding: no
16:52:49  7385    result: no
16:52:49  7385 skipping: result is not used
16:52:49  7385 expanding: ${lookup mysql{SELECT `username` FROM `mailbox` WHERE `username` = '${quote_mysql:$1}' AND `password` = '${quote_mysql:$2}'}{yes}{no}}
16:52:49  7385    result: yes
16:52:49  7385 expanded string: yes
16:52:49  7385 expanding: $1
16:52:49  7385    result: support@domain.ru
16:52:49  7385 SMTP>> 235 Authentication succeeded
16:52:49  7385 SMTP<< MAIL FROM:<support@domain.ru> SIZE=444
16:52:49  7385 spool directory space = 143809526K inodes = 24991889 check_space = 0K inodes = 0 msg_size = 5444
16:52:49  7385 SMTP>> 250 OK
16:52:49  7385 SMTP<< RCPT TO:<iisaev7@gmail.com>
16:52:49  7385 using ACL "acl_check_rcpt"
16:52:49  7385 processing "accept"
16:52:49  7385 check hosts = :
16:52:49  7385 host in ":"? no (end of list)
16:52:49  7385 accept: condition test failed
16:52:49  7385 processing "deny"
16:52:49  7385 check domains = +local_domains
16:52:49  7385 expanding: SELECT `domain` FROM `domain` WHERE `domain`='${domain}' AND `active`='1'
16:52:49  7385    result: SELECT `domain` FROM `domain` WHERE `domain`='gmail.com' AND `active`='1'
16:52:49  7385 search_open: mysql "NULL"
16:52:49  7385   cached open
16:52:49  7385 search_find: file="NULL"
16:52:49  7385   key="SELECT `domain` FROM `domain` WHERE `domain`='gmail.com' AND `active`='1'" partial=-1 affix=NULL starflags=0
16:52:49  7385 LRU list:
16:52:49  7385 internal_search_find: file="NULL"
16:52:49  7385   type=mysql key="SELECT `domain` FROM `domain` WHERE `domain`='gmail.com' AND `active`='1'"
16:52:49  7385 database lookup required for SELECT `domain` FROM `domain` WHERE `domain`='gmail.com' AND `active`='1'
16:52:49  7385 MySQL query: SELECT `domain` FROM `domain` WHERE `domain`='gmail.com' AND `active`='1'
16:52:49  7385 MYSQL using cached connection for localhost/exim/exim
16:52:49  7385 MYSQL: no data found
16:52:49  7385 lookup failed
16:52:49  7385 expanding: ${lookup mysql{SELECT `domain` FROM `domain` WHERE `domain`='${domain}' AND `active`='1'}}
16:52:49  7385    result:
16:52:49  7385 gmail.com in ""? no (end of list)
16:52:49  7385 gmail.com in "+local_domains"? no (end of list)
16:52:49  7385 deny: condition test failed
16:52:49  7385 processing "deny"
16:52:49  7385 check domains = !+local_domains
16:52:49  7385 expanding: SELECT `domain` FROM `domain` WHERE `domain`='${domain}' AND `active`='1'
16:52:49  7385    result: SELECT `domain` FROM `domain` WHERE `domain`='gmail.com' AND `active`='1'
16:52:49  7385 search_open: mysql "NULL"
16:52:49  7385   cached open
16:52:49  7385 search_find: file="NULL"
16:52:49  7385   key="SELECT `domain` FROM `domain` WHERE `domain`='gmail.com' AND `active`='1'" partial=-1 affix=NULL starflags=0
16:52:49  7385 LRU list:
16:52:49  7385 internal_search_find: file="NULL"
16:52:49  7385   type=mysql key="SELECT `domain` FROM `domain` WHERE `domain`='gmail.com' AND `active`='1'"
16:52:49  7385 cached data used for lookup of SELECT `domain` FROM `domain` WHERE `domain`='gmail.com' AND `active`='1'
16:52:49  7385 lookup failed
16:52:49  7385 expanding: ${lookup mysql{SELECT `domain` FROM `domain` WHERE `domain`='${domain}' AND `active`='1'}}
16:52:49  7385    result:
16:52:49  7385 gmail.com in ""? no (end of list)
16:52:49  7385 gmail.com in "!+local_domains"? yes (end of list)
16:52:49  7385 check local_parts = ^[./|] : ^.*[@%!] : ^.*/\\.\\./
16:52:49  7385 expanding: ^[./|] : ^.*[@%!] : ^.*/\\.\\./
16:52:49  7385    result: ^[./|] : ^.*[@%!] : ^.*/\.\./
16:52:49  7385 iisaev7 in "^[./|] : ^.*[@%!] : ^.*/\.\./"? no (end of list)
16:52:49  7385 deny: condition test failed
16:52:49  7385 processing "deny"
16:52:49  7385 expanding: $sender_helo_name
16:52:49  7385    result: [192.168.0.2]
16:52:49  7385 expanding:
16:52:49  7385    result:
16:52:49  7385 condition: eq{$sender_helo_name}{}
16:52:49  7385    result: false
16:52:49  7385 expanding: yes
16:52:49  7385    result: yes
16:52:49  7385 skipping: result is not used
16:52:49  7385 expanding: no
16:52:49  7385    result: no
16:52:49  7385 expanding: ${if eq{$sender_helo_name}{}{yes}{no}}
16:52:49  7385    result: no
16:52:49  7385 check condition = ${if eq{$sender_helo_name}{}{yes}{no}}
16:52:49  7385                 = no
16:52:49  7385 deny: condition test failed
16:52:49  7385 processing "accept"
16:52:49  7385 check authenticated = *
16:52:49  7385 auth_login in "*"? yes (matched "*")
16:52:49  7385 accept: condition test succeeded
16:52:49  7385 SMTP>> 250 Accepted
16:52:49  7385 SMTP<< DATA
16:52:49  7385 SMTP>> 354 Enter message, ending with "." on a line by itself
16:52:49  7385 search_tidyup called
16:52:49  7385 close MYSQL connection: localhost/exim/exim
PDKIM >> Hashed body data, canonicalized >>>>>>>>>>>>>>>>>>>>>>>>>>>>>
16:52:49  7385 host in ignore_fromline_hosts? no (option unset)
16:52:49  7385 >>Headers received:
16:52:49  7385 Message-ID: <4ED786CD.5090600@domain.ru>
16:52:49  7385 Date: Thu, 01 Dec 2011 16:53:17 +0300
16:52:49  7385 From: =?UTF-8?B?0JjRgdCw0LXQsiDQmNC70YzRjw==?= <support@domain.ru>
16:52:49  7385 User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:8.0) Gecko/20111105 Thunderbird/8.0
16:52:49  7385 MIME-Version: 1.0
16:52:49  7385 To: iisaev7@gmail.com
16:52:49  7385 Subject: test
16:52:49  7385 Content-Type: text/plain; charset=UTF-8; format=flowed
16:52:49  7385 Content-Transfer-Encoding: 8bit
16:52:49  7385
16:52:49  7385 rewrite_one_header: type=F:
16:52:49  7385   From: =?UTF-8?B?0JjRgdCw0LXQsiDQmNC70YzRjw==?= <support@domain.ru>
16:52:49  7385 rewrite_one_header: type=T:
16:52:49  7385   To: iisaev7@gmail.com
16:52:49  7385 search_tidyup called
16:52:49  7385 >>Headers after rewriting and local additions:
16:52:49  7385 I Message-ID: <4ED786CD.5090600@domain.ru>
16:52:49  7385   Date: Thu, 01 Dec 2011 16:53:17 +0300
16:52:49  7385 F From: =?UTF-8?B?0JjRgdCw0LXQsiDQmNC70YzRjw==?= <support@domain.ru>
16:52:49  7385   User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:8.0) Gecko/20111105 Thunderbird/8.0
16:52:49  7385   MIME-Version: 1.0
16:52:49  7385 T To: iisaev7@gmail.com
16:52:49  7385   Subject: test
16:52:49  7385   Content-Type: text/plain; charset=UTF-8; format=flowed
16:52:49  7385   Content-Transfer-Encoding: 8bit
16:52:49  7385
16:52:49  7385 Data file written for message 1RW74D-0001v7-K2
16:52:49  7385 expanding: ${tod_full}
16:52:49  7385    result: Thu, 01 Dec 2011 16:52:49 +0300
16:52:49  7385 condition: def:sender_rcvhost
16:52:49  7385    result: true
16:52:49  7385 expanding: from $sender_rcvhost
16:52:49  7385
16:52:49  7385    result: from [192.168.0.2] (port=4993)
16:52:49  7385
16:52:49  7385 condition: def:sender_ident
16:52:49  7385    result: false
16:52:49  7385 expanding: $sender_ident
16:52:49  7385    result:
16:52:49  7385 skipping: result is not used
16:52:49  7385 expanding: from ${quote_local_part:$sender_ident}
16:52:49  7385    result: from
16:52:49  7385 skipping: result is not used
16:52:49  7385 condition: def:sender_helo_name
16:52:49  7385    result: false
16:52:49  7385 expanding: (helo=$sender_helo_name)
16:52:49  7385
16:52:49  7385    result: (helo=)
16:52:49  7385
16:52:49  7385 skipping: result is not used
16:52:49  7385 expanding: ${if def:sender_ident {from ${quote_local_part:$sender_ident} }}${if def:sender_helo_name {(helo=$sender_helo_name)
16:52:49  7385  }}
16:52:49  7385    result:
16:52:49  7385 skipping: result is not used
16:52:49  7385 condition: def:received_protocol
16:52:49  7385    result: true
16:52:49  7385 expanding: with $received_protocol
16:52:49  7385    result: with esmtpa
16:52:49  7385 condition: def:tls_cipher
16:52:49  7385    result: false
16:52:49  7385 expanding: ($tls_cipher)
16:52:49  7385
16:52:49  7385    result: ()
16:52:49  7385
16:52:49  7385 skipping: result is not used
16:52:49  7385 condition: def:sender_address
16:52:49  7385    result: true
16:52:49  7385 expanding: (envelope-from <$sender_address>)
16:52:49  7385
16:52:49  7385    result: (envelope-from <support@domain.ru>)
16:52:49  7385
16:52:49  7385 condition: def:received_for
16:52:49  7385    result: true
16:52:49  7385 expanding:
16:52:49  7385  for $received_for
16:52:49  7385    result:
16:52:49  7385  for iisaev7@gmail.com
16:52:49  7385 expanding: Received: ${if def:sender_rcvhost {from $sender_rcvhost
16:52:49  7385  }{${if def:sender_ident {from ${quote_local_part:$sender_ident} }}${if def:sender_helo_name {(helo=$sender_helo_name)
16:52:49  7385  }}}}by $primary_hostname ${if def:received_protocol {with $received_protocol}} ${if def:tls_cipher {($tls_cipher)
16:52:49  7385  }}(Exim $version_number (FreeBSD))
16:52:49  7385  ${if def:sender_address {(envelope-from <$sender_address>)
16:52:49  7385  }}id $message_exim_id${if def:received_for {
16:52:49  7385  for $received_for}}
16:52:49  7385    result: Received: from [192.168.0.2] (port=4993)
16:52:49  7385  by montblanc.ru with esmtpa (Exim 4.74 (FreeBSD))
16:52:49  7385  (envelope-from <support@domain.ru>)
16:52:49  7385  id 1RW74D-0001v7-K2
16:52:49  7385  for iisaev7@gmail.com
16:52:49  7385 >>Generated Received: header line
16:52:49  7385 P Received: from [192.168.0.2] (port=4993)
16:52:49  7385  by montblanc.ru with esmtpa (Exim 4.74 (FreeBSD))
16:52:49  7385  (envelope-from <support@domain.ru>)
16:52:49  7385  id 1RW74D-0001v7-K2
16:52:49  7385  for iisaev7@gmail.com; Thu, 01 Dec 2011 16:52:49 +0300

куда рыть?!гугл не помог решить проблему. надеюсь на вас!спасибо!!

Хостинг HostFood.ru · **Хостинг HostFood.ru**

Тарифы на хостинг в России, от 12 рублей: https://www.host-food.ru/tariffs/hosting/
Тарифы на виртуальные сервера (VPS/VDS/KVM) в РФ, от 189 руб.: https://www.host-food.ru/tariffs/virtualny-server-vps/
Выделенные сервера, Россия, Москва, от 2000 рублей (HP Proliant G5, Intel Xeon E5430 (2.66GHz, Quad-Core, 12Mb), 8Gb RAM, 2x300Gb SAS HDD, P400i, 512Mb, BBU):
https://www.host-food.ru/tariffs/vydelennyi-server-ds/
Недорогие домены в популярных зонах: https://www.host-food.ru/domains/

mak_v_ · Непрочитанное сообщение **mak_v_** » 2011-12-01 16:40:07

Рыть отсюда в сторону

Код: Выделить всё

MYSQL: no data found

Gamerman

Аутентификации долго перебирает.

mak_v_ · Непрочитанное сообщение **mak_v_** » 2011-12-01 17:52:36

Аутентификации долго перебирает.

да нет - мускуль то отвечает что такого нет, соответственно копать надо оттуда:
1) доступность мускуля,
2) корректность запросов (через локальное подключение)
3) ограничения мускуля не кол-во\интенсивность запросов
5) корректность фильтров в мыльнике

balamut · Непрочитанное сообщение **balamut** » 2011-12-01 18:05:33

почему в таком порядке?

Код: Выделить всё

$auth1 =
16:52:49  7385   $auth2 = support@domain.ru
16:52:49  7385   $auth3 = 070490
expanding: SELECT `username` FROM `mailbox` WHERE `username` = '${quote_mysql:$1}' AND `password` = '${quote_mysql:$2}'

когда должно быть

Код: Выделить всё

$auth1=support@domain.ru
$auth2=070490
expanding: SELECT `username` FROM `mailbox` WHERE `username` = '${quote_mysql:$1}' AND `password` = '${quote_mysql:$2}'

от куда это берется?

balamut · Непрочитанное сообщение **balamut** » 2011-12-02 18:16:10

кто нибудь поможет?бьюсь второй день как рыба об лёд!)

mak_v_ · Непрочитанное сообщение **mak_v_** » 2011-12-02 18:18:45

вам же выше постом ответили - запросы к мускулю у вас кривоваты, а отправка в конечном счете без авторизации

balamut · Непрочитанное сообщение **balamut** » 2011-12-02 18:27:29

Freebsd нынче сама конфиги правит?я не менял ни чего вообще и пошла такая муть!

mak_v_ · Непрочитанное сообщение **mak_v_** » 2011-12-02 19:26:21

а оно не работает, кто оно, то что внутри вот этой металлической коробки

balamut · Непрочитанное сообщение **balamut** » 2011-12-02 23:10:48

разобрался!дело было в spamassassin"e!он медленно проверял письмо!не понятно одно почему он проверяет исходящую почту...

dikens3 · Непрочитанное сообщение **dikens3** » 2011-12-02 23:16:47

У вас ещё неправильный запрос к mysql в PLAIN аутентификации, хотя в LOGIN он нормальный и пользователь успешно аутентифицируется.

Решение:
Поправьте запрос или удалите/закомметируйте аутентификатор PLAIN.

balamut · Непрочитанное сообщение **balamut** » 2011-12-02 23:53:32

поправить до такого состояния?

Код: Выделить всё

SELECT `username` FROM `mailbox` WHERE `username` = '${quote_mysql:$2}' AND `password` = '${quote_mysql:$3}'

forum.lissyara.su

Медленно отправляються письма!

Медленно отправляються письма!

Услуги хостинговой компании Host-Food.ru

Re: Медленно отправляються письма!

Re: Медленно отправляються письма!

Re: Медленно отправляються письма!

Re: Медленно отправляються письма!

Re: Медленно отправляються письма!

Re: Медленно отправляються письма!

Re: Медленно отправляються письма!

Re: Медленно отправляються письма!

Re: Медленно отправляються письма!

Re: Медленно отправляються письма!

Re: Медленно отправляються письма!