Missing package(s): nginx and Local MySQL install not found

[xolee]

hi, my host have installed nginx and mysql，how to config nginx and mysql directory?

ghost@VM-34-185-ubuntu:/home/siteList/blog.ghost$ ghost install
� Checking system Node.js version
� Checking current folder permissions
System checks failed with message: 'Missing package(s): nginx'
Some features of Ghost-CLI may not work without additional configuration.
For local installs we recommend using `ghost install local` instead.
? Continue anyway? Yes
� Checking operating system
Local MySQL install not found. You can ignore this if you are using a remote MySQL host.
Alternatively you could:
a) install MySQL locally
b) run `ghost install --db=sqlite3` to use sqlite
c) run `ghost install local` to get a development install using sqlite3.
? Continue anyway? No
� Checking MySQL is installed
A SystemError occurred.

Message: MySQL check failed.

ghost@VM-34-185-ubuntu:/home/siteList/blog.ghost$ ghost install --no-stack
✔ Checking system Node.js version
✔ Checking current folder permissions
ℹ Checking operating system [skipped]
Local MySQL install not found. You can ignore this if you are using a remote MySQL host.
Alternatively you could:
a) install MySQL locally
b) run `ghost install --db=sqlite3` to use sqlite
c) run `ghost install local` to get a development install using sqlite3.
? Continue anyway? No
✖ Checking MySQL is installed
A SystemError occurred.

Message: MySQL check failed.

Debug Information:
    Node Version: v6.11.2
    Ghost-CLI Version: 1.1.1
    Environment: production
    Command: 'ghost install --no-stack'

Please refer to https://docs.ghost.org/v1/docs/troubleshooting#section-cli-errors for troubleshooting.

[acburdine]

@xolee Sorry for missing this!

Would you be able to run which nginx and which mysqld on your server? I want to double check that those commands return something.

[klpek]

the same probelm. I use ubuntu16.04 32bit. Nodejs v6.11.3

---

$ service nginx status ● nginx.service - LSB: starts the nginx web server Loaded: loaded (/etc/init.d/nginx; bad; vendor preset: enabled) Active: active (exited) since Sat 2017-09-09 10:55:52 CST; 2h 50min ago Docs: man:systemd-sysv-generator(8) Process: 1196 ExecStart=/etc/init.d/nginx start (code=exited, status=0/SUCCESS

$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 20 Server version: 5.5.55-log Source distribution

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

$ ghost install ✔ Checking system Node.js version ✔ Checking current folder permissions System checks failed with message: 'Missing package(s): nginx' Some features of Ghost-CLI may not work without additional configuration. For local installs we recommend using ghost install local instead. ? Continue anyway? Yes ✔ Checking operating system Local MySQL install not found. You can ignore this if you are using a remote MyS QL host. Alternatively you could: a) install MySQL locally b) run ghost install --db=sqlite3 to use sqlite c) run ghost install local to get a development install using sqlite3. ? Continue anyway? No ✖ Checking MySQL is installed A SystemError occurred.

Message: MySQL check failed.

Debug Information: Node Version: v6.11.3 Ghost-CLI Version: 1.1.1 Environment: production Command: 'ghost install'

---

[ErisDS]

@klpek can you provide the information that @acburdine asked for above please? Can't fix this without knowing what your system expects 😊

[klpek]

@ErisDS @acburdine $ nginx -V nginx version: nginx/1.12.1 built by gcc 5.4.0 20160609 (Ubuntu 5.4.0-6ubuntu1~16.04.4) built with OpenSSL 1.0.2l 25 May 2017 TLS SNI support enabled configure arguments: --user=www --group=www --prefix=/www/server/nginx --with-openssl=/www/server/nginx/src/openssl --add-module=/www/server/nginx/src/ngx_devel_kit --add-module=/www/server/nginx/src/lua_nginx_module --with-http_stub_status_module --with-http_ssl_module --with-http_v2_module --with-http_gzip_static_module --with-http_gunzip_module --with-stream --with-stream_ssl_module --with-ipv6 --with-http_sub_module --with-http_flv_module --with-http_addition_module --with-http_realip_module --with-http_mp4_module --with-ld-opt=-Wl,-E

---

$ mysql -V mysql Ver 14.14 Distrib 5.5.55, for Linux (i686) using readline 5.1

[ErisDS]

@klpek The request was for the result of which nginx and which mysql 😕

[klpek]

nginx version: nginx/1.12.1 mysql Ver 14.14 Distrib 5.5.55, OK? I just have one mysql and one nginx.

[acburdine]

@klpek the reason I asked for the output of which mysqld and which nginx was not to get the versions - I'm looking for where the actual mysql/nginx executables are installed on the system - which mysqld and which nginx are the commands the CLI uses to determine whether or not mysql/nginx is installed at the moment.

[klpek]

Ok, I see. $which nginx /usr/sbin/nginx $ which mysql /usr/bin/mysql

[acburdine]

ok - I think I see what the issue is here. Will fix and introduce in the next release.

[aswordok]

My system is centos 7 x64 [root@xxx ghost]# which mysqld /usr/bin/which: no mysqld in (/root/.nvm/versions/node/v6.9.5/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin) [root@xxx ghost]# which mysql /usr/bin/mysql

You can edit the file /root/.nvm/versions/node/v6.9.5/lib/node_modules/ghost-cli/lib/commands/doctor/checks/install.js, search "Local MySQL install not found", and replace "which mysqld" with "which mysql", then the error will be correct.

but I get another error on the next step: ✖ Running database migrations An error occurred. Message: 'Command failed: /bin/sh -c sudo -E -u ghost /root/.nvm/versions/node/v6.9.5/lib/node_modules/ghost-cli/node_modules/.bin/knex-migrator-migrate --init --mgpath /mnt/myData1/ghost/current sudo: unable to execute /root/.nvm/versions/node/v6.9.5/lib/node_modules/ghost-cli/node_modules/.bin/knex-migrator-migrate: Permission denied' Debug Information: Node Version: v6.9.5 Ghost-CLI Version: 1.1.1 Environment: production Command: 'ghost install' Additional log info available in: /root/.ghost/logs/ghost-cli-debug-2017-09-14T06_21_28_654Z.log Please refer to https://docs.ghost.org/docs/v1/troubleshooting#section-cli-errors for troubleshooting. How can I do ?

[acburdine]

@aswordok couple of things:

1. Could you post the contents of /root/.ghost/logs/ghost-cli-debug-2017-09-14T06_21_28_654Z.log? It should have some more information as to what exactly is going wrong.
2. The reason it is which mysqld as opposed to which mysql is the fact that the mysql command is for the mysql client, which allows you to access and run commands on mysql databases. The mysqld command, however, is the actual mysql server command (or at least it is on Ubuntu, I guess it's different on CentOS).

[aswordok]

@acburdine [root@xxx ~]# lsb_release -a LSB Version: :core-4.1-amd64:core-4.1-noarch Distributor ID: CentOS Description: CentOS Linux release 7.0.1406 (Core) Release: 7.0.1406 Codename: Core

MariaDB [(none)]> status

mysql Ver 15.1 Distrib 5.5.52-MariaDB, for Linux (x86_64) using readline 5.1 Connection id: 107 Current database: Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server: MariaDB Server version: 5.5.52-MariaDB MariaDB Server Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 1 day 19 hours 9 min 51 sec Threads: 1 Questions: 534 Slow queries: 0 Opens: 25 Flush tables: 3 Open tables: 9 Queries per second avg: 0.003

[root@xxx ~]# cat /root/.ghost/logs/ghost-cli-debug-2017-09-14T06_21_28_654Z.log Debug Information: Node Version: v6.9.5 Ghost-CLI Version: 1.1.1 Environment: production Command: 'ghost install' An error occurred. Message: 'Command failed: /bin/sh -c sudo -E -u ghost /root/.nvm/versions/node/v6.9.5/lib/node_modules/ghost-cli/node_modules/.bin/knex-migrator-migrate --init --mgpath /mnt/myData1/ghost/current sudo: unable to execute /root/.nvm/versions/node/v6.9.5/lib/node_modules/ghost-cli/node_modules/.bin/knex-migrator-migrate: Permission denied '

Stack: Error: Command failed: /bin/sh -c sudo -E -u ghost /root/.nvm/versions/node/v6.9.5/lib/node_modules/ghost-cli/node_modules/.bin/knex-migrator-migrate --init --mgpath /mnt/myData1/ghost/current sudo: unable to execute /root/.nvm/versions/node/v6.9.5/lib/node_modules/ghost-cli/node_modules/.bin/knex-migrator-migrate: Permission denied

at Promise.all.then.arr (/root/.nvm/versions/node/v6.9.5/lib/node_modules/ghost-cli/node_modules/execa/index.js:236:11) at process._tickCallback (internal/process/next_tick.js:103:7) Code: 1

[aswordok]

After several test, I choose ghost-cli@1.0.0-beta.1, and it work well: npm i -g ghost-cli@1.0.0-beta.1

[thilux]

I have ghost-cli@1.4.1 and still have this problem. To bypass it, I had to run ln -sf /usr/bin/mysql /usr/bin/mysqld as root. Debug Information: Node Version: v6.12.2 Ghost-CLI Version: 1.4.1 CentOS 7 here.

[heyakyra]

@thilux thank you! this is what I needed to get ghost working with mariadb since that is what centos prefers

[kirrg001]

Testing and research required to find out how we can detect that nginx/mysql is installed e.g. use which. Currently we are using dpkg, which turned out is not a generic approach.

[heyakyra]

For me, ghost was able to detect mysql without dpkg, but not nginx

[hao-lee]

For now, nginx is detected by dpkg, so ghost setup nginx can only work normally on Ubuntu and Debian. I think these detections should be independent of operating system.

[heyakyra]

Is there an nginx config we can recommend to drop in by hand to work around this?

[heyakyra]

@acburdine

The reason it is which mysqld as opposed to which mysql is the fact that the mysql command is for the mysql client, which allows you to access and run commands on mysql databases. The mysqld command, however, is the actual mysql server command (or at least it is on Ubuntu, I guess it's different on CentOS).

Ah, maybe an exception for which mysqld can be caught to and then try a combination of which dnf and which mysql before raising the exception?

[acburdine]

The most recent version of Ghost-CLI (1.15.0) has significantly improved checks for the existence of services like nginx + mysql. This should fix most of the problems people are seeing with the previous distro-specific commands we were using.

For nginx specifically, we also support an NGINX_PROGRAM_NAME environment variable that you can use to control what the "nginx" service name is that Ghost searches. For example, iirc some distributions refer to Nginx as the httpd service, so if you were to set NGINX_PROGRAM_NAME=httpd Ghost would search for that service's existence instead of nginx.

[ayyilmaz]

@kirrg001 @acburdine I have set permissions of user’s each folders to 775 but ghost install does not work. I am trying to install ghost version 4. I use HestiaCP (Does not support ufw) Nginx configuration.

Hey @heyakyra have you solved this problem?

What errors or information do I see in the console?

System checks failed with message: ‘Missing package(s): nginx’
Some features of Ghost-CLI may not work without additional configuration.

1. SystemError
Message: The directory /home/user/web/domain.club/ is not readable by other users on the system.
This can cause issues with the CLI, you must either make this directory readable by others or run ghost install in another location.

2. Checking for a MySQL installation
Message: MySQL check failed.

Debug Information:
OS: Ubuntu, v20.04.2 LTS
Node Version: v14.16.0
Ghost-CLI Version: 1.16.3
Environment: production
Command: ‘ghost install’

mysql Ver 15.1 Distrib 10.5.9-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 nginx version: nginx/1.19.8

[slushnys]

Not sure if this would help anyone but reading on @acburdine post that ghost is looking for nginx or httpd services running, i checked the list of services running with this command: systemctl --type=service It already contained already preinstalled apache2 running which didn't allow nginx service to be run and therefore found by ghost-cli. I removed the apache, restarted nginx and it was going well from there on.

[pratnala]

@slushnys Thanks for the tip! I didn't have apache2 running but nginx didn't start itself after installation. Ran sudo systemctl start nginx and then ghost could detect it! @acburdine You should add this to the docs to help others :)

[jingkang99]

after looking into the code, I found the reason. it checks service mysql (must be this name, not which or version) running or not. and we need a fake running process. service mysql status ghost-cli# vi packages/ghost-cli/lib/commands/doctor/checks/mysql.js

quick fix: cd /etc/init.d/ ln -s mariadb mysql

vi mysqld

!/bin/bash

while : do sleep 3600 done

chmod 700 mysqld ./mysqld

it solves the issue.

[github-actions[bot]]

Our bot has automatically marked this issue as stale because there has not been any activity here in some time. The issue will be closed soon if there are no further updates, however we ask that you do not post comments to keep the issue open if you are not actively working on a PR. We keep the issue list minimal so we can keep focus on the most pressing issues. Closed issues can always be reopened if a new contributor is found. Thank you for understanding 🙂

[ayyilmaz]

The problem has not solved so I think closing of the topic is not good idea my lovely bot. Thank you so much for every contributers

[MxtressMyxx]

I too am having this issue - trying to install on a pi4 4gb using piOS/Bullseye 64bit lite image, nginx, mariadb and node.js 16

I thought I had a misconfigured MariaDB setup so I started from scratch. The install still fails, unable to find the running mysql process.

Message: MySQL check failed.

Debug Information:
    OS: Debian GNU/Linux, v11
    Node Version: v16.13.1
    Ghost-CLI Version: 1.18.1
    Environment: production
    Command: 'ghost install'

/var/www/ghost $ service mysql status
● mariadb.service - MariaDB 10.5.12 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
     Active: active (running) since Thu 2021-12-02 10:11:02 EST; 13min ago

$ nginx -v
nginx version: nginx/1.18.0

mariadb -v
Server version: 10.5.12-MariaDB-0+deb11u1 Debian 11

If the post by @jingkang99 is a manual solution, I'm not 100% sure how to implement it.

[kappaisagreekletter]

Ghost still not detecting nginx. I have nginx running and it is still not detected. During installation:

Nginx is not installed. Skipping Nginx setup.
ℹ Setting up Nginx [skipped]
Nginx setup task was skipped, skipping SSL setup
ℹ Setting up SSL [skipped]

Running ghost setup nginx:

Nginx is not installed. Skipping Nginx setup.
ℹ Setting up Nginx [skipped]

which nginx
/usr/sbin/nginx

For now, I followed this tutorial to set up nginx for ghost so that I can at least get it working.

[ErisDS]

We're still getting quite a lot of reports of difficulty detecting nginx and mysql. We probably need a bit of a rethink of how we detect this 🤔

Suggestions and particularly PRs are welcome!

[jay-lark]

I'm running into this issue as well. On a brand new clean server I'm running the recommended stack:

• Ubuntu 20.0.4
• NGINX 1.20.1 (Installed from PPA since a supported version doesn't come with Ubuntu 20.0.4)
• MySQL 8.0.27
• Node 14.19.0

Ghost-CLI detects MySQL but not NGINX. I tried every version of Ghost-CLI from the latest back to 1.17.3
1.17.3 is the first version that works for me.

Briefly looking at all the code changes between the 1.17.3 release and the 1.17.4 release I don't see anything that would break the detection of NGINX. However, there are a ton of dependency updates between the two releases, including some to the modules I believe are used in this process.

I'm having some trouble at the moment getting the project to build on my computer so I haven't been able to test this, but my guess is one of those dependency updates broke this.

[YigitUyan]

+1, Same issue here. Would have been super cool to try out Ghost on Debian but it cannot even pass the install checks right now. :(

Debug Information:

• OS: Debian GNU/Linux, v11
• Node Version: v16.14.0
• Ghost-CLI Version: 1.18.2
• Environment: production
• Command: 'ghost install'

For database, I installed mariadb: which mysqld /usr/sbin/mysqld (sudo apt install -y mariadb-server)

For nginx, well, it's nginx: which nginx /usr/sbin/nginx (sudo apt install -y nginx)

Verifying with dpkg shows: dpkg -s mariadb-server Package: mariadb-server Status: install ok installed dpkg -s nginx Package: nginx Status: install ok installed

Both services are running fine, sudo systemctl status nginx - enabled, active (running) sudo systemctl status mysqld - enabled, active (running)

When I run ghost install, following warnings: "Local MySQL install was not found or is stopped." "Nginx is not installed. Skipping Nginx setup." "Nginx setup task was skipped, skipping SSL setup"

Can you provide some details into what specific checks are done by the installer at ghost install step? Maybe we can find a workaround by creating symbolic links, or renaming some packages/services as an immediate solution.

As a longer term solution, can you also try out on a fresh Debian install with the packages I mentioned above? Debian is pretty much the second most popular server after Ubuntu, and mariadb is the default available mysql alternative in the package manager. A lot of people will be trying to set up Ghost with the above combination, and likely failing as well.

[thepixelmonk]

Looking at the code, this seems to be what it uses for detection:

async isSupported() {
        try {
            const services = await sysinfo.services('*');
            return services.some(s => s.name === nginxProgramName);
        } catch (error) {
            return false;
        }
    }

If I print the output of services, I see the nginx service name as being:

{
    name: '  nginx',
    running: false,
    startmode: '',
    pids: [],
    cpu: 0,
    mem: 0
  }

I think those extra spaces in front of the name are messing with the comparison check.

[KodzghlyCZ]

I have the same issue here, Debian 11 and no clue how to get over it. Is there any solution available rn?

[nvnpr]

I've been searching for solution and wondering if this issue is fix?

[KodzghlyCZ]

I've been searching for solution and wondering if this issue is fix?

Probably not, or at least what do I know.

[thepixelmonk]

I've been searching for solution and wondering if this issue is fix?

Probably not, or at least what do I know.

See my comment above if you're ok with patching the code yourself.

[nvnpr]

I've been searching for solution and wondering if this issue is fix?

Probably not, or at least what do I know.

See my comment above if you're ok with patching the code yourself.

Ah. Yes... I was browsing around the code. And i found this part. Im gonna your solution. Thank you!

[KodzghlyCZ]

I've been searching for solution and wondering if this issue is fix?

Probably not, or at least what do I know.

See my comment above if you're ok with patching the code yourself.

I'm not really sure how to patch it, I hoped in Ghost to be easy to set up, not something I have to patch myself. I will probably look for some alternative, as this becomes too complicated to have it stable and updated

[kmartin26]

Same problem here with fresh install, MySQL and Nginx not detected but up and running

OS : Debian 11 Ghost CLI : 1.19.3 MariaDB : 10.5.15 (which mysqld: /usr/sbin/mysqld) Nginx : 1.18.0 (which nginx : /usr/sbin/nginx)

[FixTheAdmin]

Having this issue too. Ability to specify nginx install location in the command would be nice.

[thomasqbrady]

I've been searching for solution and wondering if this issue is fix?

Probably not, or at least what do I know.

See my comment above if you're ok with patching the code yourself.

I'm not really sure how to patch it, I hoped in Ghost to be easy to set up, not something I have to patch myself. I will probably look for some alternative, as this becomes too complicated to have it stable and updated

For KodzghlyCZ and anyone else trying to figure this out, the file that needs to be edited is https://github.com/TryGhost/Ghost-CLI/blob/main/extensions/nginx/index.js, which, if you're using Ubuntu, is likely to be found at /usr/lib/node_modules/ghost-cli/extensions/nginx/index.js (remember you'll need to use su/sudo to edit), and the portion to be edited is at the very bottom of the file (at least at the time of writing).

You'll want to change this: async isSupported() { try { const services = await sysinfo.services('*'); return services.some(s => s.name === nginxProgramName); } catch (error) { return false; } }

to this:

async isSupported() { try { const services = await sysinfo.services('*'); return services.some(s => s.name.trim() === nginxProgramName); } catch (error) { return false; } }

This just worked for me minutes ago. Will submit a PR.

[KodzghlyCZ]

I've been searching for solution and wondering if this issue is fix?

Probably not, or at least what do I know.

See my comment above if you're ok with patching the code yourself.

I'm not really sure how to patch it, I hoped in Ghost to be easy to set up, not something I have to patch myself. I will probably look for some alternative, as this becomes too complicated to have it stable and updated

For KodzghlyCZ and anyone else trying to figure this out, the file that needs to be edited is https://github.com/TryGhost/Ghost-CLI/blob/main/extensions/nginx/index.js, which, if you're using Ubuntu, is likely to be found at /usr/lib/node_modules/ghost-cli/extensions/nginx/index.js (remember you'll need to use su/sudo to edit), and the portion to be edited is at the very bottom of the file (at least at the time of writing).

You'll want to change this: async isSupported() { try { const services = await sysinfo.services('*'); return services.some(s => s.name === nginxProgramName); } catch (error) { return false; } }

to this:

async isSupported() { try { const services = await sysinfo.services('*'); return services.some(s => s.name.trim() === nginxProgramName); } catch (error) { return false; } }

This just worked for me minutes ago. Will submit a PR.

Thanks, I would probably just wait for the change to be merged, since now I'm running Hugo on my web and don't need to change to Ghost immediately. Still it would be nice if your PR gets accepted, fingers crossed

[closebracket]

Hello!

I just wanted to note that I've also encountered this issue, on a fresh Digital Ocean Ubuntu VPS. I'd completed basic setup steps (e.g. making a non-root user, adding to sudoers, setting up UFW), following which I installed MySQL, Nginx and ghost-cli.

I ran ghost install which successfully installed Ghost in two separate directories and I was able to verify the installations. The installations were stable up until I tried to change the url of one of the installations using ghost config url, at which point I encountered:

✔ Checking system Node.js version - found v16.15.1 ✔ Checking logged in user ✔ Checking current folder permissions System checks failed with message: 'Missing package(s): nginx' Some features of Ghost-CLI may not work without additional configuration. For local installs we recommend using ghost install local instead.

Further down in the error message, it states:

One or more errors occurred.

1) Checking system compatibility

Message: System stack checks failed with message: 'Missing package(s): nginx'

Debug Information: OS: Ubuntu, v20.04.4 LTS Node Version: v16.15.1 Ghost-CLI Version: 1.21.0 Environment: production

The above suggestion to change the code to async isSupported() { try { const services = await sysinfo.services('*'); return services.some(s => s.name.trim() === nginxProgramName); } catch (error) { return false; } } didn't work in my case. I had to reinstall nginx for it to be detected. The weird thing is that one of the two installations was still being served, but if I tried to install ghost in another directory, or ran ghost doctor, nginx wouldn't be detected.

[GrapesMaster98]

Had the same issue today with both, I tried the suggestion made by KodzghlyCZ, but Ghost keeps telling me that Nginx is not installed.

[4w3Official]

I had the same error. Edited the files as @KodzghlyCZ described.

At first, it did not work. After reinstalling Ghost with ghost uninstall, ghost setup found NGINX successfully.

OS: Ubuntu 22.04 LTS NGINX: 1.18.0 MySQL: ver 8.0.29-0ubuntu0.22.04.2 Ghost-CLI version: 1.21.0 Ghost version: 5.2.3

[robseb]

I had also the same error with the latest verison (5.2.3) on Ubuntu 22.04 LTS. I tryied everything to fix it. my soulution is rather simple:

1. Follow the offical installation guide
2. Install a older version that supports also ' node 16.15`:

   ghost install 4.41.0

3. Then you can update to the latest verison.

[rowanjacobs]

Encountered this issue with the latest version on Ubuntu 22.04. The workarounds in this thread didn't work; I resolved it by downgrading the server to Ubuntu 20.04, after which it worked smoothly.

[vladaman]

I have same issue. It's clean AWS ubuntu instance with following.

OS: Ubuntu 22.04 LTS NGINX: 1.18.0 Ghost-CLI version: 1.21.0 Ghost version: 5.4.1

$ ghost setup nginx
Nginx is not installed. Skipping Nginx setup.
ℹ Setting up Nginx [skipped]

[dillfrescott]

Same issue. Maybe it will be fixed soon