-----Original Message----- From: Claudio Tornado [mailto:Clau...@gmx.de] Sent: Wednesday, April 09, 2003 9:39 AM To: Gati...@verdi.lv; cour...@lists.sourceforge.net Subject: Postfix+Mysql+Maildrop config

From: Gatis Gailis

well, here it is:

hostname localhost port 3306 socket /var/lib/mysql/mysql.sock database mailbase dbuser root dbpw ************** dbtable mailbase

default_uidnumber 5001 default_gidnumber 5001 uid_field id uidnumber_field uid gidnumber_field gid maildir_field homedir homedirectory_field homedir #quota_field quota #mailstatus_field vmailstatus #where_clause ""

--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 root' --enable-trusted-groups='root mailsystem postdrop maildrop' --enable-maildirquota --enable-use-dotlock=0 --enable-use-flock=0 --enable-maildropmysql --with-mysqlconfig=/etc/maildrop/maildropmysql.conf

I have delete this file!

server:/usr/local/bin # dir maildrop* -rwsr-sr-x 1 root root 149688 Apr 4 15:46 maildrop server:/usr/local/bin # dir total 332 drwxr-xr-x 2 root root 296 Apr 5 14:16 . drwxr-xr-x 11 root root 264 Apr 5 14:16 .. -rwxr-xr-x 1 root root 19944 Apr 4 15:46 deliverquota -rwxr-xr-x 1 mailsystem mailsystem 9948 Apr 4 15:46 lockmail -rwxr-xr-x 1 root root 19288 Apr 4 15:46 mailbot -rwxr-xr-x 1 root root 21768 Apr 4 15:46 maildirmake -rwsr-sr-x 1 root root 149688 Apr 4 15:46 maildrop -rwxr-xr-x 1 root root 17240 Apr 4 15:46 makemime -rwxr-xr-x 1 root root 39288 Apr 4 15:46 reformail -rwxr-xr-x 1 root root 47448 Apr 4 15:46 reformime lrwxrwxrwx 1 root root 24 Apr 5 14:16 uvscan -> /usr/local/uvscan/uvscan server:/usr/local/bin #

server:/usr/local/bin # maildrop -v 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.

I add only this line:

maildrop unix - n n - - pipe flags=Ru user=mailsystem argv=/usr/local/bin/maildrop -d ${recipient}

I only add this line: maildrop_destinaton_recipient_limit = 1 (This parameter wasn't there before.)

Databasename: mailbase Tablename: mailbase Fields: name type Null std

id varchar(240) notnull maildir varchar(100) notnull uid int(6) notnull 5001 gid int(6) notnull 5001 password varchar(255) notnull home varchar(100) notnull /var/spool/maildirs homedir varchar(100) notnull quota int(6) notnull 0 vmailstatus varchar(100) notnull

What's in? id clau...@intern.de maildir intern.de/claudio/ uid 5001 gid 5001 password ********* home /var/spool/maildirs homedir /var/spool/maildirs/intern.de/claudio/ quota 0 vmailstatus ''

maildrop use the field 'homedir'. The two fields 'home' and 'maildir' are use of courier-imap.

Yes, this colon is actually in my transport: intern.de maildrop:

As I use virtual for mail-deliver, my colon was intern.de virtual: For maildrop I change this line to intern.de maildrop:

(Don't forget postmap transport)

mailbox: server:/var/spool/maildirs/intern.de/claudio # dir total 17 drwxrwx--- 12 mailsystem mailsystem 456 Jul 6 07:26 . drwxrwxrwx 5 mailsystem mailsystem 120 Apr 4 16:52 .. drwxrwx--- 5 mailsystem mailsystem 184 Apr 1 09:04 .Aufheben drwxrwx--- 5 mailsystem mailsystem 184 Jul 6 08:21 .Entw&APw-rfe drwxrwx--- 5 mailsystem mailsystem 184 Jul 5 17:20 .Gesendete Objekte -rwxrwx--- 1 mailsystem mailsystem 119 Apr 4 13:58 courierimapsubscribed -rw-r--r-- 1 mailsystem mailsystem 586 Jul 6 07:26 courierimapuiddb drwxrwx--- 2 mailsystem mailsystem 752 Jul 6 07:26 cur -rwx------ 1 mailsystem mailsystem 159 Apr 6 19:15 .mailfilter drwxrwx--- 2 mailsystem mailsystem 48 Jul 6 07:22 new -rw-r--r-- 1 root root 186 Apr 6 15:29 text.txt drwxrwx--- 2 mailsystem mailsystem 48 Jul 6 08:22 tmp

you can see, that mailsystem is the owner of all folder in maildirs

This send an autorespond text to mailsender.