---------- Forwarded message ---------- From: Pim Bliek <pim....@gmail.com> Date: Mon, 12 Jul 2004 19:22:50 +0200 Subject: Fwd: trouble with postfix + maildrop To:  cour...@lists.sourceforge.net

Hello All,

Please see the discussion below. I got the suggestion of the Postfix-users to move to this list since the problem seems maildrop related. If you need more info, please contact me.

Thanx a lot in advance!

Pim

---------- Forwarded message ---------- From: Pim Bliek <pim....@gmail.com> Date: Mon, 12 Jul 2004 08:52:39 +0200 Subject: Re: trouble with postfix + maildrop To: post...@postfix.org

Well, actually I use MySQL + maildrop. Here is my maildroprc:

HOME="/home/vmail" MAILDIR=domainname/username

if ( $SIZE < 26144 ) { exception { xfilter "/usr/bin/spamassassin" } }

if (/^X-Spam-Flag: *YES/) { exception { to "$HOME/$MAILDIR/.Spam/" } } else { exception { to "HOME/$MAILDIR" } }

And here is my maildropmysql.config: hostname 127.0.0.1 port 3306 database postfix dbuser postfix dbpw fiets02 dbtable mailbox default_uidnumber 1001 default_gidnumber 1001 uid_field username uidnumber_field '1001' gidnumber_field '1001' maildir_field maildir homedirectory_field '/home/vmail/' quota_field quota # unused for now, but needs to be a valid field. #mailstatus_field postfix #where_clause AND postfix = 'y'

I got my MySQL setup like this: mysql> select * from mailbox; +---------------------+------------------------------------+----------------------+----------------------+-------+--------------+---------------------+---------------------+--------+ | username | password | name | maildir | quota | domain | created | modified | active |

There is data in there that makes sense, I use postfix admin (web interface) to fill it. Followed the HOWTO on the postfix admin site.

So I try to get it to deliver to /home/vmail/us...@domain.tld/ I created mailboxes there and they have the proper permissions:

srv1:/etc/courier# ls -al /home/vmail total 16 drwx------ 4 vmail vmail 4096 Jul 11 20:11 . drwxrwsr-x 5 root staff 4096 Jul 11 00:01 .. drwx------ 5 vmail vmail 4096 Jul 11 20:11 te...@domain.tld

Any suggestions why maildrop gives the error?

Pim

On Mon, 12 Jul 2004 07:45:15 +0200, Ralf Hildebrandt <ralf...@charite.de> wrote: