Hello! I’m trying to self-host a Ghost 5.0 instance. In any. scenario using docker-compose I get Error: connect ECONNREFUSED 127.0.0.1:3306 I have tried deploying at local orangepi with Ubuntu and fly.io , with the same results. If with fly the database issue is quite obvious, with pi ubuntu serv…

SQLite3 is not supported in production from 5.0. The docker image has been belatedly updated to reflect this. The details of this breaking change are here: BREAKING CHANGE: Switch from sqlite3 to MySQL by default by tianon · Pull Request #323 · docker-library/ghost · GitHub @maroonmed24 - RE your …

Having same issue here. [2022-08-22 11:25:29] INFO Ghost is running in production... [2022-08-22 11:25:29] INFO Your site is now available on https://davidsha.me/ [2022-08-22 11:25:29] INFO Ctrl+C to shut down [2022-08-22 11:25:29] INFO Ghost server started in 1.867s [2022-08-22 11:25:29] ERROR con…

Exactly the same issue for me too. All three blogs - self hosted - are now down as a result of updating my Docker image to latest. EDIT: I’m using the alpine image if this helps. I’ve also tried reverting to ghost:5.10-alpine and ghost:5.10.1-alpine and the issue remains. All blogs are still down. …

This is because the official Docker image switched the default database to MySQL. I just fixed this on my own blog (now running on 5.10.1, still with SQLite) and wrote a post about it. Make SQLite work again with Ghost 5.x on Docker They'll have to pry SQLite from our cold, dead hands. …

Thanks for the response, and clarification. I think it would be useful to update Ghost’s self-hosting documentation regarding this change and the upcoming expectation of breakage, if that’s the case. Alternatively, would it be possible to have Ghost forcibly disable the membership, newsletter, subsc…

Hi @maroonmed24 , I’m not aware of any documentation that is out of date. If you can point me to anything specific, I’d be happy to take a look. In terms of adding db-related feature flags, this would run counter to much of what we’re trying to achieve. The primary purpose of continuing to support s…

This is a solution post for above issue with root cause analysis (Atleast in my case) cc: @Hannah So after updating Ghost to ver.5 and corresponding MySQL to ver. 8. After few days I started getting this issue. When I analysed the issue further following is my finding and steps to solve the issue…

For the sake of others :slight_smile: In the case of fly.io : MySQL is not part of Ghost’s docker image, so you need to install it separately, when doing that you realize the real issue: MySQl8 needs a lot more RAM than fly.io offers and what most hosting platforms offer. Bare minimum one seemingly …

Database error upon deployment via Docker

Developer help Self-hosting

zaclab August 22, 2022, 12:41pm 3

Same issue here as well.

Topic		Replies	Views
Upgrading from 5.8.2 to 5.9 or 5.9.4 breaks Database Self-hosting	2	708	August 18, 2022
Updating from 5.8.3 to 5.9.4 or higher crashes Ghost Self-hosting	4	597	January 17, 2023
Latest Release Cause MYSQL issues? Self-hosting	5	657	November 30, 2022
Plesk -> Docker -> Ghost -> My SQL Installation	6	2220	November 21, 2023
ECONNREFUSED 127.0.0.1:3306 when using fly.io Self-hosting	4	883	January 13, 2023

Database error upon deployment via Docker

Related topics