<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jan 8, 2015 at 7:28 AM, Steven Dake <span dir="ltr"><<a href="mailto:sdake@redhat.com" target="_blank">sdake@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><span class="">On 01/07/2015 10:21 PM, Zhou, Zhenzan wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
Hi,<br>
<br>
Does anyone know why TripleO uses "regionOne" as default region name? A comment in the code says it's the default keystone uses.<br>
</blockquote>
<br></span>
Zhenzan,<br>
<br>
I was going to point you here:<br>
<br>
<a href="https://bugs.launchpad.net/keystone/+bug/1400589" target="_blank">https://bugs.launchpad.net/<u></u>keystone/+bug/1400589</a><br>
<br>
But I see you already had commented in that bug.<br></blockquote><div><br></div><div>If we're expecting OpenStack to generally do case-sensitive comparisons, then we shouldn't be using the default MySQL collation for char columns[1]. Maybe the text columns should be BINARY rather than CHAR, or use a different collation.<br><br>mysql> describe region;<br>+------------------+--------------+------+-----+---------+-------+<br>| Field            | Type         | Null | Key | Default | Extra |<br>+------------------+--------------+------+-----+---------+-------+<br>| id               | varchar(255) | NO   | PRI | NULL    |       |<br>| description      | varchar(255) | NO   |     | NULL    |       |<br>| parent_region_id | varchar(255) | YES  |     | NULL    |       |<br>| extra            | text         | YES  |     | NULL    |       |<br>| url              | varchar(255) | YES  |     | NULL    |       |<br>+------------------+--------------+------+-----+---------+-------+<br>5 rows in set (0.00 sec)<br><br>mysql> select collation(id) from region;<br>+-----------------+<br>| collation(id)   |<br>+-----------------+<br>| utf8_general_ci |<br>+-----------------+<br>1 row in set (0.00 sec)<br><br></div><div>It's not easy to alter the collation when it's a foreign key.<br></div><div><br>mysql> alter table region convert to character set utf8 collate utf8_bin;<br>ERROR 1025 (HY000): Error on rename of './keystone/#sql-3ffc_32' to './keystone/region' (errno: 150)<br><br>[1] <a href="http://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html">http://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html</a><br></div><div><br></div><div>- Brant<br><br></div></div></div></div>