yahoo-eng-team team mailing list archive

[Launchpad Bug Tracker <1291059@xxxxxxxxxxxxxxxxxx>]

[Expired for Keystone because there has been no activity for 60 days.]

** Changed in: keystone
       Status: Incomplete => Expired

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

Title:
  db_sync fails if hostname has underscore

Status in OpenStack Identity (Keystone):
  Expired

Bug description:
  Origianlly filed in Bugzilla:
  https://bugzilla.redhat.com/show_bug.cgi?id=1069607

  Description of problem:
    When hostname has "_" character like "rhos4_cnt.example.com", keystone.pp has failed with following error:

  Notice: /Stage[main]/Keystone/Exec[keystone-manage db_sync]/returns:
  2014-02-25 20:14:37.597 5207 CRITICAL keystone [-] (OperationalError)
  (1045, "Access denied for user
  'keystone_admin'@'rhos4_cnt.example.com' (using password: YES)") None
  None

    In this case, I can see hostname has escaped by "\" as follows in
  mysql db.

  # mysql -u root
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 153
  Server version: 5.1.71 Source distribution

  Copyright (c) 2000, 2013, 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> select host, user from mysql.user;
  +------------------------+----------------+
  | host                   | user           |
  +------------------------+----------------+
  | %                      | cinder         |
  | %                      | glance         |
  | %                      | heat           |
  | %                      | keystone_admin |
  | %                      | neutron        |
  | %                      | nova           |
  | 127.0.0.1              | cinder         |
  | 127.0.0.1              | glance         |
  | 127.0.0.1              | keystone_admin |
  | 127.0.0.1              | neutron        |
  | 127.0.0.1              | nova           |
  | localhost              | heat           |
  | localhost              | root           |
  | rhos4\_cnt.example.com |                |
  | rhos4\_cnt.example.com | root           |
  +------------------------+----------------+
  15 rows in set (0.00 sec)

  
  Version-Release number of selected component (if applicable):

  
  How reproducible:
    Always

  Steps to Reproduce:
  1. set FQDN with "_" character and run packstack.
  2.
  3.

  Actual results:
    In the keystone.pp, keystone-manage db_sync failed and got python backtrace.

  Expected results:
    Install should finish normally.

  Additional info:
    Attaching packstack log and sosreport.

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