I'm having a dreadful time getting a Postfix + Courier + Mysql mail
server configured in Mandrake Linux (9.1). I was wondering if someone
here might have some expertise and be willing to help.
Attempts to log on with an Imap mail client simply fails (hints that the
password may be incorrect).
-- Testing via telnet fails outright as well:
[root@adamsmdk mail]# telnet adamsmdk.adams-lan.local 143
Trying 192.168.5.100...
Connected to adamsmdk.adams-lan.local (192.168.5.100).
Escape character is '^]'.
* OK Courier-IMAP ready. Copyright 1998-2003 Double Precision, Inc. See
COPYING for distribution information.
a login madams@adamsmdk <pass>
a NO Login failed.
a login madams <pass>
a NO Login failed.
a login root@adamsmdk <root-pass>
a NO Login failed.
a login adamsmdk noneConnection closed by foreign host.
-- My mail error log looks like this:
[root@adamsmdk mail]# tail /var/log/mail/errors
Nov 8 21:46:42 adamsmdk imapd: LOGIN FAILED, ip=[::ffff:192.168.5.100]
Nov 8 21:46:42 adamsmdk imapd: DISCONNECTED, ip=[::ffff:192.168.5.100],
headers=0, body=0
-- My authmysqlrc file looks like this:
MYSQL_SERVER adamsmdk.adams-lan.local
MYSQL_USERNAME root
MYSQL_PASSWORD admin
MYSQL_PORT 3306
MYSQL_DATABASE maildb
MYSQL_USER_TABLE users
MYSQL_CRYPT_PWFIELD crypt
MYSQL_UID_FIELD uid
MYSQL_GID_FIELD gid
MYSQL_LOGIN_FIELD id
MYSQL_HOME_FIELD home
MYSQL_NAME_FIELD name
MYSQL_MAILDIR_FIELD CONCAT(home,'/',maildir)
MYSQL_SOCKET /var/mysql/mysql.sock
MYSQL_PORT 0
MYSQL_OPT 0
MYSQL_DATABASE maildb
MYSQL_USER_TABLE users
MYSQL_CRYPT_PWFIELD crypt
DEFAULT_DOAMIN adams-lan.local
MYSQL_UID_FIELD uid
MYSQL_GID_FIELD gid
MYSQL_LOGIN_FIELD name
MYSQL_HOME_FIELD home
MYSQL_NAME_FIELD name
-- My users table in the maildb database contains:
mysql> select * from users;
+----+-------+-------+--------+-----+-----+------+----------+-----------------+-------+
| id | crypt | clear | name | uid | gid | home | maildir |
defaultdelivery | quota |
+----+-------+-------+--------+-----+-----+------+----------+-----------------+-------+
| 1 |<pass> |<pass> | madams | 501 | 501 | / | /Maildir |
| |
| 0 | <rootpass> | <rootpass | root | 0 | 0 | / | /Maildir |
| |
+----+-------+-------+--------+-----+-----+------+----------+-----------------+-------+
2 rows in set (0.00 sec)
I'd really appreciate whatever help I can get with this and would be
happy to provide more information. And if someone can tell me how to
start Mysql with logging I might know more.
Thanks.
--
Mark
-----------------
If it was easy everybody would do it.