[tpop3d-discuss] problem with auth_mysql

[heimdall]

Dear all,

I can't make tpop3d work with MySql.
I get -ERR Lies! Try again! every time.
Please help/advice where I'm wrong.
I notice that tpop3d don't make queries at all.
I browsed other threads and saw one about that
problem but without answer.
My system is Redhat 7.2, MySql 3.23.41
Thx all.

tpop3d.conf :

listen-address:         192.168.1.1:110
max-children:           20
timeout-seconds:        60
mailspool-index:        /var/spool/tpop3d
tcp-wrappers-name:      pop3d
auth-mysql-enable:      yes
auth-mysql-mail-group:  postdrop
auth-mysql-hostname:    localhost
auth-mysql-database:    mail
auth-mysql-username:    tpop3d
auth-mysql-password:    tpop3d
auth-mysql-pass-query:  SELECT 
CONCAT('/var/spool/mail/','$(local_part)'),CONCAT('{mysql}',password),'postfix','bsd'
 FROM pop3 WHERE login='$(local_part)'

tpop3d log :
tpop3d -dv

experimental BSD mailbox metadata cache enabled
TCP Wrappers support enabled, using daemon name `tpop3d'
listening on address 192.168.1.1, port 110, domain mail.test.com
1 authentication drivers successfully loaded
net_loop: tpop3d version 1.3.5 successfully started
connection_sendresponse: client [6]192.168.1.1/mail.test.com: sent `+OK 
<address@hidden>'
listeners_post_select: client [6]192.168.1.1/mail.test.com: connected
connection_parsecommand: client [6]192.168.1.1/mail.test.com: received `USER 
test'
connection_sendresponse: client [6]192.168.1.1/mail.test.com: sent `+OK Tell me 
your password.'
connection_parsecommand: client [6]192.168.1.1/mail.test.com: received `PASS 
[...]'
connection_sendresponse: client [6]192.168.1.1/mail.test.com: sent `-ERR Lies! 
Try again!'
connection_do: client `[6]192.168.1.1/mail.test.com': 1 authentication failures
net_loop: timed out client [6]192.168.1.1/mail.test.com
net_loop: terminating on signal 2

mysqlclient :

mysql> SELECT 
CONCAT('/var/spool/mail/','test'),CONCAT('{mysql}',password),'postfix','bsd' 
FROM pop3 WHERE login='test';
+----------------------------------------------------+--------------------------------+---------+-----+
| CONCAT('/var/spool/mail/','test')                  | 
CONCAT('{plaintext}',password) | postfix | bsd |
+----------------------------------------------------+--------------------------------+---------+-----+
| /var/spool/mail/test                               | {mysql}378b243e220ca493  
      | postfix | bsd |
+----------------------------------------------------+--------------------------------+---------+-----+

mysql access log :

020411 17:36:53    8952 Connect     address@hidden on mail
020411 17:36:55    8952 Quit

NOTE: no "select" query in the mysql access log during auth