Details
-
Bug
-
Resolution: Fixed
-
Low
-
4.4.3
-
None
-
4.04
-
Description
The easiest way to test:
- Create and Oracle user "JIRA2". Note this user cannot be JIRA because of another bug (
JRA-26189). Ensure this user has CREATE TABLE, UNLIMITED TABLESPACE,CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE VIEW. - Connect JIRA to Oracle as this user. We do this to get JIRA to create all its tables.
- Install the jira-func-test plugin.
- Run curl -u <username>:<password> -X POST --data '{"text":"text", "author":"author"}' -H "Content-Type: application/json" <root>/rest/func-test/latest/blog. This will add an AO object to the database and create any tables.
- Run curl -u <username>:<password> <root>/rest/func-test/latest/blog to see if the data is there.
- Stop JIRA.
- Create an Oracle user called "safeuser" with DELETE ANY TABLE, INSERT ANY TABLE, SELECT ANY SEQUENCE, SELECT ANY TABLE, UNLIMITED TABLESPACE, UPDATE ANY TABLE
- Configure dbconfig.xml with username = safeuser, password = <password> and schema-name = JIRA2 (capitals a must).
- Start JIRA.
- Run curl -u <username>:<password> <root>/rest/func-test/latest/blog. Should return the item you created above. If it returns a 500 error, then the problem still exists.