switch to pymysql

[Michal Rostecki]

Currently, in source type installation, some services are trying to use mysql-python instead of pymysql, which results in the error:

2016-02-04 12:02:40.997 36 CRITICAL keystone [-] ImportError: No module named MySQLdb
2016-02-04 12:02:40.997 36 ERROR keystone Traceback (most recent call last):
2016-02-04 12:02:40.997 36 ERROR keystone File "/var/lib/kolla/venv/bin/keystone-manage", line 10, in <module>
2016-02-04 12:02:40.997 36 ERROR keystone sys.exit(main())
2016-02-04 12:02:40.997 36 ERROR keystone File "/var/lib/kolla/venv/lib/python2.7/site-packages/keystone/cmd/manage.py", line 47, in main
2016-02-04 12:02:40.997 36 ERROR keystone cli.main(argv=sys.argv, config_files=config_files)
2016-02-04 12:02:40.997 36 ERROR keystone File "/var/lib/kolla/venv/lib/python2.7/site-packages/keystone/cmd/cli.py", line 846, in main
2016-02-04 12:02:40.997 36 ERROR keystone CONF.command.cmd_class.main()
2016-02-04 12:02:40.997 36 ERROR keystone File "/var/lib/kolla/venv/lib/python2.7/site-packages/keystone/cmd/cli.py", line 242, in main
2016-02-04 12:02:40.997 36 ERROR keystone migration_helpers.sync_database_to_version(extension, version)
2016-02-04 12:02:40.997 36 ERROR keystone File "/var/lib/kolla/venv/lib/python2.7/site-packages/keystone/common/sql/migration_helpers.py", line 198, in sync_database_to_version
2016-02-04 12:02:40.997 36 ERROR keystone _sync_common_repo(version)
2016-02-04 12:02:40.997 36 ERROR keystone File "/var/lib/kolla/venv/lib/python2.7/site-packages/keystone/common/sql/migration_helpers.py", line 146, in _sync_common_repo
2016-02-04 12:02:40.997 36 ERROR keystone engine = sql.get_engine()
2016-02-04 12:02:40.997 36 ERROR keystone File "/var/lib/kolla/venv/lib/python2.7/site-packages/keystone/common/sql/core.py", line 188, in get_engine
2016-02-04 12:02:40.997 36 ERROR keystone return _get_engine_facade().get_engine()
2016-02-04 12:02:40.997 36 ERROR keystone File "/var/lib/kolla/venv/lib/python2.7/site-packages/keystone/common/sql/core.py", line 176, in _get_engine_facade
2016-02-04 12:02:40.997 36 ERROR keystone _engine_facade = db_session.EngineFacade.from_config(CONF)
2016-02-04 12:02:40.997 36 ERROR keystone File "/var/lib/kolla/venv/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 1056, in from_config
2016-02-04 12:02:40.997 36 ERROR keystone expire_on_commit=expire_on_commit, _conf=conf)
2016-02-04 12:02:40.997 36 ERROR keystone File "/var/lib/kolla/venv/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 977, in __init__
2016-02-04 12:02:40.997 36 ERROR keystone slave_connection=slave_connection)
2016-02-04 12:02:40.997 36 ERROR keystone File "/var/lib/kolla/venv/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 338, in _start
2016-02-04 12:02:40.997 36 ERROR keystone engine_args, maker_args)
2016-02-04 12:02:40.997 36 ERROR keystone File "/var/lib/kolla/venv/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 362, in _setup_for_connection
2016-02-04 12:02:40.997 36 ERROR keystone sql_connection=sql_connection, **engine_kwargs)
2016-02-04 12:02:40.997 36 ERROR keystone File "/var/lib/kolla/venv/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 131, in create_engine
2016-02-04 12:02:40.997 36 ERROR keystone engine = sqlalchemy.create_engine(url, **engine_args)
2016-02-04 12:02:40.997 36 ERROR keystone File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/__init__.py", line 386, in create_engine
2016-02-04 12:02:40.997 36 ERROR keystone return strategy.create(*args, **kwargs)
2016-02-04 12:02:40.997 36 ERROR keystone File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 75, in create
2016-02-04 12:02:40.997 36 ERROR keystone dbapi = dialect_cls.dbapi(**dbapi_args)
2016-02-04 12:02:40.997 36 ERROR keystone File "/var/lib/kolla/venv/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 92, in dbapi
2016-02-04 12:02:40.997 36 ERROR keystone return __import__('MySQLdb')
2016-02-04 12:02:40.997 36 ERROR keystone ImportError: No module named MySQLdb

We have to change everything to pymysql.

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/276194
Committed: https://git.openstack.org/cgit/openstack/kolla-mesos/commit/?id=4aefd918fb06bb7e0f24ea8118b8e64ff3a9a95e
Submitter: Jenkins
Branch: master

commit 4aefd918fb06bb7e0f24ea8118b8e64ff3a9a95e
Author: Michal Rostecki <email address hidden>
Date: Thu Feb 4 13:25:19 2016 +0100

    Switch from mysql-python to pymysql everywhere

    Change-Id: Icb603d77c4421092a0e6b45b724b30788ea72a52
    Closes-Bug: 1541816