lost password on confluence

[Aurelie Geoffroy]

Hi community, I lost my admin password to confluence. 

I dont know why because i use the same as before ... strange

I dont find a good tutorial that help me and an employee answers me to ask to the community . So I write this post

Thank.

[Aurelie Geoffroy]

try to connect at database

An error occurred while establishing the connection:

Long Message:
IO Exception: null [90028-195]

Details:
   Type: org.h2.jdbc.JdbcSQLException
   Error Code: 90028
   SQL State: 90028

[Shannon S]

Hello Aurelie,

Is  this related to your issue in recovering your password? You only need to perform the instructions that David recommended using the database if you're in a version earlier than Confluence 6.5.0.

Note that if you are still running Confluence on the embedded H2 database, it's not possible to connect directly to it in order to make modifications.

Can you let me know what you were doing at the time that you received this message?

Also please note that you should only ever use the H2 database if you are evaluating Confluence. It's not a sufficient database to run a working Confluence instance on, and easily become corrupt. At this point, unless you have a recent backup, it will be very difficult to recover Confluence.

Regards,

Shannon

[Davin Studer]

Have you seen this article? It talks about how to reset your local admin password.

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

[Aurelie Geoffroy]

yes but i dont understand :S 

Is there an explanatory recording?

[Davin Studer]

The steps in this article will allow you to reset the admin password. What part don't you understand?

[Aurelie Geoffroy]

the part with database

[Davin Studer]

What version of Confluence are you on? If you are above 6.5 you don't need to do anything with the database.

[Aurelie Geoffroy]

• Atlassian Confluence 6.15.2
• for 10 users

[Davin Studer]

Ok, so you just need to follow steps 1-9 on the page I sent you to put Confluence into recovery mode so that you can reset the admin password. Once you've done that you bring it back out of recovery mode and continue on.

[Aurelie Geoffroy]

thank 

-Datlassian.recovery.password=<your-password> I put it before :end ??

[Davin Studer]

At the end of the setenv.sh (linux server) or setenv.bat (windows server) file you should see a section that has a bunch of statements that look like this ...

setenv.sh (linux)

CATALINA_OPTS="xxxx"

setenv.bat (windows)

set CATALINA_OPTS=xxxx

 You will add an entry that looks like this to the end of that block

setenv.sh (linux)

CATALINA_OPTS="-Datlassian.recovery.password=<your-password>"

setenv.bat (windows)

set CATALINA_OPTS=-Datlassian.recovery.password=<your-password>

[tania_bernal_ssss_gouv_qc_ca]

. sorry wrong account 

[Aurelie Geoffroy]

No it dosent work !

Thank for help me but i i spend over 5 hours to try to recover :S 

I dont know if  I want to continue or give up

(ignore the last message)