<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; ">
<div>Thank you Thomas and Joe, that UPDATE worked for me</div>
<div>Identity svc now up and running!</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<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 11:03 AM<br>
<span style="font-weight:bold">To: </span>Thomas Vachon <<a href="mailto:vachon@sessionm.com">vachon@sessionm.com</a>><br>
<span style="font-weight:bold">Cc: </span>Jonathan Gershater <<a href="mailto:jonathan_gershater@trendmicro.com">jonathan_gershater@trendmicro.com</a>>, "<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">+1
<div><br>
</div>
<div style="">Thomas beat me to it -- was just typing that up. :)</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Mon, Mar 18, 2013 at 1:02 PM, Thomas Vachon <span dir="ltr">
<<a href="mailto:vachon@sessionm.com" target="_blank">vachon@sessionm.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">If you look at this row:
<div class="im">
<div><br>
</div>
<div><span style="font-family: Calibri, sans-serif; font-size: 14px; ">| 85d4f12015d244acaa1156f59c118f35 | RegionOne | 9baa57ddfefc4dacbb1aa98f85ac2c4c | {"adminurl": </span><font color="#ff0000" style="font-family:Calibri,sans-serif;font-size:14px">null</font><span style="font-family: Calibri, sans-serif; font-size: 14px; ">,
"internalurl": "</span><a href="http://10.202.183.111:8774/v2/%(tenant_id)s--adminurl=http://10.202.183.111:8774/v2/%(tenant_id)s" style="font-family:Calibri,sans-serif;font-size:14px" target="_blank">http://10.202.183.111:8774/v2/%(tenant_id)s--adminurl=http://10.202.183.111:8774/v2/%(tenant_id)s</a><span style="font-family: Calibri, sans-serif; font-size: 14px; ">",
"publicurl": "</span><a href="http://10.202.183.111:8774/v2/%(tenant_id)s" style="font-family:Calibri,sans-serif;font-size:14px" target="_blank">http://10.202.183.111:8774/v2/%(tenant_id)s</a><span style="font-family: Calibri, sans-serif; font-size: 14px; ">"}
|</span><br>
</div>
<div><span style="font-family: Calibri, sans-serif; font-size: 14px; "><br>
</span></div>
</div>
<div><font face="Calibri,sans-serif"><span style="font-size:14px">You can see internalurl was munged and adminurl was included. Your best bet is to fix it by hand in mysql or drop and re-add the endpoint.</span></font></div>
<div><font face="Calibri,sans-serif"><span style="font-size:14px"><br>
</span></font></div>
<div><font face="Calibri,sans-serif"><span style="font-size:14px">A good insert would look like: UPDATE endpoint where id =' </span></font><span style="font-family: Calibri, sans-serif; font-size: 14px; ">85d4f12015d244acaa1156f59c118f</span><span style="font-family: Calibri, sans-serif; font-size: 14px; ">35'
set extra = '</span><span style="font-family: Calibri, sans-serif; font-size: 14px; ">{"adminurl": "http://</span><a href="http://10.202.183.111:8774/v2/%(tenant_id)s--adminurl=http://10.202.183.111:8774/v2/%(tenant_id)s" style="font-family:Calibri,sans-serif;font-size:14px" target="_blank">10.202.183.111:8774/v2/%(tenant_id)s</a>"<span style="font-family: Calibri, sans-serif; font-size: 14px; ">,
"internalurl": "</span><a href="http://10.202.183.111:8774/v2/%(tenant_id)s--adminurl=http://10.202.183.111:8774/v2/%(tenant_id)s" style="font-family:Calibri,sans-serif;font-size:14px" target="_blank">http://10.202.183.111:8774/v2/%(tenant_id)s</a><span style="font-family: Calibri, sans-serif; font-size: 14px; ">",
"publicurl": "</span><a href="http://10.202.183.111:8774/v2/%(tenant_id)s" style="font-family:Calibri,sans-serif;font-size:14px" target="_blank">http://10.202.183.111:8774/v2/%(tenant_id)s</a><span style="font-family: Calibri, sans-serif; font-size: 14px; ">"}';</span></div>
</div>
</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>