Unkown database error

[pana216]

Hello, I am getting an unknown database error after I forked the repostiory, renamed and deployed it on heroku.
These are the logs from heroku:

2022-04-04T20:47:48.246951+00:00 app[web.1]: 
2022-04-04T20:47:48.246951+00:00 app[web.1]: "Unknown database error"
2022-04-04T20:47:48.246951+00:00 app[web.1]:
2022-04-04T20:47:48.246962+00:00 app[web.1]: Error ID:
2022-04-04T20:47:48.246962+00:00 app[web.1]: 500
2022-04-04T20:47:48.246962+00:00 app[web.1]:
2022-04-04T20:47:48.246962+00:00 app[web.1]: Error Code: 
2022-04-04T20:47:48.246962+00:00 app[web.1]: ECONNREFUSED
2022-04-04T20:47:48.246963+00:00 app[web.1]:
2022-04-04T20:47:48.246963+00:00 app[web.1]: ----------------------------------------
2022-04-04T20:47:48.246964+00:00 app[web.1]:
2022-04-04T20:47:48.246964+00:00 app[web.1]: DatabaseError: connect ECONNREFUSED 127.0.0.1:3306
2022-04-04T20:47:48.246965+00:00 app[web.1]: at DatabaseStateManager.getState (/app/node_modules/ghost/core/server/data/db/state-manager.js:64:32)
2022-04-04T20:47:48.246981+00:00 app[web.1]: at DatabaseError.KnexMigrateError (/app/node_modules/knex-migrator/lib/errors.js:7:26)
2022-04-04T20:47:48.247151+00:00 app[web.1]: at new DatabaseError (/app/node_modules/knex-migrator/lib/errors.js:55:26)
2022-04-04T20:47:48.247152+00:00 app[web.1]: at /app/node_modules/knex-migrator/lib/database.js:57:19
2022-04-04T20:47:48.247152+00:00 app[web.1]: at processTicksAndRejections (internal/process/task_queues.js:95:5)
2022-04-04T20:47:48.247153+00:00 app[web.1]: at async DatabaseStateManager.getState (/app/node_modules/ghost/core/server/data/db/state-manager.js:40:13)   
2022-04-04T20:47:48.247188+00:00 app[web.1]: at async DatabaseStateManager.makeReady (/app/node_modules/ghost/core/server/data/db/state-manager.js:73:25)  
2022-04-04T20:47:48.247188+00:00 app[web.1]: at async initDatabase (/app/node_modules/ghost/core/boot.js:69:5)
2022-04-04T20:47:48.247189+00:00 app[web.1]: at async bootGhost (/app/node_modules/ghost/core/boot.js:412:9)
2022-04-04T20:47:48.247189+00:00 app[web.1]:
2022-04-04T20:47:48.247189+00:00 app[web.1]: Error: connect ECONNREFUSED 127.0.0.1:3306
2022-04-04T20:47:48.247190+00:00 app[web.1]: at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1159:16)
2022-04-04T20:47:48.247190+00:00 app[web.1]:
2022-04-04T20:47:48.247514+00:00 app[web.1]: [2022-04-04 20:47:48] WARN Ghost is shutting down
2022-04-04T20:47:48.248714+00:00 app[web.1]: [2022-04-04 20:47:48] WARN Ghost has shut down
2022-04-04T20:47:48.248996+00:00 app[web.1]: [2022-04-04 20:47:48] WARN Your site is now offline
2022-04-04T20:47:48.250054+00:00 app[web.1]: [2022-04-04 20:47:48] WARN Ghost was running for a few seconds
2022-04-04T20:47:48.358914+00:00 app[web.1]: npm ERR! code ELIFECYCLE
2022-04-04T20:47:48.359073+00:00 app[web.1]: npm ERR! errno 2
2022-04-04T20:47:48.362466+00:00 app[web.1]: npm ERR! [email protected] start: `node thelovekesh.js`
2022-04-04T20:47:48.362510+00:00 app[web.1]: npm ERR! Exit status 2
2022-04-04T20:47:48.362562+00:00 app[web.1]: npm ERR!
2022-04-04T20:47:48.362606+00:00 app[web.1]: npm ERR! Failed at the [email protected] start script.
2022-04-04T20:47:48.362642+00:00 app[web.1]: npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
2022-04-04T20:47:48.366837+00:00 app[web.1]:
2022-04-04T20:47:48.366910+00:00 app[web.1]: npm ERR! A complete log of this run can be found in:
2022-04-04T20:47:48.366946+00:00 app[web.1]: npm ERR!     /app/.npm/_logs/2022-04-04T20_47_48_363Z-debug.log
2022-04-04T20:47:48.491806+00:00 heroku[web.1]: Process exited with status 2
2022-04-04T20:47:48.657646+00:00 heroku[web.1]: State changed from starting to crashed

[thelovekesh]

DatabaseError: connect ECONNREFUSED 127.0.0.1:3306

By 127.0.0.1:3306 address I am assuming you are trying to run MySQL in the Heroku dyno itself which is not possible. So make sure first you host your MySQL server somewhere and then provide MySQL connection secrets in config vars or you can use MySQL addon - https://devcenter.heroku.com/articles/cleardb