Distribution status: This mailing has not been sent yet.

[vissersj]

Hello,

I've installed OpenEMM 2011 on CentOS 5.5 32-bit, but when I try to send a mailing via Template > Send mailing I get this error: Distribution status: This mailing has not been sent yet.

I've been through some previous topics and thought that the python-mysql bridge was missing and indeed I get this message:

[openemm@vpsxxxx ~]$ python -c 'import MySQLdb'
Traceback (most recent call last):
File "<string>", line 1, in ?
ImportError: No module named MySQLdb

So I tried to install it again, but it claims that it is already installed. I checked it and got this:

[root@vpsxxxx ~]# rpm -qi libxml2
Name : libxml2 Relocations: /usr
Version : 2.6.26 Vendor: CentOS
Release : 2.1.2.8.el5_5.1 Build Date: Tue 12 Oct 2010 09:07:40 AM MDT
Install Date: Mon 18 Apr 2011 03:25:34 AM MDT Build Host: builder10.centos.org
Group : Development/Libraries Source RPM: libxml2-2.6.26-2.1.2.8.el5_5.1.src.rpm
Size : 1590341 License: MIT
Signature : DSA/SHA1, Tue 12 Oct 2010 09:18:41 AM MDT, Key ID a8a447dce8562897
URL : http://xmlsoft.org/
Summary : Library providing XML and HTML support

Any idea what's going wrong?

[maschoff]

I use the same libxml2 version and everything works fine.

[vissersj]

Mmm very strange.. I've restarted the VPS and OpenEMM, do you see anything wrong in these lines?

[openemm@vpsxxxx ~]$ openemm.sh start
Start /home/openemm/bin/scripts/bav-update.py .. done.
Start /home/openemm/bin/scripts/bav-trigger.py .. done.
Start /home/openemm/bin/scripts/bavd.py .. done.
Start /home/openemm/bin/bav -L INFO .. done.
Start python /home/openemm/bin/scripts/recovery.py .. done.
Start /home/openemm/bin/scripts/update.py account bounce .. done.
Start /home/openemm/bin/scripts/pickdist.py .. done.
CAUGHT EXCEPTION:
Traceback (most recent call last):
File "/home/openemm/bin/scripts/smenable.py", line 107, in ?
main (sys.argv[0], sys.argv[1:])
File "/home/openemm/bin/scripts/smenable.py", line 87, in main
ctrl = SMCtrl ()
File "/home/openemm/bin/scripts/smenable.py", line 35, in __init__
self.db = agn.DBase ()
AttributeError: 'module' object has no attribute 'DBase'

Unable to determinate status for sendmail usages, assuming sendmail is enabled
Stopping obsolete sendmail processes: done.
Starting sendmails: listener sendmail: unrecognized service
admin queue exim abandoned: unknown, malformed, or incomplete option -NNEVER
mail queue exim abandoned: unknown, malformed, or incomplete option -NNEVER
done.
Start /home/openemm/bin/scripts/slrtscn.py .. done.
Starting up Tomcat ......
Check Java installation :OK
Check Tomcat installation :OK
Using CATALINA_BASE: /home/openemm
Using CATALINA_HOME: /opt/openemm/tomcat
Using CATALINA_TMPDIR: /home/openemm/temp
Using JRE_HOME: /opt/openemm/java
Using CLASSPATH: /opt/openemm/tomcat/bin/bootstrap.jar
[openemm@vpsxxxx ~]$

[maschoff]

The Python script does not find the database module MySLdb in order to access the MySQL DB. Something seems to be wrong with your installation. You should use yum (see OpenEMM Install Guide) instead of manual rpm commands to install missing packages.

[vissersj]

Now I get 'No package MySQL-python available, nothing to do' when I use the yum command. Is it an idea to manually install 'MySQL-python-1.2.3.tar' on the VPS or should I contact the VPS support desk?

[vissersj]

I´ve used: #python -c 'import MySQLdb' and ideed no module named MySQLdb is returned, but how do I need to install it? If I use: yum update, no packages are available and nothing is installed. The same counts for: yum install mysql-server sendmail-cf MySQL-python libxml2. I don't understand it either, because both OpenEMM and CMS databases are installed and I can login to OpenEMM et cetera. Please help me with this issue.

If I start OpenEMM I get this result:

[root@vps6384 /]# su - openemm
[openemm@vps6384 ~]$ openemm.sh start
Start /home/openemm/bin/scripts/bav-update.py .. done.
Start /home/openemm/bin/scripts/bav-trigger.py .. done.
Start /home/openemm/bin/scripts/bavd.py .. done.
Start /home/openemm/bin/bav -L INFO .. done.
Start python /home/openemm/bin/scripts/recovery.py .. done.
Start /home/openemm/bin/scripts/update.py account bounce .. done.
Start /home/openemm/bin/scripts/pickdist.py .. done.
CAUGHT EXCEPTION:
Traceback (most recent call last):
File "/home/openemm/bin/scripts/smenable.py", line 107, in ?
main (sys.argv[0], sys.argv[1:])
File "/home/openemm/bin/scripts/smenable.py", line 87, in main
ctrl = SMCtrl ()
File "/home/openemm/bin/scripts/smenable.py", line 35, in __init__
self.db = agn.DBase ()
AttributeError: 'module' object has no attribute 'DBase'

Unable to determinate status for sendmail usages, assuming sendmail is enabled
Stopping obsolete sendmail processes: done.
Starting sendmails: listener sendmail: unrecognized service
admin queue Failed to start /usr/sbin/sendmail (No such file or directory)
mail queue Failed to start /usr/sbin/sendmail (No such file or directory)
done.
Start /home/openemm/bin/scripts/slrtscn.py .. done.
Starting up Tomcat ......
Check Java installation :OK
Check Tomcat installation :OK
Using CATALINA_BASE: /home/openemm
Using CATALINA_HOME: /opt/openemm/tomcat
Using CATALINA_TMPDIR: /home/openemm/temp
Using JRE_HOME: /opt/openemm/java
Using CLASSPATH: /opt/openemm/tomcat/bin/bootstrap.jar
[openemm@vps6384 ~]$