db sync fails using 2.0.0 - keystone_user_id > 255

[Kevin Carter]

When backing sessions with mysql the running the ``manage.py syncdb --traceback `` command results in the following stacktrace:

Traceback (most recent call last):
  File "/usr/local/bin/horizon-manage.py", line 23, in <module>
    execute_from_command_line(sys.argv)
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 338, in execute_from_command_line
    utility.execute()
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 330, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 393, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 443, in execute
    self.check()
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 528, in check
    raise SystemCheckError(msg)
django.core.management.base.SystemCheckError: SystemCheckError: System check identified some issues:

ERRORS:
openstack_auth.User.keystone_user_id: (mysql.E001) MySQL does not allow unique CharFields to have a max_length > 255.

This is the OS Dash configuration for sessions.

SESSION_ENGINE = "django.contrib.sessions.backends.cached_db"

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'HOST': '172.29.236.100',
        'NAME': 'dash',
        'USER': 'dash',
        'PASSWORD': 'secrete',
        'default-character-set': 'utf8'
    },
}

I've not found the specific item that's causing this issue however reverting from 2.0.0 to 1.4.0 allowed the deployment test to continue. This was testing Horizon using commit "a601ce63c809644efec95568fed0af4a17201c27"

[Jesse Pretorius (jesse-pretorius)]

ref: https://bitbucket.org/tohccmedphys/qatrackplus/issues/32/mysql-syncdb-error-charfield-255-with and http://stackoverflow.com/questions/7028655/django-dump-models-dont-validate

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/228385
Committed: https://git.openstack.org/cgit/openstack/openstack-ansible/commit/?id=82d51833f68c91730f96e0680cf56d105f70f5ec
Submitter: Jenkins
Branch: master

commit 82d51833f68c91730f96e0680cf56d105f70f5ec
Author: Jesse Pretorius <email address hidden>
Date: Mon Sep 28 11:35:14 2015 +0100

    Update all SHA's to Liberty branch SHA's

    The git SHA for django-openstack-auth is carried temporarily in order
    to resolve https://bugs.launchpad.net/openstack-ansible/+bug/1497679

    Closes-Bug: #1497679
    Implements: blueprint liberty-release
    Change-Id: I6c73b7774a56cb48d8e0e2399bd48322f303ea54

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/232955
Committed: https://git.openstack.org/cgit/openstack/openstack-ansible/commit/?id=0af3666dca666e4c43e97fd7b1c61688aff4b753
Submitter: Jenkins
Branch: master

commit 0af3666dca666e4c43e97fd7b1c61688aff4b753
Author: Jesse Pretorius <email address hidden>
Date: Fri Oct 9 09:42:00 2015 +0100

    Update nova & tempest SHA's and remove django-openstack-auth SHA

    This patch updates the nova and tempest SHA's to address more issues
    found in Liberty testing.

    It also removes the git-based pin for django-openstack-auth and
    instead implements a lower cap for the package which includes the
    appropriate fix.

    Change-Id: Ib30e02dbc681d4a6005c864f0b4ccfbb604de812
    Closes-Bug: #1497679