Bug 1044661

Summary:	mysql and phpmyadmin variable can not changed by setting environment variables
Product:	OpenShift Container Platform	Reporter:	karan pujara <karanpujara17>
Component:	ImageStreams	Assignee:	Jason DeTiberus <jdetiber>
Status:	CLOSED WORKSFORME	QA Contact:	libra bugs <libra-bugs>
Severity:	unspecified	Docs Contact:
Priority:	low
Version:	2.2.0	CC:	bleanhar, karanpujara17, mfojtik, mmasters
Target Milestone:	---	Flags:	bleanhar: needinfo? (karanpujara17) bvarga: needinfo? (karanpujara17)
Target Release:	---
Hardware:	Unspecified
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2015-09-18 23:50:28 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:

Description karan pujara 2013-12-18 18:58:40 UTC

i tried to change ft_min_word_len=1
ft_stopword_file="" inmydomain/phpmyadmin but its says it is read only variable

i tried to set it by environment variable 
rhc env set OPENSHIFT_MYSQL_DB_FT_STOPWORD_FILE="" -a myapp  but it cant change, i tried rhc env set OPENSHIFT_MYSQL_DB_FT_MIN_WORD__len=2 but when i checked in phpmyadmin variable it was same as default 4

i tried OPENSHIFT_MYSQL_FT_STOPWORD_FILE (removed DB) but that is also didnot worked

so i think it is bug it should be changed, or is there any way to change that variables?

Comment 2 Brenton Leanhardt 2014-02-12 20:27:47 UTC

phpmyadmin does not ship with OpenShift enterprise.  Are you using OpenShift Online or Origin by any chance?

Comment 3 Brenton Leanhardt 2014-02-12 20:53:56 UTC

Looking at the mysql cartridge source these are the only configuration OPENSHIFT variables:

# Configurable Values:
# lower_case_table_names -> OPENSHIFT_MYSQL_LOWER_CASE_TABLE_NAMES
# default-storage-engine -> OPENSHIFT_MYSQL_DEFAULT_STORAGE_ENGINE
# max_connections -> OPENSHIFT_MYSQL_MAX_CONNECTIONS
# ft_min_word_len -> OPENSHIFT_MYSQL_FT_MIN_WORD_LEN
# ft_max_word_len -> OPENSHIFT_MYSQL_FT_MAX_WORD_LEN

See 
https://github.com/openshift/origin-server/blob/master/cartridges/openshift-origin-cartridge-mysql/conf/my.cnf.erb#L5 for more information.

I tried the following command and it worked as expected:

rhc set-env OPENSHIFT_MYSQL_FT_MIN_WORD_LEN=2 --app myapp

One thing to note is that you will have to restart the mysql gear for the configuration file to be regenerated.  That might be why you aren't seeing the changes you expect.

Comment 4 Balazs Varga 2014-07-28 09:18:51 UTC

According to Brenton it works.
Is it still an issue?

Comment 5 Miciah Dashiel Butler Masters 2015-09-18 23:50:28 UTC

Closing because we were unable to reproduce the problem, the original reporter has not responded in over a year, and we have had two major releases since the defect was originally reported.