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