Weird behaviour of the Discourse/Peertube login method

[cyberboy666]

this is a known issue when your scanlines forum email changes/does not match the email used when the peertube account was created - in the past i have been fixing this manually on request - happy to do it for you both too.

heres the info on how to resolve it from a previous post:

Issues with changing email/username used on scanlines

a couple of people ( @pixelflowers @hypermosh ) have had issues (mostly on videos.scanlines.xyz) when they change the email or username used on the main scanlines forum this is due to the way single sign on works and the lack of flexibility to change user info on peertube (which i think is due to potential account hijacking if username changes on activtypub namespaces) i think it is possible to resolve these problems by making some changes in the database - although havnt got around to looking…

how to change email for user on peertube

• first ssh into the peertube machine (need to know ip and password for this - ssh root@<ip-address>)
• enter postgres sudo -u postgres psql
• connected to db: \l to list dbs, \c peertube_prod to connect
• \d to see tables , \d user to see columns for the user table
• UPDATE "user" SET email = '<new email>' WHERE "username" = '<user>';

NOTE:

if a duplicate peertube account was created when attempting to login from scanlines (ie cyberboy666-1 you may need to delete this account within the peertube admin ui first so that the email is avaliable to be changed to for main account)