Failed to deploy teiiddemo on OpenShift scaled JBosseap 6 application

[yjma2001]

Hi,

I am tring to deploy the teiid into Openshift scaled JBosseap 6 application where mysql was added into a sperate gear, but at step of "git push", got follwoing error:

remote: MySQL already running

remote: Running .openshift/action_hooks/deploy

remote: ERROR 2003 (HY000): Can't connect to MySQL server on '5165fb985004461cf6000177-yongjie.rhcloud.com' (110)

remote:

remote: Could not find mysql database.

remote: Creating database for application named: jack03s. 1

remote: /usr/bin/mysqladmin: connect to server at '5165fb985004461cf6000177-yongjie.rhcloud.com' failed

remote: error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 110'

remote: hot_deploy_added=false

Thanks

Jack

[mdrillin]

Jack,

The teiid demo uses the action hook script located in .openshift/action_hooks/deploy to create and load the demo MySQL database.  You can just edit the script to remove its contents then re-push.  Then use the DDL at .openshift/action_hooks/customer-schema.sql to load your MySQL database at the location where it is installed.  You can also install phpMyAdmin cartridge to make admin of the db easier.

Thanks,
Mark