Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Fix for "cannot add user, all the user directories are read-only" issue. Edited

I'm not sure if this is the right place to post this as I have answered my own question but I'm writing this in the hope that it might save someone else from wasting a whole day, as I have just done.

I'm evaluating Jira and have been trying to set it up with a MySQL database. I kept getting stuck with the "cannot add user, all the user directories are read-only" error when trying to set it up and create the administrator user. I spent the entire day trying all the fixes I could find on-line with no success. I eventually found the following solution that I haven't seen documented anywhere.

I have been following the instructions here https://confluence.atlassian.com/adminjiraserver073/connecting-jira-applications-to-mysql-861253043.html and at step 2.1 there is a link to go to the MySQL website and download the JDBC Connector/J 5.1 http://dev.mysql.com/downloads/connector/j When you go to this link there is a message saying

"MySQL Connector/J 8.0 is highly recommended for use with MySQL Server 8.0, 5.7, 5.6, and 5.5. Please upgrade to MySQL Connector/J 8.0."

I'm using MySQL 5.7 so, foolishly, I believed this and installed JDBC Connector/J 8.0. This led to me getting the "cannot add user, all the user directories are read-only" error during Jira setup when trying to create the administrator user. After trying the solutions from many  messages online about this problem with no luck I finally went back to the MySQL website, clicked on "Looking for previous GA versions?" and downloaded and installed the old JDBC connector "Connector/J 5.1.47".

I restarted the Jira service and everything worked perfectly after that.

Windows 7
Jira 7.12.1
MySQL 5.7.22
Java 1.8.0_171

5 answers

0 votes
Andy Heinzer Atlassian Team Oct 23, 2018

Hi Roger,

Thanks for reporting this.  I had believed we already updated this documentation to use the more explicit link to the 5.1 jdbc driver, but it appears you found the Jira 7.3.x docs that have not been updated yet.   I will file a request with my documentation team to fix this on all the versions of this document. 

The current doc https://confluence.atlassian.com/display/ADMINJIRASERVER/Connecting+Jira+applications+to+MySQL

Does have the correct link of https://dev.mysql.com/downloads/connector/j/5.1.html

Thanks again

Andy

Thanks for your quick reply

 

- Roger

Thanks for this post. It saved me a ton of time and worked beautifully. I'm using Jira 7 and MySql 5.6

This same problem, "cannot create admin user all user directories are read-only", takes many forms. I

In my case, with Postgres 11 with Jira 8 on MacOS my problem was that I had not separated the atlassian-jira directory out into a place that is owned by the installer.

By moving that directory and properly configuring jira-application-properties and then running startup.sh from the install directory, I was able to get setup to move past this point of "cannot create admin user all user directories are read-only"

This is for my own personal eval install, not for production of course.

Simply use mysql-connector-java-5.1.47 instead of mysql-connector-java-8.0.15

 

Cheers+

Laser

0 votes

I have the same issue with H2 internal database.

Cannot add user, all the user directories are read-only.

The error means that your database haven't been properly configured. To do that, all you need to hit the home page first before creating the admin account and follow the redirects (/secure/SetupMode!default.jspa and /secure/SetupDatabase!default.jspa).

Related: https://community.atlassian.com/t5/Jira-Core-questions/java-lang-RuntimeException-javax-servlet-ServletException-java/qaq-p/1580242

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you