11 messages in net.sourceforge.lists.courier-maildropRE: SV: [maildropl] Virtual domain + ...
FromSent OnAttachments
Jan AndersenJun 8, 2003 3:20 am 
Bernhard SchmidtJun 8, 2003 5:48 am 
Jan AndersenJun 8, 2003 6:49 am 
Martin List-PetersenJun 8, 2003 7:47 am 
Bernhard SchmidtJun 8, 2003 8:13 am 
Kirk MooreJun 8, 2003 8:53 am 
Martin List-PetersenJun 8, 2003 1:24 pm 
Rolan YangJun 8, 2003 4:14 pm 
Kirk MooreJun 8, 2003 8:53 pm 
Bernhard SchmidtJun 9, 2003 2:23 am 
Martin List-PetersenJun 9, 2003 6:15 am 
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:RE: SV: [maildropl] Virtual domain + mysql + maildropActions...
From:Kirk Moore (kmo@moorewebs.com)
Date:Jun 8, 2003 8:53:39 am
List:net.sourceforge.lists.courier-maildrop

As am I..... There are several good e-mails that kinda get you there.... but do not get you over the top....

http://news.gmane.org/thread.php?group=gmane.mail.maildrop

If you search in there... there are several good mails...

Our problem is that we host e-mail for 35 domains...

Our structure right now is:

/home/DOMAIN/USER/Maildir/

Our MySQL is set up with address being us@domain.tld

And with every thing out there.. we can get no closer than the following error....

Jun 8 08:42:24 mail postfix/pipe[55048]: BC98E15E61: to=<kmo@domain.tld>, relay=maildrop, delay=0, status=deferred (temporary failure. Command output: /usr/local/sbin/maildrop: Unable to open include file. )

I have the .mailfilter with the following in it: LOGNAME=tolower($LOGNAME) include "/home/vmail/.mailfilters/$LOGNAME"

and in the .mailfilters directory we have a file named:

kmo@domain.tld

and in that file is the following:

FROM='us@domain.top' to "/home/vmail/domain.top/user/."

The following is our /etc/maildrop/maildropmysql.config

hostname localhost port 3306 database <dbase name> dbuser vmail dbpw ***** dbtable users

default_uidnumber 5000 default_gidnumber 5000

uid_field address uidnumber_field uid gidnumber_field gid maildir_field maildir_fullpath homedirectory_field homedir # quota_field quota

# unused for now, but needs to be a valid field. mailstatus_field postfix

where_clause "where postfix = 'y'"

If we can get this to work.. I will document it and submit on my site. Any help would be greatly appreciated.

Black holes are created when God divides by zero!

-----Original Message----- From: cour@lists.sourceforge.net [mailto:cour@lists.sourceforge.net] On Behalf Of Bernhard Schmidt Sent: Sunday, June 08, 2003 8:13 AM To: cour@lists.sourceforge.net Subject: Re: SV: [maildropl] Virtual domain + mysql + maildrop

Have a look at http://www.marlow.dk/postfix/

I've a description there, how to configure maildrop w/mysql and

virtual users.

<quote> Important !! You will have to add a filterfile for every user on a domain, that is delivering by maildrop. Mail can't be delivered, if the filterfile not is present. </quote>

Jan is searching for solution to do this via mysql, so he doesn't need those filterfiles anylonger. And I'm also.. Do you have any information on that?

Best regards,