No default client exists in ghost

[thehomerepot]

The documentation for setting up ghost-backup states that 2 default clients are created during initialization of ghost. ghost-backup and ghost-frontend. However, neither of those seem to exist and I don't even have a clients table in my sqlite database. Any idea how to manually create one? I see the following error because of this.

Thu Feb 13 16:48:46 UTC 2020: Checking if a mysql container exists on the network at mysql:3306
Thu Feb 13 16:48:46 UTC 2020:  ...no mysql container exists on the network. Using sqlite mode
Thu Feb 13 16:48:46 UTC 2020: creating backup: 20200213-1648...
Thu Feb 13 16:48:46 UTC 2020: backing up ghost database
Thu Feb 13 16:48:46 UTC 2020:  creating ghost db archive (sqlite)...
Thu Feb 13 16:48:46 UTC 2020:  ...completed: /backups/backup-db_20200213-1648.gz
Thu Feb 13 16:48:46 UTC 2020: backing up ghost content files
Thu Feb 13 16:48:46 UTC 2020:  creating ghost content files archive...
Thu Feb 13 16:48:47 UTC 2020:  ...completed: /backups/backup-ghost_20200213-1648.tar.gz
Thu Feb 13 16:48:47 UTC 2020: backing up ghost json file
Thu Feb 13 16:48:47 UTC 2020:  ...checking if a ghost container exists on the network at concision.us:443
Thu Feb 13 16:48:47 UTC 2020:  ...found ghost service on the network
Thu Feb 13 16:48:47 UTC 2020:  ...retrieving client secret for client: ghost-backup
Error: no such table: clients

[tillg]

Hi thehomereport, I just stumbled over the same problem: The reason seems to be that since Ghost V3.0 the table "client" doesn't exist anymore. It gets dropped here. And the backup program still expects it and tries to retrieve the keys it needs to execute the API call to extract the JSON. So either you turn back to a pre-3.0 version (just kidding) or you understand and fix it... 😜

[bennetimo]

Hi! Yeah this project wasn't updated for some time during which Ghost has changed quite a lot, including the APIs and authentication model. I have just now pushed a new branch at https://github.com/bennetimo/ghost-backup/tree/feature/ghost4-x which is adapted to work with the latest ghost 4.

I've pushed a new image tag so if interested, the tag to use would be: docker pull bennetimo/ghost-backup:4.

[ichitaka]

@bennetimo trying to run that container I get the following error:

standard_init_linux.go:228: exec user process caused: exec format error

[quyleanh]

@bennetimo could you please update to Ghost 5? Thank you.

[bennetimo]

@bennetimo could you please update to Ghost 5? Thank you.

Hiya, sadly I don't have the time just at the moment I'm afraid, but yes it's something that I hope to get round to doing at some point.

[quyleanh]

@bennetimo could you please update to Ghost 5? Thank you.

Hiya, sadly I don't have the time just at the moment I'm afraid, but yes it's something that I hope to get round to doing at some point.

Thank you very much. Just take your time and do it later.

[ahmedeldeep]

Hopefully soon. I am not able to find any other automated docker backup solution for Ghost 5.