[tpop3d-discuss] auth_mysql problem

[Tomasz Matuszewski]

Helou!
I need your help :)
I have tpop3d with mysql, and everything works fine with password in
plaintext, but i want have password encrypted by mysql. And i have
this:

listen-address: 0.0.0.0
max-children: 20
log-facility: local1
auth-mysql-enable:yes
auth-mysql-mail-group:mail
auth-mysql-hostname:localhost
auth-mysql-username:postfix
auth-mysql-password:postfix
auth-mysql-database:mail
auth-mysql-pass-query: SELECT CONCAT('/home/artnet/testmail/', 
'$(local_part)'), \
  CONCAT('{mysql}',haslo), 'postfix', 'bsd' FROM skrzynki WHERE \
  nazwa = '$(local_part)' AND domena = '$(domain)' AND alias=''

My table skrzynki in database mail
mysql> select * from skrzynki;
+--------------+-------------+-------+------------------+
| nazwa        | domena      | alias | haslo            |
+--------------+-------------+-------+------------------+
| testowekonto | poczta.test |       | 64924b706b5a77e0 |
+--------------+-------------+-------+------------------+
1 row in set (0.00 sec)

And this i have in logs:

Sep  6 13:32:23 omicron tpop3d[40116]: password: address@hidden; address@hidden 
has password type
mysql, but hash is of incorrect length 23 (expecting 8 or 16)
Sep  6 13:32:23 omicron tpop3d[40116]: auth_mysql_new_user_pass: 
address@hidden; address@hidden failed l ogin with wrong password

mysql hash is 16 lenght, but with {mysql} it has exactly 23... what is
wrong?
-- 
Tomasz Matuszewski, address@hidden, gg: 895856, tel: +48(605)052-627
"Słowa donosiciela są jak smaczne kąski: zapadają do głebii
wnętrzności" Księga Przysłów