Skip Navigation

Lemmy Support @lemmy.ml Lodion 🇦🇺 @lemmy.click 1y ago

Admin user email verification

I’ve hit an issue with Lemmy. Initial startup was fine… I created my admin user and logged in. Then I created this account.

Third account I went to test with failed to login… then my other accounts also failed, so I rebooted.

Now when I try to log into my admin account, it just spins forever. Checking logs, I see this:

lemmy_server::api_routes_websocket: email_not_verified: email_not_verified

Can anyone tell me how I can manually flag my admin account as having been email verified already?

18 comments

I was having the same issue. flipped "Email_verified" from 'f' to 't' in the "local_users" table and I'm able to log in with my admin account now. not sure what else may have been messed up in the process though.
- Thats what I figured... I just have no idea how to do it. Can you point me to any info on how to do that? :)
  
  Ok, figured it out myself. For anyone else that needs it..
  
  Run a shell within the postgres docker container:
  
  docker exec -it <sitename>_postgres_1 sh
  
  Connect to the postgres service:
  
  psql -U lemmy -h 127.0.0.1 -p 5432 -d lemmy
  
  Connect to the lemmy database:
  
  \c lemmy
  
  Then the user table: \d local_user
  
  Find the user ID of the account you want to manually toggle, probably #1:
  
  SELECT * from local_user;
  
  Then update the email_verified and _accepted_application flag on the first account:
  
  UPDATE local_user SET email_verified = 't', accepted_application = 't' WHERE id = 1;
  
  lemmy=# UPDATE local_user SET email_verified = 't', accepted_application = 't' WHERE id = 3; UPDATE 1 lemmy=# UPDATE local_user SET email_verified = 't', email_verified= 't' WHERE id = 3; UPDATE 1 lemmy=#

18 comments