yahoo-eng-team team mailing list archive

[Jaan Porkon <jaantrill@xxxxxxxxx>]

Public bug reported:

By following documentation:

http://docs.openstack.org/icehouse/install-guide/install/yum/content
/keystone-install.html

When MySQL controller is not changed in /etc/keystone/keystone.conf

Then when you are using "su -s /bin/sh -c "keystone-manage db_sync"
keystone" command won't produce any errors.. errors appear only when you
add an user for example:

keystone user-create --name=admin --pass=password --email=email@xxxxxxxxx
An unexpected error prevented the server from fulfilling your request. (HTTP 500)

In keystone.log file there will be:
CRITICAL keystone [-] OperationalError: (OperationalError) (2005, "Unknown MySQL server host 'controller' (1)") None None

If controller is changed in /etc/keystone/keystone.conf user must re-run following command:
su -s /bin/sh -c "keystone-manage db_sync" keystone

otherwise when they try to create an user they will receive the error
above and error in keystone.log

TRACE keystone.common.wsgi ProgrammingError: (ProgrammingError) (1146,
"Table 'keystone.domain' doesn't exist") 'SELECT domain.id AS domain_id,
domain.name AS domain_name, domain.enabled AS domain_enabled,
domain.extra AS domain_extra \nFROM domain \nWHERE domain.id = %s'
('default',)

** Affects: keystone
     Importance: Undecided
         Status: New


** Tags: ops

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

Title:
  No errors when creating keystone tables when MySQL fails

Status in OpenStack Identity (Keystone):
  New

Bug description:
  By following documentation:

  http://docs.openstack.org/icehouse/install-guide/install/yum/content
  /keystone-install.html

  When MySQL controller is not changed in /etc/keystone/keystone.conf

  Then when you are using "su -s /bin/sh -c "keystone-manage db_sync"
  keystone" command won't produce any errors.. errors appear only when
  you add an user for example:

  keystone user-create --name=admin --pass=password --email=email@xxxxxxxxx
  An unexpected error prevented the server from fulfilling your request. (HTTP 500)

  In keystone.log file there will be:
  CRITICAL keystone [-] OperationalError: (OperationalError) (2005, "Unknown MySQL server host 'controller' (1)") None None

  If controller is changed in /etc/keystone/keystone.conf user must re-run following command:
  su -s /bin/sh -c "keystone-manage db_sync" keystone

  otherwise when they try to create an user they will receive the error
  above and error in keystone.log

  TRACE keystone.common.wsgi ProgrammingError: (ProgrammingError) (1146,
  "Table 'keystone.domain' doesn't exist") 'SELECT domain.id AS
  domain_id, domain.name AS domain_name, domain.enabled AS
  domain_enabled, domain.extra AS domain_extra \nFROM domain \nWHERE
  domain.id = %s' ('default',)

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