exim+dovecot. трабла с smtp auth

[Sash]

поднял мыло по этой статье
http://www.lissyara.su/?id=1173
всё запустилось, всё ходит во все стороны, НО
если использовать outlook или thebat для ОТПРАВКИ почты, то оба этих клиенты не авторизуются по smtp
при добавление ИПа клиента(т.е. ИП моего компа, то всё ходит)
косяк в том, что это не сервер в локалке, а почтой будет пользоваться народ из инета и такая аутенфикация необходима.

логи от thebat

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

Jul 16 12:10:53 server dovecot: auth-worker(default): mysql: Connected to localhost (exim)
Jul 16 12:10:53 server dovecot: pop3-login: Login: user=<sash@<real_domane.ru>>, method=PLAIN, rip=193.*.*.*, lip=81.*.*.*
Jul 16 12:10:53 server dovecot: POP3(sash@<real_domane.ru>): Disconnected: Logged out top=0/0, retr=0/0, del=0/3, size=24353
Jul 16 12:10:56 server exim[39385]: no IP address found for host 195.*.*.*.ru (during SMTP connection from (YAKUPOV) [193.*.*.*]
I=[81.177.25.18]:25)
Jul 16 12:10:56 server exim[39385]: Delay 10s for  [193.*.*.*] with HELO=YAKUPOV. Mail from sash@<real_domane.ru> to sash@<another_real_domane.ru>.
Jul 16 12:10:56 server dovecot: pop3-login: Login: user=<sash@<real_domane.ru>>, method=PLAIN, rip=193.*.*.*, lip=81.*.*.*
Jul 16 12:10:56 server dovecot: POP3(sash@<real_domane.ru>): Disconnected: Logged out top=0/0, retr=0/0, del=0/3, size=24353
Jul 16 12:11:06 server exim[39385]: H=(YAKUPOV) [193.*.*.*] I=[81.*.*.*]:25 F=<sash@<real_domane.ru>> rejected RCPT <sash@<another_real_domane.ru>>: "Homo hominus
 lupus est"

логи от outlook

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

