<div dir="ltr"><div>'keystone-manage db_sync' was failing to create the keystone tables. When I used root privileges, it succeeded and tenants, users and roles setup succeeded.<br><br></div>BR<br>Sreejith<br></div>
<div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Jun 5, 2013 at 3:18 PM, Sreejith N <span dir="ltr"><<a href="mailto:sreejith.naarakathil@gmail.com" target="_blank">sreejith.naarakathil@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 class="im"><div dir="ltr"><div><div><div>I have the following line in keystone.conf:<br>connection = mysql://keystone:keystone@localhost/keystone<br>
<br></div>mysql> SHOW DATABASES;<br>+--------------------+<br>| Database |<br>
+--------------------+<br>
| information_schema |<br>| keystone |<br><br>mysql> select User from mysql.user;<br>+------------------+<br>
| User |<br>+------------------+<br>| keystone |<br><br>mysql> show grants for 'keystone'@'localhost';<br>+-----------------------------------------------------------------------------------------------------------------+<br>
| Grants for keystone@localhost |<br>+-----------------------------------------------------------------------------------------------------------------+<br>
| GRANT USAGE ON *.* TO 'keystone'@'localhost' IDENTIFIED BY PASSWORD '*936E8F7AB2E21B47F6C9A7E5D9FE14DBA2255E5A' |<br>| GRANT ALL PRIVILEGES ON `keystone`.* TO 'keystone'@'localhost' |<br>
+-----------------------------------------------------------------------------------------------------------------+<br><br></div>Also I verified the database connection with the keystone credentials. What else could go wrong?<br>
<div><br></div>Thanks<br></div>Sreejith<br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote"><div class="im">On Wed, Jun 5, 2013 at 2:53 PM, K, Shanthakumar <span dir="ltr"><<a href="mailto:shanthakumar.k@hp.com" target="_blank">shanthakumar.k@hp.com</a>></span> wrote:<br>
</div><div><div class="h5"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Ensure you have provided the passwords correctly in the all the configuration file.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Its seems your keystone itself not working properly.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Thanks<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Shanthakumar K<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Openstack [mailto:<a href="mailto:openstack-bounces%2Bsk13" target="_blank">openstack-bounces+sk13</a>=<a href="mailto:hp.com@lists.launchpad.net" target="_blank">hp.com@lists.launchpad.net</a>]
<b>On Behalf Of </b>Sreejith N<br>
<b>Sent:</b> Wednesday, June 05, 2013 2:49 PM<br>
<b>To:</b> <a href="mailto:openstack@lists.launchpad.net" target="_blank">openstack@lists.launchpad.net</a><br>
<b>Subject:</b> [Openstack] Issue with OpenStack installation on Ubuntu 12.04 LTS<u></u><u></u></span></p><div><div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<p class="MsoNormal">Hi,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> I am trying to setup Openstack in a single node architecture for evaluation. I am following the Openstack installation Guide for Ubuntu 12.04 LTS. I am getting the following error when trying to setup tenants, users and roles manually.<br>
<br>
OS: Ubuntu 12.04 LTS<br>
Model: Single node (For trying out OpenStack)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Error-1:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">~$ keystone --debug tenant-create --name demo --description "Default Tenant"<br>
REQ: curl -i <a href="http://localhost:35357/v2.0/tenants" target="_blank">http://localhost:35357/v2.0/tenants</a> -X POST -H "User-Agent: python-keystoneclient" -H "Content-Type: application/json" -H "X-Auth-Token: 012345SECRET99TOKEN012345"<br>
REQ BODY: {"tenant": {"enabled": true, "name": "demo", "description": "Default Tenant"}}<br>
<br>
RESP: [500] {'date': 'Wed, 05 Jun 2013 09:06:35 GMT', 'content-type': 'application/json', 'content-length': '401', 'vary': 'X-Auth-Token'}<br>
RESP BODY: {"error": {"message": "An unexpected error prevented the server from fulfilling your request. (ProgrammingError) (1146, \"Table 'keystone.project' doesn't exist\") 'INSERT INTO project (id, name, domain_id, description, enabled, extra) VALUES (%s,
%s, %s, %s, %s, %s)' ('9b7781a3a27c4ecaae86e0766999498c', 'demo', 'default', 'Default Tenant', 1, '{}')", "code": 500, "title": "Internal Server Error"}}<br>
<br>
Request returned failure status: 500<br>
Unable to communicate with identity service: {"error": {"message": "An unexpected error prevented the server from fulfilling your request. (ProgrammingError) (1146, \"Table 'keystone.project' doesn't exist\") 'INSERT INTO project (id, name, domain_id, description,
enabled, extra) VALUES (%s, %s, %s, %s, %s, %s)' ('9b7781a3a27c4ecaae86e0766999498c', 'demo', 'default', 'Default Tenant', 1, '{}')", "code": 500, "title": "Internal Server Error"}}. (HTTP 500)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Error-2:<br>
~$ keystone user-list<br>
Unable to communicate with identity service: {"error": {"message": "An unexpected error prevented the server from fulfilling your request. (ProgrammingError) (1146, \"Table 'keystone.user' doesn't exist\") 'SELECT
<a href="http://user.id" target="_blank">user.id</a> AS user_id, <a href="http://user.name" target="_blank">user.name</a> AS user_name, user.domain_id AS user_domain_id, user.password AS user_password, user.enabled AS user_enabled, user.extra AS user_extra
<a>\\nFROM</a> user' ()", "code": 500, "title": "Internal Server Error"}}. (HTTP 500)<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">I am stuck here, any help or hint is greatly appreciated.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Sreejith<u></u><u></u></p>
</div>
</div>
</div></div></div>
</div>
</blockquote></div></div></div><br></div>
</blockquote></div><br></div>