[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_p=
art)'), \
  CONCAT('{mysql}',haslo), 'postfix', 'bsd' FROM skrzynki WHERE \
  nazwa =3D '$(local_part)' AND domena =3D '$(domain)' AND alias=3D''

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: [testowekonto@poczta.tes=
t; testowekonto@poczta.test] 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: [testowe=
konto@poczta.test; testowekonto@poczta.test] failed l ogin with wrong pas=
sword

mysql hash is 16 lenght, but with {mysql} it has exactly 23... what is
wrong?
--=20
Tomasz Matuszewski, thom@artcom.pl, gg: 895856, tel: +48(605)052-627
"S=B3owa donosiciela s=B1 jak smaczne k=B1ski: zapadaj=B1 do g=B3ebii
wn=EAtrzno=B6ci" Ksi=EAga Przys=B3=F3w