Jul 16 12:11:54 server exim[39407]: auth_login authenticator failed for (yakupov) [193.*.*.*] I=[81.*.*.*]:25: 535 Incorrect authentication data (s
et_id=sash@<real_domane.ru>)
Jul 16 12:11:56 server dovecot: pop3-login: Login: user=<sash@<real_domane.ru>>, method=PLAIN, rip=193.*.*.*, lip=81.*.*.*Jul 16 12:11:56 rver dovecot: POP3(sash@labintech.net): Disconnected: Logged out top=0/0, retr=0/0, del=0/3, size=24353
Jul 16 12:11:56 server exim[39410]: auth_login authenticator failed for (yakupov) [193.*.*.*] I=[81.*.*.*]:25: 535 Incorrect authentication data (s
et_id=sash@<real_domane.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/

[Alex Keda]

показывай аутентификаторы...

[Sash]

они все стандартные, всё взял из предложенного конфига в статье

dovecot.conf

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

auth default {
  # Список требуемых механизмов аутентификации, разделённый пробелами
  #   plain login digest-md5 cram-md5 ntlm rpa apop anonymous gssapi
  mechanisms = plain

   # Добавлено для работы deliver от dovecot
   socket listen {
     master {
       path = /var/run/dovecot/auth-master
       mode = 0600
       user = mailnull
       #group = mail
     }
   }

eximt configure

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

 Секция авторизации при отправке писем. Ввиду того,
# что почтовых клиентов много, и все всё делают
# по-своему, то и механизмов авторизации три...
begin authenticators

# А вот по какому методу авторизуется оутглюк - я уже и
# не помню... Хотя в своё время долго ковырялся,
# пока настроил... Толь plain, толь login...
auth_plain:
  driver = plaintext
  public_name = PLAIN
  server_condition = ${lookup mysql{SELECT `username` FROM \
                     `mailbox` WHERE `username` = \
                     '${quote_mysql:$auth2}' AND `password` = \
                     '${quote_mysql:$auth3}'}{yes}{no}}
  server_prompts = :
  server_set_id = $auth2

# Вроде по этому оутглюк, а по предыдущему нетскейп.
auth_login:
  driver = plaintext
  public_name = LOGIN
  server_condition = ${lookup mysql{SELECT `username` FROM \
                     `mailbox` WHERE `username` = \
                     '${quote_mysql:$auth1}' AND `password` = \
                     '${quote_mysql:$auth2}'}{yes}{no}}
  server_prompts = Username:: : Password::
  server_set_id = $auth1

# А так авторизуется "Летучая Мышь" - TheBat!
auth_cram_md5:
  driver = cram_md5
  public_name = CRAM-MD5
  server_secret = ${lookup mysql{SELECT `password` FROM \
                        `mailbox` WHERE `username` \
                        = '${quote_mysql:$auth1}'}{$value}fail}
  server_set_id = $auth2

[Alex Keda]

чё-то влёт ошибок невижу...
попробуй с отладкой запустить exim в скрипте, а потом дёрни оттуда кусок про аутентификацию и выложи (пароли не забудь убрать...)

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

cd /tmp
script
/usr/local/etc/rc.d/exim.sh stop
exim -bd -d

[Alex Keda]

имеется ввиду - потом, после попытки отправки клиентом

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

Ctrl+C
exit 

и в файле typescript ищешь момент аутентификации клиента - оно и инетерсует

[Sash]

вот все что касается thebat

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

[root@server /tmp]# cat typescript
Script started on Mon Jul 16 12:50:21 2007
[root@server /tmp]# /usr/local/etc/rc.d/exim stop
Stopping exim.
[root@server /tmp]# exim -bd -d
Exim version 4.67 (FreeBSD 6.2) uid=0 gid=0 pid=39707 D=fbb95cfd
Probably Berkeley DB version 1.8x (native mode)
Support for: crypteq iconv() use_setclassresources PAM Perl Expand_dlfunc OpenSSL Content_Scanning Old_Demime
Lookups: lsearch wildlsearch nwildlsearch iplsearch cdb dbm dbmnz dnsdb dsearch mysql nis nis0 passwd
Authenticators: cram_md5 dovecot 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
changed uid/gid: forcing real = effective
  uid=0 gid=0 pid=39707
  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
configuration file is /usr/local/etc/exim/configure
log selectors = 0000cefe 00233821
cwd=/tmp 3 args: exim -bd -d
trusted user
admin user
seeking password data for user "mailnull": cache not available
getpwnam() succeeded uid=26 gid=26
originator: uid=0 gid=0 login=root name=Charlie Root
39707 listening on all interfaces (IPv4) port 25
39707 pid written to /var/run/exim.pid
39707 changed uid/gid: running as a daemon
39707   uid=26 gid=6 pid=39707
39707   auxiliary group list: 6 6
39707 LOG: MAIN
39707   exim 4.67 daemon started: pid=39707, no queue runs, listening for SMTP on port 25 (IPv4)
39707 set_process_info: 39707 daemon: no queue runs, listening for SMTP on port 25 (IPv4)
39707 daemon running with uid=26 gid=6 euid=26 egid=6
39707 Listening...
39707 Connection request from 193.*.*.* port 7722
39707 search_tidyup called
39707 1 SMTP accept process running
39707 Listening...
39711 sender_fullhost = [193.*.*.*]
39711 sender_rcvhost = [193.*.*.*]
39711 Process 39711 is handling incoming connection from [193.*.*.*]
39711 checking for IP options
39711 no IP options found
39711 host in host_lookup? no (option unset)
39711 set_process_info: 39711 handling incoming connection from [193.*.*.*] I=[81.*.*.*]:25
39711 host in host_reject_connection? no (option unset)
39711 gethostbyname looked up these IP addresses:
39711   name=localhost.inet address=127.0.0.1
39711 host in "localhost:127.0.0.0/8:192.168.0.0/16"? no (end of list)
39711 host in sender_unqualified_hosts? no (end of list)
39711 cached no match for +relay_from_hosts
39711 host in recipient_unqualified_hosts? no (end of list)
39711 host in helo_verify_hosts? no (option unset)
39711 host in helo_try_verify_hosts? no (option unset)
39711 host in helo_accept_junk_hosts? no (end of list)
39711 SMTP>> 220 mail.<real_domane.ru>, ESMTP EXIM 4.67
39711 Process 39711 is ready for new message
39711 smtp_setup_msg entered
39711 SMTP<< EHLO YAKUPOV
39711 YAKUPOV in helo_lookup_domains? no (end of list)
39711 sender_fullhost = (YAKUPOV) [193.*.*.*]
39711 sender_rcvhost = [193.*.*.*] (helo=YAKUPOV)
39711 set_process_info: 39711 handling incoming connection from (YAKUPOV) [193.*.*.*] I=[81.*.*.*]:25
39711 host in pipelining_advertise_hosts? yes (matched "*")
39711 host in auth_advertise_hosts? yes (matched "*")
39711 host in tls_advertise_hosts? no (option unset)
39711 SMTP>> 250-mail.<real_domane.ru> Hello YAKUPOV [193.*.*.*]
39711 250-SIZE 67108864
39711 250-PIPELINING
39711 250-AUTH PLAIN LOGIN CRAM-MD5
39711 250 HELP
39711 SMTP<< MAIL FROM:<sash@<real_domane.ru>> SIZE=1314
39711 spool directory space = 4375282K inodes = 639902 check_space = 0K inodes = 0 msg_size = 6314
39711 SMTP>> 250 OK
39711 SMTP<< RCPT TO:<x-menchik@mail.ru>
39711 using ACL "acl_check_rcpt"
39711 processing "accept"
39711 check hosts = :
39711 host in ":"? no (end of list)
39711 accept: condition test failed
39711 processing "deny"
39711 check domains = +local_domains
39711 search_open: mysql "NULL"
39711 search_find: file="NULL"
39711   key="SELECT `domain` FROM `domain` WHERE `domain`='mail.ru' AND `active`='1'" partial=-1 affix=NULL starflags=0
39711 LRU list:
39711 internal_search_find: file="NULL"
39711   type=mysql key="SELECT `domain` FROM `domain` WHERE `domain`='mail.ru' AND `active`='1'"
39711 database lookup required for SELECT `domain` FROM `domain` WHERE `domain`='mail.ru' AND `active`='1'
39711 MYSQL query: SELECT `domain` FROM `domain` WHERE `domain`='mail.ru' AND `active`='1'
39711 MYSQL new connection: host=localhost port=0 socket=NULL database=exim user=exim
39711 MYSQL: no data found
39711 lookup failed
39711 mail.ru in ""? no (end of list)
39711 mail.ru in "+local_domains"? no (end of list)
39711 deny: condition test failed
39711 processing "deny"
39711 check domains = !+local_domains
39711 search_open: mysql "NULL"
39711   cached open
39711 search_find: file="NULL"
39711   key="SELECT `domain` FROM `domain` WHERE `domain`='mail.ru' AND `active`='1'" partial=-1 affix=NULL starflags=0
39711 LRU list:
39711 internal_search_find: file="NULL"
39711   type=mysql key="SELECT `domain` FROM `domain` WHERE `domain`='mail.ru' AND `active`='1'"
39711 cached data used for lookup of SELECT `domain` FROM `domain` WHERE `domain`='mail.ru' AND `active`='1'
39711 lookup failed
39711 mail.ru in ""? no (end of list)
39711 mail.ru in "!+local_domains"? yes (end of list)
39711 check local_parts = ^[./|] : ^.*[@%!] : ^.*/\\.\\./
39711 x-menchik in "^[./|] : ^.*[@%!] : ^.*/\.\./"? no (end of list)
39711 deny: condition test failed
39711 processing "accept"
39711 check local_parts = postmaster
39711 x-menchik in "postmaster"? no (end of list)
39711 accept: condition test failed
39711 processing "deny"
39711 check condition = ${if eq{$sender_helo_name}{}{yes}{no}}
39711                 = no
39711 deny: condition test failed
39711 processing "accept"
39711 check authenticated = *
39711 accept: condition test failed
39711 processing "deny"
39711 check hosts = * : !+relay_from_hosts : !81-196.lissyara.su
39711 host in "* : !+relay_from_hosts : !81-196.lissyara.su"? yes (matched "*")
39711 check condition = ${if eq{$sender_helo_name}{$sender_host_address}{true}{false}}
39711                 = false
39711 deny: condition test failed
39711 processing "deny"
39711 check condition = ${if eq{$sender_helo_name}{$interface_address}{yes}{no}}
39711                 = no
39711 deny: condition test failed
39711 processing "deny"
39711 check condition = ${if match{$sender_helo_name}{\N^\d+$\N}{yes}{no}}
39711                 = no
39711 deny: condition test failed
39711 processing "deny"
39711 looking up host name for 193.*.*.*
39711 DNS lookup of 195.*.*.*.in-addr.arpa (PTR) succeeded
39711 IP address lookup yielded 195.*.*.*.ru
39711 gethostbyname returned 1 (HOST_NOT_FOUND)
39711 no IP address found for host 195.*.*.*.ru (during SMTP connection from (YAKUPOV) [193.*.*.*] I=[81.*.*.*]:25)
39711 LOG: host_lookup_failed MAIN
39711   no IP address found for host 195.*.*.*.ru (during SMTP connection from (YAKUPOV) [193.*.*.*] I=[81.*.*.*]:25)
39711 no IP addresses found for 195.*.*.*.ru
39711 193.*.*. does not match any IP address for 195.*.*.*.ru
39711 check condition = ${if match{$sender_host_name} {adsl|dialup|pool|peer|dhcp} {yes}{no}}
39711                 = no
39711 deny: condition test failed
39711 processing "warn"
39711 check set acl_m0 = 10s
39711 warn: condition test succeeded
39711 processing "warn"
39711 check hosts = +relay_from_hosts:213.234.195.224/28:80.253.9.18/32
39711 cached no match for +relay_from_hosts
39711 cached lookup data = NULL
39711 host in "+relay_from_hosts:213.234.195.224/28:80.253.9.18/32"? no (end of list)
39711 warn: condition test failed
39711 processing "warn"
39711 check logwrite = Delay $acl_m0 for $sender_host_name [$sender_host_address] with HELO=$sender_helo_name. Mail from $sender_address to $local_part@$domain.
39711                = Delay 10s for  [193.*.*.*] with HELO=YAKUPOV. Mail from sash@<real_domane.ru> to sash@<another_real_domane.ru>.
39711 LOG: MAIN
39711   Delay 10s for  [193.*.*.*] with HELO=YAKUPOV. Mail from sash@<real_domane.ru> to sash@<another_real_domane.ru>.
39711 check delay = $acl_m0
39711             = 10s
39711 delay modifier requests 10-second delay
39711 warn: condition test succeeded
39711 processing "accept"
39711 check domains = +local_domains
39711 search_open: mysql "NULL"
39711   cached open
39711 search_find: file="NULL"
39711   key="SELECT `domain` FROM `domain` WHERE `domain`='mail.ru' AND `active`='1'" partial=-1 affix=NULL starflags=0
39711 LRU list:
39711 internal_search_find: file="NULL"
39711   type=mysql key="SELECT `domain` FROM `domain` WHERE `domain`='mail.ru' AND `active`='1'"
39711 cached data used for lookup of SELECT `domain` FROM `domain` WHERE `domain`='mail.ru' AND `active`='1'
39711 lookup failed
39711 mail.ru in ""? no (end of list)
39711 mail.ru in "+local_domains"? no (end of list)
39711 accept: condition test failed
39711 processing "accept"
39711 check domains = +relay_to_domains
39711 search_open: mysql "NULL"
39711   cached open
39711 search_find: file="NULL"
39711   key="SELECT `domain` FROM `domain` WHERE `domain`='mail.ru' AND `active`='1'" partial=-1 affix=NULL starflags=0
39711 LRU list:
39711 internal_search_find: file="NULL"
39711   type=mysql key="SELECT `domain` FROM `domain` WHERE `domain`='mail.ru' AND `active`='1'"
39711 cached data used for lookup of SELECT `domain` FROM `domain` WHERE `domain`='mail.ru' AND `active`='1'
39711 lookup failed
39711 mail.ru in ""? no (end of list)
39711 mail.ru in "+relay_to_domains"? no (end of list)
39711 accept: condition test failed
39711 processing "accept"
39711 check hosts = +relay_from_hosts
39711 cached no match for +relay_from_hosts
39711 cached lookup data = NULL
39711 host in "+relay_from_hosts"? no (end of list)
39711 accept: condition test failed
39711 processing "deny"
39711 deny: condition test succeeded
39711 SMTP>> 550 "Homo hominus lupus est"
39711 LOG: MAIN REJECT
39711   H=(YAKUPOV) [193.*.*.*] I=[81.*.*.*]:25 F=<sash@<real_domane.ru>> rejected RCPT <sash@<anoter_real_domane.ru>>: "Homo hominus lupus est"
39711 SMTP<< RSET
39711 SMTP>> 250 Reset OK
39711 SMTP<< RSET
39711 host in smtp_accept_max_nonmail_hosts? yes (matched "*")
39711 SMTP>> 250 Reset OK
39711 SMTP<< QUIT
39711 SMTP>> 221 mail.<real_domane.ru> closing connection
39711 LOG: smtp_connection MAIN
39711   SMTP connection from (YAKUPOV) [193.*.*.*] I=[81.*.*.*]:25 closed by QUIT
39711 search_tidyup called
39711 close MYSQL connection: localhost/exim/exim
39707 child 39711 ended: status=0x0
39707 0 SMTP accept processes now running
39707 Listening...
^C
[root@server /tmp]# exit
exit

Script done on Mon Jul 16 12:53:03 2007
[root@server /tmp]#

[Alex Keda]

всё хорошо, тока я не вижу попыток аутентификации
так что рой клиентскую программу

[Sash]

вот outlook

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

Script started on Mon Jul 16 13:05:29 2007
[root@server /tmp]# exit[root@server /tmp]# [18Pexim -bd -d
Exim version 4.67 (FreeBSD 6.2) uid=0 gid=0 pid=39761 D=fbb95cfd
Probably Berkeley DB version 1.8x (native mode)
Support for: crypteq iconv() use_setclassresources PAM Perl Expand_dlfunc OpenSSL Content_Scanning Old_Demime
Lookups: lsearch wildlsearch nwildlsearch iplsearch cdb dbm dbmnz dnsdb dsearch mysql nis nis0 passwd
Authenticators: cram_md5 dovecot 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
changed uid/gid: forcing real = effective
  uid=0 gid=0 pid=39761
  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
configuration file is /usr/local/etc/exim/configure
log selectors = 0000cefe 00233821
cwd=/tmp 3 args: exim -bd -d
trusted user
admin user
seeking password data for user "mailnull": cache not available
getpwnam() succeeded uid=26 gid=26
originator: uid=0 gid=0 login=root name=Charlie Root
39761 listening on all interfaces (IPv4) port 25
39761 pid written to /var/run/exim.pid
39761 changed uid/gid: running as a daemon
39761   uid=26 gid=6 pid=39761
39761   auxiliary group list: 6 6
39761 LOG: MAIN
39761   exim 4.67 daemon started: pid=39761, no queue runs, listening for SMTP on port 25 (IPv4)
39761 set_process_info: 39761 daemon: no queue runs, listening for SMTP on port 25 (IPv4)
39761 daemon running with uid=26 gid=6 euid=26 egid=6
39761 Listening...
39761 Connection request from 193.*.*.* port 7927
39761 search_tidyup called
39761 1 SMTP accept process running
39761 Listening...
39762 sender_fullhost = [193.*.*.*]
39762 sender_rcvhost = [193.*.*.*]
39762 Process 39762 is handling incoming connection from [193.*.*.*]
39762 checking for IP options
39762 no IP options found
39762 host in host_lookup? no (option unset)
39762 set_process_info: 39762 handling incoming connection from [193.*.*.*] I=[81.*.*.*]:25
39762 host in host_reject_connection? no (option unset)
39762 gethostbyname looked up these IP addresses:
39762   name=localhost.inet address=127.0.0.1
39762 host in "localhost:127.0.0.0/8:192.168.0.0/16"? no (end of list)
39762 host in sender_unqualified_hosts? no (end of list)
39762 cached no match for +relay_from_hosts
39762 host in recipient_unqualified_hosts? no (end of list)
39762 host in helo_verify_hosts? no (option unset)
39762 host in helo_try_verify_hosts? no (option unset)
39762 host in helo_accept_junk_hosts? no (end of list)
39762 SMTP>> 220 mail.<real_domane.ru>, ESMTP EXIM 4.67
39762 Process 39762 is ready for new message
39762 smtp_setup_msg entered
39762 SMTP<< EHLO yakupov
39762 yakupov in helo_lookup_domains? no (end of list)
39762 sender_fullhost = (yakupov) [193.*.*.*]
39762 sender_rcvhost = [193.*.*.*] (helo=yakupov)
39762 set_process_info: 39762 handling incoming connection from (yakupov) [193.*.*.*] I=[81.*.*.*]:25
39762 host in pipelining_advertise_hosts? yes (matched "*")
39762 host in auth_advertise_hosts? yes (matched "*")
39762 host in tls_advertise_hosts? no (option unset)
39762 SMTP>> 250-mail.<real_domane.ru> Hello yakupov [193.*.*.*]
39762 250-SIZE 67108864
39762 250-PIPELINING
39762 250-AUTH PLAIN LOGIN CRAM-MD5
39762 250 HELP
39762 SMTP<< AUTH LOGIN
39762 SMTP>> 334 VXNlcm5hbWU6
39762 SMTP<< c2FzaEBsYWJpbnRlY2gubmV0
39762 SMTP>> 334 UGFzc3dvcmQ6
39762 SMTP<< c2FzaA==
39762 auth_login authenticator:
39762   $auth1 = sash@<real_domane.ru>
39762   $auth2 = sash
39762   $1 = sash@<real_domane.ru>
39762   $2 = sash
39762 search_open: mysql "NULL"
39762 search_find: file="NULL"
39762   key="SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'" partial=-1 affix=NULL starflags=0
39762 LRU list:
39762 internal_search_find: file="NULL"
39762   type=mysql key="SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'"
39762 database lookup required for SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'
39762 MYSQL query: SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'
39762 MYSQL new connection: host=localhost port=0 socket=NULL database=exim user=exim
39762 MYSQL: no data found
39762 lookup failed
39762 expanded string: no
39762 SMTP>> 535 Incorrect authentication data
39762 LOG: MAIN REJECT
39762   auth_login authenticator failed for (yakupov) [193.*.*.*] I=[81.*.*.*]:25: 535 Incorrect authentication data (set_id=sash@<real_domane.ru>)
39762 SMTP>> 421 mail.<real_domane.ru> lost input connection
39762 LOG: smtp_connection MAIN
39762   SMTP connection from (yakupov) [193.*.*.*] I=[81.*.*.*]:25 lost
39762 search_tidyup called
39762 close MYSQL connection: localhost/exim/exim
39761 child 39762 ended: status=0x100
39761 0 SMTP accept processes now running
39761 Listening...
39761 Connection request from 193.*.*.* port 7928
39761 search_tidyup called
39761 1 SMTP accept process running
39761 Listening...
39763 sender_fullhost = [193.*.*.*]
39763 sender_rcvhost = [193.*.*.*]
39763 Process 39763 is handling incoming connection from [193.*.*.*]
39763 checking for IP options
39763 no IP options found
39763 host in host_lookup? no (option unset)
39763 set_process_info: 39763 handling incoming connection from [193.*.*.*] I=[81.*.*.*]:25
39763 host in host_reject_connection? no (option unset)
39763 gethostbyname looked up these IP addresses:
39763   name=localhost.inet address=127.0.0.1
39763 host in "localhost:127.0.0.0/8:192.168.0.0/16"? no (end of list)
39763 host in sender_unqualified_hosts? no (end of list)
39763 cached no match for +relay_from_hosts
39763 host in recipient_unqualified_hosts? no (end of list)
39763 host in helo_verify_hosts? no (option unset)
39763 host in helo_try_verify_hosts? no (option unset)
39763 host in helo_accept_junk_hosts? no (end of list)
39763 SMTP>> 220 mail.<real_domane.ru>, ESMTP EXIM 4.67
39763 Process 39763 is ready for new message
39763 smtp_setup_msg entered
39763 SMTP<< EHLO yakupov
39763 yakupov in helo_lookup_domains? no (end of list)
39763 sender_fullhost = (yakupov) [193.*.*.*]
39763 sender_rcvhost = [193.*.*.*] (helo=yakupov)
39763 set_process_info: 39763 handling incoming connection from (yakupov) [193.*.*.*] I=[81.*.*.*]:25
39763 host in pipelining_advertise_hosts? yes (matched "*")
39763 host in auth_advertise_hosts? yes (matched "*")
39763 host in tls_advertise_hosts? no (option unset)
39763 SMTP>> 250-mail.<real_domane.ru> Hello yakupov [193.*.*.*]
39763 250-SIZE 67108864
39763 250-PIPELINING
39763 250-AUTH PLAIN LOGIN CRAM-MD5
39763 250 HELP
39763 SMTP<< AUTH LOGIN
39763 SMTP>> 334 VXNlcm5hbWU6
39763 SMTP<< c2FzaEBsYWJpbnRlY2gubmV0
39763 SMTP>> 334 UGFzc3dvcmQ6
39763 SMTP<< c2FzaA==
39763 auth_login authenticator:
39763   $auth1 = sash@<real_domane.ru>
39763   $auth2 = sash
39763   $1 = sash@<real_domane.ru>
39763   $2 = sash
39763 search_open: mysql "NULL"
39763 search_find: file="NULL"
39763   key="SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'" partial=-1 affix=NULL starflags=0
39763 LRU list:
39763 internal_search_find: file="NULL"
39763   type=mysql key="SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'"
39763 database lookup required for SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'
39763 MYSQL query: SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'
39763 MYSQL new connection: host=localhost port=0 socket=NULL database=exim user=exim
39763 MYSQL: no data found
39763 lookup failed
39763 expanded string: no
39763 SMTP>> 535 Incorrect authentication data
39763 LOG: MAIN REJECT
39763   auth_login authenticator failed for (yakupov) [193.*.*.*] I=[81.*.*.*]:25: 535 Incorrect authentication data (set_id=sash@<real_domane.ru>)
39763 SMTP>> 421 mail.<real_domane.ru> lost input connection
39763 LOG: smtp_connection MAIN
39763   SMTP connection from (yakupov) [193.*.*.*] I=[81.*.*.*]:25 lost
39763 search_tidyup called
39763 close MYSQL connection: localhost/exim/exim
39761 child 39763 ended: status=0x100
39761 0 SMTP accept processes now running
39761 Listening...
39761 Connection request from 193.*.*.* port 7930
39761 search_tidyup called
39761 1 SMTP accept process running
39761 Listening...
39766 sender_fullhost = [193.*.*.*]
39766 sender_rcvhost = [193.*.*.*]
39766 Process 39766 is handling incoming connection from [193.*.*.*]
39766 checking for IP options
39766 no IP options found
39766 host in host_lookup? no (option unset)
39766 set_process_info: 39766 handling incoming connection from [193.*.*.*] I=[81.*.*.*]:25
39766 host in host_reject_connection? no (option unset)
39766 gethostbyname looked up these IP addresses:
39766   name=localhost.inet address=127.0.0.1
39766 host in "localhost:127.0.0.0/8:192.168.0.0/16"? no (end of list)
39766 host in sender_unqualified_hosts? no (end of list)
39766 cached no match for +relay_from_hosts
39766 host in recipient_unqualified_hosts? no (end of list)
39766 host in helo_verify_hosts? no (option unset)
39766 host in helo_try_verify_hosts? no (option unset)
39766 host in helo_accept_junk_hosts? no (end of list)
39766 SMTP>> 220 mail.<real_domane.ru>, ESMTP EXIM 4.67
39766 Process 39766 is ready for new message
39766 smtp_setup_msg entered
39766 SMTP<< EHLO yakupov
39766 yakupov in helo_lookup_domains? no (end of list)
39766 sender_fullhost = (yakupov) [193.*.*.*]
39766 sender_rcvhost = [193.*.*.*] (helo=yakupov)
39766 set_process_info: 39766 handling incoming connection from (yakupov) [193.*.*.*] I=[81.*.*.*]:25
39766 host in pipelining_advertise_hosts? yes (matched "*")
39766 host in auth_advertise_hosts? yes (matched "*")
39766 host in tls_advertise_hosts? no (option unset)
39766 SMTP>> 250-mail.<real_domane.ru> Hello yakupov [193.*.*.*]
39766 250-SIZE 67108864
39766 250-PIPELINING
39766 250-AUTH PLAIN LOGIN CRAM-MD5
39766 250 HELP
39766 SMTP<< AUTH LOGIN
39766 SMTP>> 334 VXNlcm5hbWU6
39766 SMTP<< c2FzaEBsYWJpbnRlY2gubmV0
39766 SMTP>> 334 UGFzc3dvcmQ6
39766 SMTP<< c2FzaA==
39766 auth_login authenticator:
39766   $auth1 = sash@<real_domane.ru>
39766   $auth2 = sash
39766   $1 = sash@<real_domane.ru>
39766   $2 = sash
39766 search_open: mysql "NULL"
39766 search_find: file="NULL"
39766   key="SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'" partial=-1 affix=NULL starflags=0
39766 LRU list:
39766 internal_search_find: file="NULL"
39766   type=mysql key="SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'"
39766 database lookup required for SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'
39766 MYSQL query: SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'
39766 MYSQL new connection: host=localhost port=0 socket=NULL database=exim user=exim
39766 MYSQL: no data found
39766 lookup failed
39766 expanded string: no
39766 SMTP>> 535 Incorrect authentication data
39766 LOG: MAIN REJECT
39766   auth_login authenticator failed for (yakupov) [193.*.*.*] I=[81.*.*.*]:25: 535 Incorrect authentication data (set_id=sash@<real_domane.ru>)
39766 SMTP>> 421 mail.<real_domane.ru> lost input connection
39766 LOG: smtp_connection MAIN
39766   SMTP connection from (yakupov) [193.*.*.*] I=[81.*.*.*]:25 lost
39766 search_tidyup called
39766 close MYSQL connection: localhost/exim/exim
39761 child 39766 ended: status=0x100
39761 0 SMTP accept processes now running
39761 Listening...
39761 Connection request from 193.*.*.* port 7931
39761 search_tidyup called
39761 1 SMTP accept process running
39761 Listening...
39768 sender_fullhost = [193.*.*.*]
39768 sender_rcvhost = [193.*.*.*]
39768 Process 39768 is handling incoming connection from [193.*.*.*]
39768 checking for IP options
39768 no IP options found
39768 host in host_lookup? no (option unset)
39768 set_process_info: 39768 handling incoming connection from [193.*.*.*] I=[81.*.*.*]:25
39768 host in host_reject_connection? no (option unset)
39768 gethostbyname looked up these IP addresses:
39768   name=localhost.inet address=127.0.0.1
39768 host in "localhost:127.0.0.0/8:192.168.0.0/16"? no (end of list)
39768 host in sender_unqualified_hosts? no (end of list)
39768 cached no match for +relay_from_hosts
39768 host in recipient_unqualified_hosts? no (end of list)
39768 host in helo_verify_hosts? no (option unset)
39768 host in helo_try_verify_hosts? no (option unset)
39768 host in helo_accept_junk_hosts? no (end of list)
39768 SMTP>> 220 mail.<real_domane.ru>, ESMTP EXIM 4.67
39768 Process 39768 is ready for new message
39768 smtp_setup_msg entered
39768 SMTP<< EHLO yakupov
39768 yakupov in helo_lookup_domains? no (end of list)
39768 sender_fullhost = (yakupov) [193.*.*.*]
39768 sender_rcvhost = [193.*.*.*] (helo=yakupov)
39768 set_process_info: 39768 handling incoming connection from (yakupov) [193.*.*.*] I=[81.*.*.*]:25
39768 host in pipelining_advertise_hosts? yes (matched "*")
39768 host in auth_advertise_hosts? yes (matched "*")
39768 host in tls_advertise_hosts? no (option unset)
39768 SMTP>> 250-mail.<real_domane.ru> Hello yakupov [193.*.*.*]
39768 250-SIZE 67108864
39768 250-PIPELINING
39768 250-AUTH PLAIN LOGIN CRAM-MD5
39768 250 HELP
39768 SMTP<< AUTH LOGIN
39768 SMTP>> 334 VXNlcm5hbWU6
39768 SMTP<< c2FzaEBsYWJpbnRlY2gubmV0
39768 SMTP>> 334 UGFzc3dvcmQ6
39768 SMTP<< c2FzaA==
39768 auth_login authenticator:
39768   $auth1 = sash@<real_domane.ru>
39768   $auth2 = sash
39768   $1 = sash@<real_domane.ru>
39768   $2 = sash
39768 search_open: mysql "NULL"
39768 search_find: file="NULL"
39768   key="SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'" partial=-1 affix=NULL starflags=0
39768 LRU list:
39768 internal_search_find: file="NULL"
39768   type=mysql key="SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'"
39768 database lookup required for SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'
39768 MYSQL query: SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'
39768 MYSQL new connection: host=localhost port=0 socket=NULL database=exim user=exim
39768 MYSQL: no data found
39768 lookup failed
39768 expanded string: no
39768 SMTP>> 535 Incorrect authentication data
39768 LOG: MAIN REJECT
39768   auth_login authenticator failed for (yakupov) [193.*.*.*] I=[81.*.*.*]:25: 535 Incorrect authentication data (set_id=sash@<real_domane.ru>)
39768 SMTP>> 421 mail.<real_domane.ru> lost input connection
39768 LOG: smtp_connection MAIN
39768   SMTP connection from (yakupov) [193.*.*.*] I=[81.*.*.*]:25 lost
39768 search_tidyup called
39768 close MYSQL connection: localhost/exim/exim
39761 child 39768 ended: status=0x100
39761 0 SMTP accept processes now running
39761 Listening...
^C
[root@server /tmp]# exit
exit

Script done on Mon Jul 16 13:06:46 2007

[Alex Keda]

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

SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'

покажи что вернёт этот запрос из БД

[Sash]

всё хорошо, тока я не вижу попыток аутентификации
так что рой клиентскую программу

всё бы ничего, но thebat не отправляет

вот что говорит thebat

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

 16.07.2007, 13:16:13: FETCH - Получение новой почты
 16.07.2007, 13:16:14: FETCH - Соединение с POP3 сервером прошло удачно
 16.07.2007, 13:16:14: FETCH - Аутентификация прошла успешно (Обычный метод)
 16.07.2007, 13:16:14: SEND  - Отправка почты - писем в очереди: 1
 16.07.2007, 13:16:14: FETCH - Соединение завершено - получено писем: 0
 16.07.2007, 13:16:14: FETCH - Получение новой почты
 16.07.2007, 13:16:14: FETCH - Соединение с POP3 сервером прошло удачно
 16.07.2007, 13:16:14: FETCH - Аутентификация прошла успешно (Обычный метод)
 16.07.2007, 13:16:14: FETCH - На сервере писем: 0, из них новых: 0
 16.07.2007, 13:16:14: FETCH - Соединение завершено - получено писем: 0
!16.07.2007, 13:16:15: SEND  - Сервер сообщает, что он не готов, ответ: ""
 16.07.2007, 13:16:15: SEND  - Соединение завершено - отправлено писем: 0
 16.07.2007, 13:16:15: SEND  - Не удалось отправить некоторые письма - подробности смотрите в Журнале работы

[Sash]

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

SELECT `username` FROM `mailbox` WHERE `username` = 'sash@<real_domane.ru>' AND `password` =  'sash'

покажи что вернёт этот запрос из БД

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

MySQL вернула пустой результат (т.е. ноль рядов). (Запрос занял 0.0002 сек)
SQL-запрос:
SELECT `username`
FROM `mailbox`
WHERE `username` = 'sash@<real_domane.ru>'
AND `password` = 'sash'
LIMIT 0 , 30 

[Alex Keda]

ну так заполни БД...
или покажи строку для этого пользователя - чё там у тя лежит...

[Sash]

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

SQL-результат

Хост: localhost
База данных: exim
Время создания: Июл 16 2007 г., 13:20
Созданный: phpMyAdmin 2.10.2 / MySQL 5.0.45-log
SQL-запрос: SELECT * FROM `mailbox` LIMIT 0, 30 ;
Ряды: 1
username 	password 	name 	maildir 	quota 	domain 	created 	modified 	active
sash@<real_domane.ru> 	$1$15b368e8$tkqdglzb/JC9bMXk93LsH1 	sash 	sash@<real_domane.ru>/ 	0 	<real_domane.ru> 	2007-07-12 10:14:21 	2007-07-12 10:14:38 	1

[Alex Keda]

хоть бы с колонками сделла - хрен поймёшь что к чему относится... (с консоли красиво выдаёт)
====
не суть.
у тя пароль в БД шифрованый, а exim ищет в открытом виде.
либо пусть exim ищет шифрованный, либо в БД храни в открытом виде.

[Sash]

хоть бы с колонками сделла - хрен поймёшь что к чему относится... (с консоли красиво выдаёт)
====
не суть.
у тя пароль в БД шифрованый, а exim ищет в открытом виде.
либо пусть exim ищет шифрованный, либо в БД храни в открытом виде.

лучше пусть exim ищет шифрованный
как это сказать exim'у ?

[Alex Keda]

http://www.lissyara.su/?id=1233" target="_blank
и последующие несколько разделов.
тока я не знаю как оно шифруется

[Sash]

хЫх
для полной инфы ткни меня как сделать, чтобы пароли писались в открытом виде

[Alex Keda]

в конфиге постфиксадмина прописать надо

[Sash]

всё гуд
в postfixadmin ставим
$CONF['encrypt'] = 'cleartext';
в dovecot-sql.conf ставим
default_pass_scheme = CLEARTEXT
и всё работает в открытом виде

теперь как сделать в зашифрованном виде?
у кого-нить есть готовый вариант?

[Alex Keda]

кто-то из народу на форуме делал - кто не помню...
не дикенс ли...
но ему щас не до конфигов

[KaMa-CyTpA]

У меня такая-же проблема - и никак не реализовать вот это?
Ну то есть чтобы exim мог "читать" шифрованные пароли?

[freeman]

Я смотрю тем таких полно. Поищи поиском или за сегодня, которые я поднял В принципе это реально, но методов много, вот например как The Bat-овский , или вернее RFC-2095 = MD5 CRAM-HMAC Запрос/подтверждение что не вижу решения пока