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 user ✔ Checking if logged in user is directory owner ✔ Checking current folder permissions + sudo systemctl is-active ghost_mydomain-com ✔ Validating config ✔ Checking folder permissions ✔ Checking file permissions ✔ Checking content folder ownership ✔ Checking memory availability ✔ Checking binary dependencies ✔ Checking systemd unit file ✔ Checking systemd node version - found v18.18.2 + sudo systemctl start ghost_mydomain-com + sudo systemctl stop ghost_mydomain-com ✖ Starting Ghost: mydomain-com A GhostError occurred. Message: Ghost was able to start, but errored during boot with: connect ECONNREFUSED ::1:3306 Help: Unknown database error Suggestion: journalctl -u ghost_mydomain-com -n 50 Debug Information: OS: Ubuntu, v22.04.3 LTS Node Version: v18.18.2 Ghost Version: 5.71.0 Ghost-CLI Version: 1.25.3 Environment: production Command: 'ghost start' Additional log info available in: /home/user/.ghost/logs/ghost-cli-debug-2023-10-27T19_15_29_412Z.log Try running ghost doctor to check your system for known issues.
The error logs:
[2023-10-27 19:22:46] ERROR connect ECONNREFUSED ::1:3306 connect ECONNREFUSED ::1:3306 "Unknown database error" Error ID: 500 Error Code: ECONNREFUSED ---------------------------------------- Error: connect ECONNREFUSED ::1:3306 at /dir/versions/5.71.0/node_modules/knex-migrator/lib/database.js:57:19 at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1555:16)
Has anyone else encountered a similar situation?