Bug 1044840

Summary:	can not change OPENSHIFT_MYSQL_FT_MIN_WORD_LEN=2 in mysql phpmyadmin
Product:	OpenShift Online	Reporter:	karan pujara <karanpujara17>
Component:	Image	Assignee:	Dan McPherson <dmcphers>
Status:	CLOSED CURRENTRELEASE	QA Contact:	libra bugs <libra-bugs>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	2.x	CC:	chunchen, 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:	2014-01-30 00:53:43 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-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 2 openshift-github-bot 2013-12-20 15:59:05 UTC

Commit pushed to master at https://github.com/openshift/origin-server

https://github.com/openshift/origin-server/commit/6c7b7faa4f82a8cf0c6899c2d37912c4b76d0548
Bug 1044840

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!