openstack team mailing list archive

[Sreejith N <sreejith.naarakathil@xxxxxxxxx>]

'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.naarakathil@xxxxxxxxx>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 <shanthakumar.k@xxxxxx>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.com@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *Sreejith N
>> *Sent:* Wednesday, June 05, 2013 2:49 PM
>> *To:* openstack@xxxxxxxxxxxxxxxxxxx
>> *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****
>>
>
>