Sending mails failed
Posted: Thu Aug 10, 2006 1:01 pm
Hi,
I have installed openemm at a gentoo system (OpenEMM-5.0.binary.tar.gz, Gentoo default-linux/x86/2006.0).
All works fine expect of sending mails to mailing lists. It's possible to send messages to the administrator/test group, but sending mails to other mailing lists failed without any error message. After clicking at the send button, the distribution status shows "This mailing is beeing sent at the moment", but the mail never arrives. But the xml version of this message is stored in /var/spool/META:
The processlist:
console_stdout.log after sending to the administrator group (this mail arrives):
console_stdout.log after sending to a mailing list (this mails don't arrive):
Only the "administrator"-log shows "Try to execute /home/openemm/bin/xmlback ...". Is xmlback responsible for sending mails?
It would be very nice, if someone could explain some details about the sending process (involved queues, processes, files, programs, ...).
Thanks for your help,
Simon
I have installed openemm at a gentoo system (OpenEMM-5.0.binary.tar.gz, Gentoo default-linux/x86/2006.0).
All works fine expect of sending mails to mailing lists. It's possible to send messages to the administrator/test group, but sending mails to other mailing lists failed without any error message. After clicking at the send button, the distribution status shows "This mailing is beeing sent at the moment", but the mail never arrives. But the xml version of this message is stored in /var/spool/META:
Code: Select all
...
AgnMail=D20060810114745=1=35=002=liaMngA.final
AgnMail=D20060810114745=1=35=002=liaMngA.stamp
AgnMail=D20060810114745=1=35=002=liaMngA.xml.gz
The processlist:
Code: Select all
$ ps ax -o args
python /opt/openemm/bin/scripts/bav-trigger.py
/opt/openemm/bin/bav -L INFO
sendmail: accepting connections
sendmail: Queue runner@00:05:00 for /var/spool/clientmqueue
sendmail: Queue runner@00:01:00 for /opt/openemm/var/spool/ADMIN
sendmail: Queue runner@00:15:00 for /opt/openemm/var/spool/QUEUE
python /opt/openemm/bin/scripts/slrtscn.py
perl /opt/openemm/bin/wrapper.pl -chdir -name httpd ...
/opt/sun-jdk-1.5.0.07/bin/java -Xss1m -Dresin.home=...
console_stdout.log after sending to the administrator group (this mail arrives):
Code: Select all
...
Init mailing backend store proc. done
Update log done at message no:0
Start creation of mails
DB-Exec: SELECT cust.customer_id,cust.mailtype,cust.customer_id,cust.email FROM customer_1_tbl cust, customer_1_binding_tbl bind WHERE bind.customer_id = cust.customer
_id AND (bind.mailinglist_id = 1 AND (bind.user_status = 1 AND bind.user_type = 'A'))
Start block 1 using blocksize 0
Mailtype/Number/Bytes:
0/0
1/0
2/0
Currently at 0 mails (in block 1: 0)
Update log done at message no:0
End block 1
Skip validation of XML document
DB-Updt: UPDATE mailing_backend_log_tbl SET current_mails = 1, total_mails = 1 WHERE status_id = 33
Final update backend_log done.
Total mail message written: 1
Mailtype 0: 1 message
Mailtype 1: 0 messages
Mailtype 2: 0 messages
Try to execute /home/openemm/bin/xmlback -vql -E /tmp/error34227.tmp -o generate:media=email;temporary=true;syslog=true;path=/home/openemm/var/spool/ADMIN /home/openem
m/var/spool/META/AgnMail=D20060810101437=1=32=00001=liaMngA.xml
DB-Updt: INSERT INTO mailtrack_tbl (company_id, status_id, mailing_id, customer_id) SELECT 1, 33, 32, cust.customer_id FROM customer_1_tbl cust, customer_1_binding_tbl
bind WHERE bind.customer_id = cust.customer_id AND (bind.mailinglist_id = 1 AND (bind.user_status = 1 AND bind.user_type = 'A'))
DB-Updt: UPDATE maildrop_status_tbl SET genchange = now(), genstatus = 3 WHERE status_id = 33 AND genstatus = 2
Successful end
DB-Exec: SELECT 1 FROM DUAL
DB-Exec: SELECT date_format(now(), '%Y-%m-%d') FROM dual
DB-Exec: SELECT mailing_id, date_format(lastsent, '%Y-%m-%d') FROM rulebased_sent_tbl
DB-Exec: SELECT status_id, mailing_id FROM maildrop_status_tbl WHERE status_field = 'R' AND genstatus = 1 AND date_format(senddate, '%H') = '10'
Read 0 maildrop entries
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
Code: Select all
...
Init mailing backend store proc. done
Update log done at message no:0
Start creation of mails
DB-Exec: SELECT cust.customer_id,cust.mailtype,cust.customer_id,cust.email FROM customer_1_tbl cust, customer_1_binding_tbl bind WHERE bind.customer_id = cust.customer
_id AND (bind.mailinglist_id = 1 AND (bind.user_status = 1 AND bind.user_type IN ('A', 'T')))
Start block 1 using blocksize 5000
Mailtype/Number/Bytes:
0/0
1/0
2/0
Currently at 0 mails (in block 1: 0)
Update log done at message no:0
End block 1
Skip validation of XML document
Start block 2 using blocksize 5000
Mailtype/Number/Bytes:
0/1
1/0
2/0
DB-Exec: SELECT cust.customer_id,cust.mailtype,cust.customer_id,cust.email FROM customer_1_tbl cust, customer_1_binding_tbl bind WHERE bind.customer_id = cust.customer
_id AND (bind.mailinglist_id = 1 AND (bind.user_status = 1 AND bind.user_type = 'W'))
End block 2
Skip validation of XML document
DB-Updt: UPDATE mailing_backend_log_tbl SET current_mails = 2, total_mails = 2 WHERE status_id = 34
Final update backend_log done.
Total mail messages written: 2
Mailtype 0: 2 messages
Mailtype 1: 0 messages
Mailtype 2: 0 messages
DB-Updt: INSERT INTO mailtrack_tbl (company_id, status_id, mailing_id, customer_id) SELECT 1, 34, 33, cust.customer_id FROM customer_1_tbl cust, customer_1_binding_tbl
bind WHERE bind.customer_id = cust.customer_id AND (bind.mailinglist_id = 1 AND (bind.user_status = 1))
DB-Updt: UPDATE maildrop_status_tbl SET genchange = now(), genstatus = 3 WHERE status_id = 34 AND genstatus = 2
Successful end
Hibernate: select mailing0_.mailing_id as mailing1_9_, mailing0_.company_id as company2_9_, mailing0_.campaign_id as campaign3_9_, mailing0_.shortname as shortname9_,
mailing0_.description as descript5_9_, mailing0_.mailing_type as mailing6_9_, mailing0_.is_template as is7_9_, mailing0_.needs_target as needs8_9_, mailing0_.mailtempl
ate_id as mailtemp9_9_, mailing0_.mailinglist_id as mailing10_9_, mailing0_.deleted as deleted9_, mailing0_.target_expression as target12_9_, mailing0_.creation_date a
s creation13_9_ from mailing_tbl mailing0_ where mailing0_.mailing_id=? and mailing0_.company_id=? and mailing0_.deleted<>1
Hibernate: select target0_.target_id as target1_0_, target0_.company_id as company2_0_, target0_.target_description as target3_0_, target0_.target_shortname as target4
_0_, target0_.target_representation as target5_0_, target0_.target_sql as target6_0_ from dyn_target_tbl target0_ where target0_.company_id=?
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
Only the "administrator"-log shows "Try to execute /home/openemm/bin/xmlback ...". Is xmlback responsible for sending mails?
It would be very nice, if someone could explain some details about the sending process (involved queues, processes, files, programs, ...).
Thanks for your help,
Simon