Not able to install "Ghost" from Render examples

I am trying to launch a ghost blog on render. I saw that render has created an ghost example and a docs reference to it.

At first, I tried the [One-Click Deploy] method mentioned in the docs but it did not work, I am getting the following error :

Sep 27 02:29:27 PM  [2022-09-27 08:59:27] INFO Ghost is running in production...
Sep 27 02:29:27 PM  [2022-09-27 08:59:27] INFO Your site is now available on https://payqual-blog-ghost.onrender.com/
Sep 27 02:29:27 PM  [2022-09-27 08:59:27] INFO Ctrl+C to shut down
Sep 27 02:29:27 PM  [2022-09-27 08:59:27] INFO Ghost server started in 2.53s
Sep 27 02:29:28 PM  [2022-09-27 08:59:28] ERROR Invalid database host.
Sep 27 02:29:28 PM  
Sep 27 02:29:28 PM  Invalid database host.
Sep 27 02:29:28 PM  
Sep 27 02:29:28 PM  "Please double check your database config."
Sep 27 02:29:28 PM  
Sep 27 02:29:28 PM  Error ID:
Sep 27 02:29:28 PM      500
Sep 27 02:29:28 PM  
Sep 27 02:29:28 PM  Error Code: 
Sep 27 02:29:28 PM      ENOTFOUND
Sep 27 02:29:28 PM  
Sep 27 02:29:28 PM  ----------------------------------------
Sep 27 02:29:28 PM  
Sep 27 02:29:28 PM  Error: getaddrinfo ENOTFOUND mysql-db
Sep 27 02:29:28 PM      at /var/lib/ghost/versions/5.14.1/node_modules/knex-migrator/lib/database.js:50:23
Sep 27 02:29:28 PM      at GetAddrInfoReqWrap.onlookup [as oncomplete] (node:dns:109:26)

I have also tried the manual method and it is also giving me the same error.

Let me know if I am doing something wrong or if am I missing any steps. I am quite new to render as well as the ghost platform.

Thanks

1 Like

Hi there,
It seems like we recently updated the Ghost example to use Ghost5 which only supports using MySQL - the example does not provision a mySQL database.

I will raise this internally but in the mean time if you were to follow the manual deploy steps at https://render.com/docs/deploy-ghost#manual-deploy which has you provision a MySQL database then you should be able to link the 2 up.

Failing that, if you change to using the v4 branch, that would use Sqlite on the Ghost service’s disk - https://github.com/render-examples/ghost/tree/v4

Regards,

John B

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.