How To I access shell?
phankamsi
PROOP

a month ago

sqlite3 /data/oi_engine.db "ALTER TABLE signals ADD COLUMN funding_rate_1h REAL DEFAULT NULL;

How do I run this function

$20 Bounty

6 Replies

Railway
BOT

a month ago

You can run that command inside your service container using railway ssh from the Railway CLI, which opens an interactive shell session where you can execute commands directly.


Status changed to Awaiting User Response Railway about 1 month ago


Status changed to Awaiting Railway Response Railway about 1 month ago


sam-a
EMPLOYEE

a month ago

Tell me more about the problem you are having still.


Status changed to Awaiting User Response Railway about 1 month ago


phankamsi
PROOP

a month ago

Subject: How to access data stored in a mounted volume

Hi Railway Support,

I have a Python worker service running on Railway with a persistent volume mounted at /data. The service writes to a SQLite database at /data/ppds.db.

I need to access and export this database file directly. My service plan does not include shell/console access.

Could you advise on the best way to:

1. Access files stored in a mounted volume

2. Export or download the SQLite database file

Any guidance would be appreciated.

Thank you


Status changed to Awaiting Railway Response Railway about 1 month ago


Railway
BOT

a month ago

This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.

Status changed to Open Railway about 1 month ago


domehane
FREE

a month ago

Hello phankamsi,

since you can't access the shell directly , the workaround is to deploy the filebrowser template into your existing railway project (not a new one), before doing anything make sure to remove the active deployment on your worker first otherwise it may try to write to a non-existent volume, then detach the volume from your worker and attach it to filebrowser, also make sure to set use_volume_root=1 as an env variable on filebrowser so it can see your files at /data, then just open the filebrowser url, log in and download your ppds.db straight from the browser, once done detach from filebrowser reattach to your worker and redeploy. heads up your worker will be down during this so plan for a few minutes of downtime

template here: https://railway.com/deploy/Nan7Bs

hope this help you :)


phankamsi

Subject: How to access data stored in a mounted volume Hi Railway Support, I have a Python worker service running on Railway with a persistent volume mounted at /data. The service writes to a SQLite database at /data/ppds.db. I need to access and export this database file directly. My service plan does not include shell/console access. Could you advise on the best way to: 1\. Access files stored in a mounted volume 2\. Export or download the SQLite database file Any guidance would be appreciated. Thank you

(All plans have shell access)


0x5b62656e5d

(All plans have shell access)

domehane
FREE

a month ago

yes, exactly i was wondering why he said he had no access


Welcome!

Sign in to your Railway account to join the conversation.

Loading...