I urgently need help ... all mails will be bounced!

Use this forum for questions regarding installation, upgrading and configuration of OpenEMM

Moderator: moderator

Martin1987
Posts: 7
Joined: Wed Dec 23, 2009 10:33 am

I urgently need help ... all mails will be bounced!

Post by Martin1987 » Wed Dec 23, 2009 11:14 am

Hi all,

I need your help! I am from Germany ... forgive me my bad English!

My boss has bought me OpenEMM with DVD and manual to test. I know myself unfortunately not well with Linux, so I wanted to try first the finished image with pre-installed Linux (Red Hat Enterprise Linux 4) for the VMware-Player from the DVD.

I've done everything as it is in the manual, everything has worked out perfectly, I come without problems in the Web interface.

Then I wanted to try the example to send emails after creating a test mailing list, some test receiver and a test mailing. According to the program, the mails are created, but all are in the statistics as Bounced.

Not a single mail arrives! Why might that be? :cry:

In the file "var/log/...-openemm-pickdist.log" stands quite often...

Code: Select all

4487 VERBOSE/loop: No ready to send data file found
The number at the top varies.

Thanks for your help!!!

Martin

pheelix
Posts: 101
Joined: Thu Nov 20, 2008 4:34 pm
Location: Dresden, Germany
Contact:

Post by pheelix » Wed Dec 30, 2009 9:27 am


Martin1987
Posts: 7
Joined: Wed Dec 23, 2009 10:33 am

Post by Martin1987 » Tue Jan 05, 2010 9:40 am

SqiSch wrote:Hi,

i have several problems with my openEMM installation.

when i send mailings i become this message:

Bereits produzierte E-Mails: 3,400
Bereits versendete E-Mails: 0
E-Mails gesamt: 3,400

my python mysql module is installed.

the pickdist log says me:
[23.04.2007 21:00:00] 15072 VERBOSE/loop: No ready to send data file found
[23.04.2007 21:00:31] 15072 VERBOSE/loop: No ready to send data file found
[23.04.2007 21:01:02] 15072 VERBOSE/loop: No ready to send data file found


i have also errors in the update.log:
[23.04.2007 21:12:07] 16194 ERROR/loop: Unable to get database cursor
[23.04.2007 21:12:37] 16194 ERROR/loop: Unable to get database cursor
[23.04.2007 21:13:07] 16194 ERROR/loop: Unable to get database cursor


when i make a :

Code: Select all

......
>>> import agn
>>> db = agn.DBase ()
>>> db
<agn.DBase instance at 0x401e90cc>
>>> db.lasterr.args
CAUGHT EXCEPTION:
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
AttributeError: 'NoneType' object has no attribute 'args'

>>>
 
can anyone help me please?


Marcel

Solution:

Debian set the Option:
old_passwords = true
for the mysql my.cf

Comment it out and set a new password for the agnitas user with: SET PASSWORD FOR 'agnitas'@'localhost' = OLD_PASSWORD('openemm');

It still does not work! Unfortunately, I do not quite understand how the posted solution should be exactly work. Can someone tell me for stupid people? I also have (as far as I could see that) no database errors!

Meanwhile I have tried many tips from the forum, fully updated Linux, installed the python module again, and much more. But it is really nonsense, because the Linux with OpenEMM is already fully pre-installed and should run without modifications (at least for simple tests).

Every mail will be sent but comes as a hardbounce back with the reason 'unknown address'!

Please help me!
Thank you!
Martin

pheelix
Posts: 101
Joined: Thu Nov 20, 2008 4:34 pm
Location: Dresden, Germany
Contact:

Post by pheelix » Tue Jan 05, 2010 6:26 pm

what does your mail-log say? (/var/log/maillog)
are the correct recipients adressed there?
old_passwords = true
for the mysql my.cf

Comment it out and set a new password for the agnitas user with: SET PASSWORD FOR 'agnitas'@'localhost' = OLD_PASSWORD('openemm');
go into the my.cf (i think its in /etc or /etc/mysql)
and add a # in front of the line "old_passwords = true"

close the file.

start the mysql-command-line-interface, like:

Code: Select all

mysql -u root -p openemm
and run

Code: Select all

SET PASSWORD FOR 'agnitas'@'localhost' = OLD_PASSWORD('openemm');

Martin1987
Posts: 7
Joined: Wed Dec 23, 2009 10:33 am

