Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1460

LP #1733283: pt-online-schema-change slave-user and slave-password ignored when recursion-method is dsn

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Iwo last update 20-11-2017 08:07:43

      Options --slave-user and --slave-password of pt-online-schema-change are ignored when --recursion-method is set to dsn.

      Step to reproduce:

      $ PTDEBUG=1 pt-online-schema-change --recursion-method dsn=t=percona.dsns --execute D=test,t=test,h=127.0.0.1,P=20594 --slave-user dupa123 --slave-pass test321 --user=root --password=msandbox --alter "ENGINE=InnoDB"

      [...]

      1. MasterSlave:4845 7838 SELECT dsn FROM `percona`.`dsns` ORDER BY id
      2. MasterSlave:4850 7838 DSN from DSN table: h=127.0.0.1,P=20595
      3. DSNParser:2241 7838 DSN string made from options: u=root,p=msandbox

      The workaround is to define slave user and slave password directly in dsns.

      Tested against pt-online-schema-change 3.0.4.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist