Tried to update Ghost and everything is broken :(

So I got Node 18 and when tried to start there seems to be some kind of error connecting to the database, so that is something different:

May 15 20:52:13 blog node[2393]: [2024-05-15 20:52:13] INFO Ctrl+C to shut down
May 15 20:52:13 blog node[2393]: [2024-05-15 20:52:13] INFO Ghost server started in 1.326s
May 15 20:52:13 blog node[2393]: [2024-05-15 20:52:13] INFO Bootstrap client was closed.
May 15 20:52:13 blog node[2393]: [2024-05-15 20:52:13] ERROR connect ECONNREFUSED ::1:3306
May 15 20:52:13 blog node[2393]:
May 15 20:52:13 blog node[2393]: connect ECONNREFUSED ::1:3306
May 15 20:52:13 blog node[2393]: "Unknown database error"
May 15 20:52:13 blog node[2393]: Error ID:
May 15 20:52:13 blog node[2393]:     500
May 15 20:52:13 blog node[2393]: Error Code:
May 15 20:52:13 blog node[2393]:     ECONNREFUSED
May 15 20:52:13 blog node[2393]: ----------------------------------------
May 15 20:52:13 blog node[2393]: Error: connect ECONNREFUSED ::1:3306
May 15 20:52:13 blog node[2393]:     at /var/www/ghost/versions/5.82.9/node_modules/knex-migrator/lib/database.js:57:19
May 15 20:52:13 blog node[2393]:     at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1555:16)
May 15 20:52:13 blog node[2393]:
May 15 20:52:13 blog node[2393]: [2024-05-15 20:52:13] WARN Ghost is shutting down
May 15 20:52:13 blog node[2393]: [2024-05-15 20:52:13] WARN Ghost has shut down
May 15 20:52:13 blog node[2393]: [2024-05-15 20:52:13] WARN Your site is now offline
May 15 20:52:13 blog node[2393]: [2024-05-15 20:52:13] WARN Ghost was running for a few seconds
May 15 20:52:13 blog node[2393]: [2024-05-15 20:52:13] INFO Bootstrap client was closed.
May 15 20:52:13 blog systemd[1]: Stopping Ghost systemd service for blog: jvlobo-com...
May 15 20:52:14 blog node[2368]: /usr/lib/node_modules/ghost-cli/lib/process-manager.js:46
May 15 20:52:14 blog node[2368]:         throw error;
May 15 20:52:14 blog node[2368]:         ^
May 15 20:52:14 blog node[2368]: {
May 15 20:52:14 blog node[2368]:   message: {
May 15 20:52:14 blog node[2368]:     statusCode: 500,
May 15 20:52:14 blog node[2368]:     errorType: 'DatabaseError',
May 15 20:52:14 blog node[2368]:     level: 'critical',
May 15 20:52:14 blog node[2368]:     id: 500,
May 15 20:52:14 blog node[2368]:     help: 'Unknown database error',
May 15 20:52:14 blog node[2368]:     code: 'ECONNREFUSED',
May 15 20:52:14 blog node[2368]:     property: null,
May 15 20:52:14 blog node[2368]:     redirect: null,
May 15 20:52:14 blog node[2368]:     hideStack: false,
May 15 20:52:14 blog node[2368]:     message: 'connect ECONNREFUSED ::1:3306',
May 15 20:52:14 blog node[2368]:     name: 'DatabaseError',
May 15 20:52:14 blog node[2368]:     errno: -111,
May 15 20:52:14 blog node[2368]:     syscall: 'connect',
May 15 20:52:14 blog node[2368]:     address: '::1',
May 15 20:52:14 blog node[2368]:     port: 3306,
May 15 20:52:14 blog node[2368]:     fatal: true
May 15 20:52:14 blog node[2368]:   }
May 15 20:52:14 blog node[2368]: }
May 15 20:52:14 blog node[2368]: Node.js v18.20.2
May 15 20:52:14 blog systemd[1]: ghost_jvlobo-com.service: Main process exited, code=exited, status=1/FAILURE
May 15 20:52:14 blog systemd[1]: ghost_jvlobo-com.service: Failed with result 'exit-code'.
May 15 20:52:14 blog systemd[1]: Stopped Ghost systemd service for blog: jvlobo-com.

I’ll try to figure out what is happening now, MySQL is running:

Ok, I just saw this post and I changed from localhost to 127.0.0.1 on my config file and now it doesn’t throw that error anymore.

It starts with no errors, but if I try to get to my site I see:

If I restart sometimes I see the error:

502 Bad Gateway

---
nginx/1.18.0 (Ubuntu)

If I check the journal command I don’t see much, still the theme issue and this:

It doesn’t tell me much