Access database in Openshift

Question

Access database in Openshift

Asked 9 years, 2 months ago

Viewed 801 times

6

I deployed a project on OpenShift, I used a Cartridge to create a bank Mysql soon after the creation of the bank appear this information:

Mysql 5.5 database Added. Please make note of These credentials:

Root User: adminhtK8LZq Root Password: shKekKGKhHEH Database Name: Obolt

Connection URL: mysql://$OPENSHIFT_MYSQL_DB_HOST:$OPENSHIFT_MYSQL_DB_PORT/

You can Manage your new Mysql database by also embedding phpmyadmin. The phpmyadmin username and password will be the same as the Mysql credentials above.

But when I set up mine hibernate.cfg with this data the database is not created in the OpenShift.

Hibernate.cfg:

<!-- Database connection settings -->
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://$OPENSHIFT_MYSQL_DB_HOST:$OPENSHIFT_MYSQL_DB_PORT/oraculo </property>
        <property name="connection.username">adminhtK8LZq</property>
        <property name="connection.password">shKekKGKhHEH</property>
        ...

I have to pass some value in place of this URL, I tried to pass the ip that appears in phpMyAdmin but it didn’t work.

Any reason for the pass given by Openshift and the pass on Hibernate.cfg to be different?

– João Gonçalves

2015/10/06 at 08:47
And why would Hibernate create the bank? It is only able to create or update the tables in one existing bank. To do so, use <property name="hibernate.hbm2dll.auto">create</property>, or update in place of create.

– Caffé

2015/10/13 at 15:38
The bank already exists and I am using create

– DiegoAugusto

2015/10/13 at 15:47
You can access your Cartridge via ssh and see if you can connect using these credentials?

– guiandmag

2015/10/14 at 02:56
Yes, I can access using these credentials by phpMyAdmin as well

– DiegoAugusto

2015/10/14 at 11:09
vc has arrived put ip and port that so there in phpmyadmin there in mysql://$OPENSHIFT_MYSQL_DB_HOST:$OPENSHIFT_MYSQL_DB_PORT/ and make the deploy again ?

– Enzo Tiezzi

2015/10/14 at 17:01
I tried yes, but it’s still the same. I’m going to do one more test.

– DiegoAugusto

2015/10/14 at 17:02
I just tried again and nothing, when access to URL that would query the database is not created. URL: http://sistemaoraculo-projetounimed.rhcloud.com/usuario/usuarios/consultar

– DiegoAugusto

2015/10/14 at 17:12

Show 3 more comments

1 answer

Browser other questions tagged java hibernate tomcat openshift

You are not signed in. Login or sign up in order to post.

by Edgar Muniz Berlinck • **4,569** points · Answer 1 · 2015-10-15T18:56:29+00:00

I work with Openshift. I’ll explain to you what happens and how I usually work on this kind of thing.

Openshift has some variables to make your life easier. $OPENSHIFT_MYSQL_DB_HOST, $OPENSHIFT_MYSQL_DB_PORT and others are set there in openshift.

Below is an example of how I recover variables and connect using JDBC:

this.openShiftDbHost = System.getenv("OPENSHIFT_MYSQL_DB_HOST");
this.openShiftDbPort = System.getenv("OPENSHIFT_MYSQL_DB_PORT");
this.openShiftDbUser = System.getenv("OPENSHIFT_MYSQL_DB_USERNAME");
this.openShiftDbPassword = System.getenv("OPENSHIFT_MYSQL_DB_PASSWORD");
conexao =  DriverManager.getConnection("jdbc:mysql://"+this.openShiftDbHost+":"+this.openShiftDbPort+"/mydb?user="+this.openShiftDbUser+"&password="+this.openShiftDbPassword);

In the case of Hibernate I do the following coniguration:

<property name="url" value="jdbc:mysql://${OPENSHIFT_MYSQL_DB_HOST}:${OPENSHIFT_MYSQL_DB_PORT}/${OPENSHIFT_APP_NAME}" />
<property name="username" value="${OPENSHIFT_MYSQL_DB_USERNAME}" />
<property name="password" value="${OPENSHIFT_MYSQL_DB_PASSWORD}" />