How to remove LDAP repository

[Sergei Dorogin]

I added an LDAP and switch the order of user repositories. My bad I know.

But now I can't login as local admin into my Confluence as my LDAP contains a user 'admin'.

What can I do?

[Suren Raj · Accepted solution]

Hi Sergei,

This should do the trick and have at least you login with your local admin account. You need to move Internal directory into the first position:

• Step 3. Put the Internal Directory in First Position.

 Before running any SQL query, please do a full backup of your database, in case things goes sideways.

Cheers
Suren 

[Sergei Dorogin]

Thanks. But it looks like "Put the Internal Directory in First Position" assumes that I use External SQL DB but I don't. I'm on Embedded DB. How to restore the order in that case?

[Suren Raj]

Hi Sergei, I suggest you to install DB Visualizer and connect it with your embedded database. I suggest you to read below Documentation on how to connect Confluence embedded database with Db Visualizer. * https://confluence.atlassian.com/display/DOC/Connecting+to+HSQLDB+using+DBVisualizer+or+HSQL+database+manager

[Suren Raj]

After you connect the database and db visualizer, run the query in db visualizer

[Sergei Dorogin]

Thanks! I found INSERTs in confluencedb.log and swaped indeces in them: INSERT INTO CWD_APP_DIR_MAPPING VALUES(131073,65537,98305,'T',0) INSERT INTO CWD_APP_DIR_MAPPING VALUES(131074,65537,98306,'T',1) and it works now!