Unable to login to Confluence

[James Malgieri]

We have JIRA 7.10.0 Server and Confluence.  I've been using JIRA for a while now and we had wanted to start using Confluence.  We installed Confluence, linked it to our SQL database and thought everything was working fine. At this time, I am am the only person who has used Confluence and made no modifications to it.

Yesterday I tried to login to Confluence but was not able to. When I type in localhost:8090  Confluence now appears with the SQL database user ID and Password already in the Username and Password fields. My Username and Password are not recognized and I see

Log in

The following error(s) occurred:

• Please re-enter your login details and type in the word below.

Does anyone have any suggestions to get into Confluence?

Since I have not used Confluence other than installing it,should I just removing Confluence from my server and from the SQL database and start over?

Thanks for your help.

Jim

[Deleted user]

Tried the solution posted above.  This led to the following problems

1. JAVA_HOME not set
2. JRE_HOME not set
3. Configure->Confluence Administration->Users & Security->Users

Shows approx. 130 users <= I have no idea where these "Users" came from

• If I try to delete a user
• There was an error during user deletion: com.atlassian.crowd.exception.InvalidAuthenticationException: Application failed to authenticate. Please check your log files for more details.

4. If I Click on "People"

• People Directory->People with Personal Spaces->All People
  1. 10 users + Recovery Admin User = 11
  2. Set User Password : <myAdminID>
     1. Failed to change user password. Check your server logs for more information

At this point I am totally fed up with Atlassian Confluence nonsense and am planning on deleting Confluence and its database.

For what it is worth, here's the log

Caused by: com.atlassian.crowd.exception.InvalidAuthenticationException: Application failed to authenticate

      at com.atlassian.crowd.integration.rest.service.RestExecutor$MethodExecutor.throwError(RestExecutor.java:524)

      at com.atlassian.crowd.integration.rest.service.RestExecutor$MethodExecutor.andCheckResponse(RestExecutor.java:456)

      at com.atlassian.crowd.integration.rest.service.RestCrowdClient.updateUser(RestCrowdClient.java:206)

      at com.atlassian.crowd.directory.RemoteCrowdDirectory.updateUser(RemoteCrowdDirectory.java:232)

      at com.atlassian.crowd.directory.DbCachingRemoteDirectory.updateUser(DbCachingRemoteDirectory.java:527)

      at com.atlassian.crowd.manager.directory.DirectoryManagerGeneric.updateUser(DirectoryManagerGeneric.java:350)

      at com.atlassian.crowd.manager.application.ApplicationServiceGeneric.updateUser(ApplicationServiceGeneric.java:581)

      at com.atlassian.crowd.embedded.core.CrowdServiceImpl.updateUser(CrowdServiceImpl.java:274)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

      at java.lang.reflect.Method.invoke(Method.java:498)

      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)

      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

      at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16)

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

      at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)

      at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)

      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)

      at com.sun.proxy.$Proxy90.updateUser(Unknown Source)

      at com.atlassian.confluence.user.crowd.CrowdDisabledUserManager.disableUser(CrowdDisabledUserManager.java:81)

[Brant Schroeder]

You can use this to recover your password.  It requires access to the SQL DB.

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

[Deleted user]

Hi Brant, I tried the solution at the link you provided butI'm now getting a JAVA_HOME and JRE_HOME not found error. 

I wasn't getting these errors previously when it was running as a service.

I'll try again tomorrow.

Jim