Hi

we have a system running now with: postfix + mysql + courier-imap on a suse 8.1. It uses mysql as user database with postfixes internal delivery to the Maildirs. works fine! Now we need mailfilter support so we have to use maildrop dor delivery as far as I understand.

configure with: --without-db \ --with-etcdir=/etc/maildrop \ --enable-syslog=1 \ --enable-maildrop-uid=mailsystem \ --enable-maildrop-gid=mailsystem \ --enable-restrict-trusted=1 \ --enable-trusted-users='mailsystem postfix' \ --enable-trusted-groups='mailsystem postdrop maildrop' \ --enable-maildirquota --enable-use-dotlock=1 \ --enable-use-flock=0 \ --enable-maildropmysql \ --with-mysqlconfig=/etc/maildrop/maildropmysql.conf

maildrop -v shows: maildrop 1.5.2 Copyright 1998-2003 Double Precision, Inc. Maildir quota extension enabled. Virtual user database via MySQL extension enabled. This program is distributed under the terms of the GNU General Public License. See COPYING for additional information.

in main.cf of postfix i had: mailbox_command = mailbox_transport = maildrop_destinaton_recipient_limit = 1 smtpd_sender_restrictions = hash:/etc/postfix/access smtpd_client_restrictions = smtpd_helo_required = no smtpd_helo_restrictions = strict_rfc821_envelopes = no smtpd_recipient_restrictions = permit_mynetworks,check_relay_domains alias_maps = hash:/etc/aliases virtual_mailbox_base= /var/spool/maildirs virtual_uid_maps= mysql:/etc/postfix/ids.mysql virtual_gid_maps= mysql:/etc/postfix/ids.mysql virtual_mailbox_maps= mysql:/etc/postfix/mailbox.mysql virtual_minimum_uid = 5000

in master.cf i have : maildrop unix - n n - - pipe flags=Ru user=mailsystem argv=/usr/local/bin/maildrop -V9 -d $user

in /etc/maildrop/maildroprc i have: import SENDER DEFAULT=/var/spool/maildirs/

in /etc/maildrop/maildropmysql.conf I have hostname localhost #port 3306 socket /var/lib/mysql/mysql.sock database mailbase dbuser root dbpw dbrootpassword dbtable mailbase default_uidnumber 5001 default_gidnumber 5001 uid_field uid maildir_field maildir homedirectory_field home

ok the mail gets piped to maildrop, but maildrop cannot set its user or group id Apr 4 12:58:32 server maildrop[13827]: Cannot set my user or group id. Apr 4 12:58:32 server postfix/pipe[13825]: 04E488C9C: to=<clau...@intern.de>, relay=maildrop, delay=14240, status=deferred (temporary
failure. Command output: /usr/local/bin/maildrop: Cannot set my user or group id. )