All Questions
318
questions
378
votes
10
answers
794k
views
Using env variable in Spring Boot's application.properties
We are working on a Spring Boot web application, and the database we are using is MySQL;
the setup we have is we first test it locally (means we need to install MySQL on our PC);
then we push to ...
- 3,809
67
votes
22
answers
359k
views
SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
I download from https://github.com/luciddreamz/laravel Laravel for openshift
then upload over my repository over github. This code for connect to database not work.
The problem is that load variable ...
- 755
27
votes
5
answers
39k
views
Openshift: How to remote access MySQL?
So I just finished setting up a JBoss application server gear on Openshift and I attached a MySQL and phpmyadmin cartridges. My question is if there is a way to remote access to the database server ...
- 1,037
9
votes
2
answers
3k
views
Run MySQL a prefilled docker container as random (non-root) linux user?
I am trying to create an OpenShift compliant prefilled MySQL container image.
Running the container with a specified user is (sadly) not an option for us.
This is a problem since OpenShift simply ...
- 2,532
6
votes
2
answers
9k
views
How to open DB connection in Openshift? [closed]
This is my dbcon file in PHP.
Basically, I need to connect my PHP application with openshift MySQL DB. Here's what I did.
<?php
// Database Connection Setting
$dbhost = "127.0.0.1"; // ...
- 2,896
5
votes
0
answers
1k
views
The pod has been stuck in the pending state for more than five minutes
Hello I new to openshift online . Tried to deploy mysql pod and got this Error n command line
error: update acceptor rejected mysql-8: pods for deployment "mysql-8" took longer than 600 seconds to ...
- 1,127
4
votes
5
answers
4k
views
How to access Openshift mysql via locally installed wamp phpMyAdmin?
i am using openshift free tier (3 gears). My scalable app uses PHP and MySQL. But unavailability of phpMyAdmin credentials for 3 gears scalable app it's difficult for me to access Mysql table entries. ...
- 354
4
votes
2
answers
510
views
Openshift MYSQL environment variables not set
all my MySQL environment variables result in an empty string such as
echo getenv('OPENSHIFT_MYSQL_DB_URL');
echo getenv('OPENSHIFT_MYSQL_DB_HOST');
however the others such as
echo getenv('...
4
votes
4
answers
11k
views
JDBC can't connect to mysql database on openshift
I managed to set up MySQL database on OpenShift with phpMyAdmin and all.
I was told the host name and port my for my database are $OPENSHIFT_MYSQL_DB_HOST and $OPENSHIFT_MYSQL_DB_PORT respectively, ...
- 9,927
4
votes
1
answer
616
views
How to configure webpy and MySQL on OpenShift
I want to know how to deploy webpy to-do example on openshift. Here is an official webpy example showing how to deploy a webpy app on openshift, but this example does not deal with mysql. Can anyone ...
- 151
4
votes
3
answers
3k
views
Configure MySQL connection in Openshift
I am new in Openshift, and I have one question.
I was able to create the database through "phpMyAdmin", but now, I am not able to connect to it.
The error I am getting, when I try to connect to the ...
- 105
4
votes
0
answers
1k
views
In Django cursor.execute("select ..") randomly returns None
I am running Django + MySql on OpenShift server and have this problem.
Code:
from django.db import connection
...
cursor = connection.cursor()
somedate = calculateSomeDate()
query = "SELECT id ...
- 53
3
votes
2
answers
19k
views
Cannot connect to MySQL db with nodejs (openshift app)
I have a nodejs (with express) openshift app that has a MySQL database (because that is what I am most familiar with), and I cannot figure out how to connect to it on the local environment. My last ...
- 974
3
votes
1
answer
733
views
Can I have more than one database per gear in openshift?
I've deployed Java apps and now a Grails app connected in OpenShift ... so far so good (cool service)
I can deploy more than 1 app to a single gear... but can I have more than 1 DB per gear ?
This ...
- 5,904
3
votes
1
answer
2k
views
Openshift: how import database to MySQL via RHC or SSH?
I have Openshift based scalable webapp with free account so I can't create phpmyadmin cartrige. Is there a way to import database to MySQL via RHC or SSH ?
- 917
3
votes
1
answer
2k
views
How to connect to Openshift database using PhpStorm?
I've tried to connect to OpenShift MySQL database using the following settings:
And
but I've got following error message:
Connection to ConnectionNAME failed
java.sql.SQLException: ...
- 248
3
votes
1
answer
1k
views
Jenkins-Sonar communication on Openshift
I am making a development environnement based on Jenkins and Sonar.
Both are placed on isolated gears.
The Jenkins gear has been created with the Instant App option.
The Sonar gear has been created ...
- 116
3
votes
2
answers
2k
views
OpenShift: Share MySQL-database between two applications
I have the following problem.
I have two application created app_1 and app_2
On app_1 MySQL is installed and has the following parameters:
OPENSHIFT_MYSQL_DB_PORT = 3306
OPENSHIFT_MYSQL_DB_HOST = ...
- 823
3
votes
3
answers
1k
views
Play framework 2.0.1 keeps trying to evolve wrong database type
I'm working on play 2.0.1 application deployed on openshift DIY-application.
I'm having troble with the database because play keeps trying to evolve the wrong database. I have a mysql database and ...
- 3,074
3
votes
1
answer
8k
views
OpenShift Pod gets stuck in pending state
MySQL pod in OpenShift gets stuck after new deployment and shows the message "The pod has been stuck in the pending state for more than five minutes." What can I do to solve this? I tried to scale the ...
3
votes
2
answers
614
views
After long period of inactivity Openshift app throws exception when connecting to mysql
I have an application on Openshift Tomcat 7 which makes use of MySQL via JPA (Hibernate). Everything works fine except when an action is taken which involves connecting to the database after the ...
- 11.9k
3
votes
0
answers
336
views
Openshift ERROR 2003 (HY000): Can't connect to MySQL server
MySql is not started , with the error
ERROR 2003 (HY000): Can't connect to MySQL server on 'xxxxxxxxxxx-yyyyyy.rhcloud.com' (111)
I used ctl_all restart from shell but , still it isn't starting.
...
- 621
2
votes
2
answers
8k
views
OpenShift webapps mysql java connection
I have a JBoss EWS Tomcat 7 Java application on openshift, installed with the MySQL 5.5 and PhpMyAdmin 4.0 cartridges. I have copied the repository locally, and deleted the source folder. Instead, I ...
- 567
2
votes
3
answers
17k
views
Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "OPENSHIFT_MYSQL_DB_PORT"'
I am trying to deploy my Jersey project on openshift. I have implemented this apple class to test the error in the another class since I guess the problem is with the establishing the database ...
- 964
2
votes
2
answers
2k
views
Openshift wordpress app: can't connect to mysql database
I have just set up an openshift wordpress application environment (http://eigenbouw-vanhove.rhcloud.com/) but i can't get a connection to the mysql database. I added the phpmyadmin cartridge and i ...
- 4,412
2
votes
1
answer
311
views
Automate MYSQL database backups on openshift
I would like to configure automated mysql database backups on openshift and I was wondering what the easiest approach is to achieve is ?
I've been reading online and one option seems to be setting up ...
- 891
2
votes
1
answer
574
views
Openshift - No suitable driver found for jdbc:mysql
I am new to Java and Servlet Programming. I am trying to host a simple application which is working successfully in localhost. but when i host it to Openshift, it says No suitable driver found for ...
- 11.4k
2
votes
1
answer
2k
views
persistence xml on openshift and enviromental variables
I'm trying to deploy a simple application to Openshift, but I'm confused about its enviromental variables. They are used to access the mysql database that is installed. I saw a few examples but ...
- 1,695
2
votes
3
answers
2k
views
Not working enviromental variable OPENSHIFT_MYSQL_DB_HOST in a JDBC connection to MySQL
I'm trying to make a basic JDBC connection to MySQL. I deployed application on openshift server (tomcat7, mysql) but I can't connect with my db (I use phpmyadmin to create db and tables). I'am using ...
- 485
2
votes
1
answer
2k
views
OpenShift, JBoss EAP 6 - how to re-add MySQL driver
I have a Java EE 6 application on OpenShift / JBoss EAP 6, which runs out of space regularly due to big server logs.
Recently, the EAP got broken somehow. It can't find the MySQL driver anymore.
The ...
- 45.5k
2
votes
1
answer
840
views
How to connect to a MySQL database using Hibernate on OpenShift
I've just created a database on OpenShift and I'm trying to use Hibernate.
My configuration file is as follow:
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</...
2
votes
1
answer
794
views
OpenShift access MySQL from another gear
I have two apps on OpenShift.
One is running on a salable PHP gear with a MySQL cartridge.
The other one is a node.js gear.
How can I access this MySQL database from node.js
- 2,810
2
votes
1
answer
423
views
Openshift tomact7 mysql greek encoding
I've been developing a web application using spring mvc. When I deploy it on openshift using tomcat 7 and mysql database I get the following issue. Greek letters coming from an HTML MULTIPART form are ...
- 51
2
votes
1
answer
1k
views
Mysql connection URL openshift
How do I see MySql connection URL from openshift? I need it to use it in hibernate.cfg.xml
When I log onto my account online I only see the username and password.
- 69
2
votes
2
answers
2k
views
Using MySQL on Openshift with Symfony 2
I added MySQL, and PHPMyAdmin cartridges to my openshift php app.
After mysql cartridge was added I saw the page which says:
Connection URL: mysql://$OPENSHIFT_MYSQL_DB_HOST:$OPENSHIFT_MYSQL_DB_PORT/...
- 7,946
2
votes
1
answer
997
views
Joomla 3.5.1 on Openshift MySQL 5.5 out of sort memory
Fresh install of Joomla on OpenShift and when I open go to Extensions > Modules, i get the following error message:
Error
Out of sort memory, consider increasing server sort buffer size SQL=SELECT a....
- 125
2
votes
1
answer
1k
views
How do I connect a desktop app to an hosted database
I am developing a desktop app and I want to store data in hosted database like MySQL/MongoDB. I know one solution is using webservice to manipulate db. I am wondering is there a way to connect desktop ...
- 137
2
votes
1
answer
779
views
Error when deploying Strongloop/Loopback using MySQL datasource to Openshift
I've been trying to deploy a Strongloop/Loopback using MySQL datasource application to Openshift without success. Below are the steps I followed.
Installed Node on my Windows 7.
Did a npm install -g ...
- 1,703
2
votes
1
answer
440
views
How to install mysqldb on Openshift with flask
I am planning on making a website using Python + Flask + Mysql. My database requirements are very simple and hence I don't plan on using an ORM. Now I have been reading through the tuorials of mysqldb ...
- 507
2
votes
2
answers
2k
views
OpenShift Database Host Value?
I'm trying to install Infinite WP on Openshift, so far, I have uploaded the source files. But, when I was on the installation page, it asked a database host, username, and password. I have the ...
2
votes
2
answers
1k
views
Openshift.com - unable to connect with mysql
I am trying to establish a connection with mysql-5.1, but it shows errors like "could not connect" or when I change the hostname "Could not connect: No such file or directory".
My file reads like ...
- 21
2
votes
1
answer
183
views
SailsJS on OpenShift with MySQL
I'm trying to set up an SailsJS framework on OpenShift with MySQL database, but i can't get it to work...
If somebody could help with a small tutorial, i would be very gratefull...
How to correctly ...
- 101
2
votes
1
answer
1k
views
Tomcat 7 (JBoss EWS 2.0) + MySQL 5.1 + Hibernate - OpenShift - No persistence unit found
Every time I try to reach my app on OpenShift I receive the "No Persistence provider for EntityManager named appname" error.
I have been struggling to resolve this problem for two consecutive days ...
- 119
2
votes
1
answer
483
views
How to set Hibernate MySQL Connection in Openshift Tomcat 7 (JBOSS EWS 2.0)?
I'm developing Java based web application using spring hibernate and am trying out OpenShift to deploy my application. But I am facing troubles in configuring my application for the MySQL connector. I ...
- 8,099
2
votes
1
answer
74
views
Openshift MySQL event_scheduler
After restarting or updating my Openshift application, the MySQL cartridge starts with event_scheduler off.
I tried adding an environment variable to have it started in "on" mode (as suggested in the ...
- 23
2
votes
0
answers
236
views
How to deploy Express 4 application with mysql database setup on openshift?
I am finding it difficult to deploy the Express4 app on Openshift.
The project is working fine on localhost but not being able to push on server
remote: Git Post-Receive Result: failure
remote: ...
- 73
2
votes
2
answers
377
views
Can't Connect OpenShift MySql from tomcat project
I'm working on an openshift tomcat project by using mysql as backend I am trying to connect database and it is not connecting and shows error message "Communications link failure Last packet sent to ...
- 7,372
2
votes
1
answer
836
views
Can't connect to Openshift mySQL
I'm trying to connect to my Openshift MYSQL database on a database called OTA
Whenever i try to connect i get the error -
java.sql.SQLException: Access denied for user 'admin881Rhs7'@'localhost' (...
- 122
2
votes
1
answer
485
views
How do I convert the OpenShift MySQL 5.1 cartridge to UTF-8
The default MySQL 5.1 cartridge apparently creates all its tables with the latin1 character set. I have an application (Review Board, a python/Django application) that has some issues unless the DB is ...
- 76
2
votes
0
answers
289
views
OpenShift - I execute gem install rhc - successfully completed - rhc setup message command not found
Congrats,
I'm trying to debug an application(java tomcat7/mysql) and for that I have to install rhc, when I run gem install rhc everything proceeds normally in the installation, but when I run rhc ...
- 29