Ghost 4.x + SQlite3 : Support

Developer help Installation
4

Hi,

It’s a fresh Install on a new server (Ubuntu 20.04)

STEPS

# Add the NodeSource APT repository for Node 14
curl -sL https://deb.nodesource.com/setup_14.x | sudo -E bash

# Install Node.js
sudo apt-get install -y nodejs

# Install Ghost Cli
sudo npm install ghost-cli@latest -g

 ghost install --db sqlite3
✔ Checking system Node.js version
✔ Checking logged in user
✔ Checking current folder permissions
✔ Checking system compatibility
✔ Checking memory availability
✔ Checking free space
✔ Checking for latest Ghost version
✔ Setting up install directory
✔ Downloading and installing Ghost v4.1.0
✔ Finishing install process
? Enter your blog URL: https://myurl.com
✔ Configuring Ghost
✔ Setting up instance
+ sudo useradd --system --user-group ghost
+ sudo chown -R ghost:ghost /var/www/blog/content
✔ Setting up "ghost" system user
? Do you wish to set up Systemd? Yes
+ sudo mv /tmp/X-X-X-X/ghost_X-X-X-X.service /lib/systemd/system/ghost_X-X-X-X.service
+ sudo systemctl daemon-reload
✔ Setting up Systemd
+ sudo systemctl is-active ghost_X-X-X-X
? Do you want to start Ghost? Yes
+ sudo systemctl start ghost_X-X-X-X
+ sudo systemctl stop ghost_X-X-X-X
✖ Starting Ghost
One or more errors occurred.

1) GhostError

Message: Ghost was able to start, but errored during boot with: Knex: run
$ npm install sqlite3 --save
Cannot find module 'sqlite3'
Require stack:
- /var/www/blog/versions/4.1.0/node_modules/knex/lib/dialects/sqlite3/index.js
- /var/www/blog/versions/4.1.0/node_modules/knex/lib/config-resolver.js
- /var/www/blog/versions/4.1.0/node_modules/knex/lib/knex.js
- /var/www/blog/versions/4.1.0/node_modules/knex/lib/index.js
- /var/www/blog/versions/4.1.0/node_modules/knex/knex.js
- /var/www/blog/versions/4.1.0/node_modules/knex-migrator/lib/database.js
- /var/www/blog/versions/4.1.0/node_modules/knex-migrator/lib/index.js
- /var/www/blog/versions/4.1.0/core/server/data/db/state-manager.js
- /var/www/blog/versions/4.1.0/core/boot.js
- /var/www/blog/versions/4.1.0/ghost.js
- /var/www/blog/versions/4.1.0/index.js
Suggestion: journalctl -u ghost_X-X-X-X -n 50

Debug Information:
    OS: Ubuntu, v20.04.2 LTS
    Node Version: v14.16.0
    Ghost Version: 4.1.0
    Ghost-CLI Version: 1.16.3
    Environment: production
    Command: 'ghost install --db sqlite3'


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

Running “npm install sqlite3 --save”, resolved my issue but I’ve never had to do this before :thinking: