要約

This KB will help to change the email address of a local user in Confluence from Database when email updates can't be done via the UI.

ソリューション

• Run the following query for the user whose email you need to change

  • select * from cwd_user c
    inner join cwd_directory d
    on c.directory_id=d.id
    where user_name= 'name of the user' and d.directory_name='Confluence Internal Directory'

• Please ensure that you only have 1 result in the above query result.
• Update the email with the following query

  • update cwd_user set email_address = 'example@email.com', lower_email_address = 'example@email.com' 
    where id = (select c.id from cwd_user c
    inner join cwd_directory d
    on c.directory_id=d.id
    where user_name= 'name of the user' and d.directory_name='Confluence Internal Directory')
    
    

  • Replace the example@email.com with the correct email.
• Go to the Cache Management page.
• Scroll down the page and click on the Flush All button.
• Check the results. If the email wasn't changed, restart Confluence.

Please ensure that you only have 1 user with the 'name of the user' username or the email will be updated for all users with that username.