Login via Interal DB ot working

[Stewart Bradley]

Hi all,

I am running confluence 6.0 and have inherited this from a previous install. No one seems to have passwords, the LDAP does not seem to be working.

So I have tried to run through

https://confluence.atlassian.com/conf64/restore-passwords-to-recover-admin-user-rights-936511358.html

My confluence internal database is listed as priority  0

however no matter how many times i set the password to what it says in the document, or check the users are active and ok and admins

i still cannot log in with those users. Are there any logs i can check?

[Rambabu Patina {Appfire}]

Hi  @Stewart Bradley,

The Knowledge article you were referring does not work if,

• Confluence is configured for SSO through Crowd.
• You're using Confluence 3.4 or earlier.

As you are on Confluence 6.0, you could refer to the older documentation if you're still using OSUser or AtlassianUser. Hope this helps you.

Thanks,
Ram.

[Stewart Bradley]

Thanks,

running the commands from the AtlassianUser link

I can create the admin user

However when i run the :
SELECT * FROM groups;
SELECT * FROM users;

I only get the user i added and no groups show up for me to add the user to.

So i cant make this command work:

// Add group memberships into local_usersinsert into local_members (userid, groupid) values (<from select above for user>,<from_select_above_for_conf_users_group>);insert into local_members (userid, groupid) values (<from select above for user>,<from_select_above_for_conf_admin_group>);

Because no groups turn up to use the ID of

thanks