Stack Overflow
Stack Overflow

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
3
votes
1 answer

Getting Error while I Create a Function in Heroku MySQL Database Addin

I've got this error: [Err] 1419 - You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable) How can I get avoid getting this error in Heroku ClearDB MySQL…
FMQB
  • 653
  • 5
  • 12
3
votes
0 answers

Connecting ClearDB to django database engine using Heroku

I am trying to connect the settings.py database engine to the clearDB using Heroku as my service to launch, and when I enter in the terminal python manage.py syncdb, I keep receiving an error message: ImproperlyConfigured: settings.DATABASES is…
Amechi
  • 742
  • 3
  • 11
  • 32
2
votes
0 answers

How set my local database properly to be deployed to Heroku?

I have deployed my first Laravel blog into Heroku. I have added ClearDB as the remote database for Heroku. The problem is it comes out error 500 as in the link below: https://laravel-raj-blog.herokuapp.com/blog How do I properly set my database to…
Rajaruban Rajindram
  • 589
  • 4
  • 10
2
votes
0 answers

heroku set UTF-8

I have a db with heroku (clearDB). From my php page the € symbol I see it correctly. Bu inside the DB (with MYSQL Workbench) The heroku config:add LANG=en_US.UTF-8 not help me. how can i solve? same error for accented letters
joisberg
  • 175
  • 2
  • 13
2
votes
2 answers

Heroku and ClearDB MySQL Auto Increment

I am using ClearDB for a mysql database. I have a table with an auto incremented primary key. The problem is that rather than it incrementing by 1, its incrementing by 10. How can I fix this please? Also when I tested the db on local host, the…
Gerson Malca Bazan
  • 411
  • 5
  • 7
2
votes
0 answers

Using ssl with node mysql and Cleardb

I have a free ClearDB account that I got through Heroku (as a resource) It gives me the CA certificate Client cert Client Key These are all in .pem format const fs = require('fs'); const ssl = { ca: fs.readFileSync('cleardb-ca.pem', "utf-8"), …
user2402616
  • 1,434
  • 4
  • 22
  • 38
2
votes
0 answers

Deploying Flask - MySQL to Heroku

I'm trying to deploy a Flask app to Heroku. My app runs a MySQL database and it all is good locally but cannot figure out how to make it work in Heroku. I attached the ClearDB package to my app in Heroku and created the proper tables in the database…
Guillermo Brachetta
  • 3,857
  • 3
  • 18
  • 36
2
votes
0 answers

Heroku app having Mysql database on CleasDB very slow

I have uploaded my MySql data base to a ClearDb server since then, the website (which right now is running locally and is not uploaded yet ) is super slow! I even upgraded the ClearDb account by still , very slow does someone have a solution ?…
Shirli Motro
  • 33
  • 4
2
votes
2 answers

How to set UTF8 encoding for ClearDB (MySQL) on Heroku

Database I have on heroku doesn't support special characters so I want to set utf8 encoding. When I was working on local version I simply changed config files but I wonder how I can achieve this using Heroku's DB. This added to connection url…
askstackoverflow
  • 301
  • 3
  • 11
2
votes
1 answer

pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query')

I had problems connecting to the heroku ClearDB with my flask-restful application, using SQLAlchemy with my given DB_URI: mysql+pymysql://username:password@remote-hostname-xx.cleardb.net/heroku_c52490fb3111cda?reconnect=true And this was the…
MattSom
  • 2,097
  • 5
  • 31
  • 53
2
votes
1 answer

Cannot connect to clearDB on heroku with command line

I have clearDB database setup on heroku and I have all the credentials to connect remotely. I am trying to connect to it through ubuntu terminal with the command format mysql -u username -h host -p password But as I enter password, the terminal…
user11519775
2
votes
1 answer

How to make a backup of a Heroku ClearDB MySQL database?

I have a PHP Heroku app running, which uses a ClearDB MySQL database. I need to make backups of the database. I've been searching how to do it but I can't find it. Thanks.
iporto
  • 153
  • 1
  • 2
  • 10
2
votes
1 answer

Rails : Heroku CI : Mysql2::Error: Can't connect to MySQL server on '127.0.0.1' (111) for test env

I have deployed a rails app to heroku, using mysql database hosted on a remote server. For this I have added the heroku addon 'cleardb' and setup correct ENV Config vars specifying: DATABASE_URL = mysql2://user:password@host?reconnect=true I have…
Siddhant
  • 293
  • 1
  • 3
  • 8
2
votes
1 answer

After deploying Laravel project in Heroku MySQL doesn`t work

I have made my first Laravel project and tried to deploy it to the Heroku. It works, but when I tried to login or register it saying "SQLSTATE[HY000] [2002] Connection refused (SQL". There is my site: http://rocky-river-97869.herokuapp.com/login…
Darius
  • 268
  • 4
  • 16
2
votes
1 answer

What exactly does this Azure error mean?

I have a PowerShell script that deploys an ARM template to Azure, but I have encountered an error that I can't quite seem to wrap my head around. When running in PowerShell, itself, I get the following error: New-AzureRmResourceGroupDeployment :…
LillaTheHun
  • 131
  • 1
  • 13
1 2
3
…
16 17