Failed to log in, please try again

cassyblaise · January 28, 2024, 10:38am

Hey everyone, Please can anyone help me out, I do not why I am still getting this errors, my users can login and new users can not subscribe to my blog
I have check mailgun setting and everything is fine I can send bulk emails but the major issue is users can sign in or subscribe, I do not know what I am not doing right.

this is my production error logs

{"name":"Log","hostname":"merklepal","pid":160540,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"EPIPE","message":"select `jobs`.* from `jobs` where `jobs`.`name` = 'mentions-ema>
{"name":"Log","hostname":"merklepal","pid":160540,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ECONNREFUSED","message":"connect ECONNREFUSED 127.0.0.1:3306","stack":"Error: con>
{"name":"Log","hostname":"merklepal","pid":160540,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ECONNREFUSED","message":"connect ECONNREFUSED 127.0.0.1:3306","stack":"Error: con>
{"name":"Log","hostname":"merklepal","pid":160540,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ETIMEDOUT","message":"connect ETIMEDOUT","stack":"Error: connect ETIMEDOUT\n    a>
{"name":"Log","hostname":"merklepal","pid":160540,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"04370abb-86a2-4036-a535-34e013b1171b","userId":null},"url":"/send-magic-link/","method":"POST","origi>
{"name":"Log","hostname":"merklepal","pid":169104,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"8a187d4f-1cdb-4a07-a1ce-a799c6454e4c","userId":null},"url":"/send-magic-link/","method":"POST","origi>
{"name":"Log","hostname":"merklepal","pid":170183,"level":50,"version":"5.63.0","err":{"id":"9af1eb60-bdb5-11ee-8372-b7c90f0c4a4a","domain":"https://merklepal.com","code":null,"name":"BadRequestError","statusC>

Cathy_Sarisky · January 28, 2024, 12:52pm

It’s hard to help without being able to see the full error messages. You might try pasting them again (thank you for putting them in a code block!) but make sure those long lines don’t truncate.

Often these problems are related to the Ghost server not being set up to send transactional email. So… how’d you set up transactional email? Please paste the relevant part of config.production.json (or the development equivalent), obfuscating any passwords or API keys.

cassyblaise · January 28, 2024, 1:28pm

Hey @Cathy_Sarisky

this is how my config.production.json file look like

"mail": {
    "from": "noreply@merklepal.com",
    "transport": "SMTP",
    "options": {
      "host": "smtp.us.mailgun.org",
      "port": 587,
      "service": "Mailgun",
      "secure": false,
      "requireTLS": true,
      "auth": {
        "user": "news@mg.merklepal.com",
        "pass": "xxxxxxxxxxx"
      }
    }
  },

Cathy_Sarisky · January 28, 2024, 1:40pm

Anything informative in the mailgun logs?

cassyblaise · January 28, 2024, 1:47pm

this is my mailgun log:

{
	"id": "lF3x07BjRE6CUviSnh9tPg",
	"timestamp": 1706432099.5163822,
	"flags": {
		"is-system-test": false,
		"is-authenticated": true,
		"is-test-mode": false,
		"is-routed": false
	},
	"reason": "generic",
	"campaigns": [],
	"message": {
		"size": 227,
		"attachments": [],
		"headers": {
			"to": "foo@bar.com",
			"message-id": "20240128085428.170494@merklepal",
			"subject": "Hello",
			"from": "ghost-mgr@merklepal"
		}
	},
	"user-variables": {},
	"log-level": "error",
	"delivery-status": {
		"mx-host": "bar.com",
		"code": 612,
		"session-seconds": 30.081,
		"description": "",
		"enhanced-code": "",
		"message": "unable to connect to MX servers:\n - bar.com: connection failed: while dialing: dial tcp4 10.2.100.79:0->104.21.1.6:25: i/o timeout",
		"attempt-no": 1
	},
	"tags": [],
	"envelope": {
		"targets": "foo@bar.com",
		"transport": "smtp",
		"sender": "ghost-mgr@merklepal",
		"sending-ip": "69.72.42.9"
	},
	"storage": {
		"key": "BAABAAVrSLSm0Xe8BdZIsbhCh2OmOSajZQ",
		"env": "production",
		"region": "us-east4",
		"url": "https://storage-us-east4.api.mailgun.net/v3/domains/mg.merklepal.com/messages/BAABAAVrSLSm0Xe8BdZIsbhCh2OmOSajZQ"
	},
	"recipient": "foo@bar.com",
	"recipient-domain": "bar.com",
	"event": "failed",
	"severity": "permanent"
}

cassyblaise · January 28, 2024, 1:54pm

but when I change the foo@bar.com to my personal email address I got this:

{
	"recipient": "codecassy@gmail.com",
	"recipient-domain": "gmail.com",
	"event": "accepted",
	"originating-ip": "128.199.9.194",
	"log-level": "info",
	"user-variables": {},
	"id": "rWBsd0fMQ02emQRRAhMxZA",
	"flags": {
		"is-test-mode": false,
		"is-authenticated": true
	},
	"timestamp": 1706432907.6039977,
	"api-key-id": "postmaster@mg.merklepal.com",
	"tags": null,
	"envelope": {
		"transport": "smtp",
		"sender": "ghost-mgr@merklepal",
		"targets": "codecassy@gmail.com"
	},
	"method": "SMTP",
	"message": {
		"size": 235,
		"headers": {
			"message-id": "20240128090827.170657@merklepal",
			"from": "ghost-mgr@merklepal",
			"subject": "Hello",
			"to": "codecassy@gmail.com"
		}
	},
	"storage": {
		"region": "us-west1",
		"env": "production",
		"key": "BAABAQUv5Bw2Aijqez9OWaU-1GIqdZjBYg",
		"url": "https://storage-us-west1.api.mailgun.net/v3/domains/mg.merklepal.com/messages/BAABAQUv5Bw2Aijqez9OWaU-1GIqdZjBYg"
	}
}

Basically if I sending out emaill the emails get delivered but if I want to subscribe or login that is when I get this error “Failed to send magic link email”.

cassyblaise · January 28, 2024, 2:35pm

When I check the chrome dev tool this is what I get:

{"errors":[{"message":"Resource not found","context":null,"type":"NotFoundError","details":null,"property":null,"help":null,"code":null,"id":"3d7cf3a0-bdea-11ee-accc-2f62f1f65f64","ghostErrorCode":null}]}

btw I don’t think if the error is coming from the mailgun api

jannis · January 28, 2024, 2:41pm

How have you set up your Ghost installation?

Error 504 (the one you see in the Chrome dev tools) is a gateway error, indicating that the server isn’t responding.

In the initial (partial – as Cathy pointed out) errors you shared, there is a ECONNREFUSED error on 127.0.0.1:3306, indicating that there is an issue connecting to your MySQL server. Additionally, you also have a timeout error in there.

Other stuff that’s interesting: in your Mailgun logs the from address is ghost-mgr@merklepal – but I assume it should be @merklepal.com?

So, lots of different things that come together, in my eyes.

Would really help to see the full server logs (the first ones you shared) to understand what’s going on there.

cassyblaise · January 29, 2024, 1:07am

Hey @jannis Thanks for reaching out.

I have been able to fixed the 3306 error, it mysql server issue, the blog is up at the moment.

I guess the blow codes is the server logs that you want to see

{"name":"Log","hostname":"merklepal","pid":169104,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"8a187d4f-1cdb-4a07-a1ce-a799c6454e4c","userId":null},"url":"/send-magic-link/","method":"POST","origi>
{"name":"Log","hostname":"merklepal","pid":170183,"level":50,"version":"5.63.0","err":{"id":"9af1eb60-bdb5-11ee-8372-b7c90f0c4a4a","domain":"https://merklepal.com","code":null,"name":"BadRequestError","statusC>
{"name":"Log","hostname":"merklepal","pid":170183,"level":50,"version":"5.63.0","err":{"id":"60ca8250-bdc7-11ee-8372-b7c90f0c4a4a","domain":"https://merklepal.com","code":null,"name":"BadRequestError","statusC>
{"name":"Log","hostname":"merklepal","pid":170183,"level":50,"version":"5.63.0","err":{"id":"a7818520-bdce-11ee-8372-b7c90f0c4a4a","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":170183,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"ab50d4a8-527a-49dc-867f-117658813f0b","userId":null},"url":"/session/","method":"POST","originalUrl":>
{"name":"Log","hostname":"merklepal","pid":170183,"level":50,"version":"5.63.0","err":{"id":"14f710c0-bdcf-11ee-8372-b7c90f0c4a4a","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":170183,"level":50,"version":"5.63.0","err":{"id":"190bd5b0-bdcf-11ee-8372-b7c90f0c4a4a","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":170183,"level":50,"version":"5.63.0","err":{"id":"1978c850-bdcf-11ee-8372-b7c90f0c4a4a","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":170183,"level":50,"version":"5.63.0","err":{"id":"19f04240-bdcf-11ee-8372-b7c90f0c4a4a","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":170183,"level":50,"version":"5.63.0","err":{"id":"586184d0-bdcf-11ee-8372-b7c90f0c4a4a","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":1200,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"9eaf7c93-1966-4f08-953a-56bc04bad4ad","userId":null},"url":"/session/","method":"POST","originalUrl":"/>

and this is another error.log:

{"name":"Log","hostname":"merklepal","pid":71807,"level":50,"version":"5.63.0","err":{"id":"c2754060-b9b4-11ee-9c9b-13cb68aa17cc","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWarn>
{"name":"Log","hostname":"merklepal","pid":71807,"level":50,"version":"5.63.0","err":{"id":"c2b70450-b9b4-11ee-9c9b-13cb68aa17cc","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWarn>
{"name":"Log","hostname":"merklepal","pid":71807,"level":50,"version":"5.63.0","err":{"id":"c2f0b1f0-b9b4-11ee-9c9b-13cb68aa17cc","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWarn>
{"name":"Log","hostname":"merklepal","pid":71807,"level":50,"version":"5.63.0","err":{"id":"5812f2c0-b9b5-11ee-9c9b-13cb68aa17cc","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWarn>
{"name":"Log","hostname":"merklepal","pid":71807,"level":50,"version":"5.63.0","err":{"id":"5a63c090-b9b5-11ee-9c9b-13cb68aa17cc","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWarn>
{"name":"Log","hostname":"merklepal","pid":71807,"level":50,"version":"5.63.0","err":{"id":"5b9bf270-b9b5-11ee-9c9b-13cb68aa17cc","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWarn>
{"name":"Log","hostname":"merklepal","pid":71807,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"PROTOCOL_CONNECTION_LOST","message":"select `jobs`.* from `jobs` where `jobs`.`nam>
{"name":"Log","hostname":"merklepal","pid":71807,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"388591d0-0891-4cc2-adcd-c91ec2f61d94","userId":null},"url":"/posts/65af5a45b141e2188088b637/?formats=m>
{"name":"Log","hostname":"merklepal","pid":71807,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"37968313-0d36-4ef8-95e5-edfa75170a75","userId":null},"url":"/posts/65af5a45b141e2188088b637/?formats=m>
{"name":"Log","hostname":"merklepal","pid":71807,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ECONNREFUSED","message":"connect ECONNREFUSED 127.0.0.1:3306","stack":"Error: conn>
{"name":"Log","hostname":"merklepal","pid":71807,"level":50,"version":"5.63.0","err":{"id":"1e164b90-b9b9-11ee-9c9b-13cb68aa17cc","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWarn>
{"name":"Log","hostname":"merklepal","pid":71807,"level":50,"version":"5.63.0","err":{"id":"20f68820-b9b9-11ee-9c9b-13cb68aa17cc","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWarn>
{"name":"Log","hostname":"merklepal","pid":71807,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ETIMEDOUT","message":"connect ETIMEDOUT","stack":"Error: connect ETIMEDOUT\n    at>
{"name":"Log","hostname":"merklepal","pid":71807,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"78201b84-b7cd-43e6-a05f-ec2f592ae791","userId":"1"},"url":"/posts/65af5a45b141e2188088b637/?formats=mo>
{"name":"Log","hostname":"merklepal","pid":71807,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"8f9b5320-5d07-428d-b83d-e491cdd8404e","userId":null},"url":"/posts/65af5a45b141e2188088b637/?formats=m>
{"name":"Log","hostname":"merklepal","pid":71807,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ECONNREFUSED","message":"connect ECONNREFUSED 127.0.0.1:3306","stack":"Error: conn>
{"name":"Log","hostname":"merklepal","pid":80411,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"f9cdace3-aead-4eee-aeea-78352f93eb59","userId":"1"},"url":"/posts/65af5a45b141e2188088b637/?formats=mo>
{"name":"Log","hostname":"merklepal","pid":80411,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"15e36e21-c957-429f-bcc7-3c75e74af180","userId":"1"},"url":"/posts/65af5a45b141e2188088b637/?formats=mo>
{"name":"Log","hostname":"merklepal","pid":80411,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"a381874e-346c-4b14-b671-d168d39182e7","userId":"1"},"url":"/posts/65af5a45b141e2188088b637/?formats=mo>
{"name":"Log","hostname":"merklepal","pid":80411,"level":50,"version":"5.63.0","err":{"id":"3713abf0-b9fb-11ee-87d9-63e4123d1236","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWarn>
{"name":"Log","hostname":"merklepal","pid":80411,"level":50,"version":"5.63.0","err":{"id":"3752fee0-b9fb-11ee-87d9-63e4123d1236","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWarn>
{"name":"Log","hostname":"merklepal","pid":80411,"level":50,"version":"5.63.0","err":{"id":"378c5e60-b9fb-11ee-87d9-63e4123d1236","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWarn>
{"name":"Log","hostname":"merklepal","pid":80411,"level":50,"version":"5.63.0","err":{"id":"37911950-b9fb-11ee-87d9-63e4123d1236","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWarn>
{"name":"Log","hostname":"merklepal","pid":80411,"level":50,"version":"5.63.0","err":{"id":"37916770-b9fb-11ee-87d9-63e4123d1236","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWarn>
{"name":"Log","hostname":"merklepal","pid":80411,"level":50,"version":"5.63.0","err":{"id":"38fa6d50-b9fb-11ee-87d9-63e4123d1236","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWarn>
{"name":"Log","hostname":"merklepal","pid":80411,"level":50,"version":"5.63.0","err":{"id":"0dbd6ad0-ba0e-11ee-87d9-63e4123d1236","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWarn>
{"name":"Log","hostname":"merklepal","pid":80411,"level":50,"version":"5.63.0","err":{"id":"715972a0-ba0e-11ee-87d9-63e4123d1236","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWarn>
{"name":"Log","hostname":"merklepal","pid":80411,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"aef7f999-088b-41a8-86e8-c8ad5b1e0039","userId":null},"url":"/settings/?group=site%2Ctheme%2Cprivate%2C>
{"name":"Log","hostname":"merklepal","pid":80411,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"a5275d26-41be-4f52-a5a0-34d9ab49498b","userId":null},"url":"/posts/?formats=mobiledoc%2Clexical&limit=>
{"name":"Log","hostname":"merklepal","pid":80411,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"ab42cdf8-0f9b-4816-93dc-532f45f37ad2","userId":null},"url":"/stats/member_count/","method":"GET","orig>
{"name":"Log","hostname":"merklepal","pid":80411,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"fbb0b4ad-11e9-4a05-b6f8-c944f64ac44f","userId":null},"url":"/posts/?formats=mobiledoc%2Clexical&limit=>
{"name":"Log","hostname":"merklepal","pid":80411,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"e45ea368-a7a4-4291-9f6e-404b0102af37","userId":null},"url":"/stats/member_count/","method":"GET","orig>

Cathy_Sarisky · January 29, 2024, 2:29am

Looks like the MySQL issue is still there?

And if you want help with the problem, please figure out how to paste logs in without cutting them off. :)

cassyblaise · January 29, 2024, 3:57am

This is my Mysql file

 "database": {
    "client": "mysql",
    "connection": {
      "host": "127.0.0.1",
      "user": "ghost-23",
      "password": "xxxxxxx",
      "port": 3306,
      "database": "ghost_production"
    }
  },

{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","err":{"id":"48071650-bb17-11ee-99bf-2560c03e73e2","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"PROTOCOL_CONNECTION_LOST","message":"select `jobs`.* from `jobs` where `jobs`.`na>
{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ECONNREFUSED","message":"connect ECONNREFUSED 127.0.0.1:3306","stack":"Error: con>
{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ECONNREFUSED","message":"connect ECONNREFUSED 127.0.0.1:3306","stack":"Error: con>
{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"PROTOCOL_CONNECTION_LOST","message":"select `jobs`.* from `jobs` where `jobs`.`na>
{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ECONNREFUSED","message":"connect ECONNREFUSED 127.0.0.1:3306","stack":"Error: con>
{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ECONNREFUSED","message":"connect ECONNREFUSED 127.0.0.1:3306","stack":"Error: con>
{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","err":{"id":"e6156680-bb3f-11ee-99bf-2560c03e73e2","domain":"https://merklepal.com","code":null,"name":"BadRequestError","statusC>
{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"940b448e-57bc-420a-92d2-12efd8638aa7","userId":null},"url":"/users/me/?include=roles","method":"GET",>
{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"e4ae4b32-d013-40f7-947b-17ecd6880fa7","userId":null},"url":"/users/me/?include=roles","method":"GET",>
{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"248a9bb6-77e0-4bb1-8aa6-ea8d453138d4","userId":null},"url":"/users/me/?include=roles","method":"GET",>
{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"8bf2b376-865e-4efe-9584-27b9896182ba","userId":null},"url":"/authentication/setup/","method":"GET","o>
{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","message":"ECONNABORTED","stack":""},"msg":"ECONNABORTED","time":"2024-01-25T06:23:41.348>
{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","msg":"[EmailAnalytics] Error while fetching","time":"2024-01-25T06:23:43.195Z","v":0}
{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","message":"ECONNABORTED","stack":""},"msg":"ECONNABORTED","time":"2024-01-25T06:23:44.769>
{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","message":"ECONNABORTED","stack":""},"msg":"Error while fetching email analytics ECONNABO>
{"name":"Log","hostname":"merklepal","pid":102188,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","message":"ECONNABORTED","stack":""},"msg":"ECONNABORTED","time":"2024-01-25T06:23:50.324>
{"name":"Log","hostname":"merklepal","pid":114912,"level":50,"version":"5.63.0","err":{"id":"cc776010-bb4f-11ee-a893-573d24a0b085","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":114912,"level":50,"version":"5.63.0","err":{"id":"cc78e6b0-bb4f-11ee-a893-573d24a0b085","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":114912,"level":50,"version":"5.63.0","err":{"id":"cc79aa00-bb4f-11ee-a893-573d24a0b085","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":114912,"level":50,"version":"5.63.0","err":{"id":"e9569480-bb4f-11ee-a893-573d24a0b085","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":114912,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ETIMEDOUT","message":"connect ETIMEDOUT","stack":"Error: connect ETIMEDOUT\n    a>
{"name":"Log","hostname":"merklepal","pid":114912,"level":50,"version":"5.63.0","req":{"meta":{"requestId":"509dcd61-013c-4918-bcc7-8191bb152d1b","userId":null},"url":"/newsletters/?key=1187f3f7aed98d24b534911>
{"name":"Log","hostname":"merklepal","pid":114912,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ECONNREFUSED","message":"connect ECONNREFUSED 127.0.0.1:3306","stack":"Error: con>
{"name":"Log","hostname":"merklepal","pid":114912,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ECONNREFUSED","message":"connect ECONNREFUSED 127.0.0.1:3306","stack":"Error: con>
{"name":"Log","hostname":"merklepal","pid":114912,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ECONNREFUSED","message":"connect ECONNREFUSED 127.0.0.1:3306","stack":"Error: con>
{"name":"Log","hostname":"merklepal","pid":114912,"level":50,"version":"5.63.0","msg":"[EmailAnalytics] Error while fetching","time":"2024-01-25T07:36:53.654Z","v":0}
{"name":"Log","hostname":"merklepal","pid":114912,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ECONNREFUSED","message":"connect ECONNREFUSED 127.0.0.1:3306","stack":"Error: con>
{"name":"Log","hostname":"merklepal","pid":114912,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ECONNREFUSED","message":"connect ECONNREFUSED 127.0.0.1:3306","stack":"Error: con>
{"name":"Log","hostname":"merklepal","pid":114912,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ECONNREFUSED","message":"connect ECONNREFUSED 127.0.0.1:3306","stack":"Error: con>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"a6ab8260-bb5b-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"a7c15f30-bb5b-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"d20512f0-bb5b-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"d39a31e0-bb5b-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"d4ae8810-bb5b-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"e725db60-bb5b-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"e729fa10-bb5b-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"e76f6780-bb5b-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"e7d57c50-bb5b-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"f5eef3c0-bb5b-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"0ecc9d20-bb5c-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"0f8342f0-bb5c-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"0ffbf560-bb5c-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"10904620-bb5c-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ETIMEDOUT","message":"connect ETIMEDOUT","stack":"Error: connect ETIMEDOUT\n    a>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","msg":"[EmailAnalytics] Error while fetching","time":"2024-01-25T08:34:52.640Z","v":0}
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ETIMEDOUT","message":"connect ETIMEDOUT","stack":"Error: connect ETIMEDOUT\n    a>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ETIMEDOUT","message":"connect ETIMEDOUT","stack":"Error: connect ETIMEDOUT\n    a>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ETIMEDOUT","message":"connect ETIMEDOUT","stack":"Error: connect ETIMEDOUT\n    a>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"domain":"https://merklepal.com","code":"ETIMEDOUT","message":"connect ETIMEDOUT","stack":"Error: connect ETIMEDOUT\n    a>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"be701dd0-bb5f-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"c3898180-bb5f-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"6ca262a0-bb60-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>
{"name":"Log","hostname":"merklepal","pid":115721,"level":50,"version":"5.63.0","err":{"id":"6ef94af0-bb60-11ee-994f-2323dfceb85c","domain":"https://merklepal.com","code":"ABORTED_GET_HELPER","name":"HelperWar>

jannis · January 29, 2024, 5:41am

The logs are still cut off. They extend the file you are opening in your terminal on the right. Where you see the white > – that’s where some crucial information is hiding.

But yes, the MySQL issue is still there.

Your MySQL config looks correct from an application POV, but that doesn’t mean too much. The big question is: how have you configured your MySQL server? Is there a user 'ghost-23'@'127.0.0.1'? Is the server listening to 127.0.0.1 and port 3306? Does the user have privileges for the database ghost_production?

How have you set up your MySQL server?

cassyblaise · January 29, 2024, 10:05am

Hey @jannis Please do you have any idea on how to get the hidden log file?

I can really remember on how I configured my MySQL serve be it was early last year and everything was working well before the current error poped up

jannis · January 29, 2024, 10:12am

Then the big question for me is what you have changed.

Did you update any packages on your server? Did you do a distribution upgrade?

To get the full log file, you will probably need a different way to view it. Either by downloading the log file from your server (scp) or potentially by using cat to get the file as standard output, rather than nano (which is rather for editing files).

cassyblaise · January 29, 2024, 10:25am

The only update or thing I did so far is, when mailgun support team help me to update the SSL Certificate and then yesterday I updated ghost to the current version and also expanded or increase digitalocean CPU and RAM.

Btw, let me try to copy the log file. thanks for your time

jannis · January 29, 2024, 10:34am

Okay, wild guess, but is your MySQL server actually running?

Can you connect to it from the command line of your server?

mysql -u "ghost-23" -p

cassyblaise · January 29, 2024, 11:03am

Ah, I am having this error, that after it ask for my password:

ERROR 1045 (28000): Access denied for user 'ghost-23'@'localhost' (using password: YES)

AnimaVillis · January 29, 2024, 11:04am

This error says:
You can’t login to this database with those user pass.
Try to login on root, set new password or change for this what you remember and then run it again.

jannis · January 29, 2024, 11:05am

Tada

The issue isn’t with Ghost – it’s with your MySQL server. Looks like something messed with that when you did these updates.

You can log in with your root user and check permissions and potentially set a new password.

cassyblaise · January 29, 2024, 11:06am

Okay, thanks, let me try it out

Topic		Replies	Views
Ghost email subscribe is giving "Failed to sign up, please try again" error Developer help	7	1314	January 24, 2022
Suddenly unable to login Developer help	0	53	May 7, 2024
Failed to sign up, please try again Installation	12	3172	November 18, 2021
Member subscribe not working Developer help	5	370	July 2, 2023
(Mailgun) Invalid login: 535 Authentication failed Self-hosting	5	369	February 17, 2024

Failed to log in, please try again

Related Topics