CWD_USER is empty

Александр Сутыркин

Hi! I need to reset the admin password for Jira. My Jira works on the Embedded H2 database. I use the official documentation and use the H2 client:

java -jar /opt/jira/atlassian-jira/WEB-INF/lib/h2-1.4.185.jar
and in browser http://localhost:8082

I specify the file as the database:
jdbc:h2:file:~/database/h2db (The config line in dbconfig.xml: <url>jdbc:h2:file:/opt/jira/jirasoftware-home/database/h2db</url>)

Next, I need to reset the administrator password through the SQL UPDATE request, but my table with users is empty.

SELECT COUNT(*) FROM CWD_USER;
--------
COUNT(*)
0

Jira continues to work, there are users in the system and they successfully log in, but the table CWD_USER is empty. Why?

P.S.
Sorry for my English.

Angélica Luz

Hi Александр Сутыркин,

Welcome to Atlassian Community!
Firstly I would like to clarify that the H2 embedded database is not supported for production environments. The H2 database is intended for testing of an application only.

The embedded H2 database is only supported while you are evaluating Confluence. You must migrate to a supported external database before using Confluence as a production system.

Further information on this may be found at Running the setup wizard.

The best option, in this case, is to migrate from H2 to a supported database.
- Supported platforms
- Switching databases

Also, can you please let us know if you are using the default Jira user directory or another user management like LDAP, AD, Crowd?
- Configuring user directories

We look forward to hearing back and let us know how the database migration goes.

Regards,
Angélica