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