I have a working Postfix installation configured where one domain,
Domain A, is local. I have all email for Domain A working fine, I can
access the account by authenticating over IMAP to a MySQL database. I'm
using TMDA to filter the mail and that is working for local accounts
fine as well. Maildrop was not used for this scenario.
My current problem is I have another domain, Domain B, that I want to
issue only virtual mailboxes for. It will authenticate to the same
MySQL database over IMAP. Using SquirrelMail I can login to an account
for Domain B fine and send all the email I want. Problem is I can't
receive any email. I'm using TMDA which requires me to use maildrop so
I can configure it to pass email to tmda-filter.
I told postfix to use maildrop as the transport by setting the transport
in my MySQL database.
I then have this for my postfix master.cf:
maildrop unix - n n - - pipe
flags=DRhu user=vmail argv=/usr/bin/maildrop -d ${user}@${nexthop}
${extension} ${recipient} ${user} ${nexthop}
To configure maildrop for mysql I edited /etc/maildrop/maildropmysql.cf
as follows:
hostname localhost
port 3306
socket /var/run/mysqld/mysqld.sock
database vmailboxes
dbuser <myUserName>
dbpw <myPassword>
dbtable users
default_uidnumber 1010
default_gidnumber 100
uid_field id
uidnumber_field uid
gidnumber_field gid
maildir_field maildir
homedirectory_field homedir
quota_field quota
mailstatus_field postfix
where_clause ""
My problem is when I send a message to a virtual mailbox account, the
logs give me the following error:
Oct 19 14:52:14 www maildrop[23685]: Invalid user specified.
I'm guessing the problem is because maildrop doesn't know how to
authenticate against a MySQL database. My first question is how can I
get maildrop to give me more verbose messages so I know what auth system
it tried using. When I emerged maildrop I had the MySQL USE flag set so
MySQL support should be included.
I tried adding the following to /etc/maildroprc to get verbose messaging
but it doesn't appear to be working:
VERBOSE=9
logfile "/tmp/maildrop.log"
Here is the software and version's I'm using
Maildrop 1.5.3-r1
Postfix 2.1.3
TMDA 0.92
courier-imap 3.0.7
MySQL 4.0.20-r1
--Tony