Open Stack

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