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

Oracle security service busted

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 11.0
    • Fix Version/s: 11.0
    • Component/s: Kernel
    • Labels:
      None
    • Previous Issue Keys:
      KNL-1388

      Description

      Hi there,

      Since the patch for SAK-29401 got merged, it seems that the security
      service is broken under Oracle. You can see this on
      https://trunk-oracle.nightly.sakaiproject.org if you create a regular
      user and try logging in: no error gets logged, but you get back a page
      like:

      Session
      
      no session established
      
      no tool session established
      
      Unknown Request
      
      Snoop for request
      
      ${req.toString()}
      Request headers
      
      Servlet parameters (Single Value style):
                          
      Servlet parameters (Multiple Value style):
                          
      Request Attributes:
      

      After some digging through the code, we noticed that
      org/sakaiproject/authz/impl/DbAuthzGroupSqlOracle.java has its own
      implementation of getCountRealmRoleFunctionSql that wasn't updated as
      a part of the changes under SAK-29401. I've attached a patch that
      attempts to bring it back into line (and added an @Override annotation
      to stop future similar omissions)

      Cheers,

      Mark

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  buckett Matthew Buckett
                  Reporter:
                  marktriggs Mark Triggs
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration