I have posted to this mailistlist several times ago with questions and I have not gotten any helpfull/productive replies. Perhaps that was due to lack of data. But that can be fixed... (c:

I am running courier imap (debian unstable package, version 0.37.0-1) and a postgesql server (version 7.1.3-6) in a usermode Linux system: Linux usermode 2.4.17-4um #1 Fri Jan 4 20:26:55 EST 2002 i686 unknown)

This is the sqlquery and its reply the database receives from the authdemon during an logon attempt to the imap server:

doctool=# SELECT id , '', clear, uid, gid, home, maildir, '', '' FROM
mail_test_view WHERE id ='andr...@usermode.tritech.se'; id | ?column? | clear | uid | gid | home |
maildir | ?column? | ?column? -----------------------------+----------+----------+------+------+-----------+---------+----------+---------- andr...@usermode.tritech.se | | andipass | 1002 | 1002 | /var/mail |
3 | |

Or again from the logfiles of the sytem (debugging enabled in postgres):

Jan 20 22:38:35 usermode postgres[2732]: [231-1] DEBUG: query: SELECT id , '',
clear, uid, gid, home, maildir, '', '' FROM mail_test_view WHERE id Jan 20 22:38:35 usermode postgres[2732]: [231-2]
='andr...@usermode.tritech.se';

here are my courier config files:

egrep -v '^#|^[[:space:]]*$' /etc/courier/* authdaemonrc:authmodulelist="authpam authpgsql" authdaemonrc:authmodulelistorig="authcustom authcram authuserdb authldap
authmysql authpam" authdaemonrc:daemons=5 authdaemonrc:version="" authdaemonrc:authdaemonvar=/var/run/courier/authdaemon authmodulelist:authdaemon authmysqlrc:MYSQL_SERVER localhost authmysqlrc:MYSQL_USERNAME admin authmysqlrc:MYSQL_PASSWORD admin authmysqlrc:MYSQL_PORT 0 authmysqlrc:MYSQL_OPT 0 authmysqlrc:MYSQL_DATABASE mysql authmysqlrc:MYSQL_USER_TABLE passwd authmysqlrc:MYSQL_CRYPT_PWFIELD crypt authmysqlrc:MYSQL_UID_FIELD uid authmysqlrc:MYSQL_GID_FIELD gid authmysqlrc:MYSQL_LOGIN_FIELD id authmysqlrc:MYSQL_HOME_FIELD home authmysqlrc:MYSQL_NAME_FIELD name authpgsqlrc:PGSQL_HOST localhost authpgsqlrc:PGSQL_PORT 5432 authpgsqlrc:PGSQL_USERNAME doctool authpgsqlrc:PGSQL_PASSWORD doctool authpgsqlrc:PGSQL_DATABASE doctool authpgsqlrc:PGSQL_USER_TABLE mail_test_view authpgsqlrc:PGSQL_CLEAR_PWFIELD clear authpgsqlrc:PGSQL_UID_FIELD uid authpgsqlrc:PGSQL_GID_FIELD gid authpgsqlrc:PGSQL_LOGIN_FIELD id authpgsqlrc:PGSQL_HOME_FIELD home authmysqlrc:MYSQL_NAME_FIELD name authpgsqlrc:PGSQL_HOST localhost authpgsqlrc:PGSQL_PORT 5432 authpgsqlrc:PGSQL_USERNAME doctool authpgsqlrc:PGSQL_PASSWORD doctool authpgsqlrc:PGSQL_DATABASE doctool authpgsqlrc:PGSQL_USER_TABLE mail_test_view authpgsqlrc:PGSQL_CLEAR_PWFIELD clear authpgsqlrc:PGSQL_UID_FIELD uid authpgsqlrc:PGSQL_GID_FIELD gid authpgsqlrc:PGSQL_LOGIN_FIELD id authpgsqlrc:PGSQL_HOME_FIELD home authpgsqlrc:PGSQL_MAILDIR_FIELD maildir imapd:ADDRESS=0 imapd:PORT=imap2 imapd:MAXDAEMONS=40 imapd:MAXPERIP=4 imapd:PIDFILE=/var/run/courier/imapd.pid imapd:TCPDOPTS="-nodnslookup -noidentlookup" imapd:AUTHMODULES="authdaemon" imapd:AUTHMODULES_ORIG="authdaemon" imapd:IMAP_CAPABILITY="IMAP4rev1 CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT
THREAD=REFERENCES SORT" imapd:IMAP_CAPABILITY_ORIG="IMAP4rev1 CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT
THREAD=REFERENCES SORT AUTH=CRAM-MD5 AUTH=CRAM-SHA1 IDLE" imapd:IMAP_IDLE_TIMEOUT=60 imapd:IMAP_CAPABILITY_TLS="$IMAP_CAPABILITY AUTH=PLAIN" imapd:IMAP_CAPABILITY_TLS_ORIG="$IMAP_CAPABILITY_ORIG AUTH=PLAIN" imapd:IMAP_DISABLETHREADSORT=0 imapd:IMAP_CHECK_ALL_FOLDERS=0 imapd:IMAP_OBSOLETE_CLIENT=0 imapd:IMAP_ULIMITD=65536 imapd:IMAP_USELOCKS=0 imapd:IMAP_EMPTYTRASH=Trash:7 imapd:IMAP_MOVE_EXPUNGE_TO_TRASH=0 imapd:IMAPDSTART=YES module.dsn:NAME=dsn module.dsn:PRIORITY=99 module.dsn:PROG=./courierdsn module.dsn:MAXDELS=4 module.dsn:LIBRARY=librewrite.la

the mysql module is not installed.

When I do an imap login attempt I get this in the logfiles. Note that i added a printstatement to make sure that I did not misstype the login info.

Jan 19 12:01:37 usermode imaplogin: Connection, ip=[::ffff:192.168.6.210] Jan 19 12:01:37 usermode imaplogin: Password: "andipass", Userid:
"andr...@usermode.tritech.se" Jan 19 12:01:49 usermode imaplogin: LOGIN FAILED, ip=[::ffff:192.168.6.210] Jan 19 12:01:49 usermode imaplogin: DISCONNECTED, ip=[::ffff:192.168.6.210],
headers=0, body=0

my maildirs reside in /var/mail and have the name of the users id, in this case for the user andreas this would be 3. it exists and has the standard permissions: drwx--S--- doctooluser doctooluser 1024 Jan 16 10:58 3

I would apreciate help on this.