You don't have the keystone tables, so keystone-manage didn't create them.<br><br>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.<br>
<br>I don't know what else could be, I never had a similar problem.<br><br>.a.<br><br><div class="gmail_quote">On Mon, Nov 18, 2013 at 10:14 AM, Krishanu Dhar <span dir="ltr"><<a href="mailto:rony.kris@gmail.com" target="_blank">rony.kris@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Any pointers to what could be wrong?</div><div class="gmail_extra"><div><div class="h5"><br><br><div class="gmail_quote">
On Mon, Nov 18, 2013 at 2:58 AM, Krishanu Dhar <span dir="ltr"><<a href="mailto:rony.kris@gmail.com" target="_blank">rony.kris@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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"><div><div>
<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 border="0" cellpadding="0" cellspacing="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>
<br>
<table border="0" cellpadding="0" cellspacing="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></div></div><span><font color="#888888">-- <br>Krishanu
</font></span></div>
</blockquote></div><br><br clear="all"><div><br></div></div></div><span class="HOEnZb"><font color="#888888">-- <br>Krishanu
</font></span></div>
</blockquote></div><br><br clear="all"><br>-- <br><a href="mailto:antonio.s.messina@gmail.com" target="_blank">antonio.s.messina@gmail.com</a><br><a href="mailto:antonio.messina@uzh.ch" target="_blank">antonio.messina@uzh.ch</a> +41 (0)44 635 42 22<br>
GC3: Grid Computing Competence Center <a href="http://www.gc3.uzh.ch/" target="_blank">http://www.gc3.uzh.ch/</a><br>University of Zurich<br>Winterthurerstrasse 190<br>CH-8057 Zurich Switzerland<br>