Trying to recover from server crash and install JIRA on new server. Everything went smoothly the config was able to confirm connectivity via the manual installation option, but right after we are getting this exception report ... Any ideas?
Currently have JIRA installed on intranet on 192.168.x.x on open ports 8090 and 8015.
type Exception report
description The server encountered an internal error that prevented it from fulfilling this request.
java.lang.NullPointerException com.atlassian.jira.web.filters.steps.instrumentation.InstrumentationStep.finallyAfterDoFilter(InstrumentationStep.java:39) com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:94) com.atlassian.jira.web.filters.JiraFirstFilter.doFilter(JiraFirstFilter.java:60)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.55 logs.
thanks for the quick reply Nic, I was thinking that this was "information enough". when I look though the logs, it appears that i don't have permission to create tables - i followed - I thought - the instructions to the letter. the only difference between this install and my previous one was that this install is using sql2012 vs sql2008. so maybe I need more detail on exactly what permissions i need to grant to who/whom so that JIRA can instantiate those tables.
Ah, create tables will be a problem with the database user. The easy thing to do is grant the database user full access to the database Jira is going to be using (not database system level, just the right to create tables, insert, delete, select, create indices and the rest). But it's all about the database access at this point.
thanks again Nic. I thought I had all of this squared away. It turned out that the jirauser was created without any permissions whatsoever (not even access permissions for the database?? I didn't remember this at all when i did this years ago. It seemed like the db_owner naturally had all the permissions for the database it created). Perhaps the install instructions should include this little nuance?? now for the 64$ question, i went into the security section for the database in management studio and gave the jirauser ALL permissions - and everything looks like its working. But does the jirauser really need any and all permissions turned on? do you know the minimum set of permissions that the jirauser needs? where are the permissions documented. thanks again Nic!
Most of the instructions I've seen include a "grant X to jirauser" in some form or another. But I don't use MS-SQL enough to remember them. If you can translate these from MySQL/PostGreSQL, then it should be fine for running JIRA with MS-SQL as well (I *think* they're mostly the same, but I wouldn't rely on my shonky memories around MS-SQL): * Select * Insert * Update * Delete * Create * Drop * Alter * Index That should give you a locked down minimal set of database permissions. You can actually go further after installation if you're not going to use certain plugins, and lock it down to just insert/update/select/delete, but I wouldn't do it, just in case you do decide to use plugins.
Anyway, thanks much for your help, all is well now.
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot