FreeBSD 7.2
Настраиваю почтовый сервер на базе Postfix + courer-imap + mysql. Вот по этой портянке: http://www.sys-adm.org.ua/mail/mail-howto-p1.php Пытаюсь получить почту:
Код: Выделить всё
[root@mailer /usr/local/etc/authlib]# telnet localhost 110
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
+OK Hello there.
user ghopper@mailer.test.ru
+OK Password required.
pass password
-ERR Temporary problem, please try again later
Connection closed by foreign host.
Код: Выделить всё
Jul 9 14:34:58 mailer courier-imap: Connection, ip=[127.0.0.1]
Jul 9 14:35:00 mailer /usr/sbin/cron[6910]: (root) CMD (/usr/libexec/atrun)
Jul 9 14:35:07 mailer authdaemond: received auth request, service=pop3, authtype=login
Jul 9 14:35:07 mailer authdaemond: authmysql: trying this module
Jul 9 14:35:07 mailer authdaemond: authmysqllib: connected. Versions: header 50083, client 50083, server 50083
Jul 9 14:35:07 mailer authdaemond: Install of a character set for MySQL: utf8
Jul 9 14:35:07 mailer authdaemond: SQL query: SELECT username, crypt, password, 1981, 1981, home, maildir, quota, name, auxoptions FROM mailbox WHERE username = 'ghopper@mail.test.ru' AND (active='1')
Jul 9 14:35:07 mailer authdaemond: mysql_query failed, reconnecting: Unknown column 'crypt' in 'field list'
Jul 9 14:35:07 mailer authdaemond: authmysqllib: connected. Versions: header 50083, client 50083, server 50083
Jul 9 14:35:07 mailer authdaemond: Install of a character set for MySQL: utf8
Jul 9 14:35:07 mailer authdaemond: mysql_query failed second time, giving up: Unknown column 'crypt' in 'field list'
Jul 9 14:35:07 mailer authdaemond: authmysql: TEMPFAIL - no more modules will be tried
Jul 9 14:35:07 mailer courier-imap: LOGIN FAILED, user=ghopper@mailer.test.ru, ip=[127.0.0.1]
Jul 9 14:35:07 mailer courier-imap: authentication error: Input/output error
Код: Выделить всё
[root@mailer /usr/local/etc/authlib]# cat authmysqlrc | grep -v ^# | grep -v ^$
MYSQL_SERVER localhost
MYSQL_USERNAME postfix
MYSQL_PASSWORD postfix
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_PORT 0
MYSQL_OPT 0
MYSQL_DATABASE postfix
MYSQL_CHARACTER_SET utf8
MYSQL_USER_TABLE mailbox
MYSQL_CRYPT_PWFIELD crypt
MYSQL_CLEAR_PWFIELD password
MYSQL_UID_FIELD 1981
MYSQL_GID_FIELD 1981
MYSQL_LOGIN_FIELD username
MYSQL_HOME_FIELD home
MYSQL_NAME_FIELD name
MYSQL_MAILDIR_FIELD maildir
MYSQL_QUOTA_FIELD quota
MYSQL_AUXOPTIONS_FIELD auxoptions
MYSQL_WHERE_CLAUSE active='1'