search

docker-library / ghost

Docker Official Image packaging for Ghost
https://hub.docker.com/_/ghost
MIT License
740 stars 314 forks source link

Resource couldnt be found #210

Closed letsjustfixit closed 4 years ago

letsjustfixit commented 4 years ago

Hey! I've just wanted to spin up the latest official image of ghost backed with a percona mysql db, however it crashed on boot, so I've created a oneliner to test it out:

docker run -it --rm --network=db_network -e database__connection__port=6033 -e database__client=mysql -e database__connection__database=db -e database__connection__host=db -e database__connection__user=test -e database__connection__password=test1 -e unsplash__applicationId=id -e url=http://host -e urlssl=https://host ghost:latest bash

/var/lib/ghost/current# node index.js [2020-02-12 09:35:56] INFO Creating table: posts [2020-02-12 09:35:56] INFO Creating table: posts_meta [2020-02-12 09:35:56] INFO Creating table: users [2020-02-12 09:35:56] INFO Creating table: posts_authors [2020-02-12 09:35:56] INFO Creating table: roles [2020-02-12 09:35:56] INFO Creating table: roles_users [2020-02-12 09:35:56] INFO Creating table: permissions [2020-02-12 09:35:56] INFO Creating table: permissions_users [2020-02-12 09:35:56] INFO Creating table: permissions_roles [2020-02-12 09:35:56] INFO Creating table: permissions_apps [2020-02-12 09:35:56] INFO Creating table: settings [2020-02-12 09:35:56] INFO Creating table: tags [2020-02-12 09:35:56] INFO Creating table: posts_tags [2020-02-12 09:35:56] INFO Creating table: apps [2020-02-12 09:35:56] INFO Creating table: app_settings [2020-02-12 09:35:56] INFO Creating table: app_fields [2020-02-12 09:35:56] INFO Creating table: invites [2020-02-12 09:35:56] INFO Creating table: brute [2020-02-12 09:35:56] INFO Creating table: webhooks [2020-02-12 09:35:56] INFO Creating table: sessions [2020-02-12 09:35:56] INFO Creating table: integrations [2020-02-12 09:35:56] INFO Creating table: api_keys [2020-02-12 09:35:56] INFO Creating table: mobiledoc_revisions [2020-02-12 09:35:56] INFO Creating table: members [2020-02-12 09:35:56] INFO Creating table: members_stripe_customers [2020-02-12 09:35:56] INFO Creating table: members_stripe_customers_subscriptions [2020-02-12 09:35:56] INFO Creating table: actions [2020-02-12 09:35:56] INFO Creating table: emails [2020-02-12 09:35:56] INFO Model: Tag [2020-02-12 09:35:56] INFO Model: Role [2020-02-12 09:35:57] INFO Model: Permission [2020-02-12 09:39:20] INFO Model: User [2020-02-12 09:39:21] ERROR Resource could not be found.

Resource could not be found.

{"config":{"transaction":true},"name":"2-create-fixtures.js"} 1

Error ID: 8ba60190-4d7b-11ea-8ec9-7b1615d22932

MigrationScriptError: Resource could not be found. at MigrationScriptError.KnexMigrateError (/var/lib/ghost/versions/3.5.2/node_modules/knex-migrator/lib/errors.js:7:26) at new MigrationScriptError (/var/lib/ghost/versions/3.5.2/node_modules/knex-migrator/lib/errors.js:25:26) at /var/lib/ghost/versions/3.5.2/node_modules/knex-migrator/lib/index.js:1055:19 at tryCatcher (/var/lib/ghost/versions/3.5.2/node_modules/knex-migrator/node_modules/bluebird/js/release/util.js:16:23) at Promise._settlePromiseFromHandler (/var/lib/ghost/versions/3.5.2/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:547:31) at Promise._settlePromise (/var/lib/ghost/versions/3.5.2/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:604:18) at Promise._settlePromise0 (/var/lib/ghost/versions/3.5.2/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:649:10) at Promise._settlePromises (/var/lib/ghost/versions/3.5.2/node_modules/knex-migrator/node_modules/bluebird/js/release/promise.js:725:18) at _drainQueueStep (/var/lib/ghost/versions/3.5.2/node_modules/knex-migrator/node_modules/bluebird/js/release/async.js:93:12) at _drainQueue (/var/lib/ghost/versions/3.5.2/node_modules/knex-migrator/node_modules/bluebird/js/release/async.js:86:9) at Async._drainQueues (/var/lib/ghost/versions/3.5.2/node_modules/knex-migrator/node_modules/bluebird/js/release/async.js:102:5) at Immediate.Async.drainQueues [as _onImmediate] (/var/lib/ghost/versions/3.5.2/node_modules/knex-migrator/node_modules/bluebird/js/release/async.js:15:14) at processImmediate (internal/timers.js:439:21)

NotFoundError: Resource could not be found. at new NotFoundError (/var/lib/ghost/versions/3.5.2/node_modules/ghost-ignition/lib/errors/index.js:106:23) at Child.successFetchedModel (/var/lib/ghost/versions/3.5.2/core/server/models/base/utils.js:35:23) at Child.tryCatcher (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/util.js:16:23) at Promise._settlePromiseFromHandler (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:547:31) at Promise._settlePromise (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:604:18) at Promise._settlePromise0 (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:649:10) at Promise._settlePromises (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:729:18) at _drainQueueStep (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/async.js:93:12) at _drainQueue (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/async.js:86:9) at Async._drainQueues (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/async.js:102:5) at Immediate.Async.drainQueues [as _onImmediate] (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/async.js:15:14) at processImmediate (internal/timers.js:439:21)

