Uploaded image for project: 'Opencast'
  1. MH-12411

Database user requires additional permissions

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed and reviewed
    • Affects versions: 4.0
    • Fix versions: 4.0
    • Labels:
      None
    • Severity:
      Incorrect Documentation
    • Steps to reproduce:
      Hide
      Steps to reproduce:
      1. Install Opencast 4.x (develop currently)
      2. Attempt to schedule an event
      3.
       
       Actual Results:
      Big stack traces:
      Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
      Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'opencast.TL_mh_assets_properties' doesn't exist
      Error Code: 1146
      Call: INSERT INTO TL_mh_assets_properties (id) SELECT t0.id FROM mh_assets_properties t0 WHERE ((t0.namespace = ?) AND t0.mediapackage_id IN (SELECT DISTINCT t1.mediapackage_id FROM mh_assets_snapshot t2, mh_ass
      ets_properties t1 WHERE ((t1.mediapackage_id = t2.mediapackage_id) AND ((t2.organization_id = ?) AND (t1.mediapackage_id = ?)))))
              bind => [3 parameters bound]
      Query: DeleteAllQuery(referenceClass=PropertyDto sql="DELETE FROM TL_mh_assets_properties")
      [...]
       
       Expected Results:
      A scheduled event
       
       Workaround (if any):
       





      Show
      Steps to reproduce: 1. Install Opencast 4.x (develop currently) 2. Attempt to schedule an event 3.    Actual Results: Big stack traces: Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'opencast.TL_mh_assets_properties' doesn't exist Error Code: 1146 Call: INSERT INTO TL_mh_assets_properties (id) SELECT t0.id FROM mh_assets_properties t0 WHERE ((t0.namespace = ?) AND t0.mediapackage_id IN (SELECT DISTINCT t1.mediapackage_id FROM mh_assets_snapshot t2, mh_ass ets_properties t1 WHERE ((t1.mediapackage_id = t2.mediapackage_id) AND ((t2.organization_id = ?) AND (t1.mediapackage_id = ?)))))         bind => [3 parameters bound] Query: DeleteAllQuery(referenceClass=PropertyDto sql="DELETE FROM TL_mh_assets_properties") [...]    Expected Results: A scheduled event    Workaround (if any):  

      TestRail: Results

        Attachments

          Activity

            People

            • Assignee:
              greg_logan Greg Logan
              Reporter:
              greg_logan Greg Logan
            • Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                TestRail: Cases