Problem with Action Based Mailing+Double Opt-In subscription

Use this forum for questions regarding adoption and functionality of OpenEMM

Moderator: moderator

surferjoe
Posts: 19
Joined: Wed Oct 08, 2008 2:58 pm

Problem with Action Based Mailing+Double Opt-In subscription

Post 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.
surferjoe
Posts: 19
Joined: Wed Oct 08, 2008 2:58 pm

where i can find logs?

Post by surferjoe »

Can you please tell me where related logs are located? ...I'm running
OpenEMM on a CentOS 5. Thanks.
maschoff
Site Admin
Posts: 2628
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Post by maschoff »

You will find the logs in /home/openemm/var/log.

Please see also http://www.openemm.org/faq/questions/25 ... inux+only)
OpenEMM Maintainer
surferjoe
Posts: 19
Joined: Wed Oct 08, 2008 2:58 pm

Fixed!!!

Post 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!!!!
maschoff
Site Admin
Posts: 2628
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Post by maschoff »

Thanks for your feedback! I added your solution to the FAQ entry.
OpenEMM Maintainer
surferjoe
Posts: 19
Joined: Wed Oct 08, 2008 2:58 pm

np

Post by surferjoe »

np
:wink:
Post Reply