Upgrading Ghost to v5.71.0 with Node.js v18.18.2, I encountered database errors when start ghost. Ghost version 5.70.2 is running smoothly with Node.js 16.20. + sudo systemctl is-active ghost_mydomain-com ✔ Checking system Node.js version - found v18.18.2 ✔ Ensuring user is not logged in as ghost …

Node 18 prefers ipv6 resolution over ipv4 - you can see this in the error message with the MySQL connection ::1:3306. If your MySQL server isn’t listening on the ipv6 interface then node won’t be able to connect to it. Quickest fix is probably explicitly specifying 127.0.0.1 for your database host …

Upgrade ghost 5.71.0 with node 18, encountered error

Bugs

Cathy_Sarisky October 27, 2023, 7:42pm 2

Looks like your database isn’t running, or isn’t accepting connections. Can you connect to it on the command line (which would confirm that it’s up)?

1 Like

`Directory is not readable` error after update?

Topic		Replies	Views
Latest Ghost Update Throws "Unknown database error" Self-hosting	7	1208	November 25, 2023
Connect ECONNREFUSED ::1:3306 Installation	4	4176	October 31, 2023
Unable to upgrade Ghost from v3.16.1 to v3.18.0 Developer help	10	1579	June 8, 2020
Upgrade is failing because of node upgrade? Installation	2	610	October 28, 2023
Unknown database error in self-hosted install Installation	0	1283	December 14, 2021

Upgrade ghost 5.71.0 with node 18, encountered error

Related topics