Briar Rose is a user on toot.cat. You can follow them or interact with them if you have an account anywhere in the fediverse. If you don't, you can sign up here.
Briar Rose @polymerwitch

if I want to update the email of a user manually (them typoed while registering) what is the best way to do that? What table holds the email addresses?

· Web · 4 · 2

@polymerwitch Looks like the users table does, but I can't vouch for whether any other table holds that data.

@SiliconValleySurvivor I'm not sure how that would affect federation

@polymerwitch definitely better to do this using the rails console than going directly to the DB

@benign I'm fairly new to rails. Is there a tutorial that would guide me down the right path?

@polymerwitch uhmmm yes though probably other people on here know better than I do what's good. maybe there's a railscast on it if you like video/screencast things?

however off the top of my head you probably wanna do something like

ssh into your server and go to where mastodon lives and then run

RAILS_ENV=production bundle exec rails c

which will give you the console then maybe

u = User.find_by_email('foo@bar.com')

then

u.password = 'newpassword'

then

u.save

@polymerwitch i'm sure if other people see what i've said here and something is wrong they will chime in (;