[aerogear-dev] Openshift UPS template

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[aerogear-dev] Openshift UPS template

Dimitra
Hi, 

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. 

I can't seem to get it working because the MySQL pods consistently fail with the error:

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).


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


[ERROR] Aborting 

I've set the env variable LOWER_CASE_TABLE_NAMES to 2 (https://hub.docker.com/r/centos/mysql-57-centos7/) but I'm still getting the same error. 

Does anyone have any insight on how to fix this? 
Thanks!

Dimitra

_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev
Reply | Threaded
Open this post in threaded view
|

Re: [aerogear-dev] Openshift UPS template

Matthias Wessendorf
does it work w/ MySQL 5.5 ? 

that's what we use on our installation, and in our docker-compose files 

On Tue, May 23, 2017 at 5:24 PM, Dimitra Zuccarelli <[hidden email]> wrote:
Hi, 

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. 

I can't seem to get it working because the MySQL pods consistently fail with the error:

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).


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


[ERROR] Aborting 

I've set the env variable LOWER_CASE_TABLE_NAMES to 2 (https://hub.docker.com/r/centos/mysql-57-centos7/) but I'm still getting the same error. 

Does anyone have any insight on how to fix this? 
Thanks!

Dimitra

_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev



--

_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev
Reply | Threaded
Open this post in threaded view
|

Re: [aerogear-dev] Openshift UPS template

Summers Pittman
In reply to this post by Dimitra


On Tue, May 23, 2017 at 11:24 AM, Dimitra Zuccarelli <[hidden email]> wrote:
Hi, 

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. 

I can't seem to get it working because the MySQL pods consistently fail with the error:

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).


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


[ERROR] Aborting 

I've set the env variable LOWER_CASE_TABLE_NAMES to 2 (https://hub.docker.com/r/centos/mysql-57-centos7/) but I'm still getting the same error. 

Does anyone have any insight on how to fix this? 

I'm just curious how you got a case insensitive filesystem.

Also the env variable is "MYSQL_LOWER_CASE_TABLE_NAMES" not "LOWER_CASE_TABLE_NAMES" That may be a problem too.

 
Thanks!

Dimitra

_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev


_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev
Reply | Threaded
Open this post in threaded view
|

Re: [aerogear-dev] Openshift UPS template

Dimitra
Thanks! 

I tried with the mysql 5.5 image but the easiest way was just using the correct env var, MYSQL_LOWER_CASE_TABLE_NAMES because I didn't have to change too much in the template. 

It's working well now, thanks for the help :) 

On Wed, May 24, 2017 at 1:41 PM, Summers Pittman <[hidden email]> wrote:


On Tue, May 23, 2017 at 11:24 AM, Dimitra Zuccarelli <[hidden email]> wrote:
Hi, 

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. 

I can't seem to get it working because the MySQL pods consistently fail with the error:

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).


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


[ERROR] Aborting 

I've set the env variable LOWER_CASE_TABLE_NAMES to 2 (https://hub.docker.com/r/centos/mysql-57-centos7/) but I'm still getting the same error. 

Does anyone have any insight on how to fix this? 

I'm just curious how you got a case insensitive filesystem.

Also the env variable is "MYSQL_LOWER_CASE_TABLE_NAMES" not "LOWER_CASE_TABLE_NAMES" That may be a problem too.

 
Thanks!

Dimitra

_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev


_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev


_______________________________________________
aerogear-dev mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-dev