Error on Ghost install

I deployed ghost with. mysql, showed me no error. When I open the production link it shows me this error
No description
479 Replies
Percy
Percy5mo ago
Project ID: N/A
Brody
Brody5mo ago
lol was just responding
No description
barnabynagy
barnabynagy5mo ago
N/A Is that funny?
Brody
Brody5mo ago
oh no im sorry the lol was not to what you said, the lol was that i was typing my message to you and then i look over and you opened a help thread! your question is super valid, and railway is working hard to remove the user confusion from deploying templates
barnabynagy
barnabynagy5mo ago
Ah ok, thanks for clarifying Yeah that would be great I didn't even know that the templates are user submitted
Brody
Brody5mo ago
let me finish typing out my message in the forum, then i will look into why ghost is failing
barnabynagy
barnabynagy5mo ago
It's not marketed I mean it should say it somewhere When I sign up I assume that railway makes these templates available and obviously they made sure everything works fine so that the user can install without problems
Brody
Brody5mo ago
the docs do mention that any user can submit templates, but again that is a very understandable assumption currently there is no quality control for templates, but there soon will be
barnabynagy
barnabynagy5mo ago
Yeah, but I'm a regular user, I am not reading docs. This should be designed in the UX front end to be obvious Are you working for railway?
Brody
Brody5mo ago
100% agree, but in an ideal world, it wouldn’t matter if a template is user submitted as long as you know that and as long as you have assurance that they will work when you deploy them i do not work for railway
barnabynagy
barnabynagy5mo ago
Yes but it should have a tag like "user submitted" just so that I know Ok
Brody
Brody5mo ago
for sure, i like that idea, railway is going to be adding tags and i will make sure thats one of them! cc @Melissa - template feedback heres the answer to the question on the forums if you wanted to read it https://community.railway.app/questions/ghost-which-one-6645792c#p-3
barnabynagy
barnabynagy5mo ago
Cool Read it
Brody
Brody5mo ago
she does work for railway, and would definitely want to see this feedback! but i was able to deploy the Ghost (Docker) + MySQL template without issue, is that the template you deployed?
barnabynagy
barnabynagy5mo ago
Awesome. I'm a UX designer and would be happy to help. I just hate system that are not user friendly and want to fix them and make them smooth That's the one https://ghost-production-142e.up.railway.app/
Brody
Brody5mo ago
then im sure melissa will have some additional questions, im just a community mod
barnabynagy
barnabynagy5mo ago
This error message doesn't tell me anything either. It's basic UX principle to design error messages to be helpful. Tell the user what happened, why and how to fix it
No description
Brody
Brody5mo ago
thats fair, but that error can be caused by 100+ different things, i think it would be impossible for railway to tell you what the app isnt doing correctly when you take into account all the things you can deploy on railway. instead it should direct you to look into your logs for errors so yeah what errors are in the logs?
barnabynagy
barnabynagy5mo ago
yarn run v1.22.19 $ npm-run-all check-db update-tracker start-server $ node scripts/check-db.js ✓ DATABASE_URL is defined. ✓ Database connection successful. ✓ Database version check successful. Prisma schema loaded from prisma/schema.prisma Datasource "db": PostgreSQL database "railway", schema "public" at "postgres.railway.internal:5432" 3 migrations found in prisma/migrations Applying migration 01_init Applying migration 02_report_schema_session_data Applying migration 03_metric_performance_index The following migrations have been applied: migrations/ └─ 01_init/ └─ migration.sql └─ 02_report_schema_session_data/ └─ migration.sql └─ 03_metric_performance_index/ └─ migration.sql All migrations have been successfully applied. ✓ Database is up to date. $ node scripts/update-tracker.js $ node server.js ▲ Next.js 14.0.4 - Local: http://localhost:5754 - Network: http://0.0.0.0:5754 ✓ Ready in 133ms There should be an easy way to copy paste logs or even better link to log file
barnabynagy
barnabynagy5mo ago
No description
Brody
Brody5mo ago
I've been telling them that for months now, so I made this https://bookmarklets.up.railway.app/log-downloader/ could you use the bookmarklet instead and send your logs from ghost?
barnabynagy
barnabynagy5mo ago
Ah ok, sounds like they don't listen much
Brody
Brody5mo ago
haha no it's not that, it's just they have much bigger things to do, but this improves UX/DX so you could say that they should take the time out to add a button (they should)
barnabynagy
barnabynagy5mo ago
What is bigger than UX honestly? How user friendly an app is breaks or makes an app. It can increase their sales and retention as well
Brody
Brody5mo ago
absolutely but keep in mind the template creator or railway are not necessarily at fault if the service crashes can you send me a screenshot of your project?
barnabynagy
barnabynagy5mo ago
How not?
barnabynagy
barnabynagy5mo ago
This one?
No description
Brody
Brody5mo ago
for one example neither railway nor the creator could be responsible for bugs in the ghost code that cause it to crash yes but I'd like a screenshot of the entire project please
barnabynagy
barnabynagy5mo ago
Of course
barnabynagy
barnabynagy5mo ago
This one?
No description
barnabynagy
barnabynagy5mo ago
Or which part?
Brody
Brody5mo ago
no, but that's green now? is it still inaccessible?
barnabynagy
barnabynagy5mo ago
It was green before but when you click on it it shows the error
Brody
Brody5mo ago
gotcha, have you tried redeploying it? click the 3 dot menu and you will see the redeploy option
barnabynagy
barnabynagy5mo ago
Just did and get the same error
Brody
Brody5mo ago
thats super odd, just did another deploy of the template and it worked first try again, do you wanna try deploying the template again?
Brody
Brody5mo ago
oh i think i know whats going on, you are on the trial plan thus you only have access to 512mb of ram per service, but mysql uses more than that
No description
Brody
Brody5mo ago
this template would be better for a user on a trial plan, it uses an sqlite database instead of an external mysql database https://railway.app/template/9VGb60
barnabynagy
barnabynagy5mo ago
OMG so why doesn't railway tell me to upgrade then???? They are honestly losing out on customers because of bad UX
Brody
Brody5mo ago
thats a damn good question
barnabynagy
barnabynagy5mo ago
Another question
Brody
Brody5mo ago
what's up
barnabynagy
barnabynagy5mo ago
If I add a custom domain will the railway subdomain be disabled? Because in pikapods both is live and I think that's bad for SEO
Brody
Brody5mo ago
by default no, but you can just remove the railway provided domain
barnabynagy
barnabynagy5mo ago
How? Ah I see there is a delete icon
Brody
Brody5mo ago
yep
barnabynagy
barnabynagy5mo ago
Ok, is it possible to move my ghost install from pikapods to railway?
Brody
Brody5mo ago
what's pikapods
barnabynagy
barnabynagy5mo ago
PikaPods - Instant Open Source App Hosting
Run the finest Open Source web apps from $1/month, fully managed, no tracking, no ads, full privacy. Self-hosting was never this convenient.
barnabynagy
barnabynagy5mo ago
It's like railway one click open source project installs
Brody
Brody5mo ago
all created and managed by pikapods themselves?
barnabynagy
barnabynagy5mo ago
The installs?
Brody
Brody5mo ago
yeah
barnabynagy
barnabynagy5mo ago
Yeah, I think so
Brody
Brody5mo ago
does ghost provide a way to export data?
barnabynagy
barnabynagy5mo ago
They are not community added I believe I can export posts, pages and members but not images of the posts and pages Just the text and settings
Brody
Brody5mo ago
where are images stored on pika pods?
barnabynagy
barnabynagy5mo ago
I have no idea
barnabynagy
barnabynagy5mo ago
I guess here
No description
Brody
Brody5mo ago
there you go
barnabynagy
barnabynagy5mo ago
Is there sftp access on railway too?
Brody
Brody5mo ago
there is not
barnabynagy
barnabynagy5mo ago
Ah So isn't there a magic way to just migrate? Like some terminal command or something? I think on the ghost forum they mentioned shell access I don't know what that is
Brody
Brody5mo ago
nope, railway doesn't have any integrations with pikapods this would be a manual process on your part, railway is completely unmanaged
barnabynagy
barnabynagy5mo ago
Obviously I meant like a standard copy dock image paste dock image like stuff
Brody
Brody5mo ago
the docker image doesn't contain the data
barnabynagy
barnabynagy5mo ago
Ah ok Hmm I see you added the umami template to railway, is that correct? And uptime kuma
Brody
Brody5mo ago
yes those are mine
barnabynagy
barnabynagy5mo ago
Cool Is there a way to migrate those from pikapods? Import export?
Brody
Brody5mo ago
I know uptime kuma has an export/import as for umami, you would need to dump the postgres database from pikapods and then restore it to the database on railway
barnabynagy
barnabynagy5mo ago
It says the export may not work?
No description
barnabynagy
barnabynagy5mo ago
deprecated
Brody
Brody5mo ago
oh yeah, they want to to just grab the sqlite file to do a backup
barnabynagy
barnabynagy5mo ago
Sorry I don't understand
Brody
Brody5mo ago
uptime kuma stores it's data to a sqlite3 database file on disk
barnabynagy
barnabynagy5mo ago
ok So would you mind guide me how to migrate this to railway please?
Brody
Brody5mo ago
I mean I can certainly try, but remember I have never done an uptime kuma migration from anywhere to anywhere, and I have never used pikapods either, so I can help you at a high level but you would need to fill in the minor details
barnabynagy
barnabynagy5mo ago
ok sure I appreciate it
Brody
Brody5mo ago
you will need to grab the sqlite file from the pikapods deployment, using sftp, I'd use a client like winscp
barnabynagy
barnabynagy5mo ago
ok let me grab that
barnabynagy
barnabynagy5mo ago
I'm in
No description
barnabynagy
barnabynagy5mo ago
That's what I have access to
Brody
Brody5mo ago
you want kuma.db
barnabynagy
barnabynagy5mo ago
Ok, downloaded What's next?
Brody
Brody5mo ago
have you deployed uptime kuma on railway?
barnabynagy
barnabynagy5mo ago
Yes
Brody
Brody5mo ago
remove the active deployment
barnabynagy
barnabynagy5mo ago
Done
Brody
Brody5mo ago
detach its volume
barnabynagy
barnabynagy5mo ago
I don't understand I completely deleted the template
Brody
Brody5mo ago
what why
barnabynagy
barnabynagy5mo ago
No description
Brody
Brody5mo ago
deploy it again please
barnabynagy
barnabynagy5mo ago
ok You told me to remove it
Brody
Brody5mo ago
is kuma going to be used to only monitor your ghost site? the deployment not the service
barnabynagy
barnabynagy5mo ago
For now yes I don't know what's the difference sorry, I'm new to this
Brody
Brody5mo ago
no worries, railway really should have some type of walkthrough guide that tell you what parts of the UI are called what but for now, go back to your dashboard and deploy a new uptime kuma project
barnabynagy
barnabynagy5mo ago
Yes exactly a guide would be nice or rather make it UX friendly so that there is no need for a guide Done Deployed
Brody
Brody5mo ago
I'd prefer the guide, you can only make the UI so friendly before it starts to look like a kids toy
barnabynagy
barnabynagy5mo ago
Haha believe me I'm a pro UX designer, you can serve both devs and noobs with good design haha
Brody
Brody5mo ago
fair enough, so open the uptime kuma project, then open the uptime kuma service, you will see a green rectangle, that is a deployment, click the 3 dot menu and then remove it
barnabynagy
barnabynagy5mo ago
Here click remove?
No description
Brody
Brody5mo ago
yep we don't want kuma trying to write to the database while we are swapping it
barnabynagy
barnabynagy5mo ago
Removed
No description
Brody
Brody5mo ago
right click on the service's volume and click detach
barnabynagy
barnabynagy5mo ago
This is when right clicking uptime kuma
No description
barnabynagy
barnabynagy5mo ago
This is when right clicking the database
No description
Brody
Brody5mo ago
you deployed uptime kuma into the same project I highly recommend you deploy it into a new project, from the dashboard
barnabynagy
barnabynagy5mo ago
Yeah all my templates sit in the same project, is that a problem? What's the pro of having it in a separate project?
Brody
Brody5mo ago
they're separate things, unless it's something like a database and a backend api you'd want it to be separate uptime kuma could be used to monitor multiple apps in different projects, so it should be in its own project
barnabynagy
barnabynagy5mo ago
Ah ok So reddeployed it in a new project
Brody
Brody5mo ago
removed the active deployment? and disconnected it's volume?
barnabynagy
barnabynagy5mo ago
Yes sir That I still don't know how
Brody
Brody5mo ago
screenshot please 🙂 just like this
barnabynagy
barnabynagy5mo ago
If I right click on the database I see disconnect volume - is that what you mean?
No description
barnabynagy
barnabynagy5mo ago
No description
Brody
Brody5mo ago
that's a volume as indicated by the little disk logo so that's what you want to disconnect
barnabynagy
barnabynagy5mo ago
Done
No description
Brody
Brody5mo ago
from within the same project, click the + new button in the top right, click template, and search for "filebrowser" set your desired username, expand the optional preset variables and change that 0 to a 1 I would normally send you screenshots, but my power is out so phone screenshots would just confuse us both
barnabynagy
barnabynagy5mo ago
Ok, no worries Deploy?
Brody
Brody5mo ago
perfect save and deploy
barnabynagy
barnabynagy5mo ago
Done
No description
Brody
Brody5mo ago
remove the active deployment from the filebrowser, then delete the filebrowser's volume for the record, yes I am aware this is very convoluted but railway does not yet have a native volume filebrowser or sftp volume access
barnabynagy
barnabynagy5mo ago
Haha yeah it's complicated
barnabynagy
barnabynagy5mo ago
No description
Brody
Brody5mo ago
it's volume is gone?
barnabynagy
barnabynagy5mo ago
Delete service?
No description
Brody
Brody5mo ago
right click on the volume and delete the volume
barnabynagy
barnabynagy5mo ago
Delete volume?
No description
Brody
Brody5mo ago
yep
barnabynagy
barnabynagy5mo ago
Done
No description
Brody
Brody5mo ago
mount that volume to the filebrowser service at /data
barnabynagy
barnabynagy5mo ago
This?
No description
Brody
Brody5mo ago
yep!
barnabynagy
barnabynagy5mo ago
?
No description
Brody
Brody5mo ago
/data
barnabynagy
barnabynagy5mo ago
done
No description
Brody
Brody5mo ago
redeploy the filebrowser's removed deployment via it's 3 dot menu
barnabynagy
barnabynagy5mo ago
done
No description
Brody
Brody5mo ago
open the link and log in
barnabynagy
barnabynagy5mo ago
No description
Brody
Brody5mo ago
and there's the new kuma.db, delete it you should then be able to drag and drop the kuma.db file you got from pikapods
barnabynagy
barnabynagy5mo ago
No description
barnabynagy
barnabynagy5mo ago
Done
Brody
Brody5mo ago
remove the active deployment from the filebrowser service
barnabynagy
barnabynagy5mo ago
Done
No description
Brody
Brody5mo ago
unmount the volume from filebrowser
barnabynagy
barnabynagy5mo ago
Done
No description
Brody
Brody5mo ago
mount it to the kuma service, mount to /app/data
barnabynagy
barnabynagy5mo ago
You mean mount the filebrowser or mount Uptime Kuma data?
Brody
Brody5mo ago
mount the volume to the kuma service, mount to /app/data
barnabynagy
barnabynagy5mo ago
Done
No description
Brody
Brody5mo ago
restart the removed deployment from kuma
barnabynagy
barnabynagy5mo ago
You mean redeploy?
Brody
Brody5mo ago
oh yes my bad
barnabynagy
barnabynagy5mo ago
Done
No description
Brody
Brody5mo ago
you should now be able to open the address, and login with the same credentials you used for kuma on pikapods
barnabynagy
barnabynagy5mo ago
Awesome, I'm in!
No description
barnabynagy
barnabynagy5mo ago
Thank you so much!!!
Brody
Brody5mo ago
no problem!
Brody
Brody5mo ago
wasn't that hard was it lol
barnabynagy
barnabynagy5mo ago
no it was ok, just lots of mount, unmount stuff Ok so it should be possible to the same for umami?
Brody
Brody5mo ago
depends, does pikapods provide you a way to access the postgres database?
barnabynagy
barnabynagy5mo ago
I have this for umami
No description
Brody
Brody5mo ago
flip the switch what does it give you? also, there's a chance you crash postgres on railway doing the restore, might be time to upgrade to hobby?
barnabynagy
barnabynagy5mo ago
I upgraded already 🙂 Didn't let me use the filebrowser without upgrade haha
barnabynagy
barnabynagy5mo ago
No description
Brody
Brody5mo ago
oh maybe our discord bot is broken, doesn't show you as hobby
barnabynagy
barnabynagy5mo ago
No description
Brody
Brody5mo ago
fixed on the discod side of things now okay so what kind of database does umami use on pikapods?
barnabynagy
barnabynagy5mo ago
Now we're talking 🙂
barnabynagy
barnabynagy5mo ago
Looks like MySQL
No description
barnabynagy
barnabynagy5mo ago
In the dropdown it shows postgres too
No description
Brody
Brody5mo ago
my umami template uses postgres though 🫤
barnabynagy
barnabynagy5mo ago
Well, it shows postgres as an option so that should be good I guess
barnabynagy
barnabynagy5mo ago
Tried to log into postgres
No description
Brody
Brody5mo ago
but you can log into mysql?
barnabynagy
barnabynagy5mo ago
yep
No description
Brody
Brody5mo ago
do you want me to create a umami template that uses mysql?
barnabynagy
barnabynagy5mo ago
That would be great!
Brody
Brody5mo ago
okay I can do that, but I can't do that right now, I'm about to leave the house in the mean time, you need to find out how you can get a dump of that database on pikapods
barnabynagy
barnabynagy5mo ago
Ok sure
barnabynagy
barnabynagy5mo ago
Export?
No description
Brody
Brody5mo ago
I honestly have no clue, sorry, I've never used adminer not even sure if you can do the export/dump from adminer maybe look up ways to dump the database from pikapods, surely you aren't the first to want to dumb a database from them
barnabynagy
barnabynagy5mo ago
Ok, just emailed them
Brody
Brody5mo ago
sounds good
barnabynagy
barnabynagy5mo ago
My ghost install still shows this even after the upgrade to hobby plan
No description
Brody
Brody5mo ago
redeploy the mysql database and then redeploy the ghost service
barnabynagy
barnabynagy5mo ago
This one?
No description
Brody
Brody5mo ago
oh you deployed the one with sqlite
barnabynagy
barnabynagy5mo ago
No, I selected mysql
Brody
Brody5mo ago
there's no mysql database there though?
barnabynagy
barnabynagy5mo ago
I don't know man
Brody
Brody5mo ago
perhaps you deleted it?
barnabynagy
barnabynagy5mo ago
Let me redo the whole thing
Brody
Brody5mo ago
sounds good
barnabynagy
barnabynagy5mo ago
Looks the same to me
No description
barnabynagy
barnabynagy5mo ago
And has the same error Ah man this is so difficult This should be seamless 1 click install with no error
Brody
Brody5mo ago
there's still no mysql database, maybe go back to the dashboard and deploy it again?
barnabynagy
barnabynagy5mo ago
Redeployed
No description
barnabynagy
barnabynagy5mo ago
I guess this template has some problems
Brody
Brody5mo ago
no, please go to the dashboard and deploy a brand new template
barnabynagy
barnabynagy5mo ago
This was a brand new template
Brody
Brody5mo ago
I'm sorry but it's not, a brand new template would not come with filebrowser
barnabynagy
barnabynagy5mo ago
I installed that separately
Brody
Brody5mo ago
why?
barnabynagy
barnabynagy5mo ago
To be able to upload image files
Brody
Brody5mo ago
okay lets tackle that later, but for now, you must be deploying the wrong template as it is missing the mysql database
barnabynagy
barnabynagy5mo ago
I will show you
barnabynagy
barnabynagy5mo ago
CleanShot Cloud
CleanShot 2024-01-13 at 14.17.02
Video uploaded to CleanShot Cloud
Brody
Brody5mo ago
I can't watch that because I'm on mobile with a bad signal, but from the thumbnail alone, you aren't going to your dashboard, you are trying to deploy into a pre existing project
barnabynagy
barnabynagy5mo ago
Yes a pre existing project I thought you want me to redeploy the template only
Brody
Brody5mo ago
I do, but you aren't doing that go to the dashboard and deploy the template, it will create a project for you
barnabynagy
barnabynagy5mo ago
Just did
No description
barnabynagy
barnabynagy5mo ago
That's weird I don't know why from a project deploying the template would not include the mysql
Brody
Brody5mo ago
bug, it shouldn't even let you do that normally it will clearly tell you that you need to deploy it as a new project
barnabynagy
barnabynagy5mo ago
Yeah it should show me an error Ok So do you think I should go with the built in export import or do it from mysql?
Brody
Brody5mo ago
does ghost have that feature?
barnabynagy
barnabynagy5mo ago
No description
barnabynagy
barnabynagy5mo ago
No description
Brody
Brody5mo ago
sounds like this is going to involve you manually downloading images and such out of all my templates I only actively use a few of them, ghost is not one of them, so I unfortunately would not be able to help with the migration besides answering railway related questions
barnabynagy
barnabynagy5mo ago
Ok, I can try I mean it's only the images it looks like Also, have you heard of serpbear?
Brody
Brody5mo ago
I have not
barnabynagy
barnabynagy5mo ago
I'm using this on pikapods as well Would be nice to see it on railway! It shows me where my site is ranking on search engines for certain keywords
Brody
Brody5mo ago
interesting, I'll take a look later
barnabynagy
barnabynagy5mo ago
ok thanks
Brody
Brody5mo ago
do you know it's tech stack?
barnabynagy
barnabynagy5mo ago
Next.js for Frontend & Backend. Sqlite for Database.
Brody
Brody5mo ago
oh than that shouldn't be too much hassle to get going, but no promises
barnabynagy
barnabynagy5mo ago
Cool cool Would like to completely migrate away from pikapods if possible 🙂
Brody
Brody5mo ago
haha I can tell, may I ask why? heres the SerpBear template https://railway.app/template/J29H1Z
barnabynagy
barnabynagy5mo ago
In a couple of days I had several downtimes of my ghost install and they just said they had to refresh the server for the images to load better Then I asked them if it was manual or automatic and no response I had then several other questions and no response I asked them to remove the test subdomain after I pointed my custom domain and they said it's not possible Wow, super cool man!!!!
Brody
Brody5mo ago
railway has downtime to, everyone does, but i have projects i haven't touched in several months running solid
barnabynagy
barnabynagy5mo ago
Yeah I know but 3x in two days? And no explanation?
Brody
Brody5mo ago
yeah railway has had an outage that lasted that long, but you always get a good reason why, and i think it was only the logging layer that was effected sometime even full post mortem blog posts, and the biggest outages railway has had was because of gcp heres the umami template with a mysql database https://railway.app/template/ZiHXd_ but its not much good if you cant get your data off of pikapod lol
barnabynagy
barnabynagy5mo ago
I see, well, hopefully they are working on the uptime
Brody
Brody5mo ago
oh yeah that's long since been improved
barnabynagy
barnabynagy5mo ago
So I can export the mysql, do you think that will work?
Brody
Brody5mo ago
you got a way to export the data from the mysql database on pikapods?
barnabynagy
barnabynagy5mo ago
Yes sir
Brody
Brody5mo ago
what's the method?
Brody
Brody5mo ago
oh yeah that exports everything? what about images, do you need to pull those off pikapod with sftp?
barnabynagy
barnabynagy5mo ago
Are we talking about umami? There are no images just data no?
Brody
Brody5mo ago
oh ghost has the images nvm im getting things mixed up okay you can export the database, how are you importing it into the database on railway?
barnabynagy
barnabynagy5mo ago
No worries I have no idea man Hay I
Brody
Brody5mo ago
can adminer import?
barnabynagy
barnabynagy5mo ago
I guess so Haven't used it either I'm at the ghost install...
barnabynagy
barnabynagy5mo ago
No description
barnabynagy
barnabynagy5mo ago
How do I connect the filebrowser with the ghost install?
Brody
Brody5mo ago
remove the active ghost deploy unmount the volume from ghost mount the volume to the filebrowser redeploy the removed filebrowser deployment do you have the images from your pikapod app?
barnabynagy
barnabynagy5mo ago
Yes, I downloaded the images already Will this remove the data from my ghost install? I already imported the data
Brody
Brody5mo ago
do you know the file structure to put them back into when you use the filebrowser?
barnabynagy
barnabynagy5mo ago
Yes sir
Brody
Brody5mo ago
no, unmounting and such does not touch the data in the volume
barnabynagy
barnabynagy5mo ago
ok cool, good to know Let me try
Brody
Brody5mo ago
i should note that railway is not responsible for any data loss that may occur, only if they are at fault
barnabynagy
barnabynagy5mo ago
Gotcha
barnabynagy
barnabynagy5mo ago
Mount the filebrowser data too?
No description
Brody
Brody5mo ago
nah thats just the volume it comes with if people want to use filebrowser as just a place to store files and what not
barnabynagy
barnabynagy5mo ago
Ah ok
Brody
Brody5mo ago
you can ignore that for what you are doing, you could even delete it
barnabynagy
barnabynagy5mo ago
ok
barnabynagy
barnabynagy5mo ago
Seems like I did something wrong
No description
Brody
Brody5mo ago
what do the logs of the filebrowser deployment say?
barnabynagy
barnabynagy5mo ago
No description
Brody
Brody5mo ago
what path did you use to mount the volume
barnabynagy
barnabynagy5mo ago
/data
Brody
Brody5mo ago
screenshot of the project please
barnabynagy
barnabynagy5mo ago
No description
Brody
Brody5mo ago
maybe there just nothing on the volume?
barnabynagy
barnabynagy5mo ago
On the ghost volume?
Brody
Brody5mo ago
yeah, it was a brand new deploy after all
barnabynagy
barnabynagy5mo ago
Barnaby Nagy
Barnaby Nagy
Barnaby Nagy is an Artist, Singer-Songwriter, Public Speaker, Author, Mentor, Hustler, Survivor - Barnabas Nagy
barnabynagy
barnabynagy5mo ago
I already imported the content Except images all set up
Brody
Brody5mo ago
yeah but content is saved in the database
barnabynagy
barnabynagy5mo ago
I don't follow you
Brody
Brody5mo ago
text go to database, not volume
barnabynagy
barnabynagy5mo ago
ah ok So I don't know What do you suggest? Still if ghost was installed there has to be files
Brody
Brody5mo ago
proceed as normal? ghost is not installed to the volume
barnabynagy
barnabynagy5mo ago
That I don't understand
Brody
Brody5mo ago
ghost is a docker image, it is installed in the deployment, the volume is strictly data storage
barnabynagy
barnabynagy5mo ago
Ok But we were able to access the files of the uptime kuma install
Brody
Brody5mo ago
thats because kuma wrote its sqlite database to the volume
barnabynagy
barnabynagy5mo ago
omg you're speaking chinese to me Ok so how do I access the ghost install files then? to upload the images
Brody
Brody5mo ago
images should be saved to the volume, you told me that you have yet to upload images to ghost, so it makes sense that you are seeing an empty volume
barnabynagy
barnabynagy5mo ago
Yeah but I need to see the directory structure of ghost
Brody
Brody5mo ago
thats why i asked if you knew the file structure
barnabynagy
barnabynagy5mo ago
This is my ghost install on pikapods. I can see all the folders via sftp. And I need to upload the files under the Images folder
No description
barnabynagy
barnabynagy5mo ago
It's like this
No description
Brody
Brody5mo ago
the volume on the ghost service should be equivalent to the content folder
barnabynagy
barnabynagy5mo ago
Ok but then I should see the images folder, too, no?
Brody
Brody5mo ago
no since you havent added any images to ghost yet
barnabynagy
barnabynagy5mo ago
ok, so shall I just upload the whole images folder that I downloaded?
Brody
Brody5mo ago
yep that sounds right
barnabynagy
barnabynagy5mo ago
Better to zip, upload and unzip when uploaded? Or just as it is?
Brody
Brody5mo ago
im not sure if filebrowser supports unzipping a file
barnabynagy
barnabynagy5mo ago
ok
Brody
Brody5mo ago
out of all the templates youve used, the only one i didnt create was ghost lol
barnabynagy
barnabynagy5mo ago
haha ok well let's see if we can crack it
barnabynagy
barnabynagy5mo ago
No description
Brody
Brody5mo ago
lots of files, lets hope youre uploading them to the right location lol
barnabynagy
barnabynagy5mo ago
I know haha
barnabynagy
barnabynagy5mo ago
done
No description
Brody
Brody5mo ago
wow that was fast
barnabynagy
barnabynagy5mo ago
Yeah but the images don't show up
barnabynagy
barnabynagy5mo ago
Barnaby Nagy
Barnaby Nagy
Barnaby Nagy is an Artist, Singer-Songwriter, Public Speaker, Author, Mentor, Hustler, Survivor - Barnabas Nagy
Brody
Brody5mo ago
have you remounted the volume to the ghost service?
barnabynagy
barnabynagy5mo ago
no
Brody
Brody5mo ago
well theres why remove filebrowser deployment unmount its volume mount volume to ghost at /var/lib/ghost/content
barnabynagy
barnabynagy5mo ago
Ah not to data?
Brody
Brody5mo ago
nope, thats where ghost wants it mounted to and it doesnt even matter where you mount it on the filebrowser, you could mount the volume to /data1984 and it would work all the same since i designed the filebrowser template to auto detect the volume's location
barnabynagy
barnabynagy5mo ago
Barnaby Nagy
Barnaby Nagy
Barnaby Nagy is an Artist, Singer-Songwriter, Public Speaker, Author, Mentor, Hustler, Survivor - Barnabas Nagy
barnabynagy
barnabynagy5mo ago
Still no images I mounted to this
Brody
Brody5mo ago
screenshot of project please
barnabynagy
barnabynagy5mo ago
No description
Brody
Brody5mo ago
oh i think i know why on that filebrowser service, what is USE_VOLUME_ROOT set to?
barnabynagy
barnabynagy5mo ago
0
Brody
Brody5mo ago
it needs to be set to 1
barnabynagy
barnabynagy5mo ago
damn
Brody
Brody5mo ago
No description
Brody
Brody5mo ago
my bad
barnabynagy
barnabynagy5mo ago
Is this your ghost install?
Brody
Brody5mo ago
yeah just deployed it and im working along side you when i realized USE_VOLUME_ROOT was set to 0
barnabynagy
barnabynagy5mo ago
ah yeah ok
Brody
Brody5mo ago
in my defense ive never done this before either
barnabynagy
barnabynagy5mo ago
So do I delete the filebrowser template and install again ?
Brody
Brody5mo ago
no just change it to 1
barnabynagy
barnabynagy5mo ago
No worries or just change the volum root to 1?
Brody
Brody5mo ago
yeah USE_VOLUME_ROOT=1
barnabynagy
barnabynagy5mo ago
ok
Brody
Brody5mo ago
you need to mount the volume back to the filebrowser service though
barnabynagy
barnabynagy5mo ago
No description
barnabynagy
barnabynagy5mo ago
I'm in
Brody
Brody5mo ago
awsome
barnabynagy
barnabynagy5mo ago
I wonder where is that images folder that I uploaded perviously though is it in the aether? haha
Brody
Brody5mo ago
its in the storage folder, feel free to delete it
Brody
Brody5mo ago
No description
barnabynagy
barnabynagy5mo ago
Got it Uploading again done Mount it here?
Brody
Brody5mo ago
mount back to ghost
barnabynagy
barnabynagy5mo ago
Great
barnabynagy
barnabynagy5mo ago
Barnaby Nagy
Barnaby Nagy
Barnaby Nagy is an Artist, Singer-Songwriter, Public Speaker, Author, Mentor, Hustler, Survivor - Barnabas Nagy
barnabynagy
barnabynagy5mo ago
Works Except of the the logo all images seems to be restored
Brody
Brody5mo ago
logo is easy enough to re-upload, so ill take this as a win
barnabynagy
barnabynagy5mo ago
Yes, done Thank you man!!! Yes, just testing transactional email before pointing the domain name
Brody
Brody5mo ago
no clue what that is
barnabynagy
barnabynagy5mo ago
Sign up form
No description
Brody
Brody5mo ago
do you have the email stuff setup?
barnabynagy
barnabynagy5mo ago
Yes, the transactional emails were working on my previous setup
Brody
Brody5mo ago
right but have you set it up on railway?
barnabynagy
barnabynagy5mo ago
It's a ghost setting
Brody
Brody5mo ago
what do the logs of the ghost service say?
barnabynagy
barnabynagy5mo ago
Not much
barnabynagy
barnabynagy5mo ago
Nothing about this
No description
Brody
Brody5mo ago
no errors? no i mean in railway
barnabynagy
barnabynagy5mo ago
Ah let me check
barnabynagy
barnabynagy5mo ago
In mailgun it seems to be OK too
No description
barnabynagy
barnabynagy5mo ago
I think I know what's going on I have to add smtp variables to ghost
barnabynagy
barnabynagy5mo ago
in pikapods there was this https://docs.pikapods.com/apps/ghost
PikaPods Docs
Ghost
Notes on selected apps and PikaPods controls
barnabynagy
barnabynagy5mo ago
Where I could add my smtp details
Brody
Brody5mo ago
in the service variables
barnabynagy
barnabynagy5mo ago
Essentially it was doing this but in a user friendly way: https://ghost.org/docs/config/#mail
Ghost - The Professional Publishing Platform
Configuration - Adapt your publication to suit your needs
Find out how to configure your Ghost publication or override Ghost's default behaviour with robust config options, including mail, storage, scheduling and more!
barnabynagy
barnabynagy5mo ago
No description
Brody
Brody5mo ago
railway makes it easy
No description
barnabynagy
barnabynagy5mo ago
Ah that's cool
Brody
Brody5mo ago
yeah just copy over your variables you had set on pikapods
barnabynagy
barnabynagy5mo ago
So do I just copy paste those from pikapods documentation?
Brody
Brody5mo ago
id copy them from your current pikapods app since you have them already set there
barnabynagy
barnabynagy5mo ago
Ok, done It's redeploying That worked, I got the magic link!!!
Brody
Brody5mo ago
sweet
barnabynagy
barnabynagy5mo ago
Now the last bit which was actually still failing on my pikapods setup is if I get email notification of a new post
Brody
Brody5mo ago
let me know how that goes
barnabynagy
barnabynagy5mo ago
And it worked!!!
Brody
Brody5mo ago
awsome!!!
Brody
Brody5mo ago
happy to help
barnabynagy
barnabynagy5mo ago
Next up...
barnabynagy
barnabynagy5mo ago
No description
barnabynagy
barnabynagy5mo ago
Pointed my domain name
Brody
Brody5mo ago
assuming everything was done right, thats just ssl cache from your last ssl cert should sort itself out who is your domain provider
barnabynagy
barnabynagy5mo ago
this is a private browser tab So it should clear that cache no?
barnabynagy
barnabynagy5mo ago
Njalla
Njalla — Considered the worlds most notorious "e;Privacy as a Service"e; provider for domains, VPS' and VPNs.
Brody
Brody5mo ago
dont think it has anything to do with any cache on your computer can you show me how you have the domain setup in that provider?
barnabynagy
barnabynagy5mo ago
When I did a similar pointing with pikapods it was working right away
No description
barnabynagy
barnabynagy5mo ago
no ssl issue
Brody
Brody5mo ago
send me your domain so i can visit?
barnabynagy
barnabynagy5mo ago
Ok, I think it works now
barnabynagy
barnabynagy5mo ago
Barnaby Nagy
Barnaby Nagy
Barnaby Nagy is an Artist, Singer-Songwriter, Public Speaker, Author, Mentor, Hustler, Survivor - Barnabas Nagy
Brody
Brody5mo ago
yep works
barnabynagy
barnabynagy5mo ago
When I open the site from the admin it still goes to railway subdomain
No description
barnabynagy
barnabynagy5mo ago
Same with the nav links
No description
Brody
Brody5mo ago
since you added a domain you need to redeploy the service so that its aware of the new domain so to speak. (railway is aware of this, and is planning to ask you if you would like to redeploy after adding a domain)
barnabynagy
barnabynagy5mo ago
Ah ok Should ask me immediatelly 🙂
Brody
Brody5mo ago
yep railway is planning on implementing that
barnabynagy
barnabynagy5mo ago
Cool Sorry for the noob questions Works now after redeployment
Brody
Brody5mo ago
no worries, im here to help
barnabynagy
barnabynagy5mo ago
Added you as a friend and sent you a DM
zipinel
zipinel5mo ago
Had a similar problem , just wanted to jump into this conversation and say thank you guys for providing this information. Fixed my ghost mailing issue.
barnabynagy
barnabynagy5mo ago
Failed to send newsletter
No description
barnabynagy
barnabynagy5mo ago
My test newsletter were sent out without problems... Not sure what's the issue
Brody
Brody5mo ago
anything in the logs?
barnabynagy
barnabynagy5mo ago
Ghost or Railway?
Brody
Brody5mo ago
railway
barnabynagy
barnabynagy5mo ago
let me check
barnabynagy
barnabynagy5mo ago
MAybe it's this?
No description
Brody
Brody5mo ago
"Mailgun Error 420: Domain mail.barnabynagy.com is not allowed to send: recipient limit exceeded, try again after Wed, 17 Jan 2024 15:50:36 UTC"
"Mailgun Error 420: Domain mail.barnabynagy.com is not allowed to send: recipient limit exceeded, try again after Wed, 17 Jan 2024 15:50:36 UTC"
EmailError: Forbidden: Domain mail.barnabynagy.com is not allowed to send large batches yet
EmailError: Forbidden: Domain mail.barnabynagy.com is not allowed to send large batches yet
this is something you would have to fix with mailgun
barnabynagy
barnabynagy5mo ago
OMG I already paid for their fucking service and they block me? And they said they verified my account Thanks
Brody
Brody5mo ago
no problem!
barnabynagy
barnabynagy5mo ago
Mailgun is a pain in the ass It's the bottleneck of ghost stuck
Brody
Brody5mo ago
haha they want more money out of you or something?
barnabynagy
barnabynagy5mo ago
No I already paid They don't allow me to send my bulk campaign to 1200 subs They want me to validate my business and send just to 9 subs wtf For how long?
barnabynagy
barnabynagy5mo ago
No description
barnabynagy
barnabynagy5mo ago
"please conduct normal business operations with 3-5 days of consistent sending." How can I conduct normal business operation when I have a list of 1200? This company is a joke And ghost only integrates with them natively
Brody
Brody5mo ago
I'm sorry to hear that
barnabynagy
barnabynagy5mo ago
Do you think there is a way to workaround mailgun? I heard some people use zapier to use another email provider but I don't see how because ghost requires a mailgun API in their setup... Or any way to adjust the code to accept other API like sndgrid or Brevo?
barnabynagy
barnabynagy5mo ago
Ghost Forum
Mailgun Alternatives
What was the pass here? API key? I tried the same config on my website. Isn’t working 😕 Followed the steps mentioned here.
barnabynagy
barnabynagy5mo ago
Ghost Forum
Alternative for mailgun
i want to use an opensource tool called Open Source Marketing Automation - Mautic Community because of the issue i had with my mailgun configuration is there any way that i can integrate this ?
barnabynagy
barnabynagy5mo ago
Ghost Forum
Mailgun alternative for login and signup
You can easily set these transactional emails up with any SMTP. Here’s an example with Amazon SES, for example, but you can literally use any SMTP connection.
barnabynagy
barnabynagy5mo ago
Another question: how do I make sure to upgrade ghost, and my other templates to their latest version? And is there some sort of backup on railway?
Medim
Medim5mo ago
If its a docker image, just set the image to :latest and redeploy it. If its a repo, bump up the dependencies. If by backup you mean db backup, theres a template for that, railway will in the future (no eta tho) provide db backups.
Medim
Medim5mo ago
'In the future, we plan to add native support for database backups and high availability by following the same pattern: Add the primitives that can be used by anyone'. https://blog.railway.app/p/launch-01-next-gen-databases
Railway Blog
The Future of Databases is Services
Starting today, it’s now possible to deploy ANY type of database on Railway, including new technologies like PGVector, Chroma, Temporal, etc.
Medim
Medim5mo ago
That will require Ghost knowledge, so that question would be better made in the Ghost community discord server.
barnabynagy
barnabynagy5mo ago
I have no idea whether a template is a docker image or a repo. Where do I see this? Where do I insert :latest? You should make this non dev friendly!
Medim
Medim5mo ago
I'll take a screenshot for you, just one sec.
Medim
Medim5mo ago
On the Service -> Settings, theres Source Repo
No description
Medim
Medim5mo ago
It can be a Repo, or a DockerHub image Which can be acquired from one of those websites: DockerHub, GHCR or quay.io My 2 cents about all your issues: I think you have all those issues because of your previous infra before migrating to Railway, also by having no knowledge in Railway and by Railway itself having some limitations like no SFTP (and that's fine! i've been there!) But we'll sort everything out I'm still reading all this thread since it jumped through some topics, but i'll catch up
barnabynagy
barnabynagy5mo ago
No description
barnabynagy
barnabynagy5mo ago
It looks like a docker So where do I put the :latest?
Medim
Medim5mo ago
What version u are looking for? there's a list on https://hub.docker.com/_/ghost/tags
ghost Tags | Docker Hub
Ghost is a free and open source blogging platform written in JavaScript
barnabynagy
barnabynagy5mo ago
Yeah, I'm not a developer, I'm a UX designer. I just have basic dev knowledge because I did HTML+CSS and wordpress installs but this is new and new jargon. You should add tooltips or explanatory text to every step and every jargon. I can help you with that
Medim
Medim5mo ago
Is there a reason u are using :alpine instead of :latest? (wrong quote, sorry)
barnabynagy
barnabynagy5mo ago
I don't know what version. I just want to make sure that ghost is automatically and always up to date, simple and easy. This should be a defult setting set it auto update to latest version
Medim
Medim5mo ago
U just need to redeploy it then. Also, atleast if its from a template, it shows a button if there's a new update just below the Source Image text But yeah, auto updates would be cool, what u can do is create a Cron Job to redeploy it everyday, but we can get to that after we setup everything u need. Tbh Railway is very standardized if compared to other PaaS (Platform as a Service) that does the same, like Koyeb, Fly and Hop, but I get what u mean and I agree.
barnabynagy
barnabynagy5mo ago
Perhaps standardized but lacks a UX designer So if I redeploy it will pull the latest ghost?
Medim
Medim5mo ago
If ghost updated the :alpine image on the dockerhub, yes. (last update was 14 hours ago and is using version 5.76.0)
barnabynagy
barnabynagy5mo ago
Ok so where do I put :latest?
Medim
Medim5mo ago
. seems like they update the :alpine tag regularly after every update, I don't think u need to worry and change to :latest, there's must be a reason on why ur using alpine so let's keep it that way
barnabynagy
barnabynagy5mo ago
It's how the image came by default, I have not changed a thing So I just redeploy?
Medim
Medim5mo ago
yes.
barnabynagy
barnabynagy5mo ago
Ok thanks. That could be UX designed into the systme easily. To tell the user what to do if they need to keep an image updated etc
Medim
Medim5mo ago
Yeah a notification system would be nice, or even an option to auto update on image changes. Anything more you need help with?
barnabynagy
barnabynagy5mo ago
Yes like that You work at railway?
Medim
Medim5mo ago
No, this is mostly a community driven #✋|help channel. If u have any other type of issue, I suggest opening a new thread since this one got 600+ messages so it's a bit hard to catch up 😆
barnabynagy
barnabynagy5mo ago
Ok I see Do you know any good community templates on rail?
Medim
Medim5mo ago
oh man, there's a lot of them https://railway.app/templates Tbh I only use my own template which is Directus (also a CMS like ghost)
barnabynagy
barnabynagy5mo ago
Let me rephrase I'm looking for a template where people can talk and communicate eg Element, Minds etc
Medim
Medim5mo ago
oh, sorry, i don't know any
barnabynagy
barnabynagy5mo ago
ok Until the db backup automation what can I do to automate a full backup of my installed templates? @Brody
Medim
Medim5mo ago
What type of DB are you using? If it's postgres, theres this template: https://railway.app/template/I4zGrH
Brody
Brody5mo ago
barnabynagy, while a lot of your feedback is valid, please keep in mind you are coming from pikapods, pikapods is not geared towards developers, they are geared towards people who just simply want to run an app, railway caters to developers, thus with railway you will have to deal with the little details like docker images and what not. there are some things Railway just can't / won't do because it's simply not the kind of platform you are used to, railway is not just a place to run these apps, it's so much more
barnabynagy
barnabynagy5mo ago
On the website it never said it's for developers only. If it says so I won't sign up. You can cater to many non dev users by making the UX seamless. It's easy to do. Just have to do it and have the willingness and someone who knows this shit. I'm not really coming from pikapods. I'm coming from serpbear. There they listed elistio, pikapods and flyio. That's how I went down the rabbit hole. I have old school hosting and front end dev experience. So I'm not even a total noob. MySQL
Medim
Medim5mo ago
Railway doesn't has a template for that afaik, but you can use mysqldump
Brody
Brody5mo ago
never said its for developers only, thats just the main userbase
Brody
Brody5mo ago
No description
Brody
Brody5mo ago
adminer also can take database backups
Medim
Medim5mo ago
I searched for the exact same thing and nothing showed up, prob a bug then 💀
barnabynagy
barnabynagy5mo ago
All of this is manual. I wished there was a button I could click that makes a daily full backup. Database and files too as it's not just the database but images too. Set it and forget it
Brody
Brody5mo ago
that is planned
barnabynagy
barnabynagy5mo ago
When?
Brody
Brody5mo ago
sorry i dont have an eta for that
barnabynagy
barnabynagy5mo ago
For now, I set up a recurring calendar entry to remind me to export my posts and members. Back to 1980 with a 2024 system. And that does not include images, just the database and settings I need to back up my files too
Brody
Brody5mo ago
for sqlite and files on a volume you would need to use filebrowser
barnabynagy
barnabynagy5mo ago
So I need to disconnnect volume, connect to filebrowser, download files, disconnect volume, connect back in
Brody
Brody5mo ago
yep that's about the process
Brody
Brody5mo ago
I share your pain, it is far from ideal
barnabynagy
barnabynagy5mo ago
I wonder what were the maker of railway thinking when making this. Let's create the best ever easy to scale 1 click install system but let's not do 1 click backups...
Brody
Brody5mo ago
it simply hasn't been implemented yet. but please keep a friendly tone railway will implement one click volume snapshots at some point, and they will implement an easy way to browse the volume
barnabynagy
barnabynagy5mo ago
How do you know? Are you saying my tone wasn't friendly?
Brody
Brody5mo ago
because they have talked about it
barnabynagy
barnabynagy5mo ago
You know it because they have talked about it? 🙂 Would it be possible to change the ghost code to accept another email sender API apart from mailgun? And if so how much work is involved?
Brody
Brody5mo ago
yes they have, https://blog.railway.app/p/launch-01-next-gen-databases#next-gen-databases
In the future, we plan to add native support for database backups and high availability by following the same pattern: Add the primitives that can be used by anyone.
this would come in the form of volume snapshots you would need to deploy from a github repo with the ghost source code, i dont know how much work that would involve, i have not done it myself
barnabynagy
barnabynagy5mo ago
Ah blog post Ok, I see
Want results from more Discord servers?
Add your server
More Posts