Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-26228

Update AO to 0.17.2.5 to fix AO-204

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Low
    • 4.4.4
    • 4.4.3
    • None

    Description

      The easiest way to test:

      1. 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.
      2. Connect JIRA to Oracle as this user. We do this to get JIRA to create all its tables.
      3. Install the jira-func-test plugin.
      4. 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.
      5. Run curl -u <username>:<password> <root>/rest/func-test/latest/blog to see if the data is there.
      6. Stop JIRA.
      7. Create an Oracle user called "safeuser" with DELETE ANY TABLE, INSERT ANY TABLE, SELECT ANY SEQUENCE, SELECT ANY TABLE, UNLIMITED TABLESPACE, UPDATE ANY TABLE
      8. Configure dbconfig.xml with username = safeuser, password = <password> and schema-name = JIRA2 (capitals a must).
      9. Start JIRA.
      10. 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.

      REF: https://studio.atlassian.com/browse/AO-204

      Attachments

        Activity

          People

            rsmart metapoint
            bbain bain
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: