http 500 Error right after config on new server

Question

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.

thanks all

..AJ

type Exception report

message

description The server encountered an internal error that prevented it from fulfilling this request.

exception

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.

aj senol · Answer

Hello Nic, yeah MSSQL is different alright.  The permissions listed are;

alter
controlcreate sequencedelete 
executeinsert
referencesselecttake ownershipupdateview change trackingview definition

The funny thing is that in the Server Management, when you examine the implied permissions - there are tabs for "explicit" and "effective" permissions.  The "effective permissions" were all there, but the explicit permissions were all missing.  I was thinking as dbo, the effective permissions were all I needed.  Apparently not.

I'm still not sure about how I got to a point where the user, which was the owner of the db did not have even one "explicit"permission whatsoever.  It has been a while since i first did this, and I don't remember having this kind of issue before.  On the installation instructions, do you remember where you saw a listing of the permissions?  i didn't see them in anything that i had about an SQL2012 install.Anyway, thanks much for your help, all is well now.

..AJ

Nic Brough -Adaptavist- · Answer

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.

aj senol · Answer

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!