Railway•4mo ago

Need some help please!

Hi all, our site was working fine up till yesterday, now we can't get pass the login stage. Any ideas would be grateful. I've added a pic of the observability if that helps. Thank you

Solution:

You might still be using the old database connection, try reading this: https://docs.railway.app/guides/database-migration-guide#switching-over-connections...

Jump to solution

31 Replies

Percy•4mo ago

Project ID: N/A

carly7505•4mo ago

N/A

Solution

Fragly•4mo ago

You might still be using the old database connection, try reading this: https://docs.railway.app/guides/database-migration-guide#switching-over-connections

carly7505•4mo ago

I did the migration last week and it was all running and working after. Unless there's something else I haven't done. I have attached pic.

carly7505•4mo ago

Fragly•4mo ago

I'm pretty sure you're still using the old connection strings You'd want to read the link I sent you

carly7505•4mo ago

Hi sorry i'm still stuck. Where do I find the settings to change over the database. Unfortunately this was built by someone else who can no longer help. I've some computer knowledge but this is all new to me. Should I be looking in github or under the mycompass setting area in railway? Thank you

Brody•4mo ago

1. re-run the migration 2. update the variables in the variables tab of the mycompass service to the new database variables

carly7505•4mo ago

I've checked the variables in the mycompass tab, I can't see what's different. Is there anyone that we can pay to sort this service out for us? Thanks

Brody•4mo ago

have you re-ran the migration?

carly7505•4mo ago

do i delete and click this button

carly7505•4mo ago

Brody•4mo ago

yes that's the button you click

carly7505•4mo ago

hi i've tried that but nothing has changed, when go to the login page of the site it and press login it just click and nothing happens Any idea where I can look for a programmer to sort this out asap? thanks Hi anyone to help please

Brody•4mo ago

sorry I had to sleep as the last message I sent here was at 4:40am. if you add me to your railway project and github repo, I can make the necessary changes for you

carly7505•4mo ago

Oh amazing right so where do i add you?

Brody•4mo ago

add me to your repo, my username is brody192 add me to your railway project as an editor, my email is brodyover@gmail.com

carly7505•4mo ago

think i've done it

Brody•4mo ago

yeah I got the two emails, am I added as an editor to your railway project?

carly7505•4mo ago

should be admin now?

Brody•4mo ago

edit permissions is the highest you can give somebody unless you add them to the pro workspace, so as long as I'm an editor then that's good I just woke up not too long ago, will start looking into what you have going on shortly when I'm at my computer

carly7505•4mo ago

brilliant thank so much, yeah it was choice between admin or member so added you as admin, hopefully thats right

Brody•4mo ago

if you added me as an admin than that likely means you just paid (or will pay) 20$ for my seat on your team

carly7505•4mo ago

Found it added you within the project and the setting is can edit

Brody•4mo ago

where you charged? i haven't joined the team

carly7505•4mo ago

no i dont think so but not too worried if it did

Brody•4mo ago

okay I'll join the project invite and not the team invite anyway, see if you can cancel the team invite though @carly7505 - i've updated the service variables and it looks like your app is back online

carly7505•4mo ago

Omg amazing thank you so much, can i pay you a fee for your service?

Brody•4mo ago

for context this is what i changed in your service variables

db_host=${{MySQL.MYSQLHOST}}
db_name=${{MySQL.MYSQLDATABASE}}
db_pass=${{MySQL.MYSQLPASSWORD}}
db_port=${{MySQL.MYSQLPORT}}
db_user=${{MySQL.MYSQLUSER}}

db_host=${{MySQL.MYSQLHOST}}
db_name=${{MySQL.MYSQLDATABASE}}
db_pass=${{MySQL.MYSQLPASSWORD}}
db_port=${{MySQL.MYSQLPORT}}
db_user=${{MySQL.MYSQLUSER}}

you should feel absolutely no need to pay me, but if you insist theres a BMAC link in my bio

carly7505•4mo ago

Thank you!!

Brody•4mo ago

thank you so much for the trains!! once you confirm your app is in perfect working order you can delete the legacy database

Gaming

Programming

Need some help please!