1 message in net.sourceforge.lists.courier-maildrop[maildropl] Postfix/Courier/Maildrop/...
FromSent OnAttachments
Tony BibbsOct 19, 2004 1:33 pm 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:[maildropl] Postfix/Courier/Maildrop/MySQLActions...
From:Tony Bibbs (to@tonybibbs.com)
Date:Oct 19, 2004 1:33:48 pm
List:net.sourceforge.lists.courier-maildrop

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