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
_______________________________________________ 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
