Questions tagged [cleardb]

ClearDB is a reliable, fault tolerant database-as-a-service for MySQL. It is also a heroku addon for mysql databases

ClearDB is a heroku addon for managing databases.

More info here: https://devcenter.heroku.com/articles/cleardb

247 questions
0
votes
1 answer

How can I configure the password and username of a ClearDb MySQL database in an ARM template

Is there a way to set the PW and username of a ClearDB MySQL database in an ARM template? Here's the resource: { "type": "SuccessBricks.ClearDB/databases", "name": "[parameters('databases_cmsdbbasic_name')]", …
0
votes
2 answers

Communications Link Failure ClearDB

I realize that there are other questions similar to mine but I feel mine is a bit different so I'm going to ask it anyway. I've been using hibernate to develop a java web application and have run in to no problems when I run it on a localhost…
cds1995
  • 3
  • 1
0
votes
1 answer

How can I choose a different ClearDb MySQL database type within an ARM template?

I am trying to manually code a ClearDB MySQL database resource within an ARM template to be of the 'Dedicated' type and of the 'Jupiter' tier, but I can't seem to find any documentation that shows how to do so within a template. I know the ARM…
0
votes
2 answers

How to set the character-set to utf8 at session level in jhipster

When deploying my jhipster based application to cloud foundry (in my case Pivotal with ClearDB service) I don't have option to change the DB character set and not to update the JDBC parameters as it shared DB. the charset of the DB is latin1 and I…
0
votes
1 answer

Heroku Node.JS Database Error

I have a Node.JS application that is deployed with Heroku featuring a simple CRUD system. However, I am having problems whenever I update a row with the web application itself. Here is my code for the UPDATE statement in my server.js…
mayk
  • 1
  • 2
0
votes
2 answers

.NET Core wont close my MySqlConnection

I have a .NET Core program that uses the MySqlConnection class. My Database is a ClearDB Database that is stored in Azure. When I launch the program it is working like it should. But when I wait for like 10 minuts doing nothing, it wont connect to…
mmarkvoort
  • 11
  • 3
0
votes
2 answers

Can't connect my ruby on rails app running on MySQL to heroku

I am trying to deploy a rails app to Heroku for the first time. I am trying to connect my ruby on rails app which has a MySQL database. I am not sure if I have missed out on some steps but whenever I try to access heroku's provided url, I get the…
0
votes
1 answer

putting python variables into cleardb

In Short I have a heroku python setup and setup a cleardb database, but don't know how to put my python variables into that database. What lines of code, in python, connect to my db and add some variables into the database. OR Where is some example…
Rorschach
  • 3,684
  • 7
  • 33
  • 77
0
votes
0 answers

Running sails.js project locally has wiped production DB

We are trying to figure out how our production DB was wiped recently: a team member ran the local dev build using the production database url as env variables. The dev build drops all data and repopulates the tables with mock data. I am just…
JMurphyWeb
  • 382
  • 1
  • 11
0
votes
0 answers

How can I upload a CodeIgniter project to heroku?

I need to upload my project to Heroku. I have installed ClearDB mysql add-on to my app. But I don't know how my codeigniter will work on heroku? How can I upload my existing database fro localhost to live heroku? Can any1 guide me?
Ali Zia
  • 3,825
  • 5
  • 29
  • 77
0
votes
3 answers

MySQL LIMIT returning incorect set of rows

(Running on MS Azure cloud version of MySQL - CleadDB) I have a simple query: SELECT idx, date_added FROM my_table ORDER BY idx ASC LIMIT 100752, 10 I am expecting to get next 10 records after the idx 100752 (if present). However I get totally…
Milan
  • 3,209
  • 1
  • 35
  • 46
0
votes
2 answers

Can't connect to MySQL server (60)

I added cleardb to my Heroku app. config: CLEARDB_DATABASE_URL: mysql://username:password@us-cdbr-iron-east-04.cleardb.net/databse?reconnect=true DATABASE_URL: …
이국화
  • 809
  • 1
  • 9
  • 8
0
votes
0 answers

ERROR 2005 (HY000): Unknown MySQL server host, Playframework & clearDB

I created the clear db for heroku app. heroku config --app APP_NAME I get these: APPLICATION_SECRET: ABCDEFG; CLEARDB_DATABASE_URL: mysql://aaa:bbb@ccc.cleardb.net/heroku_ddd?reconnect=true DATABASE_URL: …
이국화
  • 809
  • 1
  • 9
  • 8
0
votes
0 answers

azurewebsites/IIS 7 internal server when connecting to remote MySQL db using Yii 2 framework

I have a Azure WebApp + Services written in Yii and Yii 2 respectively. The database is MySQL db from ClearDB. i am hosting it on using the empty Php app. Reference:…
praveen seela
  • 538
  • 11
  • 24
0
votes
1 answer

Editing ClearDB password in VCAP_SERVICES environment variable in Bluemix

I reset the password to my ClearDB database from the dashboard and can't seem to find a way to update the new password in Bluemix's VCAP_SERVICES environment variable, especially with the new console. I could create a custom environment variable but…
Plakhoy
  • 1,846
  • 1
  • 18
  • 30