Post by Martin1987 » Thu Jan 07, 2010 10:26 am

Many many thanks for your help, pheelix!

Back to the top: it says my mail-log:
First:

Code: Select all

openemm sendmail[2573]: alias database /etc/aliases rebuilt by root
openemm sendmail[2573]: /etc/aliases: 78 aliases, longest 10 bytes, 802 bytes total
openemm sendmail[2578]: starting daemon (8.13.1): SMTP+queueing@01:00:00
openemm sm-msp-queue[2586]: starting daemon (8.13.1): queueing@01:00:00
openemm sendmail[2591]: o047xjJk002591: Milter (bav): error connecting to filter: Connection refused by /home/openemm/var/run/bav.sock
openemm sendmail[2591]: o047xjJk002591: Milter (bav): to error state
openemm sendmail[2591]: o047xjJk002591: Milter: initialization failed, temp failing commands

openemm sm-msp-queue[2587]: nBNB3JRK003630: to=root, ctladdr=root (0/0) delay=11+20:56:26, xdelay=00:00:00, mailer=relay, pri=121442, relay=[127.0.0.1] [127.0.0.1], dsn=4.0.0, stat=Deferred: 451 4.3.2 Please try again later
openemm sm-msp-queue[2587]: nBNB3JRK003630: o047xjmi002587: DSN: Cannot send message for 5 days
and then either for example:

Code: Select all

openemm sendmail[6465]: 00000400000000002: to=<blabla@gmx.de>, delay=11+23:58:39, xdelay=00:00:05, mailer= esmtp, pri=360000, relay=mx0.gmx.net. [213.165.64.100], dsn=4.0.0, stat=Deferred: Connection reset by mx0.gmx.net.
or:

Code: Select all

openemm sendmail[6619]: STARTTLS=client, relay=mx.freenet.de., version=TLSv1/SSLv3, verify=FAIL, cipher=AES256-SHA, bits=256/256
openemm sendmail[6619]: 19d3T06cf00000002: to=<blabla@freenet.de>, delay=00:00:42, xdelay=00:00:00, mailer=esmtp, pri=0, relay=mx.freenet.de. [195.4.92.211], dsn=5.1.1, stat= User unknow
The registered e-mail addresses are actually all right as far as I've seen.


Then I did it with the password. But for me there was no file called my.cf, but one that was my.cnf. In this file there was no entry named "old_passwords = true", only "old_passwort=1". The mysql-command ("SET PASSWORD FOR 'agnitas'@'localhost' = OLD_PASSWORD('openemm');") showed:

Code: Select all

