Bug 1044661 - mysql and phpmyadmin variable can not changed by setting environment variables [NEEDINFO]
Summary: mysql and phpmyadmin variable can not changed by setting environment variables
Keywords:
Status: CLOSED WORKSFORME
Alias: None
Product: OpenShift Container Platform
Classification: Red Hat
Component: ImageStreams
Version: 2.2.0
Hardware: Unspecified
OS: Linux
low
unspecified
Target Milestone: ---
: ---
Assignee: Jason DeTiberus
QA Contact: libra bugs
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-12-18 18:58 UTC by karan pujara
Modified: 2016-05-25 13:20 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-09-18 23:50:28 UTC
Target Upstream Version:
bleanhar: needinfo? (karanpujara17)
bvarga: needinfo? (karanpujara17)


Attachments (Terms of Use)

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.


Note You need to log in before you can comment on or make changes to this bug.