fiddled with knex-migrator a little, but didnt lead anywhere useful..

Any ideas?

letsjustfixit commented 4 years ago

interesting sidenote: switching to sqlite3 got rid of the issue however that is just a workaround it doesnt solve the problem itself.. so just added -e database__client=sqlite3 -e database__connection__filename=/var/lib/ghost/current/content/data/db.sqlite3 and boom launch complete.. 😕 ❓

wglambert commented 4 years ago

I can't reproduce an issue with Ghost using Percona

docker run percona/ghost ```console $ docker run -d --rm --name db --network=db_network \ -e MYSQL_ROOT_PASSWORD=root \ -e MYSQL_USER=test \ -e MYSQL_DATABASE=db \ -e MYSQL_PASSWORD=test1 \ percona 85616f095e3beaa5005bfb5448729dd0ef77d15de081fa3f74420f80f667dd40 $ docker run -d --network=db_network --name ghost -p 8080:2368 \ -e database__client=mysql \ -e database__connection__host=db \ -e database__connection__user=test \ -e database__connection__password=test1 \ -e database__connection__database=db \ ghost:latest c009fd2132f6646d969f648e0a061b04c3ebb6e7a7f5be5258c23ac41bae1a53 $ docker logs -f ghost [2020-02-12 17:29:36] INFO Creating table: posts [2020-02-12 17:29:39] INFO Creating table: posts_meta [2020-02-12 17:29:43] INFO Creating table: users [2020-02-12 17:29:45] INFO Creating table: posts_authors [2020-02-12 17:29:54] INFO Creating table: roles [2020-02-12 17:29:59] INFO Creating table: roles_users [2020-02-12 17:30:03] INFO Creating table: permissions [2020-02-12 17:30:10] INFO Creating table: permissions_users [2020-02-12 17:30:12] INFO Creating table: permissions_roles [2020-02-12 17:30:13] INFO Creating table: permissions_apps [2020-02-12 17:30:16] INFO Creating table: settings [2020-02-12 17:30:18] INFO Creating table: tags [2020-02-12 17:30:20] INFO Creating table: posts_tags [2020-02-12 17:30:25] INFO Creating table: apps [2020-02-12 17:30:28] INFO Creating table: app_settings [2020-02-12 17:30:43] INFO Creating table: app_fields [2020-02-12 17:30:48] INFO Creating table: invites [2020-02-12 17:30:53] INFO Creating table: brute [2020-02-12 17:30:54] INFO Creating table: webhooks [2020-02-12 17:30:55] INFO Creating table: sessions [2020-02-12 17:30:58] INFO Creating table: integrations [2020-02-12 17:31:09] INFO Creating table: api_keys [2020-02-12 17:31:21] INFO Creating table: mobiledoc_revisions [2020-02-12 17:31:30] INFO Creating table: members [2020-02-12 17:31:34] INFO Creating table: members_stripe_customers [2020-02-12 17:31:36] INFO Creating table: members_stripe_customers_subscriptions [2020-02-12 17:31:38] INFO Creating table: actions [2020-02-12 17:31:40] INFO Creating table: emails [2020-02-12 17:31:43] INFO Model: Tag [2020-02-12 17:31:43] INFO Model: Role [2020-02-12 17:31:43] INFO Model: Permission [2020-02-12 17:31:43] INFO Model: User [2020-02-12 17:31:44] INFO Model: Post [2020-02-12 17:31:46] INFO Model: Integration [2020-02-12 17:31:46] INFO Relation: Role to Permission [2020-02-12 17:31:46] INFO Relation: Post to Tag [2020-02-12 17:31:47] INFO Relation: User to Role [2020-02-12 17:31:56] INFO Ghost is running in production... [2020-02-12 17:31:56] INFO Your site is now available on http://localhost:2368/ [2020-02-12 17:31:56] INFO Ctrl+C to shut down [2020-02-12 17:31:56] INFO Ghost boot 153.209s [2020-02-12 17:32:29] INFO "GET /" 200 804ms (node:1) [DEP0066] DeprecationWarning: OutgoingMessage.prototype._headers is deprecated [2020-02-12 17:32:29] INFO "GET /assets/built/screen.css?v=0cc0d819ed" 200 7ms [2020-02-12 17:32:29] INFO "GET /assets/built/casper.js?v=0cc0d819ed" 200 3ms [2020-02-12 17:32:31] INFO "GET /favicon.ico" 200 33ms [2020-02-12 17:32:37] INFO "GET /ghost/" 200 1188ms [2020-02-12 17:32:37] INFO "GET /ghost/assets/vendor.min-e80c50b3effa149734ab96b786349748.css" 200 284ms [2020-02-12 17:32:38] INFO "GET /ghost/assets/ghost.min-1cbce1aeda6ec737d5163ea0ba753666.css" 200 407ms [2020-02-12 17:32:38] INFO "GET /ghost/assets/ghost.min-8c72a50466899eec9319c299f8092f52.js" 200 596ms [2020-02-12 17:32:39] INFO "GET /ghost/assets/vendor.min-5962b43ff141d221620b6489791d96ce.js" 200 1357ms ```

image

$ docker ps
CONTAINER ID        IMAGE                          COMMAND                  CREATED             STATUS              PORTS                                            NAMES
c009fd2132f6        ghost:latest                   "docker-entrypoint.s…"   5 minutes ago      Up 5 minutes       0.0.0.0:8080->2368/tcp                           ghost 
85616f095e3b        percona                        "/docker-entrypoint.…"   9 minutes ago      Up 9 minutes       3306/tcp                                         db
letsjustfixit commented 4 years ago

Hey there!

Thanks for the blazing fast followup!

I've experimented a bit locally (database was mariadb) where all went well, then moved on to the percona xtradb cluster and it moved on to another problem, however I think this might be a ghost problem (percona xtradb cluster master-enforceing compatibility one) + proxysql, not one with the docker container.. ..so I suppose feel free to close the ticket.

anyway:

Full log of a new install of ghost:latest

``` [2020-02-17 14:59:16] INFO Creating table: posts [2020-02-17 14:59:17] INFO Creating table: posts_meta [2020-02-17 14:59:17] INFO Creating table: users [2020-02-17 14:59:17] INFO Creating table: posts_authors [2020-02-17 14:59:17] INFO Creating table: roles [2020-02-17 14:59:17] INFO Creating table: roles_users [2020-02-17 14:59:17] INFO Creating table: permissions [2020-02-17 14:59:18] INFO Creating table: permissions_users [2020-02-17 14:59:18] INFO Creating table: permissions_roles [2020-02-17 14:59:18] INFO Creating table: permissions_apps [2020-02-17 14:59:18] INFO Creating table: settings [2020-02-17 14:59:18] INFO Creating table: tags [2020-02-17 14:59:18] INFO Creating table: posts_tags [2020-02-17 14:59:18] INFO Creating table: apps [2020-02-17 14:59:18] INFO Creating table: app_settings [2020-02-17 14:59:19] INFO Creating table: app_fields [2020-02-17 14:59:19] INFO Creating table: invites [2020-02-17 14:59:19] INFO Creating table: brute [2020-02-17 14:59:19] INFO Creating table: webhooks [2020-02-17 14:59:19] INFO Creating table: sessions [2020-02-17 14:59:19] INFO Creating table: integrations [2020-02-17 14:59:19] INFO Creating table: api_keys [2020-02-17 14:59:20] INFO Creating table: mobiledoc_revisions [2020-02-17 14:59:20] INFO Creating table: members [2020-02-17 14:59:20] INFO Creating table: members_stripe_customers [2020-02-17 14:59:20] INFO Creating table: members_stripe_customers_subscriptions [2020-02-17 14:59:20] INFO Creating table: actions [2020-02-17 14:59:20] INFO Creating table: emails [2020-02-17 14:59:20] INFO Model: Tag [2020-02-17 14:59:20] INFO Model: Role [2020-02-17 14:59:20] INFO Model: Permission [2020-02-17 14:59:21] INFO Model: User [2020-02-17 14:59:22] INFO Model: Post [2020-02-17 14:59:23] INFO Model: Integration [2020-02-17 14:59:23] INFO Relation: Role to Permission [2020-02-17 14:59:24] INFO Relation: Post to Tag [2020-02-17 14:59:24] INFO Relation: User to Role [2020-02-17 14:59:29] INFO Ghost is running in production... [2020-02-17 14:59:29] INFO Your site is now available on http://10.9.1.38:2368/ [2020-02-17 14:59:29] INFO Ctrl+C to shut down [2020-02-17 14:59:29] INFO Ghost boot 15.364s [2020-02-17 15:00:15] INFO "GET /" 200 920ms (node:1) [DEP0066] DeprecationWarning: OutgoingMessage.prototype._headers is deprecated [2020-02-17 15:00:15] INFO "GET /assets/built/screen.css?v=f7b5a363e5" 200 10ms [2020-02-17 15:00:15] INFO "GET /assets/built/casper.js?v=f7b5a363e5" 200 3ms [2020-02-17 15:00:16] INFO "GET /favicon.ico" 200 5ms [2020-02-17 15:00:22] INFO "GET /ghost/" 200 219ms [2020-02-17 15:00:22] INFO "GET /ghost/assets/img/medium-7359075af28d69523987ff4c0e2067c5.png" 200 3ms [2020-02-17 15:00:22] ERROR "GET /ghost/api/v3/admin/users/me/?include=roles" 403 13ms Authorization failed "Unable to determine the authenticated user or integration. Check that cookies are being passed through if using session authentication." Error ID: 38d07030-5196-11ea-b077-dd4ff3c58726 ---------------------------------------- NoPermissionError: Authorization failed at new NoPermissionError (/var/lib/ghost/versions/3.5.2/node_modules/ghost-ignition/lib/errors/index.js:127:23) at authorizeAdminApi (/var/lib/ghost/versions/3.5.2/core/server/services/auth/authorize.js:27:25) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/layer.js:95:5) at next (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/route.js:137:13) at authenticate (/var/lib/ghost/versions/3.5.2/core/server/services/auth/session/middleware.js:103:16) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/layer.js:95:5) at next (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/route.js:137:13) at authenticate (/var/lib/ghost/versions/3.5.2/core/server/services/auth/api-key/admin.js:40:16) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/layer.js:95:5) at next (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/route.js:137:13) at Route.dispatch (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/route.js:112:3) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/layer.js:95:5) at /var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:281:22 at param (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:354:14) at param (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:365:14) at Function.process_params (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:410:3) at next (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:275:10) at /var/lib/ghost/versions/3.5.2/node_modules/cors/lib/index.js:228:13 at handleCORS (/var/lib/ghost/versions/3.5.2/core/server/web/shared/middlewares/api/cors.js:71:16) at corsMiddleware (/var/lib/ghost/versions/3.5.2/node_modules/cors/lib/index.js:204:7) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/layer.js:95:5) at trim_prefix (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:317:13) at /var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:284:7 at Function.process_params (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:335:12) at next (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:275:10) at Function.handle (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:174:3) at router (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:47:12) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/layer.js:95:5) at trim_prefix (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:317:13) at /var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:284:7 at Function.process_params (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:335:12) at next (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:275:10) at cacheControlHeaders (/var/lib/ghost/versions/3.5.2/core/server/web/shared/middlewares/cache-control.js:32:9) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/layer.js:95:5) at trim_prefix (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:317:13) at /var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:284:7 at Function.process_params (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:335:12) at next (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/index.js:275:10) at checkVersionMatch (/var/lib/ghost/versions/3.5.2/core/server/web/shared/middlewares/api/version-match.js:23:5) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.5.2/node_modules/express/lib/router/layer.js:95:5) [2020-02-17 15:00:22] INFO "GET /ghost/api/v3/admin/site/" 200 7ms [2020-02-17 15:00:23] INFO "GET /ghost/api/v3/admin/authentication/setup/" 200 30ms [2020-02-17 15:00:23] INFO "GET /ghost/api/v3/admin/authentication/setup/" 200 15ms [2020-02-17 15:00:37] INFO "POST /ghost/api/v3/admin/authentication/setup/" 201 379ms [2020-02-17 15:00:37] ERROR "POST /ghost/api/v3/admin/session" 500 23ms Unknown error Error ID: 4154c440-5196-11ea-b077-dd4ff3c58726 Error Code: ER_UNKNOWN_ERROR ---------------------------------------- InternalServerError: Unknown error at new InternalServerError (/var/lib/ghost/versions/3.5.2/node_modules/ghost-ignition/lib/errors/index.js:90:23) at Object.handleStoreError (/var/lib/ghost/versions/3.5.2/core/server/web/shared/middlewares/api/spam-prevention.js:27:25) at module.exports. (/var/lib/ghost/versions/3.5.2/node_modules/express-brute/index.js:84:19) at tryCatcher (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/util.js:16:23) at Promise.errorAdapter [as _rejectionHandler0] (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/nodeify.js:35:34) at Promise._settlePromise (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:601:21) at Promise._settlePromise0 (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:649:10) at Promise._settlePromises (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:725:18) at _drainQueueStep (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/async.js:93:12) at _drainQueue (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/async.js:86:9) at Async._drainQueues (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/async.js:102:5) at Immediate.Async.drainQueues [as _onImmediate] (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/async.js:15:14) at processImmediate (internal/timers.js:439:21) at process.topLevelDomainCallback (domain.js:130:23) Error: ER_UNKNOWN_ERROR: Percona-XtraDB-Cluster prohibits use of DML command on a table (ghost_dev.brute) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER at Query.Sequence._packetToError (/var/lib/ghost/versions/3.5.2/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14) at Query.ErrorPacket (/var/lib/ghost/versions/3.5.2/node_modules/mysql/lib/protocol/sequences/Query.js:77:18) at Protocol._parsePacket (/var/lib/ghost/versions/3.5.2/node_modules/mysql/lib/protocol/Protocol.js:291:23) at Parser._parsePacket (/var/lib/ghost/versions/3.5.2/node_modules/mysql/lib/protocol/Parser.js:433:10) at Parser.write (/var/lib/ghost/versions/3.5.2/node_modules/mysql/lib/protocol/Parser.js:43:10) at Protocol.write (/var/lib/ghost/versions/3.5.2/node_modules/mysql/lib/protocol/Protocol.js:38:16) at Socket. (/var/lib/ghost/versions/3.5.2/node_modules/mysql/lib/Connection.js:91:28) at Socket. (/var/lib/ghost/versions/3.5.2/node_modules/mysql/lib/Connection.js:525:10) at Socket.emit (events.js:223:5) at Socket.EventEmitter.emit (domain.js:475:20) at addChunk (_stream_readable.js:309:12) at readableAddChunk (_stream_readable.js:290:11) at Socket.Readable.push (_stream_readable.js:224:10) at TCP.onStreamRead (internal/stream_base_commons.js:181:23) -------------------- at Protocol._enqueue (/var/lib/ghost/versions/3.5.2/node_modules/mysql/lib/protocol/Protocol.js:144:48) at Connection.query (/var/lib/ghost/versions/3.5.2/node_modules/mysql/lib/Connection.js:201:25) at /var/lib/ghost/versions/3.5.2/node_modules/knex/lib/dialects/mysql/index.js:130:18 at Promise._execute (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/debuggability.js:384:9) at Promise._resolveFromExecutor (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:518:18) at new Promise (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:103:10) at Client_MySQL._query (/var/lib/ghost/versions/3.5.2/node_modules/knex/lib/dialects/mysql/index.js:124:12) at Client_MySQL.query (/var/lib/ghost/versions/3.5.2/node_modules/knex/lib/client.js:158:17) at Runner.query (/var/lib/ghost/versions/3.5.2/node_modules/knex/lib/runner.js:135:36) at /var/lib/ghost/versions/3.5.2/node_modules/knex/lib/runner.js:39:23 at tryCatcher (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/util.js:16:23) at /var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/using.js:185:26 at tryCatcher (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/util.js:16:23) at Promise._settlePromiseFromHandler (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:547:31) at Promise._settlePromise (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:604:18) at Promise._settlePromise0 (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:649:10) at Promise._settlePromises (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:729:18) at Promise._fulfill (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:673:18) at PromiseArray._resolve (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise_array.js:127:19) at PromiseArray._promiseFulfilled (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise_array.js:145:14) at Promise._settlePromise (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:609:26) at Promise._settlePromise0 (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:649:10) at Promise._settlePromises (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/promise.js:729:18) at _drainQueueStep (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/async.js:93:12) at _drainQueue (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/async.js:86:9) at Async._drainQueues (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/async.js:102:5) at Immediate.Async.drainQueues (/var/lib/ghost/versions/3.5.2/node_modules/bluebird/js/release/async.js:15:14) at processImmediate (internal/timers.js:439:21) at process.topLevelDomainCallback (domain.js:130:23) ```

pascalandy commented 4 years ago

There was a bug on version 3.5.x.

It's recommended to run 3.6.x

letsjustfixit commented 4 years ago

@wglambert problems start to arise if you would like to finish setting up & getting to the admin ui screen @pascalandy Hey! We meet again after so long :) :wave: I've given it one more shot :crossed_fingers: , however it is all the same. I think its just an issue with percona replication vs ghost :beetle: . /TBH I've already removed proxysql :bulb: as seemd to be the reason for the original issue (resource[fixture] not found)/

:heavy_check_mark: the issue with the bruteforce checking was an easy one with missing pk on the table: 

alter table brute add `id` varchar(24) NOT NULL;alter table brute add PRIMARY KEY(id);

then realized default value must be provided and percona has no convinience function to set uuid-s so modified it to good old int autoincrements..

ALTER TABLE brute CHANGE id id INT(10)AUTO_INCREMENT PRIMARY KEY;

:man_facepalming: I'm just going to host my own personal blog, but it seems its easier and faster to do a quick 1node vanialla mysql setup compared to my idea of db replication with perconas take on galera. Thanks for all your work with maintaining the image

:information_source: Full log for a fresh spin of ghost:latest /**3.6**/

``` [2020-02-18 09:17:59] INFO Ctrl+C to shut down [2020-02-18 09:17:59] INFO Ghost boot 17.558s [2020-02-18 09:18:07] INFO "GET /" 200 985ms (node:1) [DEP0066] DeprecationWarning: OutgoingMessage.prototype._headers is deprecated [2020-02-18 09:18:08] INFO "GET /assets/built/screen.css?v=a099c3efc1" 200 16ms [2020-02-18 09:18:08] INFO "GET /assets/built/casper.js?v=a099c3efc1" 200 8ms [2020-02-18 09:18:10] INFO "GET /favicon.ico" 200 6ms [2020-02-18 09:18:13] INFO "GET /ghost" 301 2ms [2020-02-18 09:18:14] INFO "GET /ghost/" 200 226ms [2020-02-18 09:18:14] INFO "GET /ghost/assets/vendor.min-e80c50b3effa149734ab96b786349748.css" 200 76ms [2020-02-18 09:18:14] INFO "GET /ghost/assets/ghost.min-0ec555bafc92452cf60496eb4ba4fd72.css" 200 167ms [2020-02-18 09:18:14] INFO "GET /ghost/assets/ghost.min-0df10fff52a407c2771c9ac9076c4ed4.js" 200 288ms [2020-02-18 09:18:15] INFO "GET /ghost/assets/vendor.min-5962b43ff141d221620b6489791d96ce.js" 200 766ms [2020-02-18 09:18:15] ERROR "GET /ghost/api/v3/admin/users/me/?include=roles" 403 20ms Authorization failed "Unable to determine the authenticated user or integration. Check that cookies are being passed through if using session authentication." Error ID: 97f04d30-522f-11ea-b642-99045c538f54 ---------------------------------------- NoPermissionError: Authorization failed at new NoPermissionError (/var/lib/ghost/versions/3.6.0/node_modules/ghost-ignition/lib/errors/index.js:127:23) at authorizeAdminApi (/var/lib/ghost/versions/3.6.0/core/server/services/auth/authorize.js:27:25) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/route.js:137:13) at authenticate (/var/lib/ghost/versions/3.6.0/core/server/services/auth/session/middleware.js:103:16) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/route.js:137:13) at authenticate (/var/lib/ghost/versions/3.6.0/core/server/services/auth/api-key/admin.js:40:16) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/route.js:137:13) at Route.dispatch (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/route.js:112:3) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at /var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:281:22 at param (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:354:14) at param (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:365:14) at Function.process_params (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:410:3) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:275:10) at /var/lib/ghost/versions/3.6.0/node_modules/cors/lib/index.js:228:13 at handleCORS (/var/lib/ghost/versions/3.6.0/core/server/web/shared/middlewares/api/cors.js:71:16) at corsMiddleware (/var/lib/ghost/versions/3.6.0/node_modules/cors/lib/index.js:204:7) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at trim_prefix (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:317:13) at /var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:284:7 at Function.process_params (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:335:12) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:275:10) at Function.handle (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:174:3) at router (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:47:12) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at trim_prefix (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:317:13) at /var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:284:7 at Function.process_params (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:335:12) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:275:10) at cacheControlHeaders (/var/lib/ghost/versions/3.6.0/core/server/web/shared/middlewares/cache-control.js:32:9) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at trim_prefix (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:317:13) at /var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:284:7 at Function.process_params (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:335:12) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:275:10) at checkVersionMatch (/var/lib/ghost/versions/3.6.0/core/server/web/shared/middlewares/api/version-match.js:23:5) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) [2020-02-18 09:18:15] INFO "GET /ghost/assets/img/favicon.ico" 200 13ms [2020-02-18 09:18:15] INFO "GET /ghost/api/v3/admin/site/" 200 6ms [2020-02-18 09:18:15] INFO "GET /ghost/api/v3/admin/authentication/setup/" 200 31ms [2020-02-18 09:18:15] INFO "GET /ghost/api/v3/admin/authentication/setup/" 200 8ms [2020-02-18 09:18:15] INFO "GET /ghost/assets/img/install-welcome-ff3912d18bf8949df89c83b1c3b8bb66.png" 200 11ms [2020-02-18 09:18:24] INFO "GET /ghost/assets/img/user-image-0d67f7ca80917835524605cf4d106aef.png" 200 6ms [2020-02-18 09:19:04] INFO "POST /ghost/api/v3/admin/authentication/setup/" 201 535ms [2020-02-18 09:19:04] ERROR "POST /ghost/api/v3/admin/session" 500 178ms Unknown error Error ID: b555a190-522f-11ea-b642-99045c538f54 Error Code: ER_UNKNOWN_ERROR ---------------------------------------- InternalServerError: Unknown error at new InternalServerError (/var/lib/ghost/versions/3.6.0/node_modules/ghost-ignition/lib/errors/index.js:90:23) at Object.handleStoreError (/var/lib/ghost/versions/3.6.0/core/server/web/shared/middlewares/api/spam-prevention.js:27:25) at module.exports. (/var/lib/ghost/versions/3.6.0/node_modules/express-brute/index.js:84:19) at tryCatcher (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/util.js:16:23) at Promise.errorAdapter [as _rejectionHandler0] (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/nodeify.js:35:34) at Promise._settlePromise (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:601:21) at Promise._settlePromise0 (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:649:10) at Promise._settlePromises (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:725:18) at _drainQueueStep (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/async.js:93:12) at _drainQueue (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/async.js:86:9) at Async._drainQueues (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/async.js:102:5) at Immediate.Async.drainQueues [as _onImmediate] (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/async.js:15:14) at processImmediate (internal/timers.js:456:21) at process.topLevelDomainCallback (domain.js:137:15) Error: ER_UNKNOWN_ERROR: Percona-XtraDB-Cluster prohibits use of DML command on a table (ghost_dev.brute) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER at Query.Sequence._packetToError (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14) at Query.ErrorPacket (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/protocol/sequences/Query.js:77:18) at Protocol._parsePacket (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/protocol/Protocol.js:291:23) at Parser._parsePacket (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/protocol/Parser.js:433:10) at Parser.write (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/protocol/Parser.js:43:10) at Protocol.write (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/protocol/Protocol.js:38:16) at Socket. (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/Connection.js:91:28) at Socket. (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/Connection.js:525:10) at Socket.emit (events.js:321:20) at Socket.EventEmitter.emit (domain.js:482:12) at addChunk (_stream_readable.js:294:12) at readableAddChunk (_stream_readable.js:275:11) at Socket.Readable.push (_stream_readable.js:209:10) at TCP.onStreamRead (internal/stream_base_commons.js:186:23) -------------------- at Protocol._enqueue (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/protocol/Protocol.js:144:48) at Connection.query (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/Connection.js:201:25) at /var/lib/ghost/versions/3.6.0/node_modules/knex/lib/dialects/mysql/index.js:130:18 at Promise._execute (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/debuggability.js:384:9) at Promise._resolveFromExecutor (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:518:18) at new Promise (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:103:10) at Client_MySQL._query (/var/lib/ghost/versions/3.6.0/node_modules/knex/lib/dialects/mysql/index.js:124:12) at Client_MySQL.query (/var/lib/ghost/versions/3.6.0/node_modules/knex/lib/client.js:158:17) at Runner.query (/var/lib/ghost/versions/3.6.0/node_modules/knex/lib/runner.js:135:36) at /var/lib/ghost/versions/3.6.0/node_modules/knex/lib/runner.js:39:23 at tryCatcher (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/util.js:16:23) at /var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/using.js:185:26 at tryCatcher (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/util.js:16:23) at Promise._settlePromiseFromHandler (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:547:31) at Promise._settlePromise (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:604:18) at Promise._settlePromise0 (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:649:10) at Promise._settlePromises (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:729:18) at Promise._fulfill (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:673:18) at PromiseArray._resolve (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise_array.js:127:19) at PromiseArray._promiseFulfilled (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise_array.js:145:14) at Promise._settlePromise (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:609:26) at Promise._settlePromise0 (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:649:10) at Promise._settlePromises (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:729:18) at _drainQueueStep (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/async.js:93:12) at _drainQueue (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/async.js:86:9) at Async._drainQueues (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/async.js:102:5) at Immediate.Async.drainQueues (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/async.js:15:14) at processImmediate (internal/timers.js:456:21) at process.topLevelDomainCallback (domain.js:137:15) [2020-02-18 09:19:20] INFO "GET /ghost/" 200 10ms [2020-02-18 09:19:21] ERROR "GET /ghost/api/v3/admin/users/me/?include=roles" 403 4ms Authorization failed "Unable to determine the authenticated user or integration. Check that cookies are being passed through if using session authentication." Error ID: bf659eb0-522f-11ea-b642-99045c538f54 ---------------------------------------- NoPermissionError: Authorization failed at new NoPermissionError (/var/lib/ghost/versions/3.6.0/node_modules/ghost-ignition/lib/errors/index.js:127:23) at authorizeAdminApi (/var/lib/ghost/versions/3.6.0/core/server/services/auth/authorize.js:27:25) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/route.js:137:13) at authenticate (/var/lib/ghost/versions/3.6.0/core/server/services/auth/session/middleware.js:103:16) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/route.js:137:13) at authenticate (/var/lib/ghost/versions/3.6.0/core/server/services/auth/api-key/admin.js:40:16) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/route.js:137:13) at Route.dispatch (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/route.js:112:3) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at /var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:281:22 at param (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:354:14) at param (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:365:14) at Function.process_params (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:410:3) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:275:10) at /var/lib/ghost/versions/3.6.0/node_modules/cors/lib/index.js:228:13 at handleCORS (/var/lib/ghost/versions/3.6.0/core/server/web/shared/middlewares/api/cors.js:71:16) at corsMiddleware (/var/lib/ghost/versions/3.6.0/node_modules/cors/lib/index.js:204:7) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at trim_prefix (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:317:13) at /var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:284:7 at Function.process_params (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:335:12) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:275:10) at Function.handle (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:174:3) at router (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:47:12) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at trim_prefix (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:317:13) at /var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:284:7 at Function.process_params (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:335:12) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:275:10) at cacheControlHeaders (/var/lib/ghost/versions/3.6.0/core/server/web/shared/middlewares/cache-control.js:32:9) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at trim_prefix (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:317:13) at /var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:284:7 at Function.process_params (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:335:12) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:275:10) at checkVersionMatch (/var/lib/ghost/versions/3.6.0/core/server/web/shared/middlewares/api/version-match.js:23:5) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) [2020-02-18 09:19:21] INFO "GET /ghost/api/v3/admin/site/" 200 2ms [2020-02-18 09:19:21] INFO "GET /ghost/api/v3/admin/authentication/setup/" 200 9ms [2020-02-18 09:19:30] ERROR "POST /ghost/api/v3/admin/session" 500 8ms Unknown error Error ID: c463d940-522f-11ea-b642-99045c538f54 Error Code: ER_UNKNOWN_ERROR ---------------------------------------- InternalServerError: Unknown error at new InternalServerError (/var/lib/ghost/versions/3.6.0/node_modules/ghost-ignition/lib/errors/index.js:90:23) at Object.handleStoreError (/var/lib/ghost/versions/3.6.0/core/server/web/shared/middlewares/api/spam-prevention.js:27:25) at module.exports. (/var/lib/ghost/versions/3.6.0/node_modules/express-brute/index.js:84:19) at tryCatcher (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/util.js:16:23) at Promise.errorAdapter [as _rejectionHandler0] (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/nodeify.js:35:34) at Promise._settlePromise (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:601:21) at Promise._settlePromise0 (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:649:10) at Promise._settlePromises (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:725:18) at _drainQueueStep (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/async.js:93:12) at _drainQueue (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/async.js:86:9) at Async._drainQueues (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/async.js:102:5) at Immediate.Async.drainQueues [as _onImmediate] (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/async.js:15:14) at processImmediate (internal/timers.js:456:21) at process.topLevelDomainCallback (domain.js:137:15) Error: ER_UNKNOWN_ERROR: Percona-XtraDB-Cluster prohibits use of DML command on a table (ghost_dev.brute) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER at Query.Sequence._packetToError (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14) at Query.ErrorPacket (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/protocol/sequences/Query.js:77:18) at Protocol._parsePacket (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/protocol/Protocol.js:291:23) at Parser._parsePacket (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/protocol/Parser.js:433:10) at Parser.write (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/protocol/Parser.js:43:10) at Protocol.write (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/protocol/Protocol.js:38:16) at Socket. (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/Connection.js:91:28) at Socket. (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/Connection.js:525:10) at Socket.emit (events.js:321:20) at Socket.EventEmitter.emit (domain.js:482:12) at addChunk (_stream_readable.js:294:12) at readableAddChunk (_stream_readable.js:275:11) at Socket.Readable.push (_stream_readable.js:209:10) at TCP.onStreamRead (internal/stream_base_commons.js:186:23) -------------------- at Protocol._enqueue (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/protocol/Protocol.js:144:48) at Connection.query (/var/lib/ghost/versions/3.6.0/node_modules/mysql/lib/Connection.js:201:25) at /var/lib/ghost/versions/3.6.0/node_modules/knex/lib/dialects/mysql/index.js:130:18 at Promise._execute (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/debuggability.js:384:9) at Promise._resolveFromExecutor (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:518:18) at new Promise (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:103:10) at Client_MySQL._query (/var/lib/ghost/versions/3.6.0/node_modules/knex/lib/dialects/mysql/index.js:124:12) at Client_MySQL.query (/var/lib/ghost/versions/3.6.0/node_modules/knex/lib/client.js:158:17) at Runner.query (/var/lib/ghost/versions/3.6.0/node_modules/knex/lib/runner.js:135:36) at /var/lib/ghost/versions/3.6.0/node_modules/knex/lib/runner.js:39:23 at tryCatcher (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/util.js:16:23) at /var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/using.js:185:26 at tryCatcher (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/util.js:16:23) at Promise._settlePromiseFromHandler (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:547:31) at Promise._settlePromise (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:604:18) at Promise._settlePromise0 (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:649:10) at Promise._settlePromises (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:729:18) at Promise._fulfill (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:673:18) at PromiseArray._resolve (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise_array.js:127:19) at PromiseArray._promiseFulfilled (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise_array.js:145:14) at Promise._settlePromise (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:609:26) at Promise._settlePromise0 (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:649:10) at Promise._settlePromises (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/promise.js:729:18) at _drainQueueStep (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/async.js:93:12) at _drainQueue (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/async.js:86:9) at Async._drainQueues (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/async.js:102:5) at Immediate.Async.drainQueues (/var/lib/ghost/versions/3.6.0/node_modules/bluebird/js/release/async.js:15:14) at processImmediate (internal/timers.js:456:21) at process.topLevelDomainCallback (domain.js:137:15) [2020-02-18 09:19:44] INFO "GET /ghost/" 200 6ms [2020-02-18 09:19:44] ERROR "GET /ghost/api/v3/admin/users/me/?include=roles" 403 4ms Authorization failed "Unable to determine the authenticated user or integration. Check that cookies are being passed through if using session authentication." Error ID: cd4d57c0-522f-11ea-b642-99045c538f54 ---------------------------------------- NoPermissionError: Authorization failed at new NoPermissionError (/var/lib/ghost/versions/3.6.0/node_modules/ghost-ignition/lib/errors/index.js:127:23) at authorizeAdminApi (/var/lib/ghost/versions/3.6.0/core/server/services/auth/authorize.js:27:25) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/route.js:137:13) at authenticate (/var/lib/ghost/versions/3.6.0/core/server/services/auth/session/middleware.js:103:16) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/route.js:137:13) at authenticate (/var/lib/ghost/versions/3.6.0/core/server/services/auth/api-key/admin.js:40:16) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/route.js:137:13) at Route.dispatch (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/route.js:112:3) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at /var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:281:22 at param (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:354:14) at param (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:365:14) at Function.process_params (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:410:3) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:275:10) at /var/lib/ghost/versions/3.6.0/node_modules/cors/lib/index.js:228:13 at handleCORS (/var/lib/ghost/versions/3.6.0/core/server/web/shared/middlewares/api/cors.js:71:16) at corsMiddleware (/var/lib/ghost/versions/3.6.0/node_modules/cors/lib/index.js:204:7) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at trim_prefix (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:317:13) at /var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:284:7 at Function.process_params (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:335:12) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:275:10) at Function.handle (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:174:3) at router (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:47:12) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at trim_prefix (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:317:13) at /var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:284:7 at Function.process_params (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:335:12) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:275:10) at cacheControlHeaders (/var/lib/ghost/versions/3.6.0/core/server/web/shared/middlewares/cache-control.js:32:9) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at trim_prefix (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:317:13) at /var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:284:7 at Function.process_params (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:335:12) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/index.js:275:10) at checkVersionMatch (/var/lib/ghost/versions/3.6.0/core/server/web/shared/middlewares/api/version-match.js:23:5) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) [2020-02-18 09:19:45] INFO "GET /ghost/api/v3/admin/site/" 200 3ms [2020-02-18 09:19:45] INFO "GET /ghost/api/v3/admin/authentication/setup/" 200 9ms ``` After another glance :roll_eyes: it seems its fundamentally a ghost core problem with itself (setup cant be completed :bug: ) because of: ``` [2020-02-18 09:52:45] ERROR "GET /ghost/api/v3/admin/users/me/?include=roles" 403 4ms Authorization failed "Unable to determine the authenticated user or integration. Check that cookies are being passed through if using session authentication." Error ID: 69878e90-5234-11ea-b065-df62918f8bf3 ---------------------------------------- NoPermissionError: Authorization failed at new NoPermissionError (/var/lib/ghost/versions/3.6.0/node_modules/ghost-ignition/lib/errors/index.js:127:23) at authorizeAdminApi (/var/lib/ghost/versions/3.6.0/core/server/services/auth/authorize.js:27:25) at Layer.handle [as handle_request] (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/layer.js:95:5) at next (/var/lib/ghost/versions/3.6.0/node_modules/express/lib/router/route.js:137:13) at authenticate (/var/lib/ghost/versions/3.6.0/core/server/services/auth/session/middleware.js:103:16) ```

:information_source: And its not even a new problem, others with proxy setups (in this case docker) suffered the same fate before.. http://forum.ghost.org/t/cant-create-new-site-cryptic-error-meessage/9396/11

the error above is thrown because it tries to query the roles however the setup hasnt completed yet..