未知变量“file-key-management-filename”

Question

Debian 10的新安装，带有MariaDB 10.3.29。试图设置加密程序，但由于错误，MariaDB无法启动.

2021-07-16 17:13:16 0 [Note] InnoDB: Using Linux native AIO
2021-07-16 17:13:16 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-07-16 17:13:16 0 [Note] InnoDB: Uses event mutexes
2021-07-16 17:13:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-16 17:13:16 0 [Note] InnoDB: Number of pools: 1
2021-07-16 17:13:16 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-16 17:13:16 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-07-16 17:13:16 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-16 17:13:16 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-07-16 17:13:17 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-16 17:13:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-16 17:13:17 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-16 17:13:17 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-07-16 17:13:17 0 [Note] InnoDB: Waiting for purge to start
2021-07-16 17:13:17 0 [Note] InnoDB: 10.3.29 started; log sequence number 2195357; transaction id 575
2021-07-16 17:13:17 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2021-07-16 17:13:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-16 17:13:17 0 [ERROR] /usr/sbin/mysqld: unknown variable 'file-key-management-filename=/etc/openssl/keys/keyfile.key'
2021-07-16 17:13:17 0 [ERROR] Aborting

我的server.cnf已经。

[mariadb-10.3]
plugin-load-add = file_key_management
file_key_management_filename = /etc/openssl/keys/keyfile.key
file_key_management_encryption_algorithm = AES_CTR

上面的配置是我在Centos7系统中使用的，所以我很困惑为什么它不能在Debian10上工作。这条消息是我试图在没有加密选项的MariaDB pre-10.1版本中安装加密时遇到的，但是我知道加密是MariaDB10.1之后的一个选项，所以它应该可以在这个包中使用(通过apt进行不令人兴奋的安装)，对吗？我尝试过将cnf代码移动到米舍尔德和马里亚布部分，但没有结果。没有MariaDB的早期版本--这是一个干净的安装。

有没有人遇到过这个问题，已经解决了？

Answer 1

通过安装MariaDB 10.4解决了这个问题。不知道为什么10.3不能工作，但我检查了另一个运行10.3的debian10系统，这也是同样的问题。MariaDB 10.4似乎如预期的那样工作。