Admiral Patrick

Ask me anything.

  • 6 Posts
  • 58 Comments
Joined 2 years ago
cake
Cake day: June 6th, 2023

help-circle









  • I stopped Lemmy to run it, but that was because I had already stopped it to take a full backup first. I was also removing a very large, active community. I don’t think it was necessary, and I’ve removed other communities with Lemmy running. Just see the caveat about restarting Lemmy to make sure it “forgets” the community.

    The triggers will only be disabled for the run of that script in that session. So you don’t have to worry about turning them back on because they were never turned off for any other DB sessions.











  • The queue probably got cleared when the postfix container was recreated as it’s spool directories weren’t attached to a persistent volume .

    Probably the easiest would be to manually set email_verified to true in the local_user table for those users (basically assume the email addresses were correct).

    I don’t think there’s a way to re-trigger the email verification without going through the sign-up process, so your option #3 is likely what you’ll need to do.

    You could do one of the following if you don’t want to blanket-allow the existing signups:

    Option 1: Go into the email_verification table and get the email and local user ID to look up the account and send the verification token manually to them using the email account you configured with Lemmy:

    Subject:  Verify your email address for {your-domain}
    
    Please click the link below to verify your email address for the account @{username@your-domain}. Ignore this email if the account isn't yours.
    
    , [Verify your email](https://{your-lemmy-domain}/verify_email/{verification_token})
    

    Option 2: Note the username and email address from the local_user and person tables, delete those, and recreate the accounts for them. They’ll have to reset their passwords since you’ll have to set one on their behalf, but that should be manageable. Just make sure the password you set for them is completely random, complex, and very long (not sure if the length is still 60 characters or not).

    Option 3: Delete the records as in option 2 but send them an out-of-band email from your Lemmy address saying they’ll need to re-register.