Open Stack

You don't have the keystone  tables, so keystone-manage didn't create them.

Maybe the credentials in the configuration file are not correct. You should
use exactly the same credentials to connect using the `mysql` command and
test if you are actually able to create an empty table. Remember to use the
-h option an specify the hostname you have in the keystone.conf file.

I don't know what else could be, I never had a similar problem.

.a.

On Mon, Nov 18, 2013 at 10:14 AM, Krishanu Dhar <rony.kris at gmail.com> wrote:

> Any pointers to what could be wrong?
>
>
> On Mon, Nov 18, 2013 at 2:58 AM, Krishanu Dhar <rony.kris at gmail.com>wrote:
>
>> Antonio,
>>
>> Yes it was weird. So, as requested below is the dump. Note: ignore the
>> table by the name "tenant". I created it manually to check if the keystone
>> commands go through. (it did).
>>
>>
>> test at folsom-controller:~$ mysqldump --no-data --databases keystone
>> -uroot -ptest-- MySQL dump 10.13  Distrib 5.5.34, for debian-linux-gnu
>> (x86_64)
>> --
>> -- Host: localhost    Database: keystone
>> -- ------------------------------------------------------
>> -- Server version       5.5.34-0ubuntu0.12.04.1
>>
>> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
>> /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
>> /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
>> /*!40101 SET NAMES utf8 */;
>> /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
>> /*!40103 SET TIME_ZONE='+00:00' */;
>> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
>> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
>> FOREIGN_KEY_CHECKS=0 */;
>> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
>> */;
>> /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
>>
>> --
>> -- Current Database: `keystone`
>> --
>>
>> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `keystone` /*!40100 DEFAULT
>> CHARACTER SET latin1 */;
>>
>> USE `keystone`;
>>
>> --
>> -- Table structure for table `tenant`
>> --
>>
>> DROP TABLE IF EXISTS `tenant`;
>> /*!40101 SET @saved_cs_client     = @@character_set_client */;
>> /*!40101 SET character_set_client = utf8 */;
>> CREATE TABLE `tenant` (
>>   `id` varchar(64) DEFAULT NULL,
>>   `name` varchar(64) DEFAULT NULL,
>>   `extra` varchar(100) DEFAULT NULL
>> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
>> /*!40101 SET character_set_client = @saved_cs_client */;
>> /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
>>
>> /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
>> /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
>> /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
>> /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
>> /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
>> /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
>> /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
>>
>> -- Dump completed on 2013-11-17 13:24:35
>> test at folsom-controller:~$
>>
>>
>>
>> On Sun, Nov 17, 2013 at 12:53 PM, Radek Smigielski <
>> radek.smigielski at ymail.com> wrote:
>>
>>> Krish, check your database. Looks like keystone cannot find the tenant
>>> table. Do you have the database setup? Login to your database and check if
>>> you see tenant database and if all the tables are there.
>>>
>>> ----------------
>>> Radek Śmigielski
>>>
>>>  ------------------------------
>>> * From: * Krishanu Dhar <rony.kris at gmail.com>;
>>> * To: * openstack at lists.openstack.org <openstack at lists.openstack.org>;
>>> * Subject: * [Openstack] Folsom: No handlers could be found for logger
>>> "keystoneclient.client"
>>> * Sent: * Sun, Nov 17, 2013 5:47:22 AM
>>>
>>>   Hi,
>>>
>>> I was doing a test deployment on openstack following the link "
>>> http://docs.openstack.org/folsom/basic-install/content/basic-install_controller.html"
>>> and ran into a keystone client issue.
>>>
>>> The issue is; while trying to create a tenant it's failing with a
>>> keystoneclient.exception. How do i go about fixing this? Unless i get this
>>> working i cannot proceed.
>>>
>>>
>>> Pasted below is a snippet form the logs with debug option enabled.
>>>
>>> test at folsom-controller:~/devstack$ keystone --debug tenant-create
>>> --name=admin
>>> connect: (localhost, 35357)
>>> send: 'POST /v2.0/tenants HTTP/1.1\r\nHost:
>>> localhost:35357\r\nContent-Length: 67\r\nx-auth-token:
>>> test\r\ncontent-type: application/json\r\naccept-encoding: gzip,
>>> deflate\r\nuser-agent: python-keystoneclient\r\n\r\n{"tenant": {"enabled":
>>> true, "name": "admin", "description": null}}'
>>> reply: 'HTTP/1.1 500 Internal Server Error\r\n'
>>> header: Vary: X-Auth-Token
>>> header: Content-Type: application/json
>>> header: Date: Sun, 17 Nov 2013 05:26:47 GMT
>>> header: Transfer-Encoding: chunked
>>> No handlers could be found for logger "keystoneclient.client"
>>> Traceback (most recent call last):
>>>   File "/usr/bin/keystone", line 9, in <module>
>>>     load_entry_point('python-keystoneclient==0.1.3', 'console_scripts',
>>> 'keystone')()
>>>   File "/usr/lib/python2.7/dist-packages/keystoneclient/shell.py", line
>>> 410, in main
>>>     OpenStackIdentityShell().main(sys.argv[1:])
>>>   File "/usr/lib/python2.7/dist-packages/keystoneclient/shell.py", line
>>> 354, in main
>>>     args.func(self.cs, args)
>>>   File "/usr/lib/python2.7/dist-packages/keystoneclient/v2_0/shell.py",
>>> line 126, in do_tenant_create
>>>     enabled=utils.string_to_bool(args.enabled))
>>>   File
>>> "/usr/lib/python2.7/dist-packages/keystoneclient/v2_0/tenants.py", line 83,
>>> in create
>>>     return self._create('/tenants', params, "tenant")
>>>   File "/usr/lib/python2.7/dist-packages/keystoneclient/base.py", line
>>> 82, in _create
>>>     resp, body = self.api.post(url, body=body)
>>>   File "/usr/lib/python2.7/dist-packages/keystoneclient/client.py", line
>>> 180, in post
>>>     return self._cs_request(url, 'POST', **kwargs)
>>>   File "/usr/lib/python2.7/dist-packages/keystoneclient/client.py", line
>>> 161, in _cs_request
>>>     **kwargs)
>>>   File "/usr/lib/python2.7/dist-packages/keystoneclient/client.py", line
>>> 141, in request
>>>     raise exceptions.from_response(resp, body)
>>> keystoneclient.exceptions.ClientException: An unexpected error prevented
>>> the server from fulfilling your request. (ProgrammingError) (1146, "Table
>>> 'keystone.tenant' doesn't exist") 'INSERT INTO tenant (id, name, extra)
>>> VALUES (%s, %s, %s)' ('42419636238a429992254b3419ffa6e7', 'admin',
>>> '{"enabled": true, "description": null}') (HTTP 500)
>>>
>>> krish
>>>
>>> --
>>> Krishanu
>>>
>>
>>
>>
>> --
>> Krishanu
>>
>
>
>
> --
> Krishanu
>



-- 
antonio.s.messina at gmail.com
antonio.messina at uzh.ch                     +41 (0)44 635 42 22
GC3: Grid Computing Competence Center      http://www.gc3.uzh.ch/
University of Zurich
Winterthurerstrasse 190
CH-8057 Zurich Switzerland
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20131118/4acd83ad/attachment.html>