Hello,

let me introduce myself. My name is Roman Dergam, I live in Prague and I am a freelance translator. I use the e-mail address above for subscribing to various lists and groups and would like to use maildrop to sort the mail by each group on the mail server. After some time and much reading I succeeded in compiling

maildrop 1.7.0 Copyright 1998-2003 Double Precision, Inc. GDBM extensions enabled. Maildir quota extension enabled. Virtual user database via MySQL extension enabled.

on the server running Debain Sarge, because I seem to have read somewhere that the native Debian package does not support MySQL-stored virtual users.

The configure line was

CPPFLAGS="-I/usr/include/mysql" LDFLAGS="-L/usr/lib -lmysqlclient -lz -lm" ./configure --prefix=/usr --enable-syslog=1 --enable-maildropmysql --with-mysqlconfig=/etc/courier/maildropmysql.config --enable-maildirquota --enable-maildrop-uid=5000 --enable-maildrop-gid=8 --enable-authlib

User and group are

virtmail:x:5000:5000:,,,:/var/mail:/bin/false mail:x:8:8:mail:/var/mail:/bin/sh (virtmail is the user under which all maildirs appear... the suggested vmail:vmail generated an error in my case)

/etc/courier/maildropmysql.config is

hostname localhost dbuser xxx dbpw xxx database xxx dbtable users uid_field id uidnumber_field uid default_uidnumber '5000' gidnumber_field gid default_gidnumber '8' homedirectory_field CONCAT(home,'/',maildir) maildir_field maildir #quota_field CONCAT(quota,'S') default_quota 1073741824S

and postfix main.cf contains

----------------------------------------- #virtual_transport = maildrop

## Set to 1 because Maildrop only delivers one message at a time. maildrop_destination_recipient_limit = 1 maildrop_destination_concurrency_limit = 1

transport_maps=mysql:/etc/postfix/transport.cf virtual_mailbox_maps=mysql:/etc/postfix/mysql_virt.cf virtual_uid_maps=mysql:/etc/postfix/uids.cf virtual_gid_maps=mysql:/etc/postfix/gids.cf virtual_mailbox_base=/var/spool/mail/ #virtual_mailbox_base=/

mydestination = $mydomain, $myhostname, $transport_maps virtual_maps = mysql:/etc/postfix/virtual.cf

-----------------------------------------

postfix master.cf

maildrop unix - n n - - pipe flags=DRhu user=virtmail:mail argv=/usr/bin/maildrop -d ${recipient}

and the transport table of the database has "maildrop:" instead of the former "virtual:"

The result is that the whole delivery to maildirs works (so I assume the MySQL related things are OK), but when I tried to set a filter (by including a .mailfilter file in the maildir of lists), there was no filtering. The filter I tried was

################################################################ # .mailing lists and forums

#'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' # .Postfix if ( /^Sender:.*postfix-users@postfix\.org/ \ || /^To:.*postfix-users@postfix\.org/ ) { exception { to $DEFAULT/.Postfix/ } }

# .LANTRA if ( /^Sender:.*LANTRA-L@SEGATE\.SUNET\.SE/ \ || /^To:.*LANTRA-L@SEGATE\.SUNET\.SE/ ) { exception { to $DEFAULT/.LANTRA-L/ } }

#'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

I made a beginner's mistake somewhere, but where? The mail.log shows

Sep 7 17:40:03 utopia postfix/pipe[7927]: 8C05267984: to=<lis...@intu.cz>, relay=maildrop, delay=0, status=sent (intu.cz)

so it seems as if maildrop is involved in delivering to maildirs, but why doesn't it filter and sort mail?

Sorry for the lengthy mail, my fight with the problem has been also lengthy.

Thanks for any advice

Roman