Hi,
I am having trouble with a courier-imap/courier-authlib (mysql)
installation and was wondering if any of you perhaps have seen this
sort of behaviour and what the cure is. Both courier-imap and
courier-authlib has been installed from RPM binaries
(courier-imap-4.3.1.tar.bz2 and courier-authlib-0.60.4.tar.bz2).
Both courier-authlib and courier-imap starts up fine, loads the
modules and accepts connections... however trying to login using a
valid username produces authentication failure. Enabling debugging and
checking maillog shows:
May 16 07:52:24 mailserver authdaemond: Installing libauthmysql
May 16 07:52:24 mailserver authdaemond: Installation complete: authmysql
May 16 07:52:41 mailserver authdaemond: received userid lookup
request: myusername
May 16 07:52:41 mailserver authdaemond: authmysql: trying this module
May 16 07:52:41 mailserver authdaemond: SQL query: SELECT username,
clear, user_id, group_id, home, maildir, quota,
CONCAT("disableimap=",disableimap,",disablepop3=",disablepop3) FROM
passwd WHERE username = 'myusername@' AND (suspended='N')
May 16 07:52:41 mailserver authdaemond: zero rows returned
May 16 07:52:41 mailserver authdaemond: authmysql: REJECT - try next module
May 16 07:52:41 mailserver authdaemond: FAIL, all modules rejected
Where/why does the @ sign slip in? How do I get rid of it. Logins are
based on username and not on [EMAIL PROTECTED] The username
presented to courier-imap was myusername...
The authdaemonrc configuration file has been changed to look only at
mysql. Below is my authmysqlrc:
MYSQL_SERVER 1.2.3.4
MYSQL_USERNAME dbusername
MYSQL_PASSWORD dbpassword
MYSQL_PORT 0
MYSQL_OPT 0
MYSQL_DATABASE maildb
MYSQL_USER_TABLE passwd
MYSQL_CLEAR_PWFIELD clear
MYSQL_UID_FIELD user_id
MYSQL_GID_FIELD group_id
MYSQL_LOGIN_FIELD username
MYSQL_HOME_FIELD home
MYSQL_MAILDIR_FIELD maildir
MYSQL_QUOTA_FIELD quota
MYSQL_AUXOPTIONS_FIELD
CONCAT("disableimap=",disableimap,",disablepop3=",disablepop3)
MYSQL_WHERE_CLAUSE suspended='N'
Both imapd and pop3d files are stock (no changes made).
Any pointers appreciated.
Regards,
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
courier-users mailing list
[email protected]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
