Hi,

I've got Postfix 2.1.3 + MySQL 4 + Maildrop 1.5.3 on a Debain Linux machine and having serious issues to get it to work :(. Hopefully any of you is able to help me out.

Here is the error from mail.log:

Jul 11 20:07:09 srv1 postfix/pipe[29839]: flush_add: site mydomain.nl id 22D7B31345 Jul 11 20:07:09 srv1 postfix/pipe[29839]: match_hostname: mydomain.nl ~? srv1.mydomain.nl Jul 11 20:07:09 srv1 postfix/pipe[29839]: match_hostname: mydomain.nl ~? localhost Jul 11 20:07:09 srv1 postfix/pipe[29839]: match_list_match: mydomain.nl: no match Jul 11 20:07:09 srv1 postfix/pipe[29839]: flush_add: site mydomain.nl id 22D7B31345 status 4 Jul 11 20:07:09 srv1 postfix/pipe[29839]: deliver_request_final: send: "" -1 Jul 11 20:07:09 srv1 postfix/pipe[29839]: send attr reason = Jul 11 20:07:09 srv1 postfix/pipe[29839]: send attr status = 4294967295 Jul 11 20:07:09 srv1 postfix/pipe[29839]: master_notify: status 1 Jul 11 20:07:09 srv1 postfix/pipe[29839]: connection closed Jul 11 20:07:09 srv1 postfix/pipe[29839]: watchdog_stop: 0x8054ca0 Jul 11 20:07:09 srv1 postfix/pipe[29843]: input attribute name: status Jul 11 20:07:09 srv1 postfix/pipe[29843]: input attribute value: 0 Jul 11 20:07:09 srv1 postfix/pipe[29843]: private/defer socket: wanted attribute: (list terminator) Jul 11 20:07:09 srv1 postfix/pipe[29843]: input attribute name: (end) Jul 11 20:07:09 srv1 postfix/pipe[29843]: 359E431346: to=<bli...@mydomain.nl>, relay=maildrop, delay=526, status=deferred (temporary failure. Command output: maildrop: signal 0x0B ) Jul 11 20:07:09 srv1 postfix/pipe[29843]: flush_add: site mydomain.nl id 359E431346 Jul 11 20:07:09 srv1 postfix/pipe[29843]: match_hostname: mydomain.nl ~? srv1.mydomain.nl Jul 11 20:07:09 srv1 postfix/pipe[29843]: match_hostname: mydomain.nl ~? localhost Jul 11 20:07:09 srv1 postfix/pipe[29843]: match_list_match: mydomain.nl: no match Jul 11 20:07:09 srv1 postfix/pipe[29843]: flush_add: site mydomain.nl id 359E431346 status 4 Jul 11 20:07:09 srv1 postfix/pipe[29843]: deliver_request_final: send: "" -1 Jul 11 20:07:09 srv1 postfix/pipe[29843]: send attr reason = Jul 11 20:07:09 srv1 postfix/pipe[29843]: send attr status = 4294967295 Jul 11 20:07:09 srv1 postfix/pipe[29843]: master_notify: status 1 Jul 11 20:07:09 srv1 postfix/pipe[29843]: connection closed Jul 11 20:07:09 srv1 postfix/pipe[29843]: watchdog_stop: 0x8054ca0

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