From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1GaxTv-0002PZ-IT for garchives@archives.gentoo.org; Fri, 20 Oct 2006 16:44:28 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.8/8.13.6) with SMTP id k9KGfNTu027341; Fri, 20 Oct 2006 16:41:23 GMT Received: from popmail.jettissystems.com (popmail.jettissystems.com [38.118.146.212]) by robin.gentoo.org (8.13.8/8.13.6) with ESMTP id k9KGcsaX021729 for ; Fri, 20 Oct 2006 16:38:55 GMT Received: from [10.23.0.120] (unknown [74.93.11.97]) by popmail.jettissystems.com (Postfix) with ESMTP id 8589656D484 for ; Fri, 20 Oct 2006 09:38:53 -0700 (PDT) Message-ID: <4538FB86.7060305@badapple.net> Date: Fri, 20 Oct 2006 09:38:30 -0700 From: kashani User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] postfix .. transports .. and virtual domains .. References: <20061019192507.465ead11@yoda.foad.za.net> <4537F157.8090601@badapple.net> <20061020085707.6b81bb8f@yoda.foad.za.net> In-Reply-To: <20061020085707.6b81bb8f@yoda.foad.za.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Archives-Salt: 6a5a9a5c-760b-4e20-9711-aa43461644f4 X-Archives-Hash: 56105dbc11fbe669472a80ac8d24de17 Henti Smith wrote: > This does not work. mail gets delivered to maildir as per account setup > not the transport service where it's being procesed for spam. > > All I really need to do is tell postfix to accept any mail for spam@ > and ham@ I don't need it delivered anywhere as the transport works fine > on localhost, it's just smtp deliveries that gives me problems. > If I read your original email right, you're using db driven virtual domains, mailboxes, and aliases for your users. Is that correct? Assuming it is then you'll need to shuffle mail around a bit to get things to work. All the dspam howto's I looked at do not take db based virtual users into account so they are going to be no help. Let's say you've got this: domains type virtualdomain.com virtual: localdomain.com local: Alias goto spam@virtualdomain.com -> spam@localdomain.com ham@virtualdomain.com -> ham@localdomain.com Then the path through your system would be Postfix -> mysql -> virtualdomain -> mysql -> virtual user -> localdomain -> transport table -> dspam I did something similar with sending things to /dev/null which didn't work with the virtual stuff. The other possibility is to sit down with phpmyadmin (or postgres) and change your db query in mysql_virtual_alias_maps.cf from query = SELECT goto FROM alias WHERE address='%s' to something that uses a like spam@% or like ham@% to return to the local addresses as well as doing the original query. This is definitely possible with Postfix as I do some fairly extreme Mysql queries for an email upload system, but significantly harder depending on how well you know sql. You might search around a bit and see if anyone has posted some pattern matching Postfix/Mysql queries... I had the DBA write the complex ones we user which are not solving the same problem you are. kashani -- gentoo-user@gentoo.org mailing list