influxdb deployment failed with a long mysql username

[Swann Croiset]

2016-02-09 22:26:47 ERR /etc/fuel/plugins/influxdb_grafana-0.9/puppet/modules/mysql/lib/puppet/type/mysql_user.rb:33:in `block (3 levels) in <top (required)>'
2016-02-09 22:26:47 ERR Parameter name failed on Mysql_user[grafana_stacklight@10.109.36.3]: MySQL usernames are limited to a maximum of 16 characters

The UI must validate the length of the MySQL username.
Also, there is also a possible limitation with the database name.

[Swann Croiset (swann-w)]

Doc:

https://dev.mysql.com/doc/refman/5.6/en/identifiers.html
https://dev.mysql.com/doc/refman/5.6/en/user-names.html

the username is limited to 16 characters
table and dbname are limited to 64 characters

too keep input validation simple, I propose to allow only these characteres:

ASCII: [0-9,a-z,A-Z$_] (basic Latin letters, digits 0-9, dollar, underscore)

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/278974
Committed: https://git.openstack.org/cgit/openstack/fuel-plugin-influxdb-grafana/commit/?id=fd26e819079ce5d0207021a252eef02f00513219
Submitter: Jenkins
Branch: master

commit fd26e819079ce5d0207021a252eef02f00513219
Author: Swann Croiset <email address hidden>
Date: Thu Feb 11 11:47:34 2016 +0100

    Restrict MySQL username and dbname with valid name

    Change-Id: Id15db3e5bb279007b071083eeeec4f42b86f8f39
    Fixes-bug: #1543939