Open Stack

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20131118/12b4ca5c/attachment.html>