yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** Changed in: glance/grizzly
   Importance: Undecided => Wishlist

** Changed in: glance/grizzly
       Status: New => Fix Released

** Changed in: glance/grizzly
    Milestone: None => 2013.1

** Changed in: glance/grizzly
     Assignee: (unassigned) => Brian Waldon (bcwaldon)

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Glance.
https://bugs.launchpad.net/bugs/1075676

Title:
  glance.registry.db.api does not support + as a special character for
  database password

Status in OpenStack Image Registry and Delivery Service (Glance):
  Fix Released
Status in Glance grizzly series:
  Fix Released

Bug description:
  Here is what I from Glance:

  Glance works just fine with password glance_pass

  root@control01:~# glance index
  ID Name Disk Format Container Format Size
  ------------------------------------ ------------------------------ -------------------- -------------------- --------------
  522d08d7-e748-42c1-917c-5db9180fe5da precise

  
  I change the db password to glance+pass and mysql accepts the new password:

  root@control01:~# mysql -h192.168.220.41 -uglance -pglance+pass glance
  Reading table information for completion of table and column names
  You can turn off this feature to get a quicker startup with -A

  Welcome to the MySQL monitor. Commands end with ; or \g.
  Your MySQL connection id is 69647
  Server version: 5.5.23 Source distribution, wsrep_23.6.r3755

  Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights
  reserved.

  Oracle is a registered trademark of Oracle Corporation and/or its
  affiliates. Other names may be trademarks of their respective
  owners.

  Type 'help;' or '\h' for help. Type '\c' to clear the current input
  statement.

  mysql>

  
  I change the password in glance-registry.conf:

  root@control01:~# grep mysql /etc/glance/glance-registry.conf
  sql_connection = mysql://glance:glance+pass@192.168.220.41/glance

  The service fails to restart

  root@control01:~# service glance-registry restart
  stop: Unknown instance:
  glance-registry start/running, process 5486

  root@control01:~# service glance-registry status
  glance-registry stop/waiting

  The registry log shows the password not being accepted

  root@control01:~# tail -f /var/log/glance/registry.log
  2012-11-06 17:52:36 5545 ERROR [glance.registry.db.api] Error configuring registry database with supplied sql_connection 'mysql://glance:glance+pass@192.168.220.41/glance'. Got error:
  (OperationalError) (1045, "Access denied for user 'glance'@'control01' (using password: YES)") None None
  2012-11-06 17:52:37 5552 ERROR [glance.registry.db.api] Error configuring registry database with supplied sql_connection 'mysql://glance:glance+pass@192.168.220.41/glance'. Got error:

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1075676/+subscriptions