[tpop3d-discuss]auth_pgsql problem, help please

[Svetozar Dimitrov Marinov]

hello all,
i have some problems with tpop3 and pgsql-auth.
tpop3d was compile without any error.


tpop3d.conf is :
...
auth-pgsql-enable: true
auth-pgsql-hostname: localhost
auth-pgsql-database: mail
auth-pgsql-username: admin
auth-pgsql-password: pass
auth-pgsql-pass-query: select mbox_path, password, tpop3d_user,mbox_type from
 mbox where username = '$(user)'
#auth-pgsql-apop-query:
#auth-pgsql-onlogin-query:
#auth-pgsql-mail-group:

if i run from console psql -d mail  and :

mail=# select mbox_path, password, tpop3d_user,mbox_type from
mail-#  mbox where username = 'address@hidden';
   mbox_path    | password | tpop3d_user | mbox_type
----------------+----------+-------------+-----------
 yuhu.biz/admin | test     | postfix     | mailbox
(1 row)




and if i do :
telnet localhost 110
+OK <address@hidden>
user address@hidden
+OK Tell me your password.
pass test
-ERR Lies! Try again!

in the log the message is :
Jun 10 01:16:54 BlackPearl tpop3d[7969]: authcache_new_user_pass: no entry fo
r address@hidden; address@hidden
Jun 10 01:16:54 BlackPearl tpop3d[7969]: password: address@hidden; 
address@hidden
u.biz] has password type md5, but hash is of incorrect length
Jun 10 01:16:54 BlackPearl tpop3d[7969]: auth_pgsql_new_user_pass: 
address@hidden
u.biz; address@hidden failed login with wrong password
Jun 10 01:16:54 BlackPearl tpop3d[7969]: connection_do: client `[6]127.0.0.1/
BlackPearl': username address@hidden': failing password is `test'
Jun 10 01:16:54 BlackPearl tpop3d[7969]: connection_do: client `[6]127.0.0.1/
BlackPearl': username address@hidden': 1 authentication failures
Jun 10 01:17:00 BlackPearl tpop3d[7969]: ioabs_tcp_post_select: client [6]127
.0.0.1/BlackPearl: connection closed by peer
Jun 10 01:17:00 BlackPearl tpop3d[7969]: connections_post_select: client [6]1
27.0.0.1/BlackPearl: disconnected; 32/102 bytes read/written

and from outlook 6:

Jun 10 00:18:02 BlackPearl tpop3d[2365]: listeners_post_select: client [6]10.
0.0.3/BlackPearl: connected to local address 10.0.0.4:110
Jun 10 00:18:02 BlackPearl tpop3d[2365]: authcache_new_user_pass: no entry fo
r address@hidden; address@hidden
Jun 10 00:18:02 BlackPearl tpop3d[2365]: connection_do: client `[6]10.0.0.3/B
lackPearl': username address@hidden': failing password is `test'
Jun 10 00:18:02 BlackPearl tpop3d[2365]: connection_do: client `[6]10.0.0.3/B
lackPearl': username address@hidden': 1 authentication failures
Jun 10 00:18:05 BlackPearl tpop3d[2365]: ioabs_tcp_post_select: client [6]10.
0.0.3/BlackPearl: connection closed by peer


So, can anybody help me with some directions.
i don't speak very well english, so i give you all information i have.


10x in advance