Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-5919

Setup should display error when database user does not have permissions to create tables

XMLWordPrintable

      The Setup doesn't display an error message when the user does not have permissions to create tables in the database. Instead it simply goes ahead to the next step to create a user and fails with the following exception:

      Cause:
      org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: Invalid object name 'os_user'.
      at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:85)
      caused by: java.sql.SQLException: Invalid object name 'os_user'.
      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)

      Stack Trace: [hide]

      org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: Invalid object name 'os_user'.
      java.sql.SQLException: Invalid object name 'os_user'.
      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
      at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
      at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
      at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)

      We should catch the lack of permissions earlier and display an appropriate error message.

            [CONFSERVER-5919] Setup should display error when database user does not have permissions to create tables

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2899877 ] New: CONFSERVER Bug Workflow v4 [ 2994481 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2794574 ] New: JAC Bug Workflow v3 [ 2899877 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2724869 ] New: JAC Bug Workflow v2 [ 2794574 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2388206 ] New: JAC Bug Workflow [ 2724869 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2264761 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2388206 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2208349 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2264761 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2189315 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2208349 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1924006 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2189315 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1726486 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1924006 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Bug Subtask WF (TEMP) [ 1683536 ] New: Confluence Workflow - Public Facing - Restricted v3 [ 1726486 ]

              Unassigned Unassigned
              jens@atlassian.com jens
              Affected customers:
              0 This affects my team
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: