postfix courier +postgresql ...? anyone?

[leblanc]

i can send and receive emails using postfix with virtual users hosted in posgresql

my new goal now is provide the pop3 and imap interface.... I'm stuck here.
does anyone here have courier working with postgresql?

i'm on opensuse 10.3 and having difficulty trying to troubleshoot this.

connection attempt

linux-server:/etc/authlib # telnet localhost 110
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
+OK Hello there.
user me@robusthaven.com
+OK Password required.
pass test
-ERR Temporary problem, please try again later
Connection closed by foreign host.


tail -f /var/log/mail

Nov 20 21:31:35 linux-server authdaemond: modules="authpgsql", daemons=5
Nov 20 21:31:35 linux-server authdaemond: Installing libauthpgsql
Nov 20 21:31:35 linux-server authdaemond: Installation complete: authpgsql
Nov 20 21:31:41 linux-server pop3d: Connection, ip=[::ffff:127.0.0.1]
Nov 20 21:31:45 linux-server pop3d: LOGIN FAILED, user=me@robusthaven.com, ip=[::ffff:127.0.0.1]
Nov 20 21:31:45 linux-server pop3d: authentication error: Input/output error



i have debug set to 2 but.. doesn't show the password i sent.
I wish i could see the final query!!!!
how do i set courier to log more .. vi /etc/syslog-ng/syslog-ng.conf ?

[falko]

What's the output of netstat -tap?

[leblanc]

tcp 0 0 *:imaps *:* LISTEN 3665/couriertcpd
tcp 0 0 *:pop3s *:* LISTEN 3695/couriertcpd
tcp 0 0 *:5902 *:* LISTEN 4678/vino-server
tcp 0 0 *:pop3 *:* LISTEN 3679/couriertcpd
tcp 0 0 *:imap *:* LISTEN 3649/couriertcpd
tcp 0 0 *:postgresql *:* LISTEN 3888/postmaster

[falko]

Looks ok.

This page seems to have the solution: http://resources.angelosystems.com/courier-imap.html