Quantcast

authdaemond: supplied password 'password' doesnot match encrypted password 'password'

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

authdaemond: supplied password 'password' doesnot match encrypted password 'password'

Pradeep Mishra-2
Hi

I am using courier IMAP 4.3.0 and courier authlib <a href="http://0.60.2." target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">0.60.2. I have IMAP users as virtual users in MYSQL
my auth mysqlrc is
MYSQL_SERVER            <a href="http://127.0.0.1" target="_blank" onclick="return top.js..OpenExtLink(window,event,this)">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=[hidden email], ip=[::ffff:<a href="http://61.1.64.46" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">61.1.64.46]
Aug 29 17:21:02 mx01 imapd: Disconnected, ip=[::ffff:x.x.x.x], time=15




Please Advise....


Download prohibited? No problem. CHAT from any browser, without download.
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
courier-users mailing list
[hidden email]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: authdaemond: supplied password 'password' doesnot match encrypted password 'password'

Sam Varshavchik
Pradeep Mishra writes:

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

>    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'

The second field in the SELECT is the encrypted password, the third one is
the cleartext password. Fix your SELECT clause.



-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
courier-users mailing list
[hidden email]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users

attachment0 (204 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: authdaemond: supplied password 'password' doesnot match encrypted password 'password'

Pradeep Mishra-2
thanks sam..


--- On Sat, 30/8/08, Sam Varshavchik <[hidden email]> wrote:
From: Sam Varshavchik <[hidden email]>
Subject: Re: [courier-users] authdaemond: supplied password 'password' doesnot match encrypted password 'password'
To: [hidden email]
Date: Saturday, 30 August, 2008, 6:07 PM

Pradeep Mishra writes:

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

> 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'

The second field in the SELECT is the encrypted password, the third one is
the cleartext password. Fix your SELECT clause.


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
courier-users mailing list
[hidden email]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users


Unlimited freedom, unlimited storage. Get it now
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
courier-users mailing list
[hidden email]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
Loading...