Re: Postfix+Courier-imap+Mysql: Login failed

[Noah K Sematimba <ksemat at wawa.eahd.or.ug>]

Could you also post the exact mysql command you used to create this user
in the database. I am particularly interested in the part where you insert
the password. I want to see what crypt you used either md5 or the normal
crypt. Do not use the mysql encrypt function as it is non standard and
therefore not supported.

cheers,

Noah.

On Fri, 21 Jun 2002, DOSSOU Franck wrote:

> En réponse à Noah K Sematimba <ksemat at wawa.eahd.or.ug>:
> Thank for us! this is more explain:
> I've create a virtual domaine named "test.bj" and in users (table in maildb
> database) I put into ID column: toto at test.bj so postfix delivery mail
> correctly. I also have a local user dosfrk(unix account)  with local domain
> "webopt.bj" which I've specified in transport table. For my local user who
> receive a mail in maildir format in /home/dosfrk/Maildir/, I can check
> mail through
> imap and pop3, the problem is with the virtual user who has to authenticate
> through mysql.
> For virtual user who has already receive mail in maildir format
> in /var/spool/postfix/virtual/test.bj/toto/Maildir/ I've got this:
>
> telnet localhost 110
> Trying 127.0.0.1...
> Connected to localhost.
> Escape character is '^]'.
> +OK Hello there.
> user toto at test.bj
> +OK Password required.
> pass 123
> -ERR Login failed.
> quit
> +OK Better luck next time.
> Connection closed by foreign host.
>
> This is maillog file:
> Jun 21 15:36:49 kheops pop3d: Connection, ip=[::ffff:127.0.0.1]
> Jun 21 15:37:18 kheops pop3d: LOGIN FAILED, ip=[::ffff:127.0.0.1]
> Jun 21 15:37:26 kheops pop3d: Disconnected, ip=[::ffff:127.0.0.1]
>
> mysqld.log file :
> 020620 14:52:28  mysqld started
> /usr/libexec/mysqld: ready for connections
>
> Do you know other log files which can help me?
>
> DOSSOU Franck
> Chef section Plateforme NTIC
> OPT - BENIN (Tel (229) 91 74 33/ 31 88 88)
>


-----
This is the afnog mailing list, managed by Majordomo 1.94.5

To send a message to this list, e-mail afnog at afnog.org
To send a request to majordomo, e-mail majordomo at afnog.org and put
your request in the body of the message (i.e use "help" for help)

This list is maintained by owner-afnog at afnog.org