Ghost installation in Digital ocean keep failing with this error

[Greyfeathers]

Hi,

I followed instructions in this blog. I provided the IP address of the instance to see if I am able to get the instance up and running first but I keep running into this error.

Has anyone else faced the same issue?

[Cathy_Sarisky]

your MySQL is probably listening to the ipv6 version of localhost. Here’s discussion and a fix:

Ghost Update: ECONNREFUSED ::1:3306 + Error code 502

Just to share what problem I got after update of Ghost and Ubuntu 22.04 What happened: Update of Linux (Ubuntu 22.04.3 LTS) apt-get update apt-get upgrade Update of node: Ghost update Ghost-CLI version: 1.25.3 5.66.0 → 5.69.0 Error during the update and roleback The problem Ghost was starting but didn’t work. After several attempts I got that Ghost couldn’t connect with the database with errors: Message: connect ECONNREFUSED ::1:3306 and Bad gateway Error code 502 Fix I…

[Greyfeathers]

Hi, thank you. That removed the Connection refused error. But I am having a hard time figuring out how t restart Ghost.

I did the following.

1. Set up the domain since it was undefined
   ghost config url http://<MY_SERVER_IP>
2. ghost restart

which throws this error

ghost restart

Love open source? We’re hiring JavaScript Engineers to work on Ghost full-time.
https://careers.ghost.org


Ghost instance is not running! Starting...
✖ Starting Ghost
A GhostError occurred.

Message: Ghost was able to start, but errored during boot with: Access denied for user 'root'@'localhost' (using password: NO)
Help: Unknown database error

Debug Information:
    OS: Ubuntu, v22.04.3 LTS
    Node Version: v18.17.1
    Ghost Version: 5.82.1
    Ghost-CLI Version: 1.26.0
    Environment: production
    Command: 'ghost restart'

Additional log info available in: /home/ghost-mgr/.ghost/logs/ghost-cli-debug-2024-04-12T05_39_42_254Z.log

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

You can always refer to https://ghost.org/docs/ghost-cli/ for troubleshooting.

Ghost recommends I run the Ghost commands as ghost-mgr.
So I switched to that user.
Now it complains of an unknown database.
Should I reinstall Ghost again?

[markstos]

Ghost is installed as standard systemd service:

sudo systemctl restart 'ghost*'

[mjw]

@Greyfeathers

Message: Ghost was able to start, but errored during boot with: Access denied for user 'root'@'localhost' (using password: NO)
Help: Unknown database error

It looks like you’re using root for the Ghost database use, which isn’t ideal. Typically, this MySQL account uses socket rather than password authentication. Therefore, run this code.

sudo mysql

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<YOUR-PASSWORD';
QUIT;

[Greyfeathers]

@mjw

sudo mysql

Running

root@<server>:~# sudo mysql

throws this error

sudo mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[mjw]

Try this.

sudo mysql -u root

[Greyfeathers]

Sorry that doesn’t work either

sudo mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
root@<server>:~# sudo mysql -u root -p

[AnimaVillis]

If you don’t know password for root, install mysql service one more time with full config.

If You don’t know how read my tutorial about using CloudPanel and docker.

1. #2 Installing CloudPanel on Debian 11
2. #3 Adding a reverse proxy
3. #1 GhostCMS - Installation Docker

In those steps You’ll have full working ghost instance.

[mjw]

@Greyfeathers

sudo mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Then use sudo mysql -u root -p.