Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-41804

Missing permissions for sitestats User Activity feature

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 20.0
    • Fix Version/s: 20.0
    • Component/s: Sitestats
    • Labels:
      None
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      After merging SAK-40018 the following appeared in the startup logs:

       

      16-May-2019 08:56:06.003 WARN [main] org.sakaiproject.db.impl.BasicSqlService.dbWriteCount Sql.dbWrite(): error code: 1048 sql: INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from SAKAI_REALM where REALM_ID = '!site.template'), (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = 'access'), (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = 'sitestats.usertracking.be.tracked')) binds: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'FUNCTION_KEY' cannot be null

      Looks as though some permissions were not added:

       

      sitestats.usertracking.track
sitestats.usertracking.be.tracked

      I've added them to the mysql, oracle, and hsqldb scripts.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

              depends on

              Feature Request - Functionality that you would like to see in Sakai. SAK-40018 Add feature to display detailed user activity in Sitestats

              • Major - Major loss of function or need for functionality in production in the near future.
              • RESOLVED

                Activity

                  People

                  Assignee:
                  ern Earle R Nietzel
                  Reporter:
                  ern Earle R Nietzel
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration