Any one know how to install Ghost CMS latest correctly on Cyberpanel Docker Container?

Hi,

I was trying to install ghost on Docker container using Cyberpanel Docker manager as per the below web guide.

However I’m getting below error log

[90mError: connect ECONNREFUSED 127.0.0.1:3306
at /var/lib/ghost/versions/5.22.11/node_modules/knex-migrator/lib/database.js:57:19
at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1278:16)e[39m
e[39m
[2022-11-18 07:08:27] e[35mWARNe[39m Ghost is shutting down
[2022-11-18 07:08:27] e[35mWARNe[39m Ghost has shut down
[2022-11-18 07:08:27] e[35mWARNe[39m Your site is now offline
[2022-11-18 07:08:27] e[35mWARNe[39m Ghost was running for a few seconds

Does anyone knows how to fix this and install Ghost CMS correct way?

Appreciate your support. Thank you.

Welcome @dinushalr Happy you are here

As you can see knexjs is trying to connect to your MariaDB with no success.

First of all you pull the unofficial image Docker as instructed in the tutorial you tagged

To run Ghost for production you’ll also need to be running with MySQL 8 ( Required in production) https, and a reverse proxy configured with appropriate X-Forwarded-For , X-Forwared-Host , and X-Forwarded-Proto (https ) headers. Configuration - Adapt your publication to suit your needs

https://hub.docker.com/_/ghost/

Hello @josephgodwinke Thank you so much for reply and support on this, much apricated.

So I need to installed Mysql 8 instead of Mariadb right?

No what i meant is your configure yout database correctly Configuration - Adapt your publication to suit your needs use your container settings - ENV variables

      database__client: mysql
      database__connection__host: db
      database__connection__user: root
      database__connection__password: mysqulrootp@ssworD
      database__connection__database: yourdomain_prodction

I’ve added the ENV variables like below and still getting the same error? my Mariadb hostname showing as localhost and i’ve put that into host field. is that correct? Please help.

Screenshot 2022-11-18 153526535×825 32.5 KB

Ideally yes localhost should work. Can you change the mysql port and try again

i was trying to change mysql port by editing /etc/my.cnf file, but as you can see file is empty

I also tried to edit the mariadb-server.cnf file under /etc/my.cnf.d , there also cannot see any Port defined in it. Please check below screenshot.

Anywhere else should i check?

Where did you get the root password?

what do you mean? for the server or MariaDB?

Where did you get mysql password that you have put here?

connected to MariaDB via SSH and set a password for root user. there was no password when i first connect to mysql, so i thought that was an issue, so i set a password using below command.

using this command

ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘passwordused’;
flush privileges;
exit;

Sorry buddy i was busy.

Run the command nano /usr/local/CyberCP/CyberCP/settings.py and CTRL+W DATABASES =

copy the root password

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'cyberpanel',
        'USER': 'cyberpanel',
        'PASSWORD': 'IGNORETHISPASSWORD',
        'HOST': 'localhost',
        'PORT':''
    },
    'rootdb': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'mysql',
        'USER': 'root',
        'PASSWORD': 'COPYTHISPASSWORD',
        'HOST': 'localhost',
        'PORT': '',

Hold up you wunt be able to connect your local mysql with a docker instance. Saying this from experience but you can try.

Since Ghost instance does not come with mariadb as seen here GitHub - docker-library/ghost: Docker Official Image packaging for Ghost

Can you pull an image of mysql8 and set it up. Use that to connect your ghost blog instance

Make sure you add your ports to your firewalls.

Hi Jose,

first thank you so much for helping me this far, really appreciated that.

As you mentioned earlier i got the root password but no luck, again the same error .

You mean pull mysql8 image to a separate container and try to connect that to ghost container?

Please let me know, and thank you again for supporting on this.

Yes https://hub.docker.com/layers/library/mysql/8.0.31/images/sha256-3fdbc2ee9a80a661f4aa7009ea5b4f0680094a0ad3d89582cb6cbc558691daaa?context=explore

ok i will try that out and let you know if i got stuck somewhere. Thank you Jose.

Any help if that was solved, Getting same error

added those vars to env but still not working

Any assistance here? Getting the same errors. The tutorials online do not offer any assistance.

Hello @dshan

Did you try docker deployment ?

Yes I did, i’m getting the same issue as the other