RE: [maildropl] REJECT: instead of bounce (was"unknown user" if cannot connect to mysql) - Chris Masters - net.sourceforge.lists.courier-maildrop

14 messages in net.sourceforge.lists.courier-maildropRE: [maildropl] REJECT: instead of bo...

From	Sent On	Attachments
Chris Masters	Oct 14, 2003 8:02 am
Chris Masters	Oct 14, 2003 9:06 am
John Locke	Oct 14, 2003 9:35 am
Martin List-Petersen	Oct 15, 2003 2:37 am
Chris Masters	Oct 15, 2003 3:52 am
John Locke	Oct 15, 2003 10:34 am
Rob Hutton	Oct 15, 2003 11:02 am
Chris Masters	Oct 16, 2003 5:03 am
Arnaud Pignard	Jan 28, 2004 9:07 pm
Chris Masters	Jan 30, 2004 10:48 am
Arnaud Pignard	Jan 30, 2004 3:26 pm
Robbie Scott	Jan 31, 2004 9:58 pm
Devin Rubia	Feb 2, 2004 7:06 am
Chris Masters	Feb 3, 2004 1:31 am

	Permalink for this message Paste this link in email or IM:
	Permalink for this thread Paste this link in email or IM:
	Atom feed for this thread Paste this URL into your reader:

Subject:	RE: [maildropl] REJECT: instead of bounce (was"unknown user" if cannot connect to mysql)	Actions...
From:	Chris Masters (roti...@yahoo.com)
Date:	Oct 16, 2003 5:03:47 am
List:	net.sourceforge.lists.courier-maildrop

Yes, I've used virtual_mailbox_domains and virtual_mailbox_maps before.

It's just a mapping between the address and a mailbox location. This mapping can be obtained from ldap or mysql.

--- Rob Hutton <rob....@comcast.net> wrote:

This is realy a postfix question, but if you are using virtual_mailbox_domains and virtual_mailbox_maps then you postfix will do the lookup during the SMTP conversation and reject non existant users. The problem that I ran into is that I had to read most of the Postfix documentation before I understood what was happening and therefore what should have been set up.

Thanks, Rob

-----Original Message----- From: cour...@lists.sourceforge.net

[mailto:cour...@lists.sourceforge.net]On

Behalf Of John

Locke Sent: Wednesday, October 15, 2003 1:35 PM To: Chris Masters Cc: cour...@lists.sourceforge.net Subject: [maildropl] REJECT: instead of bounce (was"unknown user" if cannot connect to mysql)

Chris's patch brings up an issue I've been thinking about. I also have virtual users set up in MySQL (and will probably migrate to LDAP soon). I use Postfix as the MTA, and I'm trying to get DSPAM set up to filter spam before handing off to maildrop for delivery.

My question is, I think the way I have this set up, Postfix knows what domains to deliver to Dspam/Maildrop, but doesn't know what user accounts are valid until it attempts delivery. Unlike the Postfix "virtual" or "local" delivery agent, if the user doesn't exist for a domain handled by Maildrop, it's too late to REJECT the message because the connection to the sending MTA has already terminated. So by the time Maildrop can return an error, the MTA then has to bounce the message (back to a potentially forged source, if it's spam...).

Am I overlooking anything here? I don't think this is an issue with local users, because the MTA gets those out of the alias table. But for virtual domains, I'm seeing lots of bounces in my logs to non-existent users.

I'm thinking the best solution might be some sort of recipient check in the MTA that first verifies the validity of the virtual user account, before handing off to Maildrop. Is anybody doing something like this? Seems like the downside is an extra call to the database--the MTA and Maildrop both query for pretty much the same thing. Anybody have an elegant solution?

Cheers, John

Chris Masters wrote:

I use maildrop to deliver mails to virtual users located in MySQL.(from Postfix).

If maildrop cannot connect to the database it returns "unknown user" instead of a 451 (tempfail) error code:

Oct 14 14:35:48 lon-quar-01 postfix/pipe[2044]:

[ID

197553 mail.info] A79E2D7388: to=<roti...@wardrobes.co.uk>, relay=maildrop, delay=55, status=bounced (user unknown. Command output: Could not connect to database 192.168.0.30 Could not connect to database 192.168.0.31 Invalid user specified. )

This SF.net email is sponsored by: SF.net Giveback Program. SourceForge.net hosts over 70,000 Open Source Projects. See the people who have HELPED US provide better services: Click here: http://sourceforge.net/supporters.php

https://lists.sourceforge.net/lists/listinfo/courier-maildrop

	Start a set with this search
	Include this search in one of my sets
	Exclude this search from one of my sets
	Permalink to these results Paste this link in email or IM:
	Atom feed for tracking future search results Paste this URL into your reader: