<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Tue, May 23, 2017 at 11:24 AM, Dimitra Zuccarelli <span dir="ltr"><<a href="mailto:dimitrazuccarelli@gmail.com" target="_blank">dimitrazuccarelli@gmail.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"><div dir="ltr">Hi, <div><br></div><div>I've just had to wipe my computer so I'm in the process of trying to get Openshift back up and running with the UPS template. </div><div><br></div><div>I can't seem to get it working because the MySQL pods consistently fail with the error:</div><div><br></div><p style="margin:0px;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timest<wbr>amp server option (see documentation for more details).</font></span></p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Menlo;min-height:14px"><span style="background-color:rgb(255,255,255)"><font color="#000000"><span></span><br></font></span></p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Menlo"><span style="background-color:rgb(255,255,255)"><font color="#000000">[ERROR] The server option 'lower_case_table_names' is configured to use case sensitive table names but the data directory is on a case-insensitive file system which is an unsupported combination. Please consider either using a case sensitive file system for your data directory or switching to a case-insensitive table name mode.</font></span></p>
<p style="margin:0px;text-align:right;font-size:12px;line-height:normal;font-family:Menlo;min-height:14px"><span style="background-color:rgb(255,255,255)"><font color="#000000"><span></span><br></font></span></p>
<div><span style="background-color:rgb(255,255,255)"><font color="#000000"><span style="font-family:Menlo;font-size:12px">[ERROR] Aborting</span> </font></span></div><div><br></div><div>I've set the env variable <span style="background-color:rgb(255,255,255)"><font color="#000000"><span style="font-family:Menlo,Monaco,"Courier New",monospace;font-size:12px;white-space:pre-wrap">LOWER_CASE_TABLE_NAME<wbr>S </span></font></span>to <span style="background-color:rgb(255,255,255)"><font color="#000000"><span style="font-family:Menlo,Monaco,"Courier New",monospace;font-size:12px;white-space:pre-wrap">2 (</span></font></span><a href="https://hub.docker.com/r/centos/mysql-57-centos7/" target="_blank">https://hub.docker.com/r/cent<wbr>os/mysql-57-centos7/</a>) but I'm still getting the same error. </div><div><br></div><div>Does anyone have any insight on how to fix this? </div></div></blockquote><div><br></div><div>I'm just curious how you got a case insensitive filesystem.</div><div><br></div><div>Also the env variable is "<span style="background-color:rgb(248,248,248);color:rgb(51,51,51);font-family:Consolas,"Liberation Mono",Courier,monospace;font-size:14px">MYSQL_LOWER_CASE_TABLE_NAMES" not "</span><span style="background-color:rgb(248,248,248);color:rgb(51,51,51);font-family:Consolas,"Liberation Mono",Courier,monospace;font-size:14px">LOWER_CASE_TABLE_NAMES</span><span style="background-color:rgb(248,248,248);color:rgb(51,51,51);font-family:Consolas,"Liberation Mono",Courier,monospace;font-size:14px">"</span> That may be a problem too.</div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Thanks!</div><span class="gmail-m_-8011802230425624737HOEnZb"><font color="#888888"><div><br></div><div>Dimitra</div></font></span></div>
<br>______________________________<wbr>_________________<br>
aerogear-dev mailing list<br>
<a href="mailto:aerogear-dev@lists.jboss.org" target="_blank">aerogear-dev@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" rel="noreferrer" target="_blank">https://lists.jboss.org/mailma<wbr>n/listinfo/aerogear-dev</a><br></blockquote></div><br></div></div>