Hi, I just installed maildrop to try and use it to replace postfix's local delivery transport. I wanted to get maildrop working with mysql so that it would plugin nicely with my virtual mailboxes in postfix, but I'm running into the following problem.

Whenever I run 'maildrop -d a...@domain.xxx' I get 'Invalid user specified'.

Doing a truss, I've noticed it open up my maildropmysql.config, but I don't ever notice it opening up /tmp/mysql.sock to make an actual connection. As well, I never see it make an actual connection to my db (I have mysql logging turned on to watch for it while I debug this).

I am using: FreeBSD 4.10-RELEASE-p2 maildrop-1.6.3 from the ports collection w/ mysql support enabled and setuid

# maildrop -v maildrop 1.6.3 Copyright 1998-2003 Double Precision, Inc. 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.

Here's my maildropmysql.config: socket /tmp/mysql.sock database mail dbuser maildrop dbpw xxxxxxxx dbtable postfix_users

default_uidnumber 20002 default_gidnumber 20002

uid_field email uidnumber_field uid gidnumber_field gid maildir_field maildir homedirectory_field homedir quota_field quota

mailstatus_field postfix where_clause "and where postfix = 'y'" ------- EOF

And here's the output of a select * from the postfix_users table: mysql> select * from postfix_users\G *************************** 1. row *************************** id: 1 email: a...@domain.xxx clear: xxxxx crypt: name: A uid: 10001 gid: 10001 homedir: /usr/home/vmail/daboyz.xxx/a maildir: /usr/home/vmail/daboyz.xxx/a/Maildir/ quota: access: Y postfix: Y 1 row in set (0.01 sec)

Any help you can give would be great. Thanks in advance.