[REQ] repair local install on Ubuntu

A few years ago I installed Ghost with mapache theme on a small self hosted server.
It didn’t survived the latest apt update + upgrade.

It’s current status has too many inconsistencies. Nothing that can’t be solved though. Below the output of ghost doctor. The Cloudinary storage may have been corrupted, I don’t know (as far as I remember it was easy to setup).
I have a backup :

This is a personal blog, I can live without it. It was already offline because my optic fiber was broken for 2 months.

If you can help, drop me a message. Thank you.

:heavy_check_mark: Checking system Node.js version - found v18.20.2
:heavy_check_mark: Checking logged in user
:heavy_check_mark: Ensuring user is not logged in as ghost user
:heavy_check_mark: Checking if logged in user is directory owner
:heavy_check_mark: Checking current folder permissions
:heavy_check_mark: Checking system compatibility
:heavy_check_mark: Checking for a MySQL installation

  • sudo systemctl is-active ghost_www-xxxxx-com
    :heavy_multiplication_x: Validating config
    :heavy_check_mark: Checking folder permissions
    :heavy_check_mark: Checking file permissions
    :heavy_check_mark: Checking content folder ownership
    :heavy_check_mark: Checking memory availability
    :heavy_multiplication_x: Checking binary dependencies
    :heavy_check_mark: Checking free space
    :heavy_check_mark: Checking systemd unit file
    Warning: Ghost is running with node v18.12.1.
    Your current node version is v18.20.2.
    :heavy_check_mark: Checking systemd node version - found v18.12.1
    One or more errors occurred.
  1. Validating config

Error detected in the production configuration.

Message: Invalid database type. Supported types are mysql and sqlite3
Configuration Key(s): database.client
Current Value(s): mysql2

Help: Run ghost config <key> <new value> for each key to fix the issue.

  1. Checking binary dependencies

Message: The installed node version has changed since Ghost was installed.
Help: Run ghost update 5.72.1 --force to re-install binary dependencies.

Debug Information:
OS: Ubuntu, v22.04.4 LTS
Node Version: v18.20.2
Ghost Version: 5.72.1
Ghost-CLI Version: 1.26.0
Environment: production
Command: ‘ghost doctor’

Try running ghost doctor to check your system for known issues.

You can always refer to Ghost-CLI - A fully loaded tool for installation and configuration for troubleshooting.

You actually have the solution right in the logs, as far as I can tell:

Looks like your configuration file has mysql2 set as database client, whereas this should be just mysql.

After fixing the above, try running the command that’s logged there.

1 Like

Thanks for the help Jannis.

I had to edit the PATH which is always pointing to the wrong version of node.js, so it can run, I just have to redo the cloudinary connection now. I’ll check it out later on and tell you.

Finally I ended up spending hours to solve all the problems.
But the whole system is back online.