The barbican package is missing a dependancy on python-pymysql

[Liam Young]

[Impact]
barbican services are not immediately usable with the preferred storage backend, mysql.

[Test Case]
Install barbican-api with mysql backend configuration
Barbican will throw a stack trace whilst trying to create the DB

[Regression Potential]
Addition of recommends for pymysql; so minimal.

[Original Bug Report]
If barbican is configured to use a mysql database then the barbican-api server fails to start with:

2015-12-16 08:07:07.273 20728 CRITICAL barbican [-] BarbicanException: Error configuring registry database with supplied sql_connection. Got error: No module named pymysql
2015-12-16 08:07:07.273 20728 ERROR barbican Traceback (most recent call last):
2015-12-16 08:07:07.273 20728 ERROR barbican File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 247, in loadapp
2015-12-16 08:07:07.273 20728 ERROR barbican return loadobj(APP, uri, name=name, **kw)
2015-12-16 08:07:07.273 20728 ERROR barbican File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 272, in loadobj
2015-12-16 08:07:07.273 20728 ERROR barbican return context.create()
2015-12-16 08:07:07.273 20728 ERROR barbican File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create
2015-12-16 08:07:07.273 20728 ERROR barbican return self.object_type.invoke(self)
2015-12-16 08:07:07.273 20728 ERROR barbican File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 144, in invoke
2015-12-16 08:07:07.273 20728 ERROR barbican **context.local_conf)
2015-12-16 08:07:07.273 20728 ERROR barbican File "/usr/lib/python2.7/dist-packages/paste/deploy/util.py", line 55, in fix_call
2015-12-16 08:07:07.273 20728 ERROR barbican val = callable(*args, **kw)
2015-12-16 08:07:07.273 20728 ERROR barbican File "/usr/lib/python2.7/dist-packages/paste/urlmap.py", line 28, in urlmap_factory
2015-12-16 08:07:07.273 20728 ERROR barbican app = loader.get_app(app_name, global_conf=global_conf)
2015-12-16 08:07:07.273 20728 ERROR barbican File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 350, in get_app
2015-12-16 08:07:07.273 20728 ERROR barbican name=name, global_conf=global_conf).create()
2015-12-16 08:07:07.273 20728 ERROR barbican File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create
2015-12-16 08:07:07.273 20728 ERROR barbican return self.object_type.invoke(self)
2015-12-16 08:07:07.273 20728 ERROR barbican File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 203, in invoke
2015-12-16 08:07:07.273 20728 ERROR barbican app = context.app_context.create()
2015-12-16 08:07:07.273 20728 ERROR barbican File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 710, in create
2015-12-16 08:07:07.273 20728 ERROR barbican return self.object_type.invoke(self)
2015-12-16 08:07:07.273 20728 ERROR barbican File "/usr/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py", line 146, in invoke
2015-12-16 08:07:07.273 20728 ERROR barbican return fix_call(context.object, context.global_conf, **context.local_conf)
2015-12-16 08:07:07.273 20728 ERROR barbican File "/usr/lib/python2.7/dist-packages/paste/deploy/util.py", line 55, in fix_call
2015-12-16 08:07:07.273 20728 ERROR barbican val = callable(*args, **kw)
2015-12-16 08:07:07.273 20728 ERROR barbican File "/usr/lib/python2.7/dist-packages/barbican/api/app.py", line 76, in _wrapper
2015-12-16 08:07:07.273 20728 ERROR barbican repositories.setup_database_engine_and_factory()
2015-12-16 08:07:07.273 20728 ERROR barbican File "/usr/lib/python2.7/dist-packages/barbican/model/repositories.py", line 100, in setup_database_engine_and_factory
2015-12-16 08:07:07.273 20728 ERROR barbican _ENGINE = _get_engine(_ENGINE)
2015-12-16 08:07:07.273 20728 ERROR barbican File "/usr/lib/python2.7/dist-packages/barbican/model/repositories.py", line 185, in _get_engine
2015-12-16 08:07:07.273 20728 ERROR barbican raise exception.BarbicanException(msg)
2015-12-16 08:07:07.273 20728 ERROR barbican BarbicanException: Error configuring registry database with supplied sql_connection. Got error: No module named pymysql
2015-12-16 08:07:07.273 20728 ERROR barbican

[James Page (james-page)]

Will add a Recommends; not everyone uses mysql as a backend.

[Brian Murray (brian-murray)]

Hello Liam, or anyone else affected,

Accepted barbican into wily-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/barbican/1:1.0.0-0ubuntu1.1 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, and change the tag from verification-needed to verification-done. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed. In either case, details of your testing will help us make a better decision.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance!

[Launchpad Janitor (janitor)]

This bug was fixed in the package barbican - 1:2.0.0~b1-0ubuntu1

---------------
barbican (1:2.0.0~b1-0ubuntu1) xenial; urgency=medium

  [ Corey Bryant ]
  * New upstream milestone for OpenStack Mitaka.
  * d/control: Align (build-)depends with upstream.

  [ James Page ]
  * d/barbican-api.install: Install missing policy.json (LP: #1526655).
  * d/control: Add Recommends on python-pymysql (LP: #1526659).
  * d/control: Add missing runtime dependency on uwsgi-plugin-python
    (LP: #1526654).
  * d/barbican-api.upstart.in: Provide full upstart configuration as
    generation using openstack-pkg-tools is not supported for uwsgi
    applications (LP: #1526654).
  * d/barbican-{api,common}.install,control: Move configuration files to
    common package to support use across all barbican packages and with
    Apache WSGI.

 -- Corey Bryant <email address hidden> Tue, 15 Dec 2015 09:57:35 -0500

[Chris J Arges (arges)]

The verification of the Stable Release Update for barbican has completed successfully and the package has now been released to -updates. Subsequently, the Ubuntu Stable Release Updates Team is being unsubscribed and will not receive messages about this bug report. In the event that you encounter a regression using the package from -updates please report a new bug using ubuntu-bug and tag the bug report regression-update so we can easily find any regressions.

[Launchpad Janitor (janitor)]

This bug was fixed in the package barbican - 1:1.0.0-0ubuntu1.1

---------------
barbican (1:1.0.0-0ubuntu1.1) wily; urgency=medium

  * d/barbican-api.install: Install missing policy.json (LP: #1526655).
  * d/control: Add Recommends on python-pymysql (LP: #1526659).
  * d/control: Add missing runtime dependency on uwsgi-plugin-python
    (LP: #1526654).
  * d/barbican-api.upstart.in: Provide full upstart configuration as
    generation using openstack-pkg-tools is not supported for uwsgi
    applications (LP: #1526654).

 -- James Page <email address hidden> Wed, 16 Dec 2015 14:38:09 +0000