I have tried to log into Confluence with both the admin account and my account. I know both passwords and neither one of them are recognized. I have then download dbvisualizer 10.0.2 and have connected to my database located at C:\Program Files\Atlassian\Application Data\Confluence\database\h2db. I have followed along with the information provided as far as the connection type, Databse driver, h2 embedded, SA for database Userid, I have left the password blank and have connected to C:\Program Files\Atlassian\Application Data\Confluence\databaseh2db. When I run the following script, select u.id, u.user_name, u.active from cwd_user u join cwd_membership m on u.id=m.child_user_id join cwd_group g on m.parent_id=g.id join cwd_directory d on d.id=g.directory_id where g.group_name = 'confluence-administrators' and d.directory_name='Confluence Internal Directory'; I get an error stating that the Table "SWD_USER" not found; Sql statement:
I had thought that it may be how I was connecting, so I used DBeaver to see the database with some other program. I connect to the database and still receive the same error. Could you please let me know what others steps I need to do in order to get either my username or the admin password reset to something that I can log in with? Thank you
I understand you are having trouble logging into your Confluence instance using the Embedded H2 Database and following Restore Passwords To Recover Admin User Rights. The latter guide will help you change the admin password to "admin" and get logged in.
The error you report, " table SWD_USER not found" hints at the following possibilities:
select * from cwd_user;
I have used the guide Restore Passwords To Recover Admin User Rights many times with excellent results. If you run through the steps in order I am optimistic that you will get logged in.
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs