'keystone-manage db_sync' was failing to create the keystone tables. When I used root privileges, it succeeded and tenants, users and roles setup succeeded.
BR Sreejith On Wed, Jun 5, 2013 at 3:18 PM, Sreejith N <sreejith.naarakat...@gmail.com>wrote: > I have the following line in keystone.conf: > connection = mysql://keystone:keystone@localhost/keystone > > mysql> SHOW DATABASES; > +--------------------+ > | Database | > +--------------------+ > | information_schema | > | keystone | > > mysql> select User from mysql.user; > +------------------+ > | User | > +------------------+ > | keystone | > > mysql> show grants for 'keystone'@'localhost'; > > +-----------------------------------------------------------------------------------------------------------------+ > | Grants for keystone@localhost > | > > +-----------------------------------------------------------------------------------------------------------------+ > | GRANT USAGE ON *.* TO 'keystone'@'localhost' IDENTIFIED BY PASSWORD > '*936E8F7AB2E21B47F6C9A7E5D9FE14DBA2255E5A' | > | GRANT ALL PRIVILEGES ON `keystone`.* TO 'keystone'@'localhost' > | > > +-----------------------------------------------------------------------------------------------------------------+ > > Also I verified the database connection with the keystone credentials. > What else could go wrong? > > Thanks > Sreejith > > > On Wed, Jun 5, 2013 at 2:53 PM, K, Shanthakumar <shanthakuma...@hp.com>wrote: > >> Ensure you have provided the passwords correctly in the all the >> configuration file.**** >> >> ** ** >> >> Its seems your keystone itself not working properly.**** >> >> ** ** >> >> Thanks**** >> >> Shanthakumar K**** >> >> ** ** >> >> *From:* Openstack [mailto:openstack-bounces+sk13= >> hp....@lists.launchpad.net] *On Behalf Of *Sreejith N >> *Sent:* Wednesday, June 05, 2013 2:49 PM >> *To:* openstack@lists.launchpad.net >> *Subject:* [Openstack] Issue with OpenStack installation on Ubuntu 12.04 >> LTS**** >> >> ** ** >> >> Hi,**** >> >> I am trying to setup Openstack in a single node architecture for >> evaluation. I am following the Openstack installation Guide for Ubuntu >> 12.04 LTS. I am getting the following error when trying to setup tenants, >> users and roles manually. >> >> OS: Ubuntu 12.04 LTS >> Model: Single node (For trying out OpenStack)**** >> >> ** ** >> >> Error-1:**** >> >> ~$ keystone --debug tenant-create --name demo --description "Default >> Tenant" >> REQ: curl -i http://localhost:35357/v2.0/tenants -X POST -H "User-Agent: >> python-keystoneclient" -H "Content-Type: application/json" -H >> "X-Auth-Token: 012345SECRET99TOKEN012345" >> REQ BODY: {"tenant": {"enabled": true, "name": "demo", "description": >> "Default Tenant"}} >> >> RESP: [500] {'date': 'Wed, 05 Jun 2013 09:06:35 GMT', 'content-type': >> 'application/json', 'content-length': '401', 'vary': 'X-Auth-Token'} >> RESP BODY: {"error": {"message": "An unexpected error prevented the >> server from fulfilling your request. (ProgrammingError) (1146, \"Table >> 'keystone.project' doesn't exist\") 'INSERT INTO project (id, name, >> domain_id, description, enabled, extra) VALUES (%s, %s, %s, %s, %s, %s)' >> ('9b7781a3a27c4ecaae86e0766999498c', 'demo', 'default', 'Default Tenant', >> 1, '{}')", "code": 500, "title": "Internal Server Error"}} >> >> Request returned failure status: 500 >> Unable to communicate with identity service: {"error": {"message": "An >> unexpected error prevented the server from fulfilling your request. >> (ProgrammingError) (1146, \"Table 'keystone.project' doesn't exist\") >> 'INSERT INTO project (id, name, domain_id, description, enabled, extra) >> VALUES (%s, %s, %s, %s, %s, %s)' ('9b7781a3a27c4ecaae86e0766999498c', >> 'demo', 'default', 'Default Tenant', 1, '{}')", "code": 500, "title": >> "Internal Server Error"}}. (HTTP 500)**** >> >> ** ** >> >> Error-2: >> ~$ keystone user-list >> Unable to communicate with identity service: {"error": {"message": "An >> unexpected error prevented the server from fulfilling your request. >> (ProgrammingError) (1146, \"Table 'keystone.user' doesn't exist\") 'SELECT >> user.id AS user_id, user.name AS user_name, user.domain_id AS >> user_domain_id, user.password AS user_password, user.enabled AS >> user_enabled, user.extra AS user_extra \\nFROM user' ()", "code": 500, >> "title": "Internal Server Error"}}. (HTTP 500)**** >> >> I am stuck here, any help or hint is greatly appreciated.**** >> >> Thanks**** >> >> Sreejith**** >> > >
_______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : openstack@lists.launchpad.net Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp