Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-32985

please provide SQL scripts to update a username directly inside the Confluence database confluence 5.4.3

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Answered
    • Icon: Highest Highest
    • None
    • 5.4.3
    • None

      please provide SQL scripts to update a username directly inside the Confluence database confluence 5.4.3 according:
      https://jira.atlassian.com/browse/CONF-4063
      We strongly need it for migration users with full history and owners into LDAP
      our local and LDAP usernames are different, and we need to migrate all data.
      Just renaming of usernames don't change full contents.

      –
      Thanks,
      Olga

            [CONFSERVER-32985] please provide SQL scripts to update a username directly inside the Confluence database confluence 5.4.3

            Olga Plisko added a comment -

            Hi Steve,

            I finished migration according the scripts.
            The script not exactly correct for Confluence 5.4.
            After migration I've got Anonymous on all Content and Contributors
            Unknown User (oldname1) 48 (21 days ago)
            ......
            Unknown User (oldmane2) 16 (22 days ago)

            Does this tool which you provided me don't miss something

            Thanks,
            Olga

            Olga Plisko added a comment - Hi Steve, I finished migration according the scripts. The script not exactly correct for Confluence 5.4. After migration I've got Anonymous on all Content and Contributors Unknown User (oldname1) 48 (21 days ago) ...... Unknown User (oldmane2) 16 (22 days ago) Does this tool which you provided me don't miss something Thanks, Olga

            Olga Plisko added a comment -

            Thanks Steve,

            Does it help also for Confluence 5.4 as well ?

            Kindly thank you for your help

            –
            OLga

            Olga Plisko added a comment - Thanks Steve, Does it help also for Confluence 5.4 as well ? Kindly thank you for your help – OLga

            Steve Haffenden (Inactive) added a comment -

            Hi Olga

            Thanks for taking the time to raise this issue. As of Confluence 5.3 we now support changing usernames as part of the user interface, you should be able to edit the user profile and update the username directly.

            For older versions of Confluence you'll need to use the techniques documented here:

            https://confluence.atlassian.com/display/CONF52/Changing+Usernames

            I hope that this helps

            Regards
            Steve Haffenden
            Confluence Bugmaster
            Atlassian

            Steve Haffenden (Inactive) added a comment - Hi Olga Thanks for taking the time to raise this issue. As of Confluence 5.3 we now support changing usernames as part of the user interface, you should be able to edit the user profile and update the username directly. For older versions of Confluence you'll need to use the techniques documented here: https://confluence.atlassian.com/display/CONF52/Changing+Usernames I hope that this helps Regards Steve Haffenden Confluence Bugmaster Atlassian

              shaffenden Steve Haffenden (Inactive)
              olga.plisko1 Olga Plisko
              Affected customers:
              0 This affects my team
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: