Bounces wont count

Use this forum for all questions related to bounce management of OpenEMM

Moderator: moderator

Bounces wont count

Postby dreamy » Fri Aug 31, 2012 7:22 pm

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?
dreamy
 
Posts: 19
Joined: Sat Aug 18, 2012 8:18 pm

Re: Bounces wont count

Postby maschoff » Sun Sep 02, 2012 11:11 am

I just tried it and it worked fine for me. Maybe you can provide some more info to allow us to reproduce your problem?
OpenEMM Maintainer
maschoff
Site Admin
 
Posts: 2131
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany

Re: Bounces wont count

Postby dreamy » Sun Sep 02, 2012 8:11 pm

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
dreamy
 
Posts: 19
Joined: Sat Aug 18, 2012 8:18 pm

Re: Bounces wont count

Postby maschoff » Mon Sep 03, 2012 6:24 am

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?
OpenEMM Maintainer
maschoff
Site Admin
 
Posts: 2131
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany

Re: Bounces wont count

Postby dreamy » Mon Sep 03, 2012 7:16 am

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!
dreamy
 
Posts: 19
Joined: Sat Aug 18, 2012 8:18 pm

Re: Bounces wont count

Postby dreamy » Mon Sep 03, 2012 8:04 am

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.
dreamy
 
Posts: 19
Joined: Sat Aug 18, 2012 8:18 pm

Re: Bounces wont count

Postby dreamy » Wed Sep 05, 2012 11:43 am

Any Idear??
dreamy
 
Posts: 19
Joined: Sat Aug 18, 2012 8:18 pm

Re: Bounces wont count

Postby maschoff » Tue Sep 25, 2012 3:07 pm

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.
OpenEMM Maintainer
maschoff
Site Admin
 
Posts: 2131
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany


Return to Bounce Management

Who is online

Users browsing this forum: No registered users and 1 guest

cron