<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; font-size: 14px; font-family: Calibri, sans-serif; ">
<div>
<div>
<div style="color: rgb(0, 0, 0); ">Joe</div>
<div style="color: rgb(0, 0, 0); ">Here is the output of the mysql query after the endpoint-list command failed</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); ">If I am not mistaken, the following is true </div>
<ul>
<li style="color: rgb(0, 0, 0); ">401e7115c7744baea8bdbd5560252707 = is the identity services</li><li>85d4f12015d244acaa1156f59c118f35 = is the admin url ID for the nova compute node – </li><li style="color: rgb(0, 0, 0); ">37461be338984ee380a389625992d622 = is the admin url ID for the nova volume service</li><li style="color: rgb(0, 0, 0); ">eca4477d4705441294337424bbb7bf06 = is the admin url ID for the image service</li><li style="color: rgb(0, 0, 0); ">abf973a6a42647779e425a553349e00e = is the admin url ID for the ec2 compatibility service</li><li style="color: rgb(0, 0, 0); ">8e718ce9ad02400ab4e154a45c07a535 = is the admin url ID for the object storage service</li></ul>
<div style="color: rgb(0, 0, 0); ">is the <font color="#ff0000">null</font> value in nova compute node entry from the keystone DB a problem? If yes how do I fix?</div>
<div style="color: rgb(0, 0, 0); ">If not, any other clues ???</div>
<div style="color: rgb(0, 0, 0); "><i><br>
</i></div>
<div style="color: rgb(0, 0, 0); "><i>Thanks for all your help to a newbie!</i></div>
<div style="color: rgb(0, 0, 0); "><i>Jonathan</i></div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); "># <b>keystone endpoint-list</b></div>
<div style="color: rgb(0, 0, 0); ">No handlers could be found for logger "keystoneclient.v2_0.client"</div>
<div style="color: rgb(0, 0, 0); ">Authorization Failed: An unexpected error prevented the server from fulfilling your request. 'NoneType' object has no attribute 'replace' (HTTP 500)</div>
</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<div style="color: rgb(0, 0, 0); ">mysql> <b>select * from endpoint;</b></div>
<div style="color: rgb(0, 0, 0); ">+----------------------------------+-----------+----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+</div>
<div style="color: rgb(0, 0, 0); ">| id | region | service_id | extra
|</div>
<div style="color: rgb(0, 0, 0); ">+----------------------------------+-----------+----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+</div>
<div style="color: rgb(0, 0, 0); ">| 401e7115c7744baea8bdbd5560252707 | RegionOne | 6ed04aa7ec2f47648c65aa68b4869049 | {"adminurl": "http://10.202.183.111:35357/v2.0", "internalurl": "http://10.202.183.111:5000/v2.0", "publicurl": "http://10.202.183.111:5000/v2.0"}
|</div>
<div><span style="color: rgb(0, 0, 0); ">| 85d4f12015d244acaa1156f59c118f35 | RegionOne | 9baa57ddfefc4dacbb1aa98f85ac2c4c | {"adminurl":
</span><font color="#ff0000">null</font>, "internalurl": "http://10.202.183.111:8774/v2/%(tenant_id)s--adminurl=http://10.202.183.111:8774/v2/%(tenant_id)s", "publicurl": "http://10.202.183.111:8774/v2/%(tenant_id)s"} |</div>
<div style="color: rgb(0, 0, 0); ">| 37461be338984ee380a389625992d622 | RegionOne | d5352eed37f54e1fb0513758b4d30318 | {"adminurl": "http://10.202.183.111:8776/v1/%(tenant_id)s", "internalurl": "http://10.202.183.111:8776/v1/%(tenant_id)s", "publicurl": "http://10.202.183.111:8776/v1/%(tenant_id)s"}
|</div>
<div style="color: rgb(0, 0, 0); ">| eca4477d4705441294337424bbb7bf06 | RegionOne | 9a3e242a74284e56928a2cb797a728ec | {"adminurl": "http://10.202.183.111:9292", "internalurl": "http://10.202.183.111:9292", "publicurl": "http://10.202.183.111:9292"}
|</div>
<div style="color: rgb(0, 0, 0); ">| abf973a6a42647779e425a553349e00e | RegionOne | 01f1ae7d6554405fb5be9680e9c992bb | {"adminurl": "http://10.202.183.111:8773/services/Admin", "internalurl": "http://10.202.183.111:8773/services/Cloud", "publicurl": "http://10.202.183.111:8773/services/Cloud"}
|</div>
<div style="color: rgb(0, 0, 0); ">| 8e718ce9ad02400ab4e154a45c07a535 | RegionOne | f6f5f15827184aecac096703dc3b472a | {"adminurl": "http://10.202.183.111:8888/v1", "internalurl": "http://10.202.183.111:8888/v1/AUTH_%(tenant_id)s", "publicurl": "http://10.202.183.111:8888/v1/AUTH_%(tenant_id)s"}
|</div>
<div style="color: rgb(0, 0, 0); ">+----------------------------------+-----------+----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+</div>
<div style="color: rgb(0, 0, 0); ">6 rows in set (0.00 sec)</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
</div>
<div style="color: rgb(0, 0, 0); "><br>
</div>
<span id="OLK_SRC_BODY_SECTION" style="color: rgb(0, 0, 0); ">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>Joe Topjian <<a href="mailto:joe.topjian@cybera.ca">joe.topjian@cybera.ca</a>><br>
<span style="font-weight:bold">Date: </span>Monday, March 18, 2013 7:10 AM<br>
<span style="font-weight:bold">To: </span>Jonathan Gershater <<a href="mailto:jonathan_gershater@trendmicro.com">jonathan_gershater@trendmicro.com</a>><br>
<span style="font-weight:bold">Cc: </span>"<a href="mailto:openstack-operators@lists.openstack.org">openstack-operators@lists.openstack.org</a>" <<a href="mailto:openstack-operators@lists.openstack.org">openstack-operators@lists.openstack.org</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [Openstack-operators] Identity service installation - authorization problem<br>
</div>
<div><br>
</div>
<div>
<div>
<div dir="ltr">Hi Jonathan,
<div><br>
</div>
<div style="">The last few lines of the error message look interesting:</div>
<div style=""><br>
</div>
<div style="">
<div> File "/usr/lib/python2.6/site-packages/keystone/catalog/backends/sql.py", line 160, in get_catalog</div>
<div> admin_url = ep['adminurl'].replace('$(', '%(')</div>
<div>AttributeError: 'NoneType' object has no attribute 'replace'</div>
<div><br>
</div>
<div style="">Are you able to do a "keystone endpoint-list" and see if the Admin URL is correct for all endpoints? If that command fails, you can run the following MySQL query against the keystone database:</div>
<div style=""><br>
</div>
<div style="">select * from endpoint</div>
<div style=""><br>
</div>
<div style="">And review the "adminurl" data in the "extra" column.</div>
<div style=""><br>
</div>
<div style="">Thanks,</div>
<div style="">Joe</div>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Fri, Mar 15, 2013 at 10:44 AM, <a href="mailto:jonathan_gershater@trendmicro.com">
jonathan_gershater@trendmicro.com</a> <span dir="ltr"><<a href="mailto:jonathan_gershater@trendmicro.com" target="_blank">jonathan_gershater@trendmicro.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="font-size:14px;font-family:Calibri,sans-serif;word-wrap:break-word">
<div>Hi</div>
<div>( first time user of openstack on Centos 6.4 with MySQL backend )</div>
<div><br>
</div>
<div>I am following these manual steps </div>
<div><a href="http://docs.openstack.org/folsom/openstack-compute/install/yum/content/ch_installing-openstack-overview.html" target="_blank">http://docs.openstack.org/folsom/openstack-compute/install/yum/content/ch_installing-openstack-overview.html</a></div>
<div><br>
</div>
<div>I installed the identity service and appeared to have no problems.</div>
<div><br>
</div>
<div>I verify using these steps</div>
<div><a href="http://docs.openstack.org/folsom/openstack-compute/install/yum/content/verifying-identity-install.html" target="_blank">http://docs.openstack.org/folsom/openstack-compute/install/yum/content/verifying-identity-install.html</a></div>
<div><br>
</div>
<div>Authentication is successful and returns </div>
<div>================================</div>
<div>
<div>+----------+----------------------------------+</div>
<div>| Property | Value |</div>
<div>+----------+----------------------------------+</div>
<div>| expires | 2013-03-16T15:36:09Z |</div>
<div>| id | 9457d8cb44514a6aba6b5ea77c45b18b |</div>
<div>| user_id | 5eecad2d999f4f9388b2c65da88cead3 |</div>
<div>+----------+----------------------------------+</div>
</div>
<div><br>
</div>
<div>Authorization fails and returns:</div>
<div>=========================</div>
<div>
<div>root@openstack-controller ~]# keystone --os-username=admin --os-password=password --os-tenant-name=demo --os-auth-url=<a href="http://10.202.183.111:35357/v2.0" target="_blank">http://10.202.183.111:35357/v2.0</a> token-get</div>
<div>No handlers could be found for logger "keystoneclient.v2_0.client"</div>
<div>Authorization Failed: An unexpected error prevented the server from fulfilling your request. 'NoneType' object has no attribute 'replace' (HTTP 500)</div>
</div>
<div><br>
</div>
<div>And in the log file:</div>
<div>==============</div>
<div>
<div>File "/usr/lib/python2.6/site-packages/keystone/common/wsgi.py", line 204, in __call__</div>
<div> result = method(context, **params)</div>
<div> File "/usr/lib/python2.6/site-packages/keystone/service.py", line 340, in authenticate</div>
<div> metadata=metadata_ref)</div>
<div> File "/usr/lib/python2.6/site-packages/keystone/catalog/core.py", line 78, in get_catalog</div>
<div> return self.driver.get_catalog(user_id, tenant_id, metadata)</div>
<div> File "/usr/lib/python2.6/site-packages/keystone/catalog/backends/sql.py", line 160, in get_catalog</div>
<div> admin_url = ep['adminurl'].replace('$(', '%(')</div>
<div>AttributeError: 'NoneType' object has no attribute 'replace'</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Why is authorization failing ?</div>
</div>
<table>
<tbody>
<tr>
<td bgcolor="#ffffff"><font color="#000000">
<pre><table><tbody><tr><td><pre>TREND MICRO EMAIL NOTICE
The information contained in this email and any attachments is confidential
and may be subject to copyright or other intellectual property protection.
If you are not the intended recipient, you are not authorized to use or
disclose this information, and we request that you notify us by reply mail or
telephone and delete the original message from your mail system.
</pre></td></tr></tbody></table></pre>
</font></td>
</tr>
</tbody>
</table>
<br>
_______________________________________________<br>
OpenStack-operators mailing list<br>
<a href="mailto:OpenStack-operators@lists.openstack.org">OpenStack-operators@lists.openstack.org</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Joe Topjian
<div>Systems Administrator</div>
<div>Cybera Inc.</div>
<div><br>
</div>
<div><a href="http://www.cybera.ca" target="_blank">www.cybera.ca</a></div>
<div><br>
</div>
<div><font color="#666666"><span>Cybera</span><span> is a not-for-profit organization that works to spur and support innovation, for the economic benefit of Alberta, through the use of cyberinfrastructure.</span></font></div>
</div>
</div>
</div>
</span>
</body>
</html>
<table><tr><td bgcolor=#ffffff><font color=#000000><pre><table class="TM_EMAIL_NOTICE"><tr><td><pre>
TREND MICRO EMAIL NOTICE
The information contained in this email and any attachments is confidential
and may be subject to copyright or other intellectual property protection.
If you are not the intended recipient, you are not authorized to use or
disclose this information, and we request that you notify us by reply mail or
telephone and delete the original message from your mail system.
</pre></td></tr></table></pre></font></td></tr></table>