kylotan Seems like it's looking for C++ libraries of a more recent version than are provided.
Correct, the sqlite3 package has a binary that isn't compatible with CentOS7.
You can work around it and update Ghost by installing different sqlite3 module with the following commands, replacing
appname with your Ghost app name:
npm install --prefix=$PWD ghost-cli@latest
../node_modules/.bin/ghost update --no-setup-linux-user
# fix the sqlite module, this requires a newer gcc so first we shell
# into an updated dev environment via scl
scl enable devtoolset-10 bash
npm install --prefix=$PWD @vscode/sqlite3 --save
rm -r ghost/current/node_modules/sqlite3
cp -r node_modules/@vscode/sqlite3 ghost/current/node_modules/
Problems like this should be less of an issue when we hope to roll out new servers with a newer OS.
Hope this helps 🙂