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
next prev parent 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