Problem with Action Based Mailing+Double Opt-In subscription

[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]

Can you please tell me where related logs are located? ...I'm running
OpenEMM on a CentOS 5. Thanks.

[maschoff]

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

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

[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]

Thanks for your feedback! I added your solution to the FAQ entry.

[surferjoe]

np