colon sign in password for mysql connection
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Glance |
New
|
Undecided
|
Unassigned |
Bug Description
I've set up mysql password inside configuration files /etc/glance/
mysql+pymysql:
and during populating of database with command "glance-manage db_sync"
I've got exit code 1 and next strace output in log file /var/log/
2017-03-14 16:18:55.631 10528 CRITICAL glance [-] ValueError: invalid interpolation syntax in 'mysql+
2017-03-14 16:18:55.631 10528 ERROR glance Traceback (most recent call last):
2017-03-14 16:18:55.631 10528 ERROR glance File "/usr/bin/
2017-03-14 16:18:55.631 10528 ERROR glance sys.exit(main())
2017-03-14 16:18:55.631 10528 ERROR glance File "/usr/lib/
2017-03-14 16:18:55.631 10528 ERROR glance return CONF.command.
2017-03-14 16:18:55.631 10528 ERROR glance File "/usr/lib/
2017-03-14 16:18:55.631 10528 ERROR glance self.command_
2017-03-14 16:18:55.631 10528 ERROR glance File "/usr/lib/
2017-03-14 16:18:55.631 10528 ERROR glance alembic_
2017-03-14 16:18:55.631 10528 ERROR glance File "/usr/lib/
2017-03-14 16:18:55.631 10528 ERROR glance a_config = get_alembic_
2017-03-14 16:18:55.631 10528 ERROR glance File "/usr/lib/
2017-03-14 16:18:55.631 10528 ERROR glance config.
2017-03-14 16:18:55.631 10528 ERROR glance File "/usr/lib/
2017-03-14 16:18:55.631 10528 ERROR glance self.set_
2017-03-14 16:18:55.631 10528 ERROR glance File "/usr/lib/
2017-03-14 16:18:55.631 10528 ERROR glance self.file_
2017-03-14 16:18:55.631 10528 ERROR glance File "/usr/lib64/
2017-03-14 16:18:55.631 10528 ERROR glance "position %d" % (value, tmp_value.
2017-03-14 16:18:55.631 10528 ERROR glance ValueError: invalid interpolation syntax in 'mysql+
2017-03-14 16:18:55.631 10528 ERROR glance
I'm trying to setup OpenStack ocata using installation manual https:/
Btw the same password in Keystone works well
Brief investigation of the issue showed me that bug caused by "sqlalchemy.
Inside this function password field is converted by method "_rfc_1738_quote" which replace characters :@/ to according URL-safe sequences. Then python parser SafeConfigParser is not able to identify interpolation pattern (in my case it is '%3A')
So I can suppose that it is not possible to use these characters inside config files mentioned above for database/connection setting
In installation manual I did not find any notifications that these characters forbidden in MySQL password
I can not reproduce this issue on OpenStack Liberty
Thank you
OS: CentOS 7.3.1611 glance- 14.0.0
OpenStack Serie: Ocata
rpm package: python-