Hello @jdeighton Yes, that is possible. Here is also part of this in the documentation: https://docs.cloudron.io/guides/connect-mysql/ But! Not documented is the part how to access the main DB, since this is risky and most users should not do that. It is present in multiple forum posts so here. While connect to the root user on the server, run: docker exec -ti mysql /bin/bash and inside the container you can simply run: mysql -uroot -p$CLOUDRON_MYSQL_ROOT_PASSWORD

The latest here https://activitypub.ghost.org/ramping-up-for-expansion/ (via the excellent https://selfh.st newsletter)

Hello @bmann @bmann said in Mail problems on Ghost: bump on this Sorry that this topic did not get any traction for almost a week! @bmann said in Mail problems on Ghost: "Do not configure app's mail delivery settings The app's mail delivery settings is left alone. You can configure it inside the app." Where did you find this text? I could not find it in the documentation, the app package or anywhere. Would like to know where this came from since this might be misleading. @bmann said in Mail problems on Ghost: Going to try it! Wish me luck! If you want to tinker with apps, always create an app backup first or even clone the app so you can take a shotgun approach to the clone. There are certain settings for each app that Cloudron will override on every app restart. I know @BrutalBirdie submitted a PR yesterday about this => https://git.cloudron.io/docs/docs/-/merge_requests/75/diffs According to the app startup https://git.cloudron.io/packages/ghost-app/-/blob/master/start.sh?ref_type=heads#L39 If CLOUDRON_MAIL_SMTP_SERVER is not empty it will set up the mail config on every app restart: if [[ -n "${CLOUDRON_MAIL_SMTP_SERVER:-}" ]]; then json -I -f /app/data/config.production.json \ -e "this.mail.from = \"${CLOUDRON_MAIL_FROM_DISPLAY_NAME:-Ghost} <${CLOUDRON_MAIL_FROM}>\"" \ -e "this.mail.options.host = '${CLOUDRON_MAIL_SMTP_SERVER}'" \ -e "this.mail.options.port = '${CLOUDRON_MAIL_SMTP_PORT}'" \ -e "this.mail.options.auth.user = '${CLOUDRON_MAIL_SMTP_USERNAME}'" \ -e "this.mail.options.auth.pass = '${CLOUDRON_MAIL_SMTP_PASSWORD}'" fi You may want to disable the mail config for the app to avoid this. See => https://docs.cloudron.io/apps/#disable-email-configuration

@bmann sounds like the intention is for it to ship with Ghost 6.0: [image: 1747211029998-c4e5da44-8f1c-431a-b769-777b3194dc27-image.png] As shown at the top of https://ghost.org/help/social-web/

@samuk Please always try to show, or explain, what the solution was. This helps anyone else with the same or similar issue.

In the interim, I underwent the business evaluation process at Mailguns. The support staff was amiable, and my blogs received positive feedback. Due to a limitation of nine emails per transmission, I was required to send newsletters in smaller batches.

yes, there is no caching on Cloudron package side

Thanks @girish maybe automatic detection could be achieved with something like https://github.com/lycheeverse/lychee

Yes, you have to setup transactional email as per https://docs.cloudron.io/apps/ghost/#email . Many of the things are hardcoded and there's also a step by step guide at https://forum.cloudron.io/topic/7043/how-on-earth-do-you-get-ghost-memberships-and-newsletters-working-with-cloudron/21 by @jdaviescoates

Right.. with node 22 it does not load root@168af0b1-79ac-45e0-84ed-54d64b54cfcf:/home/cloudron/ghost/versions/5.110.4# node Welcome to Node.js v22.14.0. Type ".help" for more information. > Error: Could not open history file. REPL session history will not be persisted. > require('@tryghost/html-to-mobiledoc') Uncaught Error: Cannot find module '@tryghost/kg-parser-plugins' Require stack: - /home/cloudron/ghost/versions/5.110.4/node_modules/@tryghost/html-to-mobiledoc/lib/converter.js - /home/cloudron/ghost/versions/5.110.4/node_modules/@tryghost/html-to-mobiledoc/index.js - <repl> at Function._resolveFilename (node:internal/modules/cjs/loader:1225:15) at Function._load (node:internal/modules/cjs/loader:1055:27) at TracingChannel.traceSync (node:diagnostics_channel:322:14) at wrapModuleLoad (node:internal/modules/cjs/loader:220:24) at Module.require (node:internal/modules/cjs/loader:1311:12) at require (node:internal/modules/helpers:136:16) at Object.<anonymous> (/home/cloudron/ghost/versions/5.110.4/node_modules/@tryghost/html-to-mobiledoc/lib/converter.js:4:31) at Module._compile (node:internal/modules/cjs/loader:1554:14) at Object..js (node:internal/modules/cjs/loader:1706:10) { code: 'MODULE_NOT_FOUND', requireStack: [ '/home/cloudron/ghost/versions/5.110.4/node_modules/@tryghost/html-to-mobiledoc/lib/converter.js', '/home/cloudron/ghost/versions/5.110.4/node_modules/@tryghost/html-to-mobiledoc/index.js', '<repl>' ] } With node 20, it works fine: root@718c9254-490c-4da1-8479-d7977bc2217b:/home/cloudron/ghost/versions/5.110.4# node Welcome to Node.js v20.18.3. Type ".help" for more information. > Error: Could not open history file. REPL session history will not be persisted. > require('@tryghost/html-to-mobiledoc') { toMobiledoc: [Function (anonymous)] } Will pin node in the ghost package - https://git.cloudron.io/packages/ghost-app/-/merge_requests/47

Is the page behind Cloudflare or some other site proxy? It's possible some WAF is filtering something out.

@joseph said in Is there a way to get the theme files running on git?: @roofboard are ghost themes simply uploaded to a directory inside /app/data ? Yes, simple uploading works /app/data/content/themes I haven't tried it, but wouldn't SFTP uploads work fast enough here? Just noticed your last bulletpoint

@wmlutz said in Emojis in email render incorrectly: They still aren't happy with v5.108.2 and recommend rolling back. https://forum.ghost.org/t/html-encoding-issue-in-emails-nbsp-amp-etc/54798/18 Any guidance on how to do this in my cloudron deployment? My members are getting cranky. The fix mentioned there has already been released (see https://forum.ghost.org/t/html-encoding-issue-in-emails-nbsp-amp-etc/54798/13 ) and has already been on Cloudron for a while as @joseph just mentioned

@rosano said in How to add this new anti bot sign-up configuration on Cloudron?: Ghost recently made a UI for this https://ghost.org/changelog/signup-spam-protection/ Thanks for the headsup! Odd that it isn't pre-poluated with the links I've already added using the previous config method!

@canadaduane thanks, might help someone! BTW FYI (and anyone else who doesn't know or who has forgotten), you can also check here: [image: 1739180184561-907f3e52-dfa3-4dc2-85b3-e30c0d6dfe16-image.png] The Admin Page will take you to /ghost and it's also mentioned in the First Time Setup which you can view again but choosing it from this menu

@brianb you have to use the Web Terminal to view the full filesystem of an app. The File manager only shows the data directory (/app/data) of an app.

Ah, just found it - apparently, I restrict access to the page in the general settings, and then in the settings of the individual post, I can set access to "public". Then the page itself is still password-protected, but the text is now included into the API call.

@shrey ah, I understood now! There is a small chance that the upstream Ghost forum has 'rebels'