No mails will be send

Jehu · Post by **Jehu** » Wed Jul 23, 2008 2:24 pm

Hi there,

for evaluation of OpenEMM is use the VMWare-Version of OpenEMM 5.4.0.
I've tested the subscribe-form (double-opt-in) and a confirmation mail was sent to me.

I've tested around also with the SOAP-Webservice (by using the OpenEMM PHP-Class).

Now, how ever - no more Mails will be send! I've searched the forums a long time but no answers according to my problem.

Finally i've found this in ~/var/log/redirection_stdout.log:

Code: Select all

23.07 (15:06:49) MailingImpl - Fire Campaign-Mail: java.lang.Exception: maildropStatusID is 0
2008-07-23 15:06:49,265 - Fire Campaign-Mail: java.lang.Exception: maildropStatusID is 0
23.07 (15:06:49) SendMailing - executeOperation: Mailing 3 to 18 failed
2008-07-23 15:06:49,266 - executeOperation: Mailing 3 to 18 failed
23.07 (15:06:49) OpenSessionInViewFilter - Closing single Hibernate Session in OpenSessionInViewFilter
DB-Exec: SELECT 1 FROM dual
DB-Exec: SELECT status_id, mailing_id FROM maildrop_status_tbl WHERE genstatus = 0 AND status_field = 'W' AND gendate < now() ORDER BY gendate

What is the reason of "java.lang.Exception: maildropStatusID is 0"?
Can anybody help me with this please?

Regards
Jehu

Jehu · Post by **Jehu** » Thu Jul 24, 2008 8:33 am

Today the ~/var/log/redirection_stdout.log says:

Code: Select all

Initial data read from database
DB-Exec: SELECT status_id FROM maildrop_status_tbl WHERE status_field = 'W' AND mailing_id = 3 ORDER BY status_id
Error configuration report:
	lowest maildrop_status_id is not mine (29) but 4
	total number of subscribers is less than 1 (0)

Mailgun fails with java.lang.Exception: Error reading ini file: java.lang.Exception: 	lowest maildrop_status_id is not mine (29) but 4
	total number of subscribers is less than 1 (0)

Help me please.

Regards
Jehu

Jehu · Post by **Jehu** » Fri Jul 25, 2008 1:48 pm

Today i've installed completely new:

CentOS 5.2
OpenEMM 5.5.0 (rpm)

Similar Error in var/log/20080725-localhost-mailgun.log

Code: Select all

[25.07.2008  16:00:00] DEBUG/dbase: DB-Exec: SELECT company_id, mailing_id, status_field, senddate, step, blocksize, genstatus FROM maildrop_status_tbl WHERE status_id = 5
[25.07.2008  16:00:00] DEBUG/dbase: DB-Updt: UPDATE maildrop_status_tbl SET genchange = now(), genstatus = 2 WHERE status_id = 5 AND genstatus = 1
[25.07.2008  16:00:00] DEBUG/dbase: DB-Exec: SELECT mailinglist_id, shortname, target_expression FROM mailing_tbl WHERE mailing_id = 3
[25.07.2008  16:00:00] DEBUG/dbase: DB-Exec: SELECT mediatype, param FROM mailing_mt_tbl WHERE mailing_id = 3
[25.07.2008  16:00:00] DEBUG/dbase: DB-Exec: SELECT url_id, full_url, MEASURE_TYPE FROM rdir_url_tbl WHERE company_id = 1 AND mailing_id = 3
[25.07.2008  16:00:00] DEBUG/dbase: DB-Exec: SELECT title_id, title, gender FROM title_gender_tbl WHERE title_id IN (SELECT title_id FROM title_tbl WHERE company_id = 1 OR company_id = 0 OR company_id IS null)
[25.07.2008  16:00:00] DEBUG/dbase: DB-Exec: SELECT * FROM customer_1_tbl WHERE 1 = 0
[25.07.2008  16:00:00] DEBUG/dbase: DB-Exec: SELECT col_name, shortname FROM customer_field_tbl WHERE company_id = 1
[25.07.2008  16:00:00] DEBUG/dbase: DB-Exec: SELECT shortname, xor_key, rdir_domain FROM company_tbl WHERE company_id = 1
[25.07.2008  16:00:00] DEBUG/dbase: DB-Exec: SELECT count(distinct(customer_id)) FROM customer_1_binding_tbl bind WHERE mailinglist_id = 1 AND user_status = 1
[25.07.2008  16:00:00] DEBUG/dbase: DB-Updt: DELETE FROM mailing_status_tbl WHERE mailing_id=3
[25.07.2008  16:00:00] DEBUG/dbase: DB-Updt: INSERT INTO mailing_status_tbl (mailing_id, status_text) VALUES ( 3 , 'generating in progress' )
[25.07.2008  16:00:00] DEBUG/init: Initial data read from database
[25.07.2008  16:00:00] DEBUG/dbase: DB-Exec: SELECT status_id FROM maildrop_status_tbl WHERE status_field = 'W' AND mailing_id = 3 ORDER BY status_id
[25.07.2008  16:00:00] ERROR/init: Error configuration report:
	lowest maildrop_status_id is not mine (5) but 4

What's wrong?

Jehu · Post by **Jehu** » Mon Jul 28, 2008 12:10 pm

Hello again,

today i've deleted completely the database and do a new import of the sql-file. Then i use the OpenEMM Webform for adding a subscriber.
-> doi-Mail was sent

After that i added successfully a subscriber via webservice
-> doi-Mail was _not_ sent

I also used the OpenEMM webform for adding a subscriber again.
-> doi-Mail was sent

So. It seems OpenEMM is working right now (no more errors in the logfiles).
But why the doi-Mail won't be sent?

Can anybody please say, which webservice-methods must be called after
addSubscriber and setSubscriberBinding for sending the doi-Mail (Double-Opt-In)? By using updateEmailMailing() it ends in an java.lang.NullPointerException.

Do nobody else need this informations? Can't find some doc expect WebService*.pdf which not explains this.

Thanks in advance
Jehu