[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