Dani Crisan wrote:
> Hello,
> 2) If I try to authenticate with the new created user: [EMAIL PROTECTED] I
> get this in the log file:
> Jul 18 16:02:35 mail imapd-ssl: Connection, ip=[::ffff:127.0.0.1]
> Jul 18 16:02:35 mail authdaemond: received auth request, service=imap,
> authtype=login
> Jul 18 16:02:35 mail authdaemond: authmysql: trying this module
> Jul 18 16:02:35 mail authdaemond: SQL query: SELECT id, crypt, "", uid,
> gid, home, concat(home,'/',maildir), "", name, "" FROM users WHERE id =
> "[EMAIL PROTECTED]" AND (enabled=1)
Does that query work correctly from, say, `mysql --batch
--user=the-value-configured-in-authmysqlrc --database=ditto
--execute='SELECT id, crypt, "", [...] AND (enabled=1)'`?
> Jul 18 16:02:35 mail authdaemond: supplied password 'THIS PASSWORD IS
> CLEAR TEXT AND IT IS CORRECT' does not match encrypted password
> 'sdtrusfX0Jj66'
Eh? I don't think that text is stored as your cleartext password.
Where is it from?
Hello,
Thank you for your answer.
The text 'THIS PASSWORD IS CLEAR TEXT AND IT IS CORRECT' I modified when
writing the email...It was actually the password I was trying to authenticate
as user [EMAIL PROTECTED] in clear text and it was correct.
Regarding the second issue:
- first i did:
# mysql --batch [EMAIL PROTECTED] --database=maildb --execute='SELECT id,
crypt, "", uid,gid, home, concat(home,'/',maildir), "", name, "" FROM users
WHERE id ="[EMAIL PROTECTED]"'
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'maildb'
- and then:
# mysql --batch --user=mail --database=maildb --execute='SELECT id, crypt,
"", uid,gid, home, concat(home,'/',maildir), "", name, "" FROM users WHERE id
="[EMAIL PROTECTED]"' -p
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near '/,maildir), "", name, "" FROM users WHERE id ="[EMAIL PROTECTED]"' at
line 1
I guess I have a file with wrong credentials set?
Thank you.
-------------------------------------------------------------------------
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
[email protected]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
-------------------------------------------------------------------------
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
[email protected]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
