Bug 893957 - Build jenkins failed for scalable cakephp applications.
Summary: Build jenkins failed for scalable cakephp applications.
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: OKD
Classification: Red Hat
Component: Templates
Version: 2.x
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ---
: ---
Assignee: Dan McPherson
QA Contact: libra bugs
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-01-10 11:06 UTC by Mengjiao Gao
Modified: 2015-05-15 02:12 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2013-01-17 03:22:22 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)
console out (109.14 KB, application/octet-stream)
2013-01-10 11:06 UTC, Mengjiao Gao
no flags Details

Description Mengjiao Gao 2013-01-10 11:06:43 UTC
Created attachment 676241 [details]
console out

Description of problem:
Build jenkins failed for scalable cakephp applications.

Version-Release number of selected component (if applicable):
devenv_2657,STG

How reproducible:
always

Steps to Reproduce:
1.Create a scalable cakephp app in website,and check the app url.
2.Enable jenkins to cakephp.
3.Build cakephp on jenkins server. 
  
Actual results:
1.the app url is accessable.
3.Build failed with following message:
-------------------------------------
....
ERROR 2003 (HY000): Can't connect to MySQL server on '466283a7bf-devyujie.dev.rhcloud.com' (111)
Exit code: 1
Build step 'Execute shell' marked build as failure
Archiving artifacts
Finished: FAILURE
-------------------------------------

Expected results:
3, the scalable cakephp should be built successfully.

Additional info:
The non-scalable cakephp can be built successfully on jenkins server.

For the scalable cakephp, I failed to connect the app's mysql using "mysql -u admin --password=qtSmwGTB-W1i -h 466283a7bf-devyujie.dev.rhcloud.com cakephpscale" in my machine.
This problem seems caused by the mysql server connection problem.

Comment 1 Dan McPherson 2013-01-16 20:31:41 UTC
Looks like it might just be the port isn't specified on the connection lines:

https://github.com/openshift/cakephp-example/blob/master/.openshift/action_hooks/deploy

/usr/bin/mysql -u "$OPENSHIFT_MYSQL_DB_USERNAME" --password="$OPENSHIFT_MYSQL_DB_PASSWORD" -h "$OPENSHIFT_MYSQL_DB_HOST" -e "select * from posts;" "$OPENSHIFT_APP_NAME"

and


/usr/bin/mysql -u "$OPENSHIFT_MYSQL_DB_USERNAME" --password="$OPENSHIFT_MYSQL_DB_PASSWORD" -h "$OPENSHIFT_MYSQL_DB_HOST" "$OPENSHIFT_APP_NAME" < "$OPENSHIFT_REPO_DIR/.openshift/action_hooks/cake.sql"

Comment 2 Dan McPherson 2013-01-16 20:58:12 UTC
Also this has nothing to do with jenkins right?  Just scaled cakephp.

Comment 3 Dan McPherson 2013-01-16 21:40:32 UTC
Fixed in github

Comment 4 Chandrika Gole 2013-01-17 03:22:22 UTC
verified this on devenv_2679


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