<div dir="ltr">Antonio,<div><br></div><div>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).</div>
<div><br><div><br></div><div><div>test@folsom-controller:~$ mysqldump --no-data --databases keystone -uroot -ptest-- MySQL dump 10.13 Distrib 5.5.34, for debian-linux-gnu (x86_64)</div><div>--</div><div>-- Host: localhost Database: keystone</div>
<div>-- ------------------------------------------------------</div><div>-- Server version 5.5.34-0ubuntu0.12.04.1</div><div><br></div><div>/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;</div><div>
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;</div><div>/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;</div><div>/*!40101 SET NAMES utf8 */;</div><div>/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;</div>
<div>/*!40103 SET TIME_ZONE='+00:00' */;</div><div>/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;</div><div>/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;</div>
<div>/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;</div><div>/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;</div><div><br></div><div>--</div><div>-- Current Database: `keystone`</div>
<div>--</div><div><br></div><div>CREATE DATABASE /*!32312 IF NOT EXISTS*/ `keystone` /*!40100 DEFAULT CHARACTER SET latin1 */;</div><div><br></div><div>USE `keystone`;</div><div><br></div><div>--</div><div>-- Table structure for table `tenant`</div>
<div>--</div><div><br></div><div>DROP TABLE IF EXISTS `tenant`;</div><div>/*!40101 SET @saved_cs_client = @@character_set_client */;</div><div>/*!40101 SET character_set_client = utf8 */;</div><div>CREATE TABLE `tenant` (</div>
<div> `id` varchar(64) DEFAULT NULL,</div><div> `name` varchar(64) DEFAULT NULL,</div><div> `extra` varchar(100) DEFAULT NULL</div><div>) ENGINE=InnoDB DEFAULT CHARSET=latin1;</div><div>/*!40101 SET character_set_client = @saved_cs_client */;</div>
<div>/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;</div><div><br></div><div>/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;</div><div>/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;</div><div>/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;</div>
<div>/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;</div><div>/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;</div><div>/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;</div>
<div>/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;</div><div><br></div><div>-- Dump completed on 2013-11-17 13:24:35</div><div>test@folsom-controller:~$</div></div><div><br></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Sun, Nov 17, 2013 at 12:53 PM, Radek Smigielski <span dir="ltr"><<a href="mailto:radek.smigielski@ymail.com" target="_blank">radek.smigielski@ymail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<table cellspacing="0" cellpadding="0" border="0"><tbody><tr><td valign="top"><p dir="ltr">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.<br>
</p>
<p dir="ltr">----------------<br>
Radek ¦migielski</p>
</td></tr></tbody></table> <div>
<div>
<br>
<div>
<div style="font-size:0.9em">
<hr size="1">
<b>
<span style="font-weight:bold">From:</span>
</b>
Krishanu Dhar <<a href="mailto:rony.kris@gmail.com" target="_blank">rony.kris@gmail.com</a>>; <br>
<b>
<span style="font-weight:bold">To:</span>
</b>
<a href="mailto:openstack@lists.openstack.org" target="_blank">openstack@lists.openstack.org</a> <<a href="mailto:openstack@lists.openstack.org" target="_blank">openstack@lists.openstack.org</a>>; <br>
<b>
<span style="font-weight:bold">Subject:</span>
</b>
[Openstack] Folsom: No handlers could be found for logger "keystoneclient.client" <br>
<b>
<span style="font-weight:bold">Sent:</span>
</b>
Sun, Nov 17, 2013 5:47:22 AM <br>
</div><div><div class="h5">
<br>
<table cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td valign="top"><div dir="ltr">Hi,<br><div><br>I was doing a test deployment on openstack following the link
"<a rel="nofollow" href="http://docs.openstack.org/folsom/basic-install/content/basic-install_controller.html" target="_blank">http://docs.openstack.org/folsom/basic-install/content/basic-install_controller.html</a>" and ran into a keystone client issue.<br>
<br>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. <br><br><br>Pasted below is a snippet form the
logs with debug option enabled.<br><br>test@folsom-controller:~/devstack$ keystone --debug tenant-create --name=admin<br>connect: (localhost, 35357)<br>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}}'<br>
reply: 'HTTP/1.1 500 Internal Server Error\r\n'<br>header: Vary: X-Auth-Token<br>header: Content-Type: application/json<br>header: Date: Sun, 17 Nov 2013 05:26:47 GMT<br>header: Transfer-Encoding: chunked<br>No handlers could be found for logger "keystoneclient.client"<br>
Traceback (most recent call last):<br> File "/usr/bin/keystone", line 9, in <module><br> load_entry_point('python-keystoneclient==0.1.3', 'console_scripts', 'keystone')()<br> File "/usr/lib/python2.7/dist-packages/keystoneclient/shell.py", line 410, in main<br>
OpenStackIdentityShell().main(sys.argv[1:])<br> File "/usr/lib/python2.7/dist-packages/keystoneclient/shell.py", line 354, in main<br> args.func(self.cs, args)<br> File "/usr/lib/python2.7/dist-packages/keystoneclient/v2_0/shell.py", line 126, in do_tenant_create<br>
enabled=utils.string_to_bool(args.enabled))<br> File "/usr/lib/python2.7/dist-packages/keystoneclient/v2_0/tenants.py", line 83, in create<br> return self._create('/tenants', params, "tenant")<br>
File "/usr/lib/python2.7/dist-packages/keystoneclient/base.py", line 82, in _create<br> resp, body = self.api.post(url, body=body)<br> File "/usr/lib/python2.7/dist-packages/keystoneclient/client.py", line 180, in post<br>
return self._cs_request(url, 'POST', **kwargs)<br> File "/usr/lib/python2.7/dist-packages/keystoneclient/client.py", line 161, in _cs_request<br> **kwargs)<br> File "/usr/lib/python2.7/dist-packages/keystoneclient/client.py", line 141, in request<br>
raise exceptions.from_response(resp, body)<br>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)<br>
<br></div><div>krish<br clear="all"></div><div><br>-- <br>Krishanu
</div></div></td>
</tr>
</tbody>
</table>
</div></div></div>
</div>
</div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Krishanu
</div>