Query OK, 0 rows affected
:(

And now?
Thank you!
Martin

pheelix
Posts: 101
Joined: Thu Nov 20, 2008 4:34 pm
Location: Dresden, Germany
Contact:

Post by pheelix » Thu Jan 07, 2010 1:32 pm

here is an article about Debugging the OpenEMM Bounce Handling Setup
http://lzone.de/?q=node/8
openemm sendmail[6465]: 00000400000000002: to=<blabla@gmx.de>, delay=11+23:58:39, xdelay=00:00:05, mailer= esmtp, pri=360000, relay=mx0.gmx.net. [213.165.64.100], dsn=4.0.0, stat=Deferred: Connection reset by mx0.gmx.net.
do you use a FQDN? most of the mailservers accept emails only from servers with a fqdn. emails from a server without fqdn are often blocked for spampurposes.
openemm sendmail[6619]: STARTTLS=client, relay=mx.freenet.de., version=TLSv1/SSLv3, verify=FAIL, cipher=AES256-SHA, bits=256/256
openemm sendmail[6619]: 19d3T06cf00000002: to=<blabla@freenet.de>, delay=00:00:42, xdelay=00:00:00, mailer=esmtp, pri=0, relay=mx.freenet.de. [195.4.92.211], dsn=5.1.1, stat= User unknow
says 'User unknow' so seems that the mailbox for the user blabla does not exist?

Martin1987
Posts: 7
Joined: Wed Dec 23, 2009 10:33 am

Post by Martin1987 » Thu Jan 07, 2010 2:34 pm

A FQDN? Unfortunately I do not know what you mean! Can you tell me how can I set it?

And the user blabla was just one example. All e-mail address to which I wanted to send yet, were my own. That the mailbox does not exist, is not true!

But have you seen in the log file also records:

Code: Select all

openemm sendmail[2591]: o047xjJk002591: Milter (bav): error connecting to filter: Connection refused by /home/openemm/var/run/bav.sock
openemm sendmail[2591]: o047xjJk002591: Milter (bav): to error state
openemm sendmail[2591]: o047xjJk002591: Milter: initialization failed, temp failing commands 

openemm sm-msp-queue[2587]: nBNB3JRK003630: to=root, ctladdr=root (0/0) delay=11+20:56:26, xdelay=00:00:00, mailer=relay, pri=121442, relay=[127.0.0.1] [127.0.0.1], dsn=4.0.0, stat=Deferred: 451 4.3.2 Please try again later
openemm sm-msp-queue[2587]: nBNB3JRK003630: o047xjmi002587: DSN: Cannot send message for 5 days
That is not normal! There's something wrong. I will read the article about Debugging the OpenEMM Bounce Handling Setup, thank you!

pheelix
Posts: 101
Joined: Thu Nov 20, 2008 4:34 pm
Location: Dresden, Germany
Contact:

Post by pheelix » Thu Jan 07, 2010 2:44 pm

Fully Qualified Domain Name means that your domain has a dns-record for your server. like "newsletter.yourdomain.com" -> 'newsletter' is the name of the server, 'yourdomain.com' is your domainname together with the topleveldomain.
openemm sm-msp-queue[2587]: nBNB3JRK003630: to=root, ctladdr=root (0/0) delay=11+20:56:26, xdelay=00:00:00, mailer=relay, pri=121442, relay=[127.0.0.1] [127.0.0.1], dsn=4.0.0, stat=Deferred: 451 4.3.2 Please try again later
i am not sure but i think "mailer=relay" and relay=localhost coul be another mistake, because afaik a relay is a different server used to send your emails.

Martin1987
Posts: 7
Joined: Wed Dec 23, 2009 10:33 am

Post by Martin1987 » Thu Jan 07, 2010 3:37 pm

Where can I set the FQDN?

Have you any idea what I could now be done to make it work?

I do not understand it at all!
As I said, I have the VM-Player on Windows Vista to use the pre-installed Linux Red Hat with OpenEMM. According to the manual it should work without any adjustments.

But it does not!
:?

pheelix
Posts: 101
Joined: Thu Nov 20, 2008 4:34 pm
Location: Dresden, Germany
Contact:

Post by pheelix » Thu Jan 07, 2010 4:22 pm

it does work, as a test-environment,
but when you have a normal dial-up internet / adsl - connection with a dynamic ip, almost none of the providers will accept your emails (i never tried it with dyndns).

otherwise you can send mails only within your LAN, when your mailserver accepts it. and the ip-adress of the vm must be configured for your net.
(in /etc/sysconfig/network-scripts/ifcfg-ethX for centos & redhat, i guess)

how to set a fqdn in redhat:
To change the FQDN (fully qualified domain name) of a Red hat linux server, add the line
HOSTNAME=SERVER_FQDN
To the file /etc/sysconfig/network, making sure to remove any other line that starts with HOSTNAME=. The server’s hostname will be updated after a restart.

from http://www.servepath.com/support/redhat ... cklist.php
but before you can do this, you need to add an 'A-Record' to your dns-zone. and your server needs an official ip.

Martin1987
Posts: 7
Joined: Wed Dec 23, 2009 10:33 am

Post by Martin1987 » Fri Jan 08, 2010 9:06 am

Slowly, buddy!

It now sounds logical, but that it does not work on a normal adsl internet connection with a dynamic IP, I do not know :? ! And it stands also not in the manual.

It seems to me that you would know about it. My knowledge in Linux is fairly low and I have to do besides many other things.
To find out how to do it all, I had to look long. Would you perhaps so nice, and would in terms of 'A-Record' and official IP help me make it work?

You're the best!
I thank you ...
:)

pheelix
Posts: 101
Joined: Thu Nov 20, 2008 4:34 pm
Location: Dresden, Germany
Contact:

Post by pheelix » Fri Jan 08, 2010 9:14 am

It now sounds logical, but that it does not work on a normal adsl internet connection with a dynamic IP, I do not know Confused ! And it stands also not in the manual.
it does work, but the providers dont accept it because this is a potential source for spam.

Post Reply