新安装 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 10.1 之前的版本中安装加密时遇到了此消息，该版本没有加密选项，但我知道加密是 Mariadb 10.1 之后的一个选项，因此它应该在此包中可用（通过 apt 进行简单的安装），对吗？我尝试将 cnf 代码移动到 [mysqld] 和 [mariadb] 部分，但无济于事。没有以前版本的 MariaDB 挂在那里 - 这是一个全新安装。
有谁遇到过这个问题并已经解决了吗？
答案1
通过安装 MariaDB 10.4 解决了这个问题。不确定为什么 10.3 无法正常工作，但我检查了另一个运行 10.3 的 debian10 系统，那里也有同样的问题。MariaDB 10.4 似乎按预期运行。