URL: https://www.opennet.me/cgi-bin/openforum/vsluhboard.cgi
Форум: vsluhforumID1
Нить номер: 59987
[ Назад ]

Исходное сообщение
"Exim + mySQL"

Отправлено Князь , 13-Сен-05 11:24 
Не могу настроить Exim.
При попытке отправить письмо выдает:
2005-09-13 17:06:17 auth_cram_md5 authenticator failed for ([127.0.0.1]) [192.168.0.94]: 535 Incorrect authentication data (set_id=demiurg)
2005-09-13 17:06:17 auth_plain authenticator failed for ([127.0.0.1]) [192.168.0.94]: 535 Incorrect authentication data (set_id=demiurg)
2005-09-13 17:06:17 auth_login authenticator failed for ([127.0.0.1]) [192.168.0.94]: 535 Incorrect authentication data (set_id=demiurg)
---
Настройки Exim:
######################################################################
#                   AUTHENTICATION CONFIGURATION                     #
######################################################################

# There are no authenticator specifications in this default configuration file.

begin authenticators

auth_plain:
        driver = plaintext
        public_name = PLAIN

  server_condition = ${lookup mysql{SELECT `user_idnr` FROM `dbmail_users` \
        WHERE userid = '${quote_mysql:$2}' AND `passwd` = '${quote_mysql:$3}'}}
  server_set_id = $2

# AUTH LOGIN authentication method with MySQL support used by Outlook Express.
auth_login:
  driver = plaintext
  public_name = LOGIN
  server_condition = ${lookup mysql{SELECT `user_idnr` FROM `dbmail_users` \
        WHERE userid = '${quote_mysql:$1}' AND `passwd` = '${quote_mysql:$2}'}}
  server_prompts = "Username:: : Password::"
  server_set_id = $1

# AUTH CRAM-MD5 authentication method with MySQL used by The Bat!.
auth_cram_md5:
  driver = cram_md5
  public_name = CRAM-MD5

  server_secret = ${lookup mysql{SELECT `passwd` FROM `dbmail_users` \
        WHERE `userid` = '${quote_mysql:$1}'}{$value}fail}
  server_set_id = $1
------------
Система: FreeBSD 5.3
Exim 4.52 + DBMail 2.0.4


Содержание

Сообщения в этом обсуждении
"Exim + mySQL"
Отправлено SubGun , 13-Сен-05 14:33 
#../exim -bV ?

"Exim + mySQL"
Отправлено Xela , 13-Сен-05 15:39 
plain:
  driver = plaintext
  public_name = PLAIN
  server_debug_print = yes
  server_condition = ${if eq{$2}{${lookup mysql {SELECT passwd FROM dbmail_users WHERE userid='${quote_mysql:$1}'}{$value}fail}} {yes}{no}}
  server_set_id = $1

login:
  driver = plaintext
  public_name = LOGIN
  server_prompts = "Username:: : Password::"
  server_debug_print = yes
  server_condition = ${if eq{$2}{${lookup mysql{SELECT passwd FROM dbmail_users WHERE userid='${quote_mysql:$1}'}{$value}fail}} {yes}{no}}
   server_set_id = $1

cram:
  driver = cram_md5
  public_name = CRAM-MD5
  server_secret = ${lookup mysql{SELECT passwd FROM dbmail_users \
                    WHERE userid = '${quote_mysql:$1}'}{$value}fail}
  server_set_id = $1


"Exim + mySQL"
Отправлено Князь , 14-Сен-05 05:04 
Заработало после такой правки конфига:
######################################################################
#                   AUTHENTICATION CONFIGURATION                     #
######################################################################

# There are no authenticator specifications in this default configuration file.

begin authenticators

auth_plain:
    driver = plaintext
    public_name = PLAIN
    server_condition = "${if crypteq{$2}{${extract{1}{:}{${lookup mysql{SELECT \
    passwd FROM dbmail_users WHERE userid = '${quote_mysql:$2}'}}}}}{1}{0}}"
    server_set_id = $2

# AUTH LOGIN authentication method with MySQL support used by Outlook Express.
auth_login:
    driver = plaintext
    public_name = LOGIN
    server_condition = "${if crypteq{$2}{${extract{1}{:}{${lookup mysql{SELECT \
    passwd FROM dbmail_users WHERE userid = '${quote_mysql:$1}'}}}}}{1}{0}}"
    server_prompts = "Username:: : Password::"
    server_set_id = $1

P.S. Не подскажете админки для Exim, dbMail? На свете такие вообще существуют?