Courier logins fail (postfix+courier+mysql)
Hi all,
I'm trying to get a virtual mailbox setup going using Postfix,
Courier-IMAP, and mySQL, all from the unstable/sid tree, using this
tutorial as a guide: http://www.high5.net/howto. I'm able to have
postfix recognize incoming mail and put it into the appropriate
maildirs, but I've met with utter failure trying to access those
virtual mailboxes through courier.
I have the latest courier-authdaemon, courier-authmysql, and
courier-base packages (0.42.2-7), and am running the courier-imap
1.7.3-7 package.
Courier is obviously talking to mySQL, this is what's logged during a
login attempt to a virtual mailbox:
---
postfix@localhost on 104 Init DB postfix 104 Query SELECT
username, password, "", '101', '101', home, maildir, "", name FROM
mailbox WHERE username = "themailbox@beingaccessed" 104 Quit
---
In courier's authdaemonrc I have "authpwd authpam authmysql" all
listed, and if it's helpful here are the values I have in authmysqlrc:
---
MYSQL_SERVER localhost
MYSQL_USERNAME postfix
MYSQL_PASSWORD postfix
MYSQL_PORT 0
MYSQL_OPT 0
MYSQL_DATABASE postfix
MYSQL_USER_TABLE mailbox
MYSQL_CRYPT_PWFIELD password
MYSQL_UID_FIELD '101'
MYSQL_GID_FIELD '101'
MYSQL_LOGIN_FIELD username
MYSQL_HOME_FIELD home
MYSQL_MAILDIR_FIELD maildir
---
But any login to a virtual account results in a "Login failed." Have
any of you had similar problems? Could pam have something do do with
it? How do I go about fixing this?
Cheers and thanks in advance,
Stefan
Reply to: