Thank you, Nick! Excellent work. I have tried the instructions and worked fine with one extra amendment. By choosing the latest versions of Docker and Ghost, I have found an incompatibility issue that has to do with the DB initialization. The official Docker Ghost image has also shipped with SQLite as the default database for years....until it didn't. The release of Ghost 5.0 back in May 2022, one of the biggest architectural changes was the announcement that MySQL 8 would be the only database officially supported in production environments. Somewhere in the vicinity of the Docker image release for Ghost 5.9, the default database was switched to MySQL. Not a terribly unreasonable idea given that the production default for Ghost 5.x _is_ MySQL, but unfortunately this change broke a lot of people's existing Ghost-on-Docker instances that used the old default sqlite3 setup, as evidenced by the numerous subsequent complaints. Thankfully, the fix for this is relatively easy, assuming you want to keep using SQLite. The following environment variables should be added to the Ghost container : -e database__client=sqlite3 \ -e database__connection__filename="content/data/ghost.db" \ -e database__useNullAsDefault=true \ -e database__debug=false \ The above parameters may be entered in the Docker parameter screen @ 16.40 of the video.
Wow, many thanks for this information and an easy fix! Pinned your comment and added a callout in the description, so people can see it when following the tutorial. I will also add the fix to a text version of tutorial (with attribution). I knew, that they were planning to switch to MySQL. But as sqlite worked just fine in 5.0 I thought, that no major changes will be made until Ghost 6 release.
Hi Nick, Thanks for this video. I've tried it but I'm having the same problem every time -> As soon as I install the Ghost image, I can't access SSH on GCP, so I can't finalize the installation etc "Code : 4003 Motif : failed to connect to backend" Can you help me on that ?
I got to this point 14:33 but the Cyberpanel log in window would not open because my url is forcing HTTPS and not at all resolving to HTTP. So I cannot access the login window.
I appreciate your video but if you have to pay 8 usd/month for Google cloud it's like the same I mean, if you pay the 9 usd /month for Ghost pro, or am I wrong?
Thank you for watching. You can use Google cloud free tier (or Oracle free tier) and host your blog essentially for free. Ghost pro is way easier to setup and maintain though.
Hey! I am trying to install the program but it shows this error. I have tried several times but after 30 mins (more or less) it shows same error. What should I do ? ''You cannot connect to the VM instance because of an unexpected error. Wait a few moments and then try again. See troubleshooting docs.''
here is one more error comes at the end Branch 'v2.3.3' set up to track remote branch 'v2.3.3' from 'origin'. Switched to a new branch 'v2.3.3' /root ^C You have new mail in /var/mail/root root@humiblogs:~#
Hi Nick, can you help me please? I followed all the steps in your video but when I come to 18:17 and type my domain name/ghost it says the site can't be reached :( I don't even have a clue how to troubleshoot because I was just following your video. Thank you xx
Hi Marie, sorry to hear that. The issue might be due to ip address of the VM got changed. By default it is assigned a dynamic one and I totally forgot to cover this aspect in the video - my apologies for that. You can assign a static ip for the instance following this guide from Google: cloud.google.com/compute/docs/ip-addresses/reserve-static-external-ip-address Make sure to change the ip everywhere to a new static one. Hope this helps.
Hey Nick, first of all: Nice Video. But I have a question. I followed every step of your tutorial. But in the end I get a 503 HTTP Error. Do you havy any idea what the problem could be here? Thanks in advance and have a nice day!
Thank you for watching! I am sorry, that you've run into issues because of a bit outdated information in the tutorial. As Ghost have moved to another database system by default, it can't pick up the sqlite3 database and is looking for a mysql, resulting in 503 error. However there's an easy fix. Please check the pinned comment thread on how to add environment variables to the Ghost Docker container - this should solve the issue.
@@NickBorodenko unfortunately the 503 error stays even after changing the environment variables. do you have any idea how to work this error out? or do you have a documentation that you used to create this video?
@@derdaniel8655 So, you can access Cyberpanel via IP, but your blog returns 503 error when entering via domain name, right? Have you set up reverse proxy (time code 17:15 ) ? When you open Docker Container dashboard inside Cyberpanel - are there any errors popping up inside Logs? Normally it should state someting like Ghost is running in production... and Container status should be Status: running
Hi! Thank you for watching and commenting. Ghost CMS and Strapi CMS are two different content management systems, each with their own set of features and use cases. So as both Ghost and Strapi are quite similar tools, they are not designed to work together.
@@NickBorodenko thanks for replying. I meant if want to do Google cloud hosting with Strapi instead of ghost, would this method work? If not, do you know another CMS alternative? 😊
I'm afraid this method will not work for Strapi setup, at least not without some major changes. However, there are Google Cloud deployment guides specifically for Strapi if you want to use that CMS.
Are you using Cloudflare? They don't support 8090 port for free plan. If that's the case you can either change the port to the one, that Cloudflare supports (just google cyberpanel cloudflare 8090) or create a separate subdomain to access Cyberpanel ( bobcares.com/blog/cloudflare-cyberpanel/ ). P.S. You should be able to access Cyberpanel via server ip address:8090.
Good day, Nick. I enjoyed your video, but my intention is different: I want to create a static ghost website and publish it with github (thus eliminating the requirement for a Google Cloud account). But I'm encountering some issues along the way, so how can I download static files from my self-hosted ghost website without errors?
Thanks for watching and commenting. I've never used ghost for static websites personally, but as far as I know there are free ghost static websites generators out there (Ghost static site generator being one of them) - and they should pull everything out of your existing ghost site to later convert it into a static website.
Nick Borodenko, I fixed the problem by using wget to install everything with a single cmd script. The issue was that I relocated the ghost folder to another location and forgot to alter the config file. But, once again, thank you for your quick answer! ❤
Awesome video! Extremely helpful! When I type my domain name into the browser, I'm getting 503 Service Unavailable; any idea what could be the problem?
Thank you! Have you set up reverse proxy for Ghost (video time code 17:14 ) ? Could you please also check if there's an A record correctly pointing your domain to your server's external IP at dnschecker.org ? If you turn off and turn on Google cloud VM - it might change IP to a new one, so you might want to check that as well. And maybe try opening your site in an incognito browser mode or clearing browser cache. Let me know if that helped.
I failed to do it. Cant get through the ''server setup'' step. shows error even following the same steps. not recommended for people like me who have 0 knowledge of coding and stuff
Hi! Sorry to hear that. As Ghost is continuously developing, something might have been changed since I've installed it myself and made the video documenting the process. I suggest checking out Digital ocean. It's not free, but much cheaper compared to Ghost pro hosting and installation process is a breeze (there are 60 days promo codes available).
@@NickBorodenko Hey! I have bought the Ghost Pro. It would be so helpful if you could make a video on "how to set ghost pro (themes etc.)" , how to use tags and make sub pages. and all the features we should know.
Yes, but it's kinda complicated unless using Mailgun to send the newsletter, which is officially integrated with Ghost but isn't cheap. You can read more on Ghost newsletter functionality here: ghost.org/docs/faq/mailgun-newsletters/
You can install Cyberpanel by copy-pasting the command into SSH window of your Google Cloud server. There's a link to a text version in the description of this video - look for step 6 there.
Oracle's free tier is far more generous, but my billing information wasn't accepted for signing up for whatever reason, so I decided to try out Google instead.
Thank you, Nick! Excellent work. I have tried the instructions and worked fine with one extra amendment.
By choosing the latest versions of Docker and Ghost, I have found an incompatibility issue that has to do with the DB initialization.
The official Docker Ghost image has also shipped with SQLite as the default database for years....until it didn't.
The release of Ghost 5.0 back in May 2022, one of the biggest architectural changes was the announcement that MySQL 8 would be the only database officially supported in production environments.
Somewhere in the vicinity of the Docker image release for Ghost 5.9, the default database was switched to MySQL. Not a terribly unreasonable idea given that the production default for Ghost 5.x _is_ MySQL, but unfortunately this change broke a lot of people's existing Ghost-on-Docker instances that used the old default sqlite3 setup, as evidenced by the numerous subsequent complaints.
Thankfully, the fix for this is relatively easy, assuming you want to keep using SQLite.
The following environment variables should be added to the Ghost container :
-e database__client=sqlite3 \
-e database__connection__filename="content/data/ghost.db" \
-e database__useNullAsDefault=true \
-e database__debug=false \
The above parameters may be entered in the Docker parameter screen @ 16.40 of the video.
Wow, many thanks for this information and an easy fix!
Pinned your comment and added a callout in the description, so people can see it when following the tutorial. I will also add the fix to a text version of tutorial (with attribution).
I knew, that they were planning to switch to MySQL. But as sqlite worked just fine in 5.0 I thought, that no major changes will be made until Ghost 6 release.
Could you please attach a picture for the fix? I've tried but 503 error still occurs on the page.
@@NickBorodenko Could you please attach a picture for the fix? I've tried but 503 error still occurs on the page.
Can you be more specific on how to set these parameters?
@@JulianArango1984
Insert these variables to Ghost docker
(Left Column)
database__client
database__connection__filename
database__useNullAsDefault
database__debug
(Right Column)
sqlite3
content/data/ghost.db
true
fasle
Hope this helps.
As a heavy linux tech user, I greatly enjoyed how you literally have us using VIM, with properly quitting, in this tutorial.
Hi i got the blog up and running but the only thing is the image is not displaying on my blog, anyone know how to fix it? Thanks in advance!
Amazing tutorial, thank you!
Am about to watch it again, while installing Ghost, wish me luck!
Hi Nick,
Thanks for this video. I've tried it but I'm having the same problem every time -> As soon as I install the Ghost image, I can't access SSH on GCP, so I can't finalize the installation etc
"Code : 4003
Motif : failed to connect to backend"
Can you help me on that ?
Very detailed.
I appreciate the time and effort put into this video.
Thanks!
Thank you for watching and your comment!
I got to this point 14:33 but the Cyberpanel log in window would not open because my url is forcing HTTPS and not at all resolving to HTTP. So I cannot access the login window.
I appreciate your video but if you have to pay 8 usd/month for Google cloud it's like the same I mean, if you pay the 9 usd /month for Ghost pro, or am I wrong?
Thank you for watching. You can use Google cloud free tier (or Oracle free tier) and host your blog essentially for free.
Ghost pro is way easier to setup and maintain though.
Hey! I am trying to install the program but it shows this error. I have tried several times but after 30 mins (more or less) it shows same error. What should I do ?
''You cannot connect to the VM instance because of an unexpected error. Wait a few moments and then try again.
See troubleshooting docs.''
here is one more error comes at the end
Branch 'v2.3.3' set up to track remote branch 'v2.3.3' from 'origin'.
Switched to a new branch 'v2.3.3'
/root
^C
You have new mail in /var/mail/root
root@humiblogs:~#
Hi Nick, can you help me please? I followed all the steps in your video but when I come to 18:17 and type my domain name/ghost it says the site can't be reached :( I don't even have a clue how to troubleshoot because I was just following your video. Thank you xx
I've tried the fix in the pinned post and it still doesn't work
Hi Marie, sorry to hear that.
The issue might be due to ip address of the VM got changed. By default it is assigned a dynamic one and I totally forgot to cover this aspect in the video - my apologies for that. You can assign a static ip for the instance following this guide from Google: cloud.google.com/compute/docs/ip-addresses/reserve-static-external-ip-address
Make sure to change the ip everywhere to a new static one.
Hope this helps.
Hey Nick, first of all: Nice Video.
But I have a question. I followed every step of your tutorial. But in the end I get a 503 HTTP Error. Do you havy any idea what the problem could be here?
Thanks in advance and have a nice day!
Thank you for watching! I am sorry, that you've run into issues because of a bit outdated information in the tutorial.
As Ghost have moved to another database system by default, it can't pick up the sqlite3 database and is looking for a mysql, resulting in 503 error. However there's an easy fix.
Please check the pinned comment thread on how to add environment variables to the Ghost Docker container - this should solve the issue.
@@NickBorodenko thanks a lot for your message. have a nice day! :)
@@NickBorodenko unfortunately the 503 error stays even after changing the environment variables. do you have any idea how to work this error out? or do you have a documentation that you used to create this video?
@@derdaniel8655 So, you can access Cyberpanel via IP, but your blog returns 503 error when entering via domain name, right?
Have you set up reverse proxy (time code 17:15 ) ?
When you open Docker Container dashboard inside Cyberpanel - are there any errors popping up inside Logs?
Normally it should state someting like Ghost is running in production... and Container status should be Status: running
@@NickBorodenko perfectly did it but still 503
Hey! Thanks for the epic tutorial. Does this work with any CMS like Strapi?
Hi! Thank you for watching and commenting.
Ghost CMS and Strapi CMS are two different content management systems, each with their own set of features and use cases. So as both Ghost and Strapi are quite similar tools, they are not designed to work together.
@@NickBorodenko thanks for replying. I meant if want to do Google cloud hosting with Strapi instead of ghost, would this method work? If not, do you know another CMS alternative? 😊
I'm afraid this method will not work for Strapi setup, at least not without some major changes.
However, there are Google Cloud deployment guides specifically for Strapi if you want to use that CMS.
Domain name followed by :8090 not working in my machine. Can you help me with this?
Are you using Cloudflare? They don't support 8090 port for free plan.
If that's the case you can either change the port to the one, that Cloudflare supports (just google cyberpanel cloudflare 8090) or create a separate subdomain to access Cyberpanel ( bobcares.com/blog/cloudflare-cyberpanel/ ).
P.S. You should be able to access Cyberpanel via server ip address:8090.
Good day, Nick. I enjoyed your video, but my intention is different: I want to create a static ghost website and publish it with github (thus eliminating the requirement for a Google Cloud account).
But I'm encountering some issues along the way, so how can I download static files from my self-hosted ghost website without errors?
Thanks for watching and commenting.
I've never used ghost for static websites personally, but as far as I know there are free ghost static websites generators out there (Ghost static site generator being one of them) - and they should pull everything out of your existing ghost site to later convert it into a static website.
Nick Borodenko, I fixed the problem by using wget to install everything with a single cmd script. The issue was that I relocated the ghost folder to another location and forgot to alter the config file. But, once again, thank you for your quick answer! ❤
Bloghandy CMS works much better for me without needing to have any coding knowledge.
Awesome video! Extremely helpful!
When I type my domain name into the browser, I'm getting 503 Service Unavailable; any idea what could be the problem?
Thank you!
Have you set up reverse proxy for Ghost (video time code 17:14 ) ?
Could you please also check if there's an A record correctly pointing your domain to your server's external IP at dnschecker.org ? If you turn off and turn on Google cloud VM - it might change IP to a new one, so you might want to check that as well.
And maybe try opening your site in an incognito browser mode or clearing browser cache.
Let me know if that helped.
Plz check my comment about a fix.
Thank you, so helpful.
Awesome one, thanks nick!
Thank you for watching and commenting!
I failed to do it. Cant get through the ''server setup'' step. shows error even following the same steps. not recommended for people like me who have 0 knowledge of coding and stuff
Hi! Sorry to hear that. As Ghost is continuously developing, something might have been changed since I've installed it myself and made the video documenting the process.
I suggest checking out Digital ocean. It's not free, but much cheaper compared to Ghost pro hosting and installation process is a breeze (there are 60 days promo codes available).
@@NickBorodenko Hey! I have bought the Ghost Pro. It would be so helpful if you could make a video on "how to set ghost pro (themes etc.)" , how to use tags and make sub pages. and all the features we should know.
Can I start a newsletter using ghost
Yes, but it's kinda complicated unless using Mailgun to send the newsletter, which is officially integrated with Ghost but isn't cheap. You can read more on Ghost newsletter functionality here: ghost.org/docs/faq/mailgun-newsletters/
Thank you for this valuable video!
Thank you for your support!
Thank you for your video!
Thank you for the comment. Glad the video was helpful!
Thanks!
Thanks again! It's working as promised :)
Thanks a lot
Thank you for stopping by!
@@NickBorodenko I dont know how to get cyber panal. how can i get it
You can install Cyberpanel by copy-pasting the command into SSH window of your Google Cloud server.
There's a link to a text version in the description of this video - look for step 6 there.
p̷r̷o̷m̷o̷s̷m̷ 🎶
Oh wow I didn't know google had an always free tier, I use Oracles always free tier, which gives you 200GB free.
Oracle's free tier is far more generous, but my billing information wasn't accepted for signing up for whatever reason, so I decided to try out Google instead.