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

Heroku PHP: Connecting to ClearDB via Herrera PDO

I've read several questions about using ClearDB via Heroku, but none of them provided enough guidance to solve my issue. So, my issue... Currently I've got a PHP application deployed that is basically empty except the code which I'll place below.…
Christopher Ford
  • 23
  • 3
2
votes
1 answer

Change default Schema name in Cleardb add-on on Heroku

I have provisioned a ClearDB addon to my app running on Heroku. I am able to manage the database using MySQLWorkbench. However the account created to access the database has no permissions to change the default schema name created nor does it have…
Java Mantr
  • 77
  • 6
1
vote
0 answers

Trying to deploy Strapi on Heroku with ClearDB unable to acquire connection

Required System information Node.js version: v18.16.0 NPM version: v9.5.1 Strapi version: v4.11.0 Database:ClearDB Operating system: macOS Monterey version 12.6.6 Is your project Javascript or Typescript:JS Describe the bug Trying to deploy Strapi…
Paul Matthew
  • 11
  • 1
1
vote
1 answer

Deploying Django to Heroku using ClearDB, version issue

I keep getting this error, "NotSupportedError at /logs/ MySQL 5.7 or later is required (found 5.6.50)." Is this a problem with ClearDB?
djangodeveloper1234
  • 11
  • 1
1
vote
1 answer

Upgraded plans on ClearDB and unable to connect when deployed to heroku

I upgraded my plan from the free tier to a dedicated 25 plan. When I updated and tested locally I am ABLE to connect. Same with workbench, I could query my data. When I updated my Env vars in Heroku tho, it fails to establish a connection without…
Braden Borman
  • 309
  • 1
  • 8
1
vote
1 answer

Can't add new command when connection is in closed state (express.js + mysql2 + mysql2/promise + clearDB + heruko)

i am facing thi error whenever i make a second call to the api i created using mysql2+expressjs+clearDB(on HERUKO)+heruko deployment server this is my code .... const [rows,fields]= await db.execute(MYQUERY,[myarguments]) i am calling the mysql…
Syed Salleh
  • 51
  • 7
1
vote
1 answer

SELECT command denied to user @ for table
i faced this error while calling the query to the database to the clearDB . it returns the error i specified in the title... SELECT command denied to user @ for table ...... i uploaded my clearDB on heruko , i am using the express.js mysql2 npm…
Syed Salleh
  • 51
  • 7
1
vote
1 answer

can not connect to clearDBmySQL from django

DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'tajaratdatabase', 'USER': '', #here I am using my username 'PASSWORD':'', #here I am using my password …
Ruma
  • 86
  • 1
  • 18
1
vote
0 answers

Access denied connecting node.js to ClearDB

I'm having a weird issue trying to connect my Node.js app (hosted on Heroku) to my ClearDB database. If I'm hosting my server on localhost I can connect to the remote DB no problem. Initially I was using…
Jeffrey Carr
  • 137
  • 9
1
vote
0 answers

Issues accessing ClearDb MySql from Heroku hosted NodeJS/Express app

I'm in the process of getting my React/NodeJS/Express app with a MySql database up and running on Heroku (using free dynos). I'm using ClearDb ("Punch" licensing level) to host my MySql database in production. I am using the mysql2 npm package to…
havab
  • 33
  • 1
  • 5
1
vote
0 answers

Identical CREATE VIEW query works on localhost database, but not ClearDB

I'm very new to coding, so I'm sure that I'm missing something simple, but I've been struggling with it for a while now. I can use the following query to create a desired view in a locally hosted database on MySQL Workbench: CREATE VIEW …
NewDev94
  • 11
  • 1
1
vote
1 answer

AdapterNotSpecified deploying Rails app to Heroku using ClearDB for MySQL

I'm trying to revive an old Rails application I worked on several years ago. I'm using ruby 2.3.3 and rails 3.2.15 on the Heroku-16 stack with ClearDB for my MySQL database with the mysql2 adapter. When deploying to Heroku it succeeds on the deploy…
Bill Dudley
  • 13
  • 3
1
vote
1 answer

When using terraform with heroku, is there a way to refresh app state after an addon is attached?

I'm using terraform to set up an app on heroku. The app needs a mysql database and I'm using ClearDB addon for that. When ClearDB is attached to the app, it sets a CLEARDB_DATABASE_URL config variable. The app requires the database url to be in a…
romank
  • 11
  • 1
1
vote
2 answers

Connect to MySQL database in PHP

I'm trying to build a blog website. It is deployed on Heroku and it is supposed to connect to a MySQL database. The info required to login to my database is stored in an environment variable on Heroku, and looks like this (These are fake credentials…
Arti-Art
  • 25
  • 6
1
vote
0 answers

Auth0 login fails with Node.js web app on Heroku (but success on localhost)

I deployed my web app on Heroku (Node.js, Express, ClearDB, Auth0). In terms of login using Auth0, it works at localhost but not online. Before using auth0, app works on both local and Heroku. According to logs of Auth dashboard, every login is…
tcb
  • 11
  • 2
1 2 3
…
16 17