No module named MySQLdb

[Guangyu Suo]

Installing ceilometer to virtualenv, all packages in requirements.txt have installed, but got the following error when type ceilometer-dbsync:

(.venv)[root@master ceilometer]# ceilometer-dbsync
2013-11-27 09:16:58.806 4020 DEBUG ceilometer.storage [-] looking for 'mysql' driver in 'ceilometer.storage' get_engine /root/ceilometer/ceilometer/storage/__init__.py:72
2013-11-27 09:16:59.418 4020 CRITICAL ceilometer [-] No module named MySQLdb
2013-11-27 09:16:59.418 4020 TRACE ceilometer Traceback (most recent call last):
2013-11-27 09:16:59.418 4020 TRACE ceilometer File "/root/ceilometer/.venv/bin/ceilometer-dbsync", line 10, in <module>
2013-11-27 09:16:59.418 4020 TRACE ceilometer sys.exit(dbsync())
2013-11-27 09:16:59.418 4020 TRACE ceilometer File "/root/ceilometer/ceilometer/storage/__init__.py", line 139, in dbsync
2013-11-27 09:16:59.418 4020 TRACE ceilometer get_connection(cfg.CONF).upgrade()
2013-11-27 09:16:59.418 4020 TRACE ceilometer File "/root/ceilometer/ceilometer/storage/impl_sqlalchemy.py", line 152, in upgrade
2013-11-27 09:16:59.418 4020 TRACE ceilometer session = sqlalchemy_session.get_session()
2013-11-27 09:16:59.418 4020 TRACE ceilometer File "/root/ceilometer/ceilometer/openstack/common/db/sqlalchemy/session.py", line 423, in get_session
2013-11-27 09:16:59.418 4020 TRACE ceilometer engine = get_engine(sqlite_fk=sqlite_fk, slave_engine=slave_session)
2013-11-27 09:16:59.418 4020 TRACE ceilometer File "/root/ceilometer/ceilometer/openstack/common/db/sqlalchemy/session.py", line 561, in get_engine
2013-11-27 09:16:59.418 4020 TRACE ceilometer sqlite_fk=sqlite_fk)
2013-11-27 09:16:59.418 4020 TRACE ceilometer File "/root/ceilometer/ceilometer/openstack/common/db/sqlalchemy/session.py", line 658, in create_engine
2013-11-27 09:16:59.418 4020 TRACE ceilometer engine = sqlalchemy.create_engine(sql_connection, **engine_args)
2013-11-27 09:16:59.418 4020 TRACE ceilometer File "/root/ceilometer/.venv/lib/python2.6/site-packages/sqlalchemy/engine/__init__.py", line 338, in create_engine
2013-11-27 09:16:59.418 4020 TRACE ceilometer return strategy.create(*args, **kwargs)
2013-11-27 09:16:59.418 4020 TRACE ceilometer File "/root/ceilometer/.venv/lib/python2.6/site-packages/sqlalchemy/engine/strategies.py", line 64, in create
2013-11-27 09:16:59.418 4020 TRACE ceilometer dbapi = dialect_cls.dbapi(**dbapi_args)
2013-11-27 09:16:59.418 4020 TRACE ceilometer File "/root/ceilometer/.venv/lib/python2.6/site-packages/sqlalchemy/connectors/mysqldb.py", line 52, in dbapi
2013-11-27 09:16:59.418 4020 TRACE ceilometer return __import__('MySQLdb')
2013-11-27 09:16:59.418 4020 TRACE ceilometer ImportError: No module named MySQLdb

Is it missing MySQL-python package in requirements.txt ?

[gordon chung (chungg)]

i tend to agree we should add MySQL-python to requirements.txt. it is the default backend for ceilometer in devstack. the question is should we have both pymongo and MySQL-python listed? we don't have kombu and qpid listed...

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/59549

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/59549
Committed: http://github.com/openstack/ceilometer/commit/9a6558c4daff1fd173b7ad5f5574c4c933016156
Submitter: Jenkins
Branch: master

commit 9a6558c4daff1fd173b7ad5f5574c4c933016156
Author: Gordon Chung <email address hidden>
Date: Mon Dec 2 16:21:09 2013 -0500

    No module named MySQLdb bug

    sql is our default backend but we're missing requirement

    Change-Id: I051942d4f16287a4d84c0cf1ce3574f05bf23967
    Closes-Bug: #1255458