public inbox for gentoo-user@lists.gentoo.org
 help / color / mirror / Atom feed
From: kashani <kashani-list@badapple.net>
To: gentoo-user@lists.gentoo.org
Subject: Re: [gentoo-user] postfix .. transports .. and virtual domains ..
Date: Fri, 20 Oct 2006 09:38:30 -0700	[thread overview]
Message-ID: <4538FB86.7060305@badapple.net> (raw)
In-Reply-To: <20061020085707.6b81bb8f@yoda.foad.za.net>

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



  reply	other threads:[~2006-10-20 16:44 UTC|newest]

Thread overview: 9+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2006-10-19 17:25 [gentoo-user] postfix .. transports .. and virtual domains Henti Smith
2006-10-19 21:42 ` kashani
2006-10-20  6:57   ` Henti Smith
2006-10-20 16:38     ` kashani [this message]
2006-10-19 22:53 ` Neil Bothwick
2006-10-20  7:02   ` Henti Smith
  -- strict thread matches above, loose matches on Subject: below --
2006-10-19 20:21 Sieb, Glenn E (Glenn)
2006-10-19 21:43 ` kashani
2006-10-19 22:09 Sieb, Glenn E (Glenn)

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=4538FB86.7060305@badapple.net \
    --to=kashani-list@badapple.net \
    --cc=gentoo-user@lists.gentoo.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox