Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-4572

postinst maintainer script in percona-server-server-5.6 does not escape password properly

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Won't Fix
    • Affects Version/s: 5.6.40-84.0, 5.6.43-84.3
    • Fix Version/s: None
    • Component/s: Packaging
    • Labels:
      None

      Description

      Hello,

      I'm trying to install the percona-server-server-5.6 package on Ubuntu 16.04 using the Ubuntu 16.04 repository provided by Percona.

      We're preloading the mysql root password into debconf before installing, so it doesn't query for it. However, when using a password with double quotation marks ('"') in it, the postinst script fails to set the password:

      `ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';'") WHERE user='root';' at line 1`

      This error also occurs when providing the password manually at install time.

      The percona-server-server-5.7 package installs and sets the root password correctly, even when using a double quotation mark.

      Greetings
      Fabian

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              evgeniy.patlan Evgeniy Patlan
              Reporter:
              fniepelt Fabian Niepelt
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 6 hours
                  6h

                    Smart Checklist