Bug 1044840 - can not change OPENSHIFT_MYSQL_FT_MIN_WORD_LEN=2 in mysql phpmyadmin
Summary: can not change OPENSHIFT_MYSQL_FT_MIN_WORD_LEN=2 in mysql phpmyadmin
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: OpenShift Online
Classification: Red Hat
Component: Image
Version: 2.x
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: ---
: ---
Assignee: Dan McPherson
QA Contact: libra bugs
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-12-19 05:28 UTC by karan pujara
Modified: 2015-05-15 00:36 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-01-30 00:53:43 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description karan pujara 2013-12-19 05:28:54 UTC
sir our many application depends on fulltext search please look at this bug and reply as soon as possible

i want to change my.cnf file and i have seen comment in my.cnf file that i have to set it through "rhc env set " comand. i set follwing environment variables 

rhc env set OPENSHIFT_MYSQL_LOWER_CASE_TABLE_NAMES=1 -a mysd
rhc env set OPENSHIFT_MYSQL_FT_MIN_WORD_LEN=2 -a mysd

and i restarted
  rhc cartridge restart mysql-5.1 -a mysd
 rhc cartridge restart phpmyadmin-4 -a mysd 

then i open
https://mysd-studentdesk.rhcloud.com/phpmyadmin in variable section MYSQL_LOWER_CASE_TABLE_NAMES=1 (changed from 0 to 1)

but 

FT_MIN_WORD_LEN=4 (remains 4 i want 2)

i can only change MYSQL_LOWER_CASE_TABLE_NAMES variable nothing else.

Comment 1 Dan McPherson 2013-12-20 14:40:25 UTC
https://github.com/openshift/origin-server/pull/4387

Comment 3 chunchen 2013-12-23 06:12:51 UTC
It's fixed, verified on devenv_4167, please refer to the following results:

1. Create an app
rhc app create ceap6 jbosseap-6 --no-git
2. Add mysql and phpmyadmin
rhc cartridge add -c mysql-5.5 -a ceap6
rhc cartridge add -c phpmyadmin-4 -a ceap6
3. Set OPENSHIFT_MYSQL_FT_MIN_WORD_LEN variable
rhc env set OPENSHIFT_MYSQL_FT_MIN_WORD_LEN=2 -a ceap6
4. Check the value of OPENSHIFT_MYSQL_FT_MIN_WORD_LEN

at step 4:
1) ]$ rhc ssh ceap6 'env |grep FT_MIN_WORD_LEN'
OPENSHIFT_MYSQL_FT_MIN_WORD_LEN=2

2) open https://ceap6-cdm.dev.rhcloud.com/phpmyadmin in "Variables" section, the "ft min word len" is setted to 2.

Comment 4 chunchen 2013-12-24 01:47:15 UTC
BTW, we should restart mysql and phpmyadmin after set "OPENSHIFT_MYSQL_FT_MIN_WORD_LEN" variable in Comment 3 to make the variable take effect when testing it. 

Thanks!


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