Unable to login to Confluence

Question

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

unknown · Answer

Tried the solution posted above. This led to the following problems * JAVA_HOME not set * JRE_HOME not set * 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* 10 users + Recovery Admin User = 11 * Set User Password : * 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)

unknown · Answer

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

Brant Schroeder · Answer

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