I have Postfix 1.1.7 on MySQL + VDA patch on RedHat. I have only virtual user (no /etc/passwd).

If i use Postifix with transport virtual: everything works fine.

Now, I think a mail filtering. I take maildrop-1.3.8.20020418.tar.gz and read a FAQ: http://www-dt.e-technik.uni-dortmund.de/~ma/postfix/HOWTO-maildrop.html

I apply the patch of Matthias Andree and my configure is:

%configure --enable-userdb --enable-DEBUG --with-devel \ --enable-syslog=1 --enable-sendmail=/usr/sbin/sendmail \ --enable-smallmsg=10240 \ --enable-maildirquota --enable-restrict-trusted=0 \ --with-etcdir=/etc/maildrop --enable-maildropmysql \ --with-mysqlconfig=/etc/maildrop/maildropmysql.cf

In main.cf: transport_maps=mysql:/etc/postfix/mysql/transport.cf

with transport maildrop:

In master.cf, i try: 1) maildrop unix - n n - - pipe flags=uR user=vscan argv=/usr/bin/maildrop -d {recipient}

2) maildrop unix - n n - - pipe flags=uR user=vscan argv=/usr/bin/maildrop -d {user}

3) maildrop unix - n n - - pipe flags=uR user=vscan argv=/usr/bin/maildrop -d user

4) maildrop unix - n n - - pipe flags=uR user=vscan argv=/usr/bin/maildrop -d /usr/bin/maildrop -d "$USER" -f
"$SENDER" "$EXTENSION"

but i have always: Apr 25 15:40:45 pcalby maildrop[14781]: Invalid user specified. Apr 25 15:40:45 pcalby postfix/pipe[14780]: E3C7E169CF: to=<ben...@prova.it>, relay=maildrop, delay=1, status=bounced (user unknown. Command output: /usr/bin/maildrop: Invalid user specified. )

If i try: cat master.cf |maildrop -V9 -d ben...@prova.it

maildrop: Changing to /home/user/benati-prova.it Message start at 0 bytes, envelope sender=ben...@prova.it Tokenized import Tokenized string: "SENDER" Tokenized ; Tokenized string: "DEFAULT" Tokenized = Tokenized string: "$HOME/Maildir/" Tokenized ; Tokenized echo Tokenized string: "$DEFAULT" Tokenized ; Tokenized eof /etc/maildrop/maildroprc(1): import "SENDER" /etc/maildrop/maildroprc(2): DEFAULT="/home/user/benati-prova.it/Maildir/" /home/user/benati-prova.it/Maildir/ maildrop: Attempting .mailfilter maildrop: Delivery complete.

user ben...@prova.it is in userdb.

If i use ben...@prova.it in maildropmysql.cf:

hostname 127.0.0.1 port 3306 socket /tmp/mysql.sock database mail_db dbuser ******* dbpw ******* dbtable account

default_uidnumber 450 default_gidnumber 450 uid_field nome uidnumber_field id gidnumber_field id homedirectory_field home

mysql> select * from account; +------+------------------+----------+------------------------------+---------+--------+------------+ | id | nome | password | home | quota | status | +------+------------------+----------+------------------------------+---------+--------+------------+ | 1001 | ben...@prova.it | prova | /home/user/benati-prova.it/ | 2258291 | | | 1001 | benati | prova | /home/user/benati-prova.it/ | 2258291 | | | 1002 | albe...@prova.it | pippo | /home/user/alberto-prova.it/ | 2258291 | 1 | +------+------------------+----------+------------------------------+---------+--------+------------+ 3 rows in set (0.00 sec)

cat maildroprc |maildrop -V9 -d ben...@prova.it maildrop: Invalid user specified.

Can you help me?

AL