latest doa breaks with new db layout

[Eric Peterson]

When upgrading to new horizon and doa, a mysql backed session engine sees this error:

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

[Eric Peterson (ericpeterson-l)]

I think this change did it https://review.openstack.org/#/c/222478/

[Eric Peterson (ericpeterson-l)]

when I try to run the migrate command, the following occurs:

$ tools/with_venv.sh python manage.py migrate
Allowed hosts are: 127.0.0.1,bfd02.os.cloud.twc.net,horizon.os.cloud.twc.net,bfd.os.cloud.twc.net,eric-VirtualBox,127.0.1.1
CommandError: 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.

see: https://docs.djangoproject.com/en/1.8/ref/django-admin/#django-admin-migrate

[OpenStack Infra (hudson-openstack)]

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

[Eric Peterson (ericpeterson-l)]

Even with the code changes, there is a larger issue, from running the syncdb / migrate commands from django - as seen in:

http://paste.openstack.org/show/474068/

[Eric Peterson (ericpeterson-l)]

I've tested running the syncdb / migrate command, while running older horizon. The older horizon continues to run ok. Then bringing up the new horizon, which now runs the new db layout. Seems to be ok, running through this path.

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/228024
Committed: https://git.openstack.org/cgit/openstack/django_openstack_auth/commit/?id=731fc62fb77d1ae1f29a8a8257a19a638e052203
Submitter: Jenkins
Branch: master

commit 731fc62fb77d1ae1f29a8a8257a19a638e052203
Author: eric <email address hidden>
Date: Fri Sep 25 13:59:41 2015 -0600

    doa does not work with mysql

    recent change to specify db user model and it's key
    are not compliant with mysql

    This change modifies the character limit to be 255 instead of 256,
    which is compliant with mysql.

    Change-Id: I85f984c690297003d0e6d696f3103ad5fcf34045
    Closes-bug: #1499856

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/liberty
Review: https://review.openstack.org/229994

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/229994
Committed: https://git.openstack.org/cgit/openstack/django_openstack_auth/commit/?id=88fb89b5b787824d06b4c58337b7c960ccd0263b
Submitter: Jenkins
Branch: stable/liberty

commit 88fb89b5b787824d06b4c58337b7c960ccd0263b
Author: eric <email address hidden>
Date: Fri Sep 25 13:59:41 2015 -0600

    doa does not work with mysql

    recent change to specify db user model and it's key
    are not compliant with mysql

    This change modifies the character limit to be 255 instead of 256,
    which is compliant with mysql.

    Change-Id: I85f984c690297003d0e6d696f3103ad5fcf34045
    Closes-bug: #1499856
    (cherry picked from commit 731fc62fb77d1ae1f29a8a8257a19a638e052203)

[OpenStack Infra (hudson-openstack)]

Change abandoned by Eric Peterson (<email address hidden>) on branch: master
Review: https://review.openstack.org/228536

[Jesse Pretorius (jesse-pretorius)]

Shouldn't the Horizon requirements be updated to include django_openstack_auth>=2.0.1 to ensure that this fix is included?

[Paul White (paulw2u)]

Marking the Ubuntu content as "Invalid" to close after 4+ years.