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

Missing permissions for sitestats User Activity feature

    XMLWordPrintable

Details

    • Bug
    • Status: RESOLVED
    • Major
    • Resolution: Fixed
    • 20.0
    • 20.0
    • Sitestats
    • None
    • 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

              Activity

                People

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

                  Dates

                    Created:
                    Updated:
                    Resolved:

                    Git Integration