I have been setting up different Ghost instances since version 3, and this is quite the first time, no matter how many times I re-do the whole setup, Ghost is unable to connect to mysql, though I do know in the past. Hi all the results, I think Ghost have no issues but this mysql issue kept coming up oddly. Is there other ways I can help to jumpstart the mysql setup as it seems like the main issue I am consistently facing here. Do it mean I have to change the password, as my current password is pretty strong, but I am unsure that ghost's mysql actually validates the password. The only new things which I do not get is sudo mysql_secure_installation, as the password I had used kept the program going in an endless loop. ✔ Checking systemd node version - found v18.15.0 + sudo systemctl reset-failed ghost_mywebsite-com + sudo systemctl is-active ghost_mywebsite-com ✔ Checking if logged in user is directory owner ✔ Ensuring user is not logged in as ghost user ✔ Checking system Node.js version - found v18.15.0 Hi had tried all of the above before and had tried it again. In addition, I have also tried to add an additional user my-ghost to handle the db-interactions but it just seems like Ghost cannot access mysql. | mysql.sys | localhost | caching_sha2_password | | ssion | localhost | caching_sha2_password | | schema | localhost | caching_sha2_password | | debian-sys-maint | localhost | caching_sha2_password | Suggestion: journalctl -u ghost_mywebsite -n 50 Message: Ghost was able to start, but errored during boot with: connect ECONNREFUSED ::1:3306 Hope someone may have some better headway on this matter to give some advice moving forward. However, the same issue still persisted even though I destroyed and restarted the whole process about 20 times. Thus, I thought by utilizing the server method, I might have more control over what I can change to help resolve the solution. Switch to your regular user, or create a new user with regular account privileges and use this user to run 'ghost doctor'.I am trying to do a brand new install from scratch via the Bare Linux method, as even though I have tried using DigitalOcean’s Marketplace’s Ghost v5.41.0 Installer, the same error of being unable to connect to the database still persists. You can't run commands as the 'root' user. You can always refer to for troubleshooting.įor any further commands, please switch to the ghost-mgr user to manage Ghost. Verifying: Ĭommand: 'ghost install -auto -db=mysql -dbhost=localhost -dbname=ghost_production -dbuser=ghost -dbpass=58486a38b83ea8e04686c81b60b9d04e094ddc0e1a8f452e -dir=/var/Try running ghost doctor to check your system for known issues. Getting domain auth token for each domain The domain key is here: /etc/letsencrypt//.key ACCOUNT_THUMBPRINT='MeGBylrE1fTwmzBGd_FtEokW60E6HEXUypsc2jbIX_k' Please add '-debug' or '-log' to check more details. Message: Command failed: /bin/sh -c sudo -S -p '#node-sudo-passwd#' /etc/letsencrypt/acme.sh -issue -home /etc/letsencrypt -domain -webroot /var/www/ghost/system/nginx-root -reloadcmd "nginx -s reload" -accountemail Jan 16 20:45:] :Verify error:Invalid response from : + sudo systemctl enable ghost_kaminskiplus-de -quiet + sudo systemctl is-enabled ghost_kaminskiplus-de + sudo systemctl start ghost_kaminskiplus-de + sudo systemctl is-active ghost_kaminskiplus-de + sudo mv /tmp/kaminskiplus-de/ghost_rvice /lib/systemd/system/ghost_rvice + sudo /etc/letsencrypt/acme.sh -issue -home /etc/letsencrypt -domain -webroot /var/www/ghost/system/nginx-root -reloadcmd "nginx -s reload" -accountemail Setting up SSL ? Enter your email (For SSL Certificate) sudo mkdir -p /etc/letsencrypt + sudo ln -sf /etc/nginx/sites-available/.conf /etc/nginx/sites-enabled/.conf + sudo mv /tmp/kaminskiplus-de/.conf /etc/nginx/sites-available/.conf + sudo chown -R ghost:ghost /var/www/ghost/content ✔ Downloading and installing Ghost v3.40.5 + sudo chown -R ghost-mgr:ghost-mgr /home/ghost-mgr/.config Press enter when you are ready to get started! Add an A Record -> 161.35.122.128 & ensure the DNS has fully propagatedĢ. + 26 packages from 16 contributors, removed 17 packages, updated 51 packages and moved 6 packages in 37.425s usr/bin/ghost -> /usr/lib/node_modules/ghost-cli/bin/ghost + sudo npm i -g \ fetchMetadata: sill resolveWithNewModule checking installable status | fetchMetadata: sill resolveWithNewModule checking installable status | fetchMetadata: sill resolveWithNewModule checking installable status Once complete, you are encouraged to run mysql_secure_installation to ready Please wait a minute while your 1-Click is configured. Configuring DigitalOcean 1-Click Ghost installation. I have tried to install ghost using droplet on Digital Ocean.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |