Uploaded image for project: 'Build'
  1. Build
  2. BUILD-703

Database password encoding issue at install time

    XMLWordPrintable

Details

    • Bug
    • Resolution: Workaround exists
    • Neutral
    • None
    • BOM 5.7.19, BOM 6.2.20
    • None

    Description

      Steps to reproduce

      1. On a Magnolia 5.7.15 instance setup mysql configuration
      2. At jackrabbit-bundle-mysql-search.xml file, set the password Base64 encoded as explained here
      3. Start magnolia and check that the following error is thrown:

        Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

      Expected results

      The Magnolia instance starts normally

      Actual results

      Exception is thrown

      Workaround

      • Install Magnolia with a PersistenceManager setup not requiring a password
      • Once deployment is complete, switch to mysql with encoded password

      Development notes

      • Debugging shows that things actually blow at org.apache.jackrabbit.core.util.db.ConnectionHelper.getExtraNameCharacters(ConnectionHelper.java:185) since at that stage the password hasn’t been decoded yet
      • Looks like a JackRabbit issue, not Magnolia's.


      Slack https://magnolia-cms.slack.com/archives/CDF2T239Q/p1646124892266279

      Checklists

        Acceptance criteria

        Attachments

          Activity

            People

              fgrilli Federico Grilli
              ccantalapiedra Carlos Cantalapiedra
              Foundation
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: