Hello,

I need help to setup the mysql_select_clause in /etc/courier. I understood that in debian etch maildrop uses /etc/courier/couriermysqlrc to connect to the database.

This file looks as follows:

/etc/courier/authmysqlrc MYSQL_SERVER 127.0.0.1 MYSQL_USERNAME syscp MYSQL_PASSWORD ********** MYSQL_PORT 0 MYSQL_DATABASE syscp MYSQL_USER_TABLE mail_users MYSQL_CRYPT_PWFIELD password_enc MYSQL_UID_FIELD uid MYSQL_GID_FIELD gid MYSQL_LOGIN_FIELD username MYSQL_HOME_FIELD homedir MYSQL_MAILDIR_FIELD maildir

but: username is not an e-mail-adresse, the username has nothing to do with any part of the e-mail-adress. This brings trouble. The result is "invalid user specified". I therefore need to make an select clause. But I did not found anything that shows me, how to set it up.

Infomations: Distri: Debian etch Postfix, courier-imap, courier-pop, maildrop (in /etc), syscp, spamassassin, clamav.

Structure of the maildirs:

/var/kunden/mail/user/mailaddress/

Leander