DigitalOcean Database Connection

Help Installation
#1

Hi there

I’m looking to install ghost with a DigitalOcean db cluster and not a local db on the server.

I can’t seem to figure out what the issue is with my setup.

Debug Information:
    OS: Ubuntu, v18.04.4 LTS
    Node Version: v10.23.0
    Ghost Version: 3.41.9
    Ghost-CLI Version: 1.13.1
    Environment: production
    Command: 'ghost start'
Message: Invalid database host.

Config: (not actually using variables for now but modified for safety)

"database": {
    "client": "mysql",
    "connection": {
      "host": "name-db-do-user-1234556-0.b.db.ondigitalocean.com",
      "database__connection__port": port_number,
      "user": "db_user",
      "password": "db_password",
      "database": "database_name"
    }
#2

Anybody?

#3

After running some more tests I was able to isolate the problem.
It leads me to this thread:

Any recommendations on a database that would work with Ghost? Looks like DigitalOcean wasn’t a good choice for Ghost with a managed db.

#4

@eba8 Ghost 4.0 has fixes for tables without primary keys. Perhaps you could start with a local mysql database and then migrate to the managed db once 4.0 is released and you’ve upgraded?

1 Like
#5

Thanks, Kevin.
That’s what I ended up going with. Just don’t like this solution but would prefer to stick with Ghost.

Any timeline on the release of 4.0? Just that feature makes the release oh so exciting :heart_eyes: