Page 1 of 1

Bounces wont count

Posted: Fri Aug 31, 2012 7:22 pm
by dreamy
Hello,

i have finshed the setup.

I could, send Newsletter.

The bouncefilter works(?) --> a answer to the Newsletter will activate the auto-response and forwarded to my mailaccount.

But a non-existing mailadress should response a bounce, but no soft- or hardbounce are recorded.

Whats wrong?

Re: Bounces wont count

Posted: Sun Sep 02, 2012 11:11 am
by maschoff
I just tried it and it worked fine for me. Maybe you can provide some more info to allow us to reproduce your problem?

Re: Bounces wont count

Posted: Sun Sep 02, 2012 8:11 pm
by dreamy
Hello,

here are my config files:

/etc/hosts

Code: Select all

127.0.0.1	localhost
127.0.1.1	120.giga-dns.com	120
xx.xxx.xx.xxx	host.my-domain.net	host

# The following lines are desirable for IPv6 capable hosts
::1     ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
/etc/mail/aliases

Code: Select all

postmaster:	root
MAILER-DAEMON:	postmaster
abuse:		postmaster
spam:		postmaster
/etc/mail/local-host-names

Code: Select all

localhost
/etc/mail/mailertable

Code: Select all

news.my-domain.net	procmail:/home/openemm/conf/bav/bav.rc
/etc/mail/relay-domains

Code: Select all

news.my-domain.net
/etc/mail/trusted-users and /etc/mail/virtusertable are empty.

/etc/mail/sendmail.mc

Code: Select all

define(`_USE_ETC_MAIL_')dnl
include(`/usr/share/sendmail/cf/m4/cf.m4')dnl
VERSIONID(`$Id: sendmail.mc, v 8.14.3-9.4 2010-09-21 11:05:34 cowboy Exp $')
OSTYPE(`debian')dnl
DOMAIN(`debian-mta')dnl
dnl # Items controlled by /etc/mail/sendmail.conf - DO NOT TOUCH HERE
undefine(`confHOST_STATUS_DIRECTORY')dnl        #DAEMON_HOSTSTATS=
dnl # Items controlled by /etc/mail/sendmail.conf - DO NOT TOUCH HERE
dnl #
dnl # General defines
dnl #
dnl # SAFE_FILE_ENV: [undefined] If set, sendmail will do a chroot()
dnl #   into this directory before writing files.
dnl #   If *all* your user accounts are under /home then use that
dnl #   instead - it will prevent any writes outside of /home !
dnl #   define(`confSAFE_FILE_ENV',             `')dnl
dnl #
dnl # Daemon options - restrict to servicing LOCALHOST ONLY !!!
dnl # Remove `, Addr=' clauses to receive from any interface
dnl # If you want to support IPv6, switch the commented/uncommentd lines
dnl #
FEATURE(`no_default_msa')dnl
FEATURE(`mailertable', `hash -o /etc/mail/mailertable.db')dnl
dnl DAEMON_OPTIONS(`Family=inet6, Name=MTA-v6, Port=smtp, Addr=::1')dnl
DAEMON_OPTIONS(`Family=inet,  Name=MTA-v4, Port=smtp')dnl
dnl DAEMON_OPTIONS(`Family=inet6, Name=MSP-v6, Port=submission, M=Ea, Addr=::1')dnl
DAEMON_OPTIONS(`Family=inet,  Name=MSP-v4, Port=submission, M=Ea, Addr=127.0.0.1')dnl
dnl #
dnl # Be somewhat anal in what we allow
define(`confPRIVACY_FLAGS',dnl
`needmailhelo,needexpnhelo,needvrfyhelo,restrictqrun,restrictexpand,nobodyreturn,authwarnings')dnl
dnl #
dnl # Define connection throttling and window length
define(`confCONNECTION_RATE_THROTTLE', `15')dnl
define(`confCONNECTION_RATE_WINDOW_SIZE',`10m')dnl
dnl #
dnl # Features
dnl #
dnl # use /etc/mail/local-host-names
FEATURE(`use_cw_file')dnl
FEATURE(`virtusertable')dnl
dnl #
dnl # The access db is the basis for most of sendmail's checking
FEATURE(`access_db', , `skip')dnl
dnl #
dnl # The greet_pause feature stops some automail bots - but check the
dnl # provided access db for details on excluding localhosts...
FEATURE(`greet_pause', `1000')dnl 1 seconds
dnl #
dnl # Delay_checks allows sender<->recipient checking
FEATURE(`delay_checks', `friend', `n')dnl
dnl #
dnl # If we get too many bad recipients, slow things down...
define(`confBAD_RCPT_THROTTLE',`3')dnl
dnl #
dnl # Stop connections that overflow our concurrent and time connection rates
FEATURE(`conncontrol', `nodelay', `terminate')dnl
FEATURE(`ratecontrol', `nodelay', `terminate')dnl
dnl #
dnl # If you're on a dialup link, you should enable this - so sendmail
dnl # will not bring up the link (it will queue mail for later)
dnl define(`confCON_EXPENSIVE',`True')dnl
dnl #
dnl # Dialup/LAN connection overrides
dnl #
include(`/etc/mail/m4/dialup.m4')dnl
include(`/etc/mail/m4/provider.m4')dnl
dnl #
dnl # Default Mailer setup
define(`PROCMAIL_MAILER_PATH',`/usr/bin/procmail')dnl
define(`LOCAL_MAILER_FLAGS', `ShPfn')dnl
define(`LOCAL_MAILER_ARGS', `procmail -a $h -d $u')dnl
FEATURE(`local_procmail')dnl
MAILER_DEFINITIONS
MAILER(`local')dnl
MAILER(`smtp')dnl
MAILER(`procmail')dnl
dnl #
dnl # Masquerading options
dnl FEATURE(`always_add_domain')dnl
dnl MASQUERADE_AS(`vmd2080.giga-dns.com')dnl
dnl FEATURE(`allmasquerade')dnl
dnl FEATURE(`masquerade_envelope')dnl
dnl #
INPUT_MAIL_FILTER(`bav', `S=unix:/home/openemm/var/run/bav.sock, F=T')dnl
My System is a Debian 6 (64 bit) and I had build OpenEMM by my self.

DNS/ host -a my-domain.net

Code: Select all

my-domain.net	86400	IN	A	xx.xxx.xx.xxx
my-domain.net	86400	IN	MX	10 news.my-domain.net
news.my-domain.net	86400	IN	A	xx.xxx.xx.xxx
/home/openemm/conf/bav/bav.conf-local

Code: Select all

newsletter@news.my-domain.net	alias:ext_1@news.my-domain.net
In the mailing I set the sender- and reply-adress to newsletter@news.my-domain.net

newsletter@news.my-domain.net does not exist on the Server and ext_1@news.my-domain.net is the mailadresse the Bouncefilter use.

The Bouncefilter also auto-replys and forworded answers to the mailing to my.user@my-domain.net. my.user is an existing user with a mailbox and could receive emails.


THX

Re: Bounces wont count

Posted: Mon Sep 03, 2012 6:24 am
by maschoff
Your configuration looks ok to us. Two ideas:

1. Python can not connect with the MySQL database (but this would mean that all other Python processes can not connect to MySQL as well and is, therefore, unlikely).

2. The bounce text has a pattern which is not recognized by the ruleset in file ~/conf/bav.rule. Could you manually reproduce the bounce and post its content here?

Re: Bounces wont count

Posted: Mon Sep 03, 2012 7:16 am
by dreamy
Thank you!

Here is a Mail send from root@news.my-domain.net to notexist@my-other-domain.com

Code: Select all

Date: Mon, 3 Sep 2012 07:52:24 +0200
From: Mail Delivery Subsystem <MAILER-DAEMON>
To: root@my-domain.net
Subject: Returned mail: see transcript for details

[-- Attachment #1 --]
[-- Type: text/plain, Encoding: 7bit, Size: 0.5K --]

The original message was received at Mon, 3 Sep 2012 07:52:23 +0200
from localhost [127.0.0.1]

   ----- The following addresses had permanent fatal errors -----
<notexist@my-other-domain.com>
    (reason: 550 unknown user)

   ----- Transcript of session follows -----
... while talking to mail.juwelier-shop24.com.:
>>> DATA
<<< 550 unknown user
550 5.1.1 <notexist@my-other-domain.com>... User unknown
<<< 503-All RCPT commands were rejected with this error:
<<< 503-unknown user
<<< 503 Valid RCPT command must precede DATA

[-- Attachment #2 --]
[-- Type: message/delivery-status, Encoding: 7bit, Size: 0.3K --]

Reporting-MTA: dns; my-domain.net
Received-From-MTA: DNS; localhost
Arrival-Date: Mon, 3 Sep 2012 07:52:23 +0200

Final-Recipient: RFC822; notexist@my-other-domain.com
Action: failed
Status: 5.1.1
Remote-MTA: DNS; mail.my-other-domain.com
Diagnostic-Code: SMTP; 550 unknown user
Last-Attempt-Date: Mon, 3 Sep 2012 07:52:24 +0200

[-- Attachment #3 --]
[-- Type: text/rfc822-headers, Encoding: 7bit, Size: 0.7K --]

Return-Path: <root@my-domain.net>
Received: from my-domain.net (localhost [127.0.0.1])
        by my-domain.net (8.14.3/8.14.3/Debian-9.4) with ESMTP id
+q835qNj2004380
        for <notexist@my-other-domain.com>; Mon, 3 Sep 2012 07:52:23 +0200
Received: (from root@localhost)
        by my-domain.net (8.14.3/8.14.3/Submit) id q835qN1W004379
        for notexist@my-other-domain.com; Mon, 3 Sep 2012 07:52:23 +0200
Date: Mon, 3 Sep 2012 07:52:23 +0200
From: root <root@news.my-domain.net>
To: notexist@my-other-domain.com
Subject: test
Message-ID: <20120903055223.GA4343@news.my-domain.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.5.20 (2009-06-14)
And this email was send from my.user@news.my-domain.net to notexist@my-other-domain.com

Code: Select all

Date: Mon, 3 Sep 2012 08:04:51 +0200
From: Mail Delivery Subsystem <MAILER-DAEMON>
To: my.user@my-domain.net
Subject: Returned mail: see transcript for details

[-- Attachment #1 --]
[-- Type: text/plain, Encoding: 7bit, Size: 0.5K --]

The original message was received at Mon, 3 Sep 2012 08:04:51 +0200
from localhost [127.0.0.1]

   ----- The following addresses had permanent fatal errors -----
<notexist@my-other-domain.com>
    (reason: 550 unknown user)

   ----- Transcript of session follows -----
... while talking to mail.my-other-domain.com.:
>>> DATA
<<< 550 unknown user
550 5.1.1 <notexist@my-other-domain.com>... User unknown
<<< 503-All RCPT commands were rejected with this error:
<<< 503-unknown user
<<< 503 Valid RCPT command must precede DATA

[-- Attachment #2 --]
[-- Type: message/delivery-status, Encoding: 7bit, Size: 0.3K --]

Reporting-MTA: dns; my-domain.net
Received-From-MTA: DNS; localhost
Arrival-Date: Mon, 3 Sep 2012 08:04:51 +0200

Final-Recipient: RFC822; notexist@my-other-domain.com
Action: failed
Status: 5.1.1
Remote-MTA: DNS; mail.my-other-domain.com
Diagnostic-Code: SMTP; 550 unknown user
Last-Attempt-Date: Mon, 3 Sep 2012 08:04:51 +0200

[-- Attachment #3 --]
[-- Type: text/rfc822-headers, Encoding: 7bit, Size: 0.7K --]

Return-Path: <my.user@my-domain.net>
Received: from my-domain.net (localhost [127.0.0.1])
        by my-domain.net (8.14.3/8.14.3/Debian-9.4) with ESMTP id
+q8364p8w004484
        for <notexist@my-other-domain.com>; Mon, 3 Sep 2012 08:04:51 +0200
Received: (from my.user@localhost)
        by my-domain.net (8.14.3/8.14.3/Submit) id q8364pux004482
        for notexist@my-other-domain.com; Mon, 3 Sep 2012 08:04:51 +0200
Date: Mon, 3 Sep 2012 08:04:51 +0200
From: Markus Rauth <my.user@news.my-domain.net>
To: notexist@my-other-domain.com
Subject: Test
Message-ID: <20120903060451.GA4464@news.my-domain.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.5.20 (2009-06-14)
my-other.domain.com is an registered domain with a MX-record to mail.my-other-domain.com.

These Mail are filtered and wont be in the mailbox, if I send my mailing.

Thanks for the time!

Re: Bounces wont count

Posted: Mon Sep 03, 2012 8:04 am
by dreamy
Hello,

I have found this Python-Script and tested the connection to MySql:

Code: Select all

#!/usr/bin/python
import sys
import MySQLdb

my_host = "localhost"
my_user = "user"
my_pass = "password"
my_db = "test_db"

try:
    db = MySQLdb.connect(host=my_host, user=my_user, passwd=my_pass, db=my_db)
except MySQLdb.Error, e:
     print "Error %d: %s" % (e.args[0], e.args[1])
     sys.exit (1)

cursor = db.cursor()
sql = "select column1, column2 from `table`";
cursor.execute(sql)    
results = cursor.fetchall()
for row in results:
    column1 = row[0]
    column2 = row[1]
    print "column1: %s, column2: %s"%(column1,column2)

db.close()
I work! So I think the connection of Python and MySql are not the problem.

Re: Bounces wont count

Posted: Wed Sep 05, 2012 11:43 am
by dreamy
Any Idear??

Re: Bounces wont count

Posted: Tue Sep 25, 2012 3:07 pm
by maschoff
It looks like the original mail was not sent by OpenEMM because the AGN UID is missing. The AGN UID is needed by the bounce management to map the single mail to its recipient in the OpenEMM database.