Public bug reported: I was doing a fresh installation of devstack today and had set the admin password as "Test@321" in local.conf file. The installation started failing for Glance and when I had a look at the backtrace, it looks like it converts '@' to '%40' and starts failing.
Either this needs to be fixed or proper note needs to be added in devstack setup stating that one cannot use '@' symbol in passwords. ubuntu@openstack:~/devstack$ glance --version 2.6.0 ubuntu@openstack:~/devstack$ CRITICAL glance [-] Unhandled error: ValueError: invalid interpolation syntax in 'mysql+pymysql://root:Test%[email protected]/glance?charset=utf8' at position 27 ERROR glance Traceback (most recent call last): ERROR glance File "/usr/local/bin/glance-manage", line 10, in <module> ERROR glance sys.exit(main()) ERROR glance File "/opt/stack/glance/glance/cmd/manage.py", line 452, in main ERROR glance return CONF.command.action_fn() ERROR glance File "/opt/stack/glance/glance/cmd/manage.py", line 291, in sync ERROR glance self.command_object.sync(CONF.command.version) ERROR glance File "/opt/stack/glance/glance/cmd/manage.py", line 117, in sync ERROR glance alembic_migrations.place_database_under_alembic_control() ERROR glance File "/opt/stack/glance/glance/db/sqlalchemy/alembic_migrations/__init__.py", line 73, in place_database_under_alembic_control ERROR glance a_config = get_alembic_config() ERROR glance File "/opt/stack/glance/glance/db/sqlalchemy/alembic_migrations/__init__.py", line 37, in get_alembic_config ERROR glance config.set_main_option('sqlalchemy.url', str(engine.url)) ERROR glance File "/usr/local/lib/python2.7/dist-packages/alembic/config.py", line 218, in set_main_option ERROR glance self.set_section_option(self.config_ini_section, name, value) ERROR glance File "/usr/local/lib/python2.7/dist-packages/alembic/config.py", line 245, in set_section_option ERROR glance self.file_config.set(section, name, value) ERROR glance File "/usr/lib/python2.7/ConfigParser.py", line 752, in set ERROR glance "position %d" % (value, tmp_value.find('%'))) ERROR glance ValueError: invalid interpolation syntax in 'mysql+pymysql://root:Test%[email protected]/glance?charset=utf8' at position 27 ERROR glance +lib/glance:init_glance:1 exit_trap +./stack.sh:exit_trap:492 local r=1 ++./stack.sh:exit_trap:493 jobs -p +./stack.sh:exit_trap:493 jobs= +./stack.sh:exit_trap:496 [[ -n '' ]] +./stack.sh:exit_trap:502 kill_spinner +./stack.sh:kill_spinner:388 '[' '!' -z '' ']' +./stack.sh:exit_trap:504 [[ 1 -ne 0 ]] +./stack.sh:exit_trap:505 echo 'Error on exit' Error on exit +./stack.sh:exit_trap:506 generate-subunit 1496417170 632 fail +./stack.sh:exit_trap:507 [[ -z /opt/stack/logs ]] +./stack.sh:exit_trap:510 /home/ubuntu/devstack/tools/worlddump.py -d /opt/stack/logs World dumping... see /opt/stack/logs/worlddump-2017-06-02-153642.txt for details +./stack.sh:exit_trap:516 exit 1 ubuntu@openstack:~/devstack$ ** Affects: glance Importance: Undecided Status: New ** Tags: glance -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to Glance. https://bugs.launchpad.net/bugs/1695299 Title: Glance installation fails if password contains '@' symbol Status in Glance: New Bug description: I was doing a fresh installation of devstack today and had set the admin password as "Test@321" in local.conf file. The installation started failing for Glance and when I had a look at the backtrace, it looks like it converts '@' to '%40' and starts failing. Either this needs to be fixed or proper note needs to be added in devstack setup stating that one cannot use '@' symbol in passwords. ubuntu@openstack:~/devstack$ glance --version 2.6.0 ubuntu@openstack:~/devstack$ CRITICAL glance [-] Unhandled error: ValueError: invalid interpolation syntax in 'mysql+pymysql://root:Test%[email protected]/glance?charset=utf8' at position 27 ERROR glance Traceback (most recent call last): ERROR glance File "/usr/local/bin/glance-manage", line 10, in <module> ERROR glance sys.exit(main()) ERROR glance File "/opt/stack/glance/glance/cmd/manage.py", line 452, in main ERROR glance return CONF.command.action_fn() ERROR glance File "/opt/stack/glance/glance/cmd/manage.py", line 291, in sync ERROR glance self.command_object.sync(CONF.command.version) ERROR glance File "/opt/stack/glance/glance/cmd/manage.py", line 117, in sync ERROR glance alembic_migrations.place_database_under_alembic_control() ERROR glance File "/opt/stack/glance/glance/db/sqlalchemy/alembic_migrations/__init__.py", line 73, in place_database_under_alembic_control ERROR glance a_config = get_alembic_config() ERROR glance File "/opt/stack/glance/glance/db/sqlalchemy/alembic_migrations/__init__.py", line 37, in get_alembic_config ERROR glance config.set_main_option('sqlalchemy.url', str(engine.url)) ERROR glance File "/usr/local/lib/python2.7/dist-packages/alembic/config.py", line 218, in set_main_option ERROR glance self.set_section_option(self.config_ini_section, name, value) ERROR glance File "/usr/local/lib/python2.7/dist-packages/alembic/config.py", line 245, in set_section_option ERROR glance self.file_config.set(section, name, value) ERROR glance File "/usr/lib/python2.7/ConfigParser.py", line 752, in set ERROR glance "position %d" % (value, tmp_value.find('%'))) ERROR glance ValueError: invalid interpolation syntax in 'mysql+pymysql://root:Test%[email protected]/glance?charset=utf8' at position 27 ERROR glance +lib/glance:init_glance:1 exit_trap +./stack.sh:exit_trap:492 local r=1 ++./stack.sh:exit_trap:493 jobs -p +./stack.sh:exit_trap:493 jobs= +./stack.sh:exit_trap:496 [[ -n '' ]] +./stack.sh:exit_trap:502 kill_spinner +./stack.sh:kill_spinner:388 '[' '!' -z '' ']' +./stack.sh:exit_trap:504 [[ 1 -ne 0 ]] +./stack.sh:exit_trap:505 echo 'Error on exit' Error on exit +./stack.sh:exit_trap:506 generate-subunit 1496417170 632 fail +./stack.sh:exit_trap:507 [[ -z /opt/stack/logs ]] +./stack.sh:exit_trap:510 /home/ubuntu/devstack/tools/worlddump.py -d /opt/stack/logs World dumping... see /opt/stack/logs/worlddump-2017-06-02-153642.txt for details +./stack.sh:exit_trap:516 exit 1 ubuntu@openstack:~/devstack$ To manage notifications about this bug go to: https://bugs.launchpad.net/glance/+bug/1695299/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
