Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8888

Redo log encrypion does not seam to work when enabling after installing

    Details

      Description

      Redo log encryption does not seem to work. We enabled it after the installation. Inserting a string into an encrypted table showed up in the redo log using 'strings' command.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              Hide
              elenst Elena Stepanova added a comment - - edited

              Michaël de groot,

              Please provide your configuration (cnf files), data structure, INSERT that you are running and the string that you find in the InnoDB logs.

              Here is an example of my results (could not reproduce the problem so far):

              New server started with innodb_encrypt_log=1
              MariaDB [test]> select @@innodb_encrypt_log;
              +----------------------+
              | @@innodb_encrypt_log |
              +----------------------+
              |                    1 |
              +----------------------+
              1 row in set (0.00 sec)
              
              MariaDB [test]> create table t1 (pk int primary key, c varchar(256)) engine=InnoDB;
              Query OK, 0 rows affected (0.58 sec)
              
              MariaDB [test]> insert into t1 values (1,'foobar1');
              Query OK, 1 row affected (0.10 sec)
              
              MariaDB [test]> system strings data/ib_logfile* | grep foobar1
              
              Server is restarted with innodb_encrypt_log=0
              MariaDB [test]> select @@innodb_encrypt_log;
              +----------------------+
              | @@innodb_encrypt_log |
              +----------------------+
              |                    0 |
              +----------------------+
              1 row in set (0.01 sec)
              
              MariaDB [test]> create table t2 (pk int primary key, c varchar(256)) engine=InnoDB;
              Query OK, 0 rows affected (0.61 sec)
              
              MariaDB [test]> insert into t2 values (1,'foobar2');
              Query OK, 1 row affected (0.10 sec)
              
              MariaDB [test]> system strings data/ib_logfile* | grep foobar2
              foobar2
              
              Server is restarted again with innodb_encrypt_log=1
              MariaDB [test]> select @@innodb_encrypt_log;
              +----------------------+
              | @@innodb_encrypt_log |
              +----------------------+
              |                    1 |
              +----------------------+
              1 row in set (0.00 sec)
              
              MariaDB [test]> create table t3 (pk int primary key, c varchar(256)) engine=InnoDB;
              Query OK, 0 rows affected (0.57 sec)
              
              MariaDB [test]> insert into t3 values (1,'foobar3');
              Query OK, 1 row affected (0.14 sec)
              
              MariaDB [test]> system strings data/ib_logfile* | grep foobar3
              
              Show
              elenst Elena Stepanova added a comment - - edited Michaël de groot , Please provide your configuration (cnf files), data structure, INSERT that you are running and the string that you find in the InnoDB logs. Here is an example of my results (could not reproduce the problem so far): New server started with innodb_encrypt_log=1 MariaDB [test]> select @@innodb_encrypt_log; +----------------------+ | @@innodb_encrypt_log | +----------------------+ | 1 | +----------------------+ 1 row in set (0.00 sec) MariaDB [test]> create table t1 (pk int primary key, c varchar(256)) engine=InnoDB; Query OK, 0 rows affected (0.58 sec) MariaDB [test]> insert into t1 values (1,'foobar1'); Query OK, 1 row affected (0.10 sec) MariaDB [test]> system strings data/ib_logfile* | grep foobar1 Server is restarted with innodb_encrypt_log=0 MariaDB [test]> select @@innodb_encrypt_log; +----------------------+ | @@innodb_encrypt_log | +----------------------+ | 0 | +----------------------+ 1 row in set (0.01 sec) MariaDB [test]> create table t2 (pk int primary key, c varchar(256)) engine=InnoDB; Query OK, 0 rows affected (0.61 sec) MariaDB [test]> insert into t2 values (1,'foobar2'); Query OK, 1 row affected (0.10 sec) MariaDB [test]> system strings data/ib_logfile* | grep foobar2 foobar2 Server is restarted again with innodb_encrypt_log=1 MariaDB [test]> select @@innodb_encrypt_log; +----------------------+ | @@innodb_encrypt_log | +----------------------+ | 1 | +----------------------+ 1 row in set (0.00 sec) MariaDB [test]> create table t3 (pk int primary key, c varchar(256)) engine=InnoDB; Query OK, 0 rows affected (0.57 sec) MariaDB [test]> insert into t3 values (1,'foobar3'); Query OK, 1 row affected (0.14 sec) MariaDB [test]> system strings data/ib_logfile* | grep foobar3

                People

                • Assignee:
                  jplindst Jan Lindström
                  Reporter:
                  michaeldg Michaël de groot
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated: