← Back to team overview

yahoo-eng-team team mailing list archive

  1. yahoo-eng-team team
  2. Mailing list archive
  3. Message #64496

[Bug 1695299] [NEW] Glance installation fails if password contains '@' symbol

  Thread Previous • Date Previous • • Thread Next 
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%40321@127.0.0.1/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%40321@127.0.0.1/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%40321@127.0.0.1/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%40321@127.0.0.1/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

Follow ups

  Thread Previous • Date Previous • • Thread Next