[tpop3d-discuss]auth_pgsql problem, help please

Svetozar Dimitrov Marinov beorn at svetulcho.org
Thu, 10 Jun 2004 01:27:25 +0300 (EEST)


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 = 'admin@yuhu.biz';
   mbox_path    | password | tpop3d_user | mbox_type
----------------+----------+-------------+-----------
 yuhu.biz/admin | test     | postfix     | mailbox
(1 row)




and if i do :
telnet localhost 110
+OK <d0c9c37aa1fb52f56238a5f6de34c73b@BlackPearl>
user admin@yuhu.biz
+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 [admin@yuhu.biz; admin@yuhu.biz]
Jun 10 01:16:54 BlackPearl tpop3d[7969]: password: [admin@yuhu.biz; admin@yuh
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: [admin@yuh
u.biz; admin@yuhu.biz] failed login with wrong password
Jun 10 01:16:54 BlackPearl tpop3d[7969]: connection_do: client `[6]127.0.0.1/
BlackPearl': username `admin@yuhu.biz': failing password is `test'
Jun 10 01:16:54 BlackPearl tpop3d[7969]: connection_do: client `[6]127.0.0.1/
BlackPearl': username `admin@yuhu.biz': 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 [admin@yuhu.biz; admin@yuhu.biz]
Jun 10 00:18:02 BlackPearl tpop3d[2365]: connection_do: client `[6]10.0.0.3/B
lackPearl': username `admin@yuhu.biz': failing password is `test'
Jun 10 00:18:02 BlackPearl tpop3d[2365]: connection_do: client `[6]10.0.0.3/B
lackPearl': username `admin@yuhu.biz': 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