Bug 1223675

Summary:	Want to change the configuration of mysql-5.5 for changing character set utf-8mb4. Unable to get file my.cnf
Product:	OpenShift Container Platform	Reporter:	Raman Joshi <raman.joshi>
Component:	Unknown	Assignee:	Brenton Leanhardt <bleanhar>
Status:	CLOSED WONTFIX	QA Contact:	XiuJuan Wang <xiuwang>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	2.2.0	CC:	aos-bugs, jokerman, libra-bugs, libra-onpremise-devel, mmccomas, tiwillia, xtian
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-09-08 18:19:09 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Raman Joshi 2015-05-21 08:11:48 UTC

Description of problem:
Want to change the character set of mysql to utf-8mb4 for saving emoji in mysql-5.5. Unable to find conf file in ~/mysql/conf/my.cnf. One my.cnf file find in /etc/my.cnf. When I going to edit using vim, cat, nano it has the read only permission.

So please give me the solution for this problem. How can I edit mysql-5.5 configuration file of openshift server?

Comment 2 Raman Joshi 2015-05-21 08:26:32 UTC

We successfully  able to support UTF-8 in local database. But for openshift we investigate a lot and found that we do not have the permission to edit mysql configuration file. So we will look into this and let you know if we found any solution on that.
Steps we follow for support UTF-8 in local - 
a) Edit my.cnf by this command.
       > sudo vim  /etc/mysql/my.cnf
b) In there we add these lines
 
[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
init-connect='SET NAMES utf8mb4'
collation_server=utf8mb4_unicode_ci
character_set_server=utf8mb4
        
c) then restart the mysql service 
      > sudo /etc/init.d/mysql restart

Comment 3 Timothy Williams 2016-09-08 18:19:09 UTC

At this point in the release cycle, this feature is not important enough to be worked. Closing this.