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; } } }

I can not log in with admin.

Willam Won

I can not log in with admin.aa.PNG

aa.PNG

Accepted answers

All comments

Nic Brough -Adaptavist-

You've exceeded the attempts to log in with incorrect details. You'll need to use "forgot your password" to retrieve some details, or get one of your other admins to reset the account for you.

Alejandro Conde Carrillo

Hi William.

If you forgot your admin password, you can follow the procedure in Restoring Passwords To Recover Admin User Rights.

Willam Won

Originally also it can login , but i did nothing, i don't know what happened leading it can't login,the password didn't change.

Willam Won

By the way, admin is the only account for admins.

Willam Won

i can't connect hsql with DbVisualizer,The confluence server installed in linux,how to connect hsql?

Nic Brough -Adaptavist-

Ah, well, that's actually really easy to fix. Throw away your installation and re-install it. HSQL is not used in production, so you haven't got anything in your Confluence you really need, and it's nice to get a clean stable re-installation every now and then for dev/test.

Willam Won

But now embeded HSQL is used in production,how to migrate to other database such as MySql.

Nic Brough -Adaptavist-

Right. What I would do here:

Sack the person who allowed HSQL to be used in production - Why have all the warnings in the documentation, the installation and the admin screens been ignored? The reason HSQL is not used in production is that it can fail, spectacularly and without warning. You can lose chunks of data or the whole lot in one go without ever finding any reason why. Mostly, it doesn't. Sometimes, it does and you usually end up having to start from scratch, having lost everything. <end rant>
Stop Confluence
Find the file called "database.script"
Take a copy of it and put it somewhere safe
Open the page that Alex Conde pointed you to earlier - that has instructions on setting the password in the database, and you'll need the password stuff from it
Open the database.script file in a TEXT editor (don't try to use an IDE or a word processor, they might try to be clever, you must load and save this as text)
Somewhere in it, you will find a line like: INSERT INTO CWD_USER VALUES(10000,1,'admin','admin',1,'2011-07-01 12:23:16.808000000','2011-07-01 12:23:16.808000000','','','','','admin','admin','admin@example.com','admin@example.com','{PKCS5S2}WRcV6qyUqFl6rlpHFfVakNvc7RPu2XLkk+jSGHlnnOhcj0NowWUPH8Z0RcZSSP2O',NULL)
You need to change that line in your file so that the password and number of login attempts are set according to what the docmentation says - your file may have different values for id, username and so-on, do NOT amend them - you're only interested in the password hash and the number of failed attempts to log in.
Restart Confluence
Export the data to xml
Shut down Confluence
Put it on a supported database
Import the XML
Let the users back in

If steps 2 - 9 do not work, then the next option is to stop Confluence, and dig up the regular exports it makes by default (if you have the automatic backups enabled), and rebuild Confluence from that. If you don't have that enabled, then you should look for the backups of the database.script you should have been taking - you can simply put an older version over the current one. Then you can try to merge any changes that were in database.script, but the amount of rescuable data depends on how damaged the database is.

If none of those work, then I'm afraid your next option is to get your users to export anything they can see in their spaces to XML and import them into a new Confluence.

Willam Won

i can't find file called "database.script", only find the file called "confluencedb.properties".

Nic Brough -Adaptavist-

I'm terribly sorry, I was thinking of JIRA hsql there, and got confuddled. Look for a file called confluencedb.script not database.script.

Nic Brough -Adaptavist-

Check the whole installation too - it seems to wander around in different systems. Sometimes it's under the "home" directory for the application, in others the whole dataset lives under home/database

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

confluence-administration