Page 1 of 1

Problem with Action Based Mailing+Double Opt-In subscription

Posted: Wed Oct 08, 2008 3:30 pm
by surferjoe
Hi all,
I create an action based mailing, 3 forms and 3 actions just like wrote on OpenEmm UserManual in order to create a confirmed mailing list subscription. After submitting the first "DoubleSubscribe" form, no confirmation email is send out.
Anyway, I'm able to send test emails for my action based mailing to the mailing adminidtrator. My OpenEMM version is 5.5.0
Thanks a lot.

where i can find logs?

Posted: Wed Oct 08, 2008 5:22 pm
by surferjoe
Can you please tell me where related logs are located? ...I'm running
OpenEMM on a CentOS 5. Thanks.

Posted: Thu Oct 09, 2008 8:15 am
by maschoff
You will find the logs in /home/openemm/var/log.

Please see also http://www.openemm.org/faq/questions/25 ... inux+only)

Fixed!!!

Posted: Thu Oct 09, 2008 10:24 am
by surferjoe
Thank you very mutch, now it works!
I fixed in this way:
- Looking on openemm/var/spool/META/AgnMail....xml.gz i saw that intermediate files containing confirmation email details was generated.
- From linux shell "ps -u openemm -f", I saw that the process pickdist.py was running.
- On last generated log file /home/openemm/var/log/<date>-<host>-pickdist.log I found this error:
[09.10.2008 3:05:27] xxxxx ERROR/data: Unable to get database cursor
-> this was looking at me like a MySQL related problem
- searching on support forum, I found this usefull thred: http://www.openemm.org/forums/ntopic770.html
after changing MySQL connection/configuration parameters on file
/home/openemm/bin/scripts/agn.py (rows 1115 - 1118) and restarting openEmm (sh /home/openemm/bin/OpenEMM.sh stop; sh /home/openemm/bin/OpenEMM.sh start), I received all missing confirmation emails.
Thanks once again!!!!

Posted: Thu Oct 09, 2008 10:46 am
by maschoff
Thanks for your feedback! I added your solution to the FAQ entry.

np

Posted: Thu Oct 09, 2008 11:57 am
by surferjoe
np
:wink: