Unable to access Admin UI - "Unknown Error"

Hi there!

I am running a self-hosted Ghost setup with Gatsby on the frontend. I used this link to get to my current set up: heroku
(Heroku/Cloudinary/JawsDB)

My issue is that I can’t log in. And when I check the Network tab, I see that I am not getting a set-cookie header in the response:

The sign in spinner is running but nothing is happening, except for the “Unknown Error” tag showing up in red.

Notable in Network tab:
ghost/api/v3/admin/users/me/?include=roles
(403 forbidden) - to be expected? Read that somewhere.

ghost/api/v3/admin/session
(500 internal server error) - request payload contains correct username/pw

Site: http://managecobuy.herokuapp.com/
Error happened day one after creating the ghost backend using the link above. 10 Posts were added and two users.

Any help would be greatly appreciated. Also, what other information/insight can I provide to make it easier to pinpoint the issue?

Thank you!

  • Mikkel

Here is what the Server Logs when I enter username/pw and click “sign in”:

2020-06-30T09:25:52.619337+00:00 app[web.1]: e[39m
    2020-06-30T09:25:52.619692+00:00 heroku[router]: at=info method=GET path="/ghost/api/v3/admin/users/me/?include=roles" host=managecobuy.herokuapp.com request_id=b3ec811e-830b-4941-b4e8-4351e6a1564c fwd="92.220.91.82" dyno=web.1 connect=1ms service=30ms status=403 bytes=713 protocol=https
    2020-06-30T09:25:52.695959+00:00 heroku[router]: at=info method=GET path="/ghost/assets/img/favicon.ico" host=managecobuy.herokuapp.com request_id=8520e312-344a-42f4-888d-ed492f17b582 fwd="92.220.91.82" dyno=web.1 connect=0ms service=3ms status=200 bytes=1362 protocol=https
    2020-06-30T09:25:52.697352+00:00 app[web.1]: [2020-06-30 09:25:52] e[36mINFOe[39m "GET /ghost/assets/img/favicon.ico" e[32m200e[39m 3ms
    2020-06-30T09:25:52.754441+00:00 heroku[router]: at=info method=GET path="/ghost/api/v3/admin/site/" host=managecobuy.herokuapp.com request_id=0fceffb8-6398-4cf1-9f9b-ab97d16f5df3 fwd="92.220.91.82" dyno=web.1 connect=1ms service=5ms status=200 bytes=473 protocol=https
    2020-06-30T09:25:52.754568+00:00 app[web.1]: [2020-06-30 09:25:52] e[36mINFOe[39m "GET /ghost/api/v3/admin/site/" e[32m200e[39m 3ms
    2020-06-30T09:25:52.899224+00:00 app[web.1]: [2020-06-30 09:25:52] e[36mINFOe[39m "GET /ghost/api/v3/admin/authentication/setup/" e[32m200e[39m 24ms
    2020-06-30T09:25:52.899814+00:00 heroku[router]: at=info method=GET path="/ghost/api/v3/admin/authentication/setup/" host=managecobuy.herokuapp.com request_id=61c7bcea-b118-4be1-b261-f69cdd4a30b3 fwd="92.220.91.82" dyno=web.1 connect=1ms service=25ms status=200 bytes=410 protocol=https
    2020-06-30T09:27:27.026335+00:00 heroku[router]: at=info method=POST path="/ghost/api/v3/admin/session" host=managecobuy.herokuapp.com request_id=60d012d2-d598-4c8b-a894-39233032759c fwd="92.220.91.82" dyno=web.1 connect=1ms service=79ms status=500 bytes=683 protocol=https
    2020-06-30T09:27:27.028521+00:00 app[web.1]: [2020-06-30 09:27:27] e[31mERRORe[39m "POST /ghost/api/v3/admin/session" e[31m500e[39m 77ms
    2020-06-30T09:27:27.028539+00:00 app[web.1]: e[31m
    2020-06-30T09:27:27.028540+00:00 app[web.1]: e[31mUnknown errore[39m
    2020-06-30T09:27:27.028540+00:00 app[web.1]: 
    2020-06-30T09:27:27.028541+00:00 app[web.1]: e[1me[37mError ID:e[39me[22m
    2020-06-30T09:27:27.028542+00:00 app[web.1]:     e[90me9a81300-bab3-11ea-b608-0b11661d7f66e[39m
    2020-06-30T09:27:27.028542+00:00 app[web.1]: 
    2020-06-30T09:27:27.028543+00:00 app[web.1]: e[1me[37mError Code: e[39me[22m
    2020-06-30T09:27:27.028543+00:00 app[web.1]:     e[90mER_TABLEACCESS_DENIED_ERRORe[39m
    2020-06-30T09:27:27.028544+00:00 app[web.1]: 
    2020-06-30T09:27:27.028544+00:00 app[web.1]: e[90m----------------------------------------e[39m
    2020-06-30T09:27:27.028544+00:00 app[web.1]: 
    2020-06-30T09:27:27.028545+00:00 app[web.1]: e[90mInternalServerError: Unknown error
    2020-06-30T09:27:27.028545+00:00 app[web.1]:     at new InternalServerError (/app/node_modules/ghost-ignition/lib/errors/index.js:77:23)
    2020-06-30T09:27:27.028546+00:00 app[web.1]:     at Object.handleStoreError (/app/node_modules/ghost/core/server/web/shared/middlewares/api/spam-prevention.js:27:25)
    2020-06-30T09:27:27.028546+00:00 app[web.1]:     at module.exports.<anonymous> (/app/node_modules/express-brute/index.js:133:21)
    2020-06-30T09:27:27.028547+00:00 app[web.1]:     at tryCatcher (/app/node_modules/bluebird/js/release/util.js:16:23)
    2020-06-30T09:27:27.028548+00:00 app[web.1]:     at Promise.errorAdapter (/app/node_modules/bluebird/js/release/nodeify.js:35:34)
    2020-06-30T09:27:27.028548+00:00 app[web.1]:     at Promise._settlePromise (/app/node_modules/bluebird/js/release/promise.js:601:21)
    2020-06-30T09:27:27.028549+00:00 app[web.1]:     at Promise._settlePromise0 (/app/node_modules/bluebird/js/release/promise.js:649:10)
    2020-06-30T09:27:27.028549+00:00 app[web.1]:     at Promise._settlePromises (/app/node_modules/bluebird/js/release/promise.js:725:18)
    2020-06-30T09:27:27.028549+00:00 app[web.1]:     at _drainQueueStep (/app/node_modules/bluebird/js/release/async.js:93:12)
    2020-06-30T09:27:27.028550+00:00 app[web.1]:     at _drainQueue (/app/node_modules/bluebird/js/release/async.js:86:9)
    2020-06-30T09:27:27.028550+00:00 app[web.1]:     at Async._drainQueues (/app/node_modules/bluebird/js/release/async.js:102:5)
    2020-06-30T09:27:27.028551+00:00 app[web.1]:     at Immediate.Async.drainQueues [as _onImmediate] (/app/node_modules/bluebird/js/release/async.js:15:14)
    2020-06-30T09:27:27.028551+00:00 app[web.1]:     at runCallback (timers.js:705:18)
    2020-06-30T09:27:27.028552+00:00 app[web.1]:     at tryOnImmediate (timers.js:676:5)
    2020-06-30T09:27:27.028552+00:00 app[web.1]:     at processImmediate (timers.js:658:5)
    2020-06-30T09:27:27.028553+00:00 app[web.1]:     at process.topLevelDomainCallback (domain.js:126:23)
    2020-06-30T09:27:27.028553+00:00 app[web.1]: 
    2020-06-30T09:27:27.028554+00:00 app[web.1]: Error: ER_TABLEACCESS_DENIED_ERROR: INSERT command denied to user 'h7c5ufh52o6n51ll'@'ec2-3-85-219-125.compute-1.amazonaws.com' for table 'brute'
    2020-06-30T09:27:27.028555+00:00 app[web.1]:     at Query.Sequence._packetToError (/app/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
    2020-06-30T09:27:27.028555+00:00 app[web.1]:     at Query.ErrorPacket (/app/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)
    2020-06-30T09:27:27.028555+00:00 app[web.1]:     at Protocol._parsePacket (/app/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    2020-06-30T09:27:27.028556+00:00 app[web.1]:     at Parser._parsePacket (/app/node_modules/mysql/lib/protocol/Parser.js:433:10)
    2020-06-30T09:27:27.028556+00:00 app[web.1]:     at Parser.write (/app/node_modules/mysql/lib/protocol/Parser.js:43:10)
    2020-06-30T09:27:27.028557+00:00 app[web.1]:     at Protocol.write (/app/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    2020-06-30T09:27:27.028557+00:00 app[web.1]:     at Socket.<anonymous> (/app/node_modules/mysql/lib/Connection.js:91:28)
    2020-06-30T09:27:27.028557+00:00 app[web.1]:     at Socket.<anonymous> (/app/node_modules/mysql/lib/Connection.js:525:10)
    2020-06-30T09:27:27.028558+00:00 app[web.1]:     at Socket.emit (events.js:198:13)
    2020-06-30T09:27:27.028558+00:00 app[web.1]:     at Socket.EventEmitter.emit (domain.js:448:20)
    2020-06-30T09:27:27.028559+00:00 app[web.1]:     at addChunk (_stream_readable.js:288:12)
    2020-06-30T09:27:27.028559+00:00 app[web.1]:     at readableAddChunk (_stream_readable.js:269:11)
    2020-06-30T09:27:27.028560+00:00 app[web.1]:     at Socket.Readable.push (_stream_readable.js:224:10)
    2020-06-30T09:27:27.028560+00:00 app[web.1]:     at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)
    2020-06-30T09:27:27.028560+00:00 app[web.1]:     --------------------
    2020-06-30T09:27:27.028561+00:00 app[web.1]:     at Protocol._enqueue (/app/node_modules/mysql/lib/protocol/Protocol.js:144:48)
    2020-06-30T09:27:27.028561+00:00 app[web.1]:     at Connection.query (/app/node_modules/mysql/lib/Connection.js:201:25)
    2020-06-30T09:27:27.028561+00:00 app[web.1]:     at /app/node_modules/knex/lib/dialects/mysql/index.js:130:18
    2020-06-30T09:27:27.028562+00:00 app[web.1]:     at Promise._execute (/app/node_modules/bluebird/js/release/debuggability.js:384:9)
    2020-06-30T09:27:27.028562+00:00 app[web.1]:     at Promise._resolveFromExecutor (/app/node_modules/bluebird/js/release/promise.js:518:18)
    2020-06-30T09:27:27.028563+00:00 app[web.1]:     at new Promise (/app/node_modules/bluebird/js/release/promise.js:103:10)
    2020-06-30T09:27:27.028563+00:00 app[web.1]:     at Client_MySQL._query (/app/node_modules/knex/lib/dialects/mysql/index.js:124:12)
    2020-06-30T09:27:27.028563+00:00 app[web.1]:     at Client_MySQL.query (/app/node_modules/knex/lib/client.js:158:17)
    2020-06-30T09:27:27.028564+00:00 app[web.1]:     at /app/node_modules/knex/lib/transaction.js:331:24
    2020-06-30T09:27:27.028564+00:00 app[web.1]:     at Promise._execute (/app/node_modules/bluebird/js/release/debuggability.js:384:9)
    2020-06-30T09:27:27.028564+00:00 app[web.1]:     at Promise._resolveFromExecutor (/app/node_modules/bluebird/js/release/promise.js:518:18)
    2020-06-30T09:27:27.028565+00:00 app[web.1]:     at new Promise (/app/node_modules/bluebird/js/release/promise.js:103:10)
    2020-06-30T09:27:27.028565+00:00 app[web.1]:     at Client_MySQL.trxClient.query (/app/node_modules/knex/lib/transaction.js:326:12)
    2020-06-30T09:27:27.028566+00:00 app[web.1]:     at Runner.query (/app/node_modules/knex/lib/runner.js:135:36)
    2020-06-30T09:27:27.028566+00:00 app[web.1]:     at /app/node_modules/knex/lib/runner.js:39:23
    2020-06-30T09:27:27.028566+00:00 app[web.1]:     at tryCatcher (/app/node_modules/bluebird/js/release/util.js:16:23)
    2020-06-30T09:27:27.028567+00:00 app[web.1]:     at /app/node_modules/bluebird/js/release/using.js:185:26
    2020-06-30T09:27:27.028575+00:00 app[web.1]:     at tryCatcher (/app/node_modules/bluebird/js/release/util.js:16:23)
    2020-06-30T09:27:27.028575+00:00 app[web.1]:     at Promise._settlePromiseFromHandler (/app/node_modules/bluebird/js/release/promise.js:547:31)
    2020-06-30T09:27:27.028576+00:00 app[web.1]:     at Promise._settlePromise (/app/node_modules/bluebird/js/release/promise.js:604:18)
    2020-06-30T09:27:27.028576+00:00 app[web.1]:     at Promise._settlePromise0 (/app/node_modules/bluebird/js/release/promise.js:649:10)
    2020-06-30T09:27:27.028577+00:00 app[web.1]:     at Promise._settlePromises (/app/node_modules/bluebird/js/release/promise.js:729:18)e[39m
    2020-06-30T09:27:27.028577+00:00 app[web.1]: e[39m

This is the pertinent line in the log you’ve posted:

Error: ER_TABLEACCESS_DENIED_ERROR: INSERT command denied to user 'h7c5ufh52o6n51ll'@'ec2-3-85-219-125.compute-1.amazonaws.com' for table 'brute'

You’ll need to look into your database permissions.

2 Likes

Hi Kevin,

Thanks for your help. You are right. After digging more into it, and connecting to the db with HeidiSQL I see that the DB is currently 5.5mb. The free JawsDB tier is limited to 5mb and will revoke INSERT permissions when this limit is reached. How wonderful.

Thanks again