[maildropl] MailDrop with MySQL

[Ian M. <ia...@ia...>]

Hello maidrop-list,

I am having trouble getting MailDrop to work with my MySQL/Postfix.
Basically my MailDrop is looking for all these fields in my users table,
like gid/uid/maildir/etc, when all I have is email/passwdcrypt.

The UID/GID is hardcoded as vmail, and all Maildirs are built from the
email. ie. ia...@ia... is
/home/vmail/ianbmacdonald.com/ian/

I don't want maildrop to just read in the 'email' field, and then know
where to put my mail. 

Looking at SQL Queries, MailDrop does the following:
SELECT email, "5000", "5000", "/home/vmail",
CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), "0", vmailstatus FROM users WHERE email = "im...@ia..."

You can see I tried to hardcode the uid/gid/maildirbase by settings, but
it just passed them on in the SQL query, rather than using them
independently of the query.  The CONCAT line, creates the maildir from
the email (Exactly how Postfix does it)

I need to feed maildrop the right maildirbase/UID/GID, etc, without
modifying my current users/mailbox table.  The postfix mailbox.cf is
shown below.

Is there a maildropmysql.config I can create, and then rebuild-with,
that tells MailDrop this?

Any help appreciated,

cheers,
iMac


Further BackGround/Config Details:
----------------------------------

I have a Postfix-Courier system running on Debian Sarge. All my domains
run through virtual transport, and are configured via MySQL.  The
configuration was originally based on Chris Hass great HOWTO
http://workaround.org/articles/ispmail-sarge/

This was great for limited users/domains.  Now I want per-user
filtering, with per-user spam settings, and the ability to have per user
Spam/Ham folders.  The solution is to use MailDrop as the virtual
transport and have it   It's all setup, except for getting maildrop to
lookup proper details from Postfix user table.   /etc/maildroprc is
ready to go.

I have rebuilt MailDrop with MySQL support:
maildrop 1.5.3 Copyright 1998-2003 Double Precision, Inc.
GDBM extensions enabled.
Maildir quota extension enabled.
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.

Postfix MailBoxs: cat /etc/postfix/mysql-virtual_mailboxes.cf 
user = xxxx
password = xxxx
dbname = xxxx
table = users
select_field =
CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
where_field = email
hosts = xxxx