yahoo-eng-team team mailing list archive

[Adam Young <1291059@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: keystone
     Importance: Undecided
         Status: New

-- 
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):
  New

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