Data too long for column 'password'

[Eduardo Gonzalez]

Hi guys,

While trying to create the default vim it hangs raising the following error:

tacker vim-register --is-default --config-file vim-example.yaml --description "Vim description" example-vim

2017-01-18 15:34:28.627 5 ERROR tacker.api.v1.resource DBDataError: (pymysql.err.DataError) (1406, u"Data too long for column 'password' at row 1") [SQL: u'INSERT INTO vimauths (id, vim_id, password, auth_url, vim_project, auth_cred) VALUES (%(id)s, %(vim_id)s, %(password)s, %(auth_url)s, %(vim_project)s, %(auth_cred)s)'] [parameters: {'vim_project': '{"id": "", "name": "admin", "project_domain_name": "default"}', 'vim_id': '88b2023b-2987-4061-a8ec-0de76e5b855d', 'auth_url': u'http://192.168.100.10:5000/v3', 'auth_cred': '{"username": "admin", "user_id": "", "user_domain_name": "default", "project_name": "admin", "auth_url": "http://192.168.100.10:5000/v3", "project_id": "", "project_domain_name": "default"}', 'password': 'gAAAAABYf4sDKWmbe2kDRU2fequcJWVaVx2T3ggO3lxKBles6L9KkEHWsslls69-sJsQwprnUHrQRKu2BFM_W4REqjittb7SUcJWHqbOHauGec1zy2Ow9UBd7KkQSwhvzmZN1KqWu8qO', 'id': '23a75b0d-cb02-4be4-8bf1-7039f7237365'}]

This is happening when using generated passwords from uuid (length 40). 0TsF4PM60CgxArQBKOa2D4JbNbGCU6i1GiRlriYO
If use a sorter password, lets say length 10 as example, task will success.

I'm using Kolla-ansible to deploy Tacker and passwords are autogenerated from uuid as most of the services.

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/422531
Committed: https://git.openstack.org/cgit/openstack/tacker/commit/?id=fbf0381948621ad34053a6d47a0ef5072279a245
Submitter: Jenkins
Branch: master

commit fbf0381948621ad34053a6d47a0ef5072279a245
Author: gong yong sheng <[e-mail]>
Date: Thu Jan 19 18:19:57 2017 +0800

    Increase vim password column length

    The original size 128 is not enough for tool generated password.
    (The saved password is one transferred, which increased the length).

    This patch increase the size to 255 which is enough for ansible
    uuid password.

    Change-Id: I9defd7522c6a243f00cc8edd7047e96c4586c943
    Closes-bug: #1657508

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/tacker 0.7.0 release.