atom feed3 messages in net.sourceforge.lists.courier-users[courier-users] authdaemond: supplied...
FromSent OnAttachments
Pradeep MishraAug 30, 2008 12:05 am 
Sam VarshavchikAug 30, 2008 5:36 am 
Pradeep MishraSep 1, 2008 4:36 am 
Subject:[courier-users] authdaemond: supplied password 'password' doesnot match encrypted password 'password'
From:Pradeep Mishra (prad@yahoo.co.in)
Date:Aug 30, 2008 12:05:29 am
List:net.sourceforge.lists.courier-users

Hi

I am using courier IMAP 4.3.0 and courier authlib 0.60.2. I have IMAP users as
virtual users in MYSQL

my auth mysqlrc is

MYSQL_SERVER            127.0.0.1

MYSQL_USERNAME          vmailuser

MYSQL_PASSWORD          password123

MYSQL_SOCKET                   /var/lib/mysql/mysql.sock

#Use MYSQL_SOCKET instead of MYSQL_PORT.

#If you can't do that, use MYSQL_PORT

#If your socket path is in a different location, please modify it.

MYSQL_OPT               0

MYSQL_DATABASE          postfix

MYSQL_USER_TABLE       mailbox

#MYSQL_CRYPT_PWFIELD     password

MYSQL_CLEAR_PWFIELD    password

MYSQL_UID_FIELD         uid

MYSQL_GID_FIELD         gid

MYSQL_LOGIN_FIELD       username

MYSQL_HOME_FIELD        /vmail/

MYSQL_NAME_FIELD        name

MYSQL_MAILDIR_FIELD     maildir

MYSQL_QUOTA_FIELD       quota

MYSQL_UID_FIELD         uid

MYSQL_AUXOPTIONS_FIELD

CONCAT("disableimap=", disableimap,",disablepop3=",disablepop3,",disablewebmail=",disablewebmail,",sharedgroup=",sharedgroup)

#MYSQL_WHERE_CLAUSE      active='1'

MYSQL_SELECT_CLAUSE SELECT username, password, '','1001', '1001', '/vmail', maildir, quota, name, '' FROM mailbox WHERE  active = '1'

#username = '$(local_part)' OR email = '$(local_part)@$(domain)

#MYSQL_SELECT_CLAUSE SELECT username, cryptpass, '', '9999', '9999', '/home/mail', maildir, quota, name, '' FROM mailboxes WHERE username = '$(local_part)' OR  email = '$(local_part)@$(domain)'

now whenever I try login I get belo mentioned errror...

Aug 29 17:20:47 mx01 imapd: Connection, ip=[::ffff:x.x.x.x.x]

Aug 29 17:20:48 mx01 authdaemond: received auth request, service=imap,
authtype=login

Aug 29 17:20:48 mx01 authdaemond: authmysql: trying this module

Aug 29 17:20:48 mx01 authdaemond: authmysqllib: connected. Versions: header
50045, client 50045, server 50045

Aug 29 17:20:48 mx01 authdaemond: SQL query: SELECT username, password, '','1001', '1001', '/vmail', maildir, quota, name, '' FROM mailbox WHERE  active = '1'

Aug 29 17:20:48 mx01 authdaemond: supplied password 'password123' does not match
encrypted password 'password123'

Aug 29 17:20:48 mx01 authdaemond: authmysql: REJECT - try next module

Aug 29 17:20:48 mx01 authdaemond: FAIL, all modules rejected

Aug 29 17:20:48 mx01 imapd: LOGIN FAILED, user=prad@xxxxxx.com,
ip=[::ffff:61.1.64.46]

Aug 29 17:21:02 mx01 imapd: Disconnected, ip=[::ffff:x.x.x.x], time=15

Please Advise....

Unlimited freedom, unlimited storage. Get it now, on
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/