Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-5366

MySQL Connector column hash v2 does not work

    XMLWordPrintable

Details

    • False
    • None
    • False
    • Hide
      • In MySQL Connector config, specify hash v2 configuration:
        column.mask.hash.SHA-256.with.salt.salt123: redact\.redact\.redact 
      • redact.redact.redact column will not be hashed
      Show
      In MySQL Connector config, specify hash v2 configuration: column.mask.hash.SHA-256.with.salt.salt123: redact\.redact\.redact redact.redact.redact column will not be hashed

    Description

      In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.

      Bug report

      For bug reports, provide this information, please:

      What Debezium connector do you use and what version?

      MySQL Connector - v1.9.4

      What is the connector configuration?

       

          column.mask.hash.SHA-256.with.salt.salt123: redact\.redact\.redact
          database.exclude.list: information_schema,sys,mysql,performance_schema,redact    database.history.kafka.bootstrap.servers: kafka-cluster-kafka-bootstrap.kafka-cluster.svc.cluster.local:9092
          database.history.kafka.topic: schema-changes.redact-cloudsql-source-redact-connector-1656582369
          database.hostname: redact-cloudsql-proxy-auth.proxysql.svc
          database.user: kafka
          database.password: redact
          database.port: "3306"
          database.server.id: "30086"
          database.server.name: redact-cloudsql-source-redact-connector-1656582369
          name: redact-cloudsql-source-redact-connector-1656582369
          time.precision.mode: connect
          topic.creation.default.cleanup.policy: delete
          topic.creation.default.compression.type: lz4
          topic.creation.default.max.message.bytes: "20971520"
          topic.creation.default.partitions: "3"
          topic.creation.default.replication.factor: "1"
          topic.creation.default.retention.bytes: "-1"
          topic.creation.default.retention.ms: "-1"
          transforms: route
          transforms.route.regex: ([^.]+)\.([^.]+)\.([^.]+)
          transforms.route.replacement: redact-$2.$3
          transforms.route.type: org.apache.kafka.connect.transforms.RegexRouter
        tasksMax: 1 

       

       

      What is the captured database version and mode of depoyment?

      MySQL 8.0 (CloudSQL on Google Cloud Platform)

      What behaviour do you expect?

      My column `redact.redact.redact` should be hashed using salted SHA-256

      What behaviour do you see?

      The column is in plaintext (not hashed)

      Do you see the same behaviour using the latest relesead Debezium version?

      (Ideally, also verify with latest Alpha/Beta/CR version)

      Yes, on latest LTS version (v1.9.4)

      Do you have the connector logs, ideally from start till finish?

      No.

      How to reproduce the issue using our tutorial deployment?

      In MySQL Connector config, specify hash v2 configuration:

      column.mask.hash.SHA-256.with.salt.salt123: redact\.redact\.redact 

      Attachments

        Activity

          People

            Unassigned Unassigned
            phongvq Phong Vu (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: