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 <[email protected]> wrote: > Any pointers to what could be wrong? > > > On Mon, Nov 18, 2013 at 2:58 AM, Krishanu Dhar <[email protected]>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@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@folsom-controller:~$ >> >> >> >> On Sun, Nov 17, 2013 at 12:53 PM, Radek Smigielski < >> [email protected]> 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 <[email protected]>; >>> * To: * [email protected] <[email protected]>; >>> * 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@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 > -- [email protected] [email protected] +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
_______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : [email protected] Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
