nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Adding A User To The "System-Administrators" Group

Zebadiah Ramos

Hello!

I just recently completed the local install of Confluence, and I'm running into problems setting up our SMTP server for notifications. The issue is due to not having System Administration access (Currently no account is listed as having System Administrator access).

Are there any queries that I can run against the DB to verify that no on is in that group? If no one is in the group is there a query I can run that will add an existing user to the group?

Thank you for all of the help and please let me know if more information is needed!

Accepted answers

Mikael Sandberg

This should hopefully help you, https://confluence.atlassian.com/doc/restore-passwords-to-recover-admin-user-rights-158390.html

All comments

Mikael Sandberg

This should hopefully help you, https://confluence.atlassian.com/doc/restore-passwords-to-recover-admin-user-rights-158390.html

Zebadiah Ramos

Hello Mikael,

I tried going through this earlier, but I'm running into an issue after executing the below query.

update cwd_user set credential =
'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A=='
where id=1212121;

After running the query I attempt to login using username "admin" and the password "admin", but I'm receiving an incorrect password error and I'm also asked to type out a word now when attempting to log in.

Mikael Sandberg

Is your Confluence instance connected to AD or are you just using an internal user directory. If you are using multiple, did you do the step where it moved the internal directory to be first?

Zebadiah Ramos

Currently I'm just using the internal directory. It is linked to Jira Service Desk though, which is using Active Directory for authentication (not sure if this has any effect on Confluence authentication though).