Redhat - Simple Example With MySQL DB

STEP 1) Create project “mysqldsTest” and create “mysqldsTest.war” file

STEP 2) Create “mysqldsTest” App Openshift:

$ rhc app create -a mysqldsTest -t jbossas-7

STEP 3) Before starting adding content removing the current pom.xml and other artifacts
created at application creation is required:

$ git rm -r src pom.xml

$ git commit -m "removing artifacts from application creation phase"

STEP 4) Copy the “mysqldsTest.war” & “mysql-connector-java-5.1.20.jar” into “mysqldsTest/deployments/”

STEP 5) Add to your openshift git commit and push:

Now that you have a war file ready for deployment (mysqldsTest/deployments/mysqldsTest.war)

lets add it to the git repository and then commit and finally we will push the war to the openshift express instance.

Open a terminal window and switch the working directory to the application’s deployments
directory then execute the following commands:

$ cd deployments/

$ git add mysqldsTest.war

$ git commit -m "depolying myapp application" mysqldsTest.war

$ git push

Note that git repository is created at the root project level so all files can be added to git and not only the deployment.

STEP 6) 2 Ways To access MySQL Database:

    a) Using PhpAdmin:

    - Open the https://openshift.redhat.com/app/console/applications/mysqldsTest

        - Click on “Add Cartridge +” and Add “phpMyAdmin 3.4”

    - Save the Credentials.

    - Open: https://mysqldsTest-jsr10.rhcloud.com/phpmyadmin/

b) Using SSH (Open Terminal and Execute following commands):

    $ ssh fe734b753f194025a616bb14bf3689a3@mysqldsTest-jsr10.rhcloud.com

   

You will be now at “[mysqldsTest-jsr10.rhcloud.com ~]\>” path (i.e. “mysqldsTest” Applications root directory)

    [mysqldsTest-jsr10.rhcloud.com ~]\> mysql

       
        You will be now at “mysql>” path

mysql> show databases;

STEP 7) Your push completed and you application should be available at the following
openshift URL:

http://mysqldstest-jsr10.rhcloud.com/mysqldsTest/index.jsp