On 3 Jul 2009, at 10:17, Warren Baker wrote:
> 2009/7/3 Jonathan Gilpin <jonathan@???>
> Hi,
>
> I have been setting up a catchall system on my exim server.
>
> I have a mysql table with users in for example. postmaster@???
> and then the following setup:
>
> mysql_aliases:
> driver = redirect
> file_transport = address_file
> pipe_transport = address_pipe
> data = ${lookup mysql{SELECT destination FROM aliases,emailtable
> WHERE emailtable.email = aliases.destination and (aliases.address = '$
> {quote_mysql:$local_part}@${quote_mysql:$domain}' or aliases.address =
> '*@${quote_mysql:$domain}')}}
>
> This has an alias of *@domain.com to postmaster@??? to create a
> catchall...
>
> However, with this setup, duplicate mails are dropped.. so if someone
> sends an email to bob@???,eggs@??? then only one message
> is delivered with Two addresses on the Envelope-to field..
>
> How can I modify this so that two seperate messages are delivered to
> the Maildir? I need this method to work as I am delivering the
> messages via SMTP from the Maildir to Exchange Servers.
>
>
> How are you delivering from maildir to the exchange servers? Both
> envelope-to addresses should be sent in the SMTP session when
> delivering to the exchange server.
I'm using serialmail and a fifo socket and some bridging code.. But
thats not the issue. The issue is I want seperate emails delivered to
the Maidlir with a single Envelope-To instead
fo one email with multple addresses seperated by a comma for the
Envelope To.
JonathanFrom awd@??? Thu Jul 02 12:36:53 2009
Envelope-to: exim-users@???
Received: from ppp234-119.static.internode.on.net ([203.122.234.119]:62298
helo=home.awdcomp.net) by tahini.csx.cam.ac.uk with esmtp (Exim 4.69)
(envelope-from <awd@???>) id 1MMKas-0004aT-NI
for exim-users@???; Thu, 02 Jul 2009 12:36:53 +0100
Received: from getafix.abdulla ([192.168.202.99] helo=[127.0.0.1])
by home.awdcomp.net with esmtp (Exim 4.69 (FreeBSD))
(envelope-from <awd@???>)
id 1MMKaf-0006DN-7l; Thu, 02 Jul 2009 21:06:40 +0930
Message-ID: <4A4C9BC1.9030901@???>
Date: Thu, 02 Jul 2009 21:06:33 +0930
From: Andrew <awd@???>
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
To: Mike Cardwell <exim-users@???>
References: <6fb3dd4a0907020156y3f6a0138sdf2acf08e5a8b022@???> <4A4C8910.6070309@???> <b245e6760907020408m13b8c6b3t1a745b52aa738966@???>
<4A4C987B.7020902@???>
In-Reply-To: <4A4C987B.7020902@???>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 090701-0, 01/07/2009), Outbound message
X-Antivirus-Status: Clean
X-Spam-Report: Spam detection software, running on the system "gateway.abdulla",
has
identified this incoming email as possible spam. The original message
has been attached to this so you can view it (if it isn't spam) or
label similar future email. If you have any questions, see
The administrator of that system for details.
Content preview: Mike Cardwell wrote: > Joan wrote: > --snip-- > FYI,
if you
want to apply "country" based rules to incoming connections, > there are
dnsbl's that map IPs to countries. Eg,
to accept mail from > hosts in the
UK and France: > > accept dnslists = uk.countries.nerd.dk :
fr.countries.nerd.dk
> > countries.nerd.dk also let you download their full data set in
rbldns
> format (and other formats I think) so you can create your own local
dnsbl. > [...]
Content analysis details: (-1.4 points, 5.0 required)
pts rule name description
---- ----------------------
--------------------------------------------------
-1.4 ALL_TRUSTED Passed through trusted hosts only via SMTP
X-Spam-Score: -13 (-)
X-Spam-Score: -2.6 (--)
X-Spam-Status: No, score=-2.6 required=5.0 tests=BAYES_00=-1.5, EXIM_ACL=-1.2,
FORGED_RCVD_HELO=0.135 autolearn=ham version=3.1.8
X-Mailman-Approved-At: Fri, 03 Jul 2009 11:28:47 +0100
Cc: Exim Users List <exim-users@???>,
Joan <aseques@???>
Subject: Re: [exim] blocking on failure of reverse_host_lookup
X-BeenThere: exim-users@???
X-Mailman-Version: 2.1.9
Precedence: list
List-Id: A user list for the exim MTA <exim-users.exim.org>
List-Unsubscribe: <http://lists.exim.org/mailman/listinfo/exim-users>,
<mailto:exim-users-request@exim.org?subject=unsubscribe>
List-Archive: <http://lists.exim.org/lurker/list/exim-users.html>
List-Post: <mailto:exim-users@exim.org>
List-Help: <mailto:exim-users-request@exim.org?subject=help>
List-Subscribe: <http://lists.exim.org/mailman/listinfo/exim-users>,
<mailto:exim-users-request@exim.org?subject=subscribe>
X-List-Received-Date: Thu, 02 Jul 2009 11:36:53 -0000
Mike Cardwell wrote:
> Joan wrote:
>
--snip--
> FYI, if you want to apply "country" based rules to incoming connections,
> there are dnsbl's that map IPs to countries. Eg, to accept mail from
> hosts in the UK and France:
>
> accept dnslists = uk.countries.nerd.dk : fr.countries.nerd.dk
>
> countries.nerd.dk also let you download their full data set in rbldns
> format (and other formats I think) so you can create your own local dnsbl.
>
There is also another option using geoip tools using the maxmind.com
database.
http://www.maxmind.com/app/geoip_country
Completely free. one download a month, so no thousands of DNS queries
and you no longer have to maintain a list of country IPs.
I am using the perl API and have been for at least 4 years with no
issues as all :)
HTH
cya
Andrew
