[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[tpop3d-discuss]auth_pgsql problem, help please
From: |
Svetozar Dimitrov Marinov |
Subject: |
[tpop3d-discuss]auth_pgsql problem, help please |
Date: |
Thu, 10 Jun 2004 01:27:25 +0300 (EEST) |
User-agent: |
SquirrelMail/1.4.1 |
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
- [tpop3d-discuss]auth_pgsql problem, help please,
Svetozar Dimitrov Marinov <=