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

        Smart Checklist

          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