Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-4843

PRD 5.0 Encrypts JDBC Passwords Longer than 11 Characters Differently than PRD 4.8 Meaning PRPTs must be manually edited when migrating from 4.8 to 5.0

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 5.0.0 GA (5.0.0 GA Suite Release)
    • Fix Version/s: 6.0.0 GA
    • Component/s: Data Source, Engine
    • Labels:
      None
    • 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.

      Description

      PRD 5.0 encrypts JDBC connection passwords with a length longer than 11 characters differently than PRD 4.8. This means if you use a password longer than 11 characters you cannot migrate PRPTs from Pentaho 4.8 BI Server to Pentaho 5.0 BI Server. You must edit every PRPT during the migration and re-enter the password for the JDBC connection.

      Both PRD 4.8 and PRD 5.0 encrypt the password abcdefghijk as 520c4657510d0301045f41.

      However if you use the password abcdefghijkl then PRD 4.8 encrypts the password as 520c4657510d0301045f4183 and PRD 5.0 encrypts the password as 520c4657510d0301045f41ae. The last 2 characters of the encrypted password are different.

        Attachments

          Activity

            People

            • Assignee:
              sbolka Siarhei Bolka (Inactive)
              Reporter:
              cdeptula Chris Deptula
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: