openstack team mailing list archive

[Sreejith N <sreejith.naarakathil@xxxxxxxxx>]

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****
>