LINUX.ORG.RU
ФорумAdmin

ошибка регистрации в exim с postgresql...


0

1

Помогите решить проблему. Есть сервер с freebsd на нём стоит exim, pgsql и courier-imap.
Всё вроде настроил правильно, но при попытке зарегистрироваться например с outlook'а происходит ошибка при прохождении теста «Вход на сервер входящей почты (IMAP): Ошибка при подключении к серверу. Отправка тестового электронного сообщения: Отклик сервера: 451 Temporary local problem - plea».
В /var/log/exim/paniclog находятся следующие запии:

failed to expand "$ {lookup pgsql{SELECT domain FROM local_domain}}" while checking a list: $ not followed by letter, digit, or {

Запросы sql смотрел все внорме вроде. Помогите с проблемой!

Ответ на: комментарий от bass

Исправил данные ошибки, теперь в логе /var/log/exim/paniclog всё тихо.
Но подключиться всё равно не получается вот что пишет outlook:

Вход на сервер входящей почты (IMAP): Ошибка при подключении к серверу. Отправка тестового электронного сообщения: Сервер исходящей почты (SMTP) обнаружил внутреннюю ошибку. Если вы продолжаете получать это сообщение, обратитесь к администратору сервера или поставщику услуг Интернета.  Отклик сервера: 451 Temporary local problem - please try later

А вот в логах /var/log/exim/mainlog:
2013-12-22 14:21:28 no host name found for IP address 192.168.0.2
2013-12-22 14:21:28 1VudLs-0000Kv-Hj H=(undertaketpc) [192.168.0.2] F=<aida@aida.net.ru> A=login:aida@aida.net.ru temporarily rejected during MIME ACL $

И /var/log/exim/rejectlog:
2013-12-22 14:21:28 1VudLs-0000Kv-Hj H=(undertaketpc) [192.168.0.2] F=<aida@aida.net.ru> A=login:aida@aida.net.ru temporarily rejected during MIME ACL $
Envelope-from: <"aida@aida.net.ru"@mail.aida.net.ru>
Envelope-to: <aida@aida.net.ru>
P Received: from [192.168.0.2] (helo=undertaketpc)
        by mail.aida.net.ru with esmtpa (Exim 4.80.1 (FreeBSD))
        (envelope-from <"aida@aida.net.ru"@mail.aida.net.ru>)
        id 1VudLs-0000Kv-Hj
        for aida@aida.net.ru; Sun, 22 Dec 2013 14:21:28 +0700
F From: Microsoft Office Outlook <aida@aida.net.ru>
T To: =?utf-8?B?YWlkYQ==?= <aida@aida.net.ru>
  Subject: =?utf-8?B?0KLQtdGB0YLQvtCy0L7QtSDRgdC+0L7QsdGJ0LXQvdC40LUgTWljcm9zb2Z0IE9mZmljZSBPdXRsb29r?=
  MIME-Version: 1.0
  Content-Type: text/html;
    charset="utf-8"
  Content-Transfer-Encoding: 8bit
I Message-Id: <E1VudLs-0000Kv-Hj@mail.aida.net.ru>
S Sender: "aida@aida.net.ru"@mail.aida.net.ru
  Date: Sun, 22 Dec 2013 14:21:28 +0700

UnderTaket
() автор топика
Ответ на: комментарий от UnderTaket

не является.

используй дебаг чтобы найти ошибку. полный дебаг так:

exim -bd -d +all

для удобства быстрой проверки можно и скриптом:

(echo "EHLO mxs.mail.ru"; echo "MAIL FROM: tester@mail.ru"; \
echo "RCPT TO: UnderTaket@yuordomain.com"; \
echo "DATA"; echo "Subject: test"; echo "."; echo "QUIT";) \
| exim -d -bhc 94.100.176.20 > testlog 2>&1

все проверки идут по порядку, смотри где споткнулся и ищи там ошибку

bass ★★★★★
()
Ответ на: комментарий от bass
Exim version 4.80.1 (FreeBSD 8.4) uid=0 gid=0 pid=87433 D=fbb95cfd
Probably Berkeley DB version 1.8x (native mode)
Support for: crypteq iconv() IPv6 use_setclassresources PAM Expand_dlfunc OpenSSL Content_Scanning DKIM Old_Demime
Lookups (built-in): lsearch wildlsearch nwildlsearch iplsearch cdb dbm dbmjz dbmnz dnsdb dsearch nis nis0 passwd pgsql
Authenticators: cram_md5 plaintext spa
Routers: accept dnslookup ipliteral manualroute queryprogram redirect
Transports: appendfile/maildir/mailstore/mbx autoreply lmtp pipe smtp
Fixed never_users: 0
Size of off_t: 8
Compiler: GCC [4.2.1 20070831 patched [FreeBSD]]
Library version: OpenSSL: Compile: OpenSSL 0.9.8y 5 Feb 2013
                          Runtime: OpenSSL 0.9.8y 5 Feb 2013
Library version: PCRE: Compile: 8.32
                       Runtime: 8.32 2012-11-30
Total 14 lookups
WHITELIST_D_MACROS unset
TRUSTED_CONFIG_LIST unset
changed uid/gid: forcing real = effective
  uid=0 gid=0 pid=87433
  auxiliary group list: 0
seeking password data for user "mailnull": using cached result
getpwnam() succeeded uid=26 gid=26
seeking password data for user "root": cache not available
getpwnam() succeeded uid=0 gid=0
changed uid/gid: calling tls_validate_require_cipher
  uid=26 gid=26 pid=87434
  auxiliary group list: 26
tls_validate_require_cipher child 87434 ended: status=0x0
configuration file is /usr/local/etc/exim/configure
log selectors = 00000ffc 00212001
cwd=/root 4 args: exim -d -d +all
trusted user
admin user
changed uid/gid: privilege not needed
  uid=26 gid=26 pid=87433
  auxiliary group list: 26
seeking password data for user "mailnull": cache not available
getpwnam() succeeded uid=26 gid=26
seeking password data for user "26": cache not available
originator: uid=0 gid=0 login=root name=Charlie Root
sender address = root@mail.aida.net.ru
set_process_info: 87433 accepting a local non-SMTP message from <root@mail.aida.net.ru>
Sender: root@mail.aida.net.ru
Recipients:
  +all
search_tidyup called

>>Headers received:

rewrite_one_header: type=F:
  From: Charlie Root <root@mail.aida.net.ru>
search_tidyup called
>>Headers after rewriting and local additions:
I Message-Id: <E1VujCM-000MkD-Rr@mail.aida.net.ru>
F From: Charlie Root <root@mail.aida.net.ru>
  Date: Sun, 22 Dec 2013 20:36:09 +0700

а вот тут процесс останавливается пока принудительно его не завершишь! Вот что после завершения пишет.

exim: SIGINT received - message abandoned
LOG: MAIN
  SIGINT received while reading local message
search_tidyup called
>>>>>>>>>>>>>>>> Exim pid=87433 terminating with rc=1 >>>>>>>>>>>>>>>>
Не смог найти ошибку...

UnderTaket
() автор топика
Ответ на: комментарий от UnderTaket

ты запустил exim в debug, но делаешь локальную отправку/доставку, которой демон вообщем-то и ненужен, естественно уровень логгирования минимальный.

bass ★★★★★
()
Ответ на: комментарий от UnderTaket

регистрация по imap
в конфиге imapd courier-imap

bass ★★★★★
()
Ответ на: комментарий от bass

Вот лог скрипта:

Exim version 4.80.1 (FreeBSD 8.4) uid=0 gid=0 pid=810 D=fbb95cfd
Probably Berkeley DB version 1.8x (native mode)
Support for: crypteq iconv() IPv6 use_setclassresources PAM Expand_dlfunc OpenSSL Content_Scanning DKIM Old_Demime
Lookups (built-in): lsearch wildlsearch nwildlsearch iplsearch cdb dbm dbmjz dbmnz dnsdb dsearch nis nis0 passwd pgsql
Authenticators: cram_md5 plaintext spa
Routers: accept dnslookup ipliteral manualroute queryprogram redirect
Transports: appendfile/maildir/mailstore/mbx autoreply lmtp pipe smtp
Fixed never_users: 0
Size of off_t: 8
Compiler: GCC [4.2.1 20070831 patched [FreeBSD]]
Library version: OpenSSL: Compile: OpenSSL 0.9.8y 5 Feb 2013
                          Runtime: OpenSSL 0.9.8y 5 Feb 2013
Library version: PCRE: Compile: 8.32
                       Runtime: 8.32 2012-11-30
Total 14 lookups
WHITELIST_D_MACROS unset
TRUSTED_CONFIG_LIST unset
changed uid/gid: forcing real = effective
  uid=0 gid=0 pid=810
  auxiliary group list: 0
seeking password data for user "mailnull": using cached result
getpwnam() succeeded uid=26 gid=26
seeking password data for user "root": cache not available
getpwnam() succeeded uid=0 gid=0
changed uid/gid: calling tls_validate_require_cipher
  uid=26 gid=26 pid=811
  auxiliary group list: 26
tls_validate_require_cipher child 811 ended: status=0x0
configuration file is /usr/local/etc/exim/configure
log selectors = 00000ffc 00212001
trusted user
admin user
changed uid/gid: privilege not needed
  uid=26 gid=26 pid=810
  auxiliary group list: 26
seeking password data for user "mailnull": cache not available
getpwnam() succeeded uid=26 gid=26
seeking password data for user "26": cache not available
originator: uid=0 gid=0 login=root name=Charlie Root
sender address = root@mail.aida.net.ru
sender_fullhost = [94.100.176.20]
sender_rcvhost = [94.100.176.20]
host in hosts_connection_nolog? no (option unset)
LOG: smtp_connection MAIN
  SMTP connection from [94.100.176.20]
host in host_lookup? yes (matched "*")
looking up host name for 94.100.176.20
DNS lookup of 20.176.100.94.in-addr.arpa (PTR) succeeded
IP address lookup yielded mxs.mail.ru
gethostbyname2(af=inet6) returned 4 (NO_DATA)
gethostbyname2 looked up these IP addresses:
  name=mxs.mail.ru address=94.100.176.20
checking addresses for mxs.mail.ru
  94.100.176.20 OK
sender_fullhost = mxs.mail.ru [94.100.176.20]
sender_rcvhost = mxs.mail.ru ([94.100.176.20])
set_process_info:   810 handling incoming connection from mxs.mail.ru [94.100.176.20]
host in host_reject_connection? no (option unset)
host in sender_unqualified_hosts? no (option unset)
host in recipient_unqualified_hosts? no (option unset)
host in helo_verify_hosts? no (option unset)
host in helo_try_verify_hosts? no (option unset)
host in helo_accept_junk_hosts? no (option unset)
SMTP>> 220 mail.aida.net.ru ESMTP Exim 4.80.1 Sun, 22 Dec 2013 21:26:14 +0700
smtp_setup_msg entered

**** SMTP testing session as if from host 94.100.176.20
**** but without any ident (RFC 1413) callback.
**** This is not for real!

220 mail.aida.net.ru ESMTP Exim 4.80.1 Sun, 22 Dec 2013 21:26:14 +0700
SMTP<< EHLO mxs.mail.ru
sender_fullhost = mxs.mail.ru [94.100.176.20]
sender_rcvhost = mxs.mail.ru ([94.100.176.20])
set_process_info:   810 handling incoming connection from mxs.mail.ru [94.100.176.20]
host in pipelining_advertise_hosts? yes (matched "*")
host in auth_advertise_hosts? yes (matched "*")
host in tls_advertise_hosts? yes (matched "*")
SMTP>> 250-mail.aida.net.ru Hello mxs.mail.ru [94.100.176.20]
250-SIZE 20971520
250-8BITMIME
250-PIPELINING
250-AUTH CRAM-MD5 LOGIN
250-STARTTLS
250 HELP
SMTP<< MAIL FROM: tested@mail.ru
SMTP>> 250 OK
SMTP<< RCPT TO: aida@aida.net.ru
using ACL "acl_check_rcpt"
processing "accept"
check hosts = :
host in ":"? no (end of list)
accept: condition test failed in ACL "acl_check_rcpt"
processing "deny"
check domains = +local_domains
search_open: pgsql "NULL"
search_find: file="NULL"
  key="SELECT domain FROM local_domain" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
  type=pgsql key="SELECT domain FROM local_domain"
database lookup required for SELECT domain FROM local_domain
PostgreSQL query: SELECT domain FROM local_domain
PGSQL new connection: host=localhost port= database=mail user=pgsql
lookup yielded: aida.net.ru
aida.net.ru in "aida.net.ru"? yes (matched "aida.net.ru")
aida.net.ru in "+local_domains"? yes (matched "+local_domains")
check local_parts = ^[.] : ^.*[@%!/|]
aida in "^[.] : ^.*[@%!/|]"? no (end of list)
deny: condition test failed in ACL "acl_check_rcpt"
processing "accept"
check domains = +local_domains
search_open: pgsql "NULL"
  cached open
search_find: file="NULL"
  key="SELECT domain FROM local_domain" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
  type=pgsql key="SELECT domain FROM local_domain"
cached data used for lookup of SELECT domain FROM local_domain
lookup yielded: aida.net.ru
aida.net.ru in "aida.net.ru"? yes (matched "aida.net.ru")
aida.net.ru in "+local_domains"? yes (matched "+local_domains")
accept: condition test succeeded in ACL "acl_check_rcpt"
SMTP>> 250 Accepted
SMTP<< DATA
SMTP>> 354 Enter message, ending with "." on a line by itself
search_tidyup called
close PGSQL connection: localhost/mail/pgsql
host in ignore_fromline_hosts? no (option unset)
>>Headers received:
Subject: test

search_tidyup called
>>Headers after rewriting and local additions:
  Subject: test

Data file written for message 1Vujyw-0000D4-1b
>>Generated Received: header line
P Received: from mxs.mail.ru ([94.100.176.20])
        by mail.aida.net.ru with esmtp (Exim 4.80.1 (FreeBSD))
        (envelope-from <tested@mail.ru>)
        id 1Vujyw-0000D4-1b
        for aida@aida.net.ru; Sun, 22 Dec 2013 21:26:14 +0700
PDKIM <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
No Content-Type: header - presumably not a MIME message.
SMTP>> 451 Temporary local problem - please try later
LOG: MAIN REJECT
  H=mxs.mail.ru [94.100.176.20] F=<tested@mail.ru> temporarily rejected after DATA: unknown ACL verb "acl_check_virus" in "acl_check_virus"
smtp_setup_msg entered
SMTP<< QUIT
SMTP>> 221 mail.aida.net.ru closing connection
LOG: smtp_connection MAIN
  SMTP connection from mxs.mail.ru [94.100.176.20] closed by QUIT
search_tidyup called
>>>>>>>>>>>>>>>> Exim pid=810 terminating with rc=0 >>>>>>>>>>>>>>>>
250-mail.aida.net.ru Hello mxs.mail.ru [94.100.176.20]
250-SIZE 20971520
250-8BITMIME
250-PIPELINING
250-AUTH CRAM-MD5 LOGIN
250-STARTTLS
250 HELP
250 OK
250 Accepted
354 Enter message, ending with "." on a line by itself
451 Temporary local problem - please try later
221 mail.aida.net.ru closing connection

UnderTaket
() автор топика
Ответ на: комментарий от UnderTaket

PDKIM <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
No Content-Type: header - presumably not a MIME message.

читать что-это и исправлять.

bass ★★★★★
()
Вы не можете добавлять комментарии в эту тему. Тема перемещена в архив.