Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-14835

Unable to find and assign system role (Authenticated) to access control after migrating from 4.x to 5.4.x

    XMLWordPrintable

    Details

    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Maintenance
    • Steps to Reproduce:
      Hide

      1. Configure a 4.x PDI server with Microsoft Active Directory(MSAD) authentication.
      2. Login with your MSAD credentials to create and save some contents such as (ktr/kjb) and a DB connection in the PDI repository.
      3. Stop the DI server and close spoon.
      4. Run export using the latest migrator tool.
      5. Run the import with the bundle from step 4 using the latest migrator tool on a 5.4.x (5.4.0.6 or 5.4.07).
      6. You will likely run into the issue described here BISERVER-11444, where the admin user doesn't have admin privileges after the migration. Please make the respective changes described on here BISERVER-11443 so the admin can get admin privileges.
      7. Log in to the 5.4.x repository with the admin user after migration and explore the repository.
      8. Go to the connections tab, click on a DB connection > click on the plus sign to add a role to the DB connections, you will notice that the "Authenticated" system role is no where to be found. The same behavior can be replicated if you go to the browse tab > click on a folder and apply security, you will notice that the Authenticated system role is not present.

      Expected Result: The "Authenticated" system role should be listed in the available roles list.
      Actual Result: The "Authenticated" system role is not listed.

      Show
      1. Configure a 4.x PDI server with Microsoft Active Directory(MSAD) authentication. 2. Login with your MSAD credentials to create and save some contents such as (ktr/kjb) and a DB connection in the PDI repository. 3. Stop the DI server and close spoon. 4. Run export using the latest migrator tool. 5. Run the import with the bundle from step 4 using the latest migrator tool on a 5.4.x (5.4.0.6 or 5.4.07). 6. You will likely run into the issue described here BISERVER-11444 , where the admin user doesn't have admin privileges after the migration. Please make the respective changes described on here BISERVER-11443 so the admin can get admin privileges. 7. Log in to the 5.4.x repository with the admin user after migration and explore the repository. 8. Go to the connections tab, click on a DB connection > click on the plus sign to add a role to the DB connections, you will notice that the "Authenticated" system role is no where to be found. The same behavior can be replicated if you go to the browse tab > click on a folder and apply security, you will notice that the Authenticated system role is not present. Expected Result: The "Authenticated" system role should be listed in the available roles list. Actual Result: The "Authenticated" system role is not listed.

      Description

      Authenticated system role is not listed after migrating from 4.x that was using MSAD (microsoft active directory) authentication to 5.4.x (5.4.0.6 or 5.4.0.7). Please see Steps to reproduce for more info.

        Attachments

          Activity

            People

            Assignee:
            upihin Uladzimir Pihin (Inactive)
            Reporter:
            gabellard Gregory Abellard
            Votes:
            2 Vote for this issue
            Watchers:
            12 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: