[tpop3d-discuss]SHA1 hashes in MySQL and more verbose debug

[estoy@ver.megared.net.mx]

Hi,

I'm new to this list (and tpop3d), so excuse me if this is something 
obvious.

I'm trying to set up Exim+MySQL+tpop3d auth but it is not working, I 
have 2 questions:

1.- How do i set the auth-mysql-pass-query in order to use SHA1 hashes 
in my MySQL???

I saw in the documentation that only these are supported:
~~~~~~~~~~~~~~~~~~~
{crypt}
{crypt_md5}
{plaintext}
{mysql}
{md5} or no prefix
~~~~~~~~~~~~~~~~~~~

But no prefix seems to work with SHA1 hashes 

my conf file:
~~~~~~~~</usr/local/etc/tpop3d.conf>~~~~~~~~~~~
auth-mysql-pass-query: SELECT CONCAT(emp_home,'/Maildir'), \
        CONCAT('{crypt}',pwd_hash), \
        'mailnull','maildir' \
        FROM emp \
        WHERE login='$(local_part)'
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

In order to get thing work, I decided to use ENCRYPT() to store the 
hashes in the MySQL tables (so I can use CONCAT('{crypt}',pwd_hash)
in the auth-mysql-pass-query... but even It's not working (see next 
question)

2.- How do I get more useful information from the logs???
I've tried the "log-bad-passwords:" and the server is getting the
correct username and password, so it's not username/password the 
problem... but in the logs appears "authentication failures":
~~~~~~~~~</var/log/maillog>~~~~~~~~~~~~~~~~
[...]
Sep 29 09:02:46 mail tpop3d[26887]: listeners_post_select: client [6]
172.16.1.3/mydomain.com: connected to local address 172.16.1.252:110
Sep 29 09:02:46 mail tpop3d[26887]: connection_do: client `[6]
172.16.1.3/mydomain.com': username `myuser': 1 authentication failures
Sep 29 09:02:49 mail tpop3d[26887]: ioabs_tcp_post_select: client [6]
172.16.1.3/mydomain.com: connection closed by peer
Sep 29 09:02:49 mail tpop3d[26887]: connections_post_select: client [6]
172.16.1.3/mydomain.com: disconnected; 32/107 bytes read/written
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

There is nothing in the logs that I can use in order to track the root 
of the problem...

Thanks in advance for you support.
Regards,
Ed