在RHEL 8上安装GEM MySQL2 -V 0.3.21的错误

Question

我正在将应用程序复制到新服务器，因为旧服务器已损坏，但是在尝试运行捆绑式安装时，GEM MySQL2无法安装。

[me@localhost redmine]$ gem install mysql2 -v 0.3.21
Building native extensions. This could take a while...
ERROR:  Error installing mysql2:
        ERROR: Failed to build gem native extension.

    current directory: /home/x-mwojciechow4/.rvm/gems/ruby-2.2.9/gems/mysql2-0.3.21/ext/mysql2
/home/x-mwojciechow4/.rvm/rubies/ruby-2.2.9/bin/ruby -I /home/x-mwojciechow4/.rvm/rubies/ruby-2.2.9/lib/ruby/site_ruby/2.2.0 -r ./siteconf20220613-3672195-xa12ap.rb extconf.rb
checking for ruby/thread.h... yes
checking for rb_thread_call_without_gvl() in ruby/thread.h... yes
checking for rb_thread_blocking_region()... no
checking for rb_wait_for_single_fd()... yes
checking for rb_hash_dup()... yes
checking for rb_intern3()... yes
-----
Using mysql_config at /usr/bin/mysql_config
-----
checking for mysql.h... yes
checking for errmsg.h... yes
checking for mysqld_error.h... yes
-----
Setting libpath to /usr/lib64/mysql
-----
creating Makefile

current directory: /home/x-mwojciechow4/.rvm/gems/ruby-2.2.9/gems/mysql2-0.3.21/ext/mysql2
make "DESTDIR=" clean

current directory: /home/x-mwojciechow4/.rvm/gems/ruby-2.2.9/gems/mysql2-0.3.21/ext/mysql2
make "DESTDIR="
compiling client.c
client.c: In function ‘nogvl_read_query_result’:
client.c:439:3: error: unknown type name ‘my_bool’; did you mean ‘bool’?
   my_bool res = mysql_read_query_result(client);
   ^~~~~~~
   bool
client.c: In function ‘_mysql_client_options’:
client.c:762:3: error: unknown type name ‘my_bool’; did you mean ‘bool’?
   my_bool boolval;
   ^~~~~~~
   bool
client.c:797:10: error: ‘MYSQL_SECURE_AUTH’ undeclared (first use in this function); did you mean ‘MYSQL_DEFAULT_AUTH’?
     case MYSQL_SECURE_AUTH:
          ^~~~~~~~~~~~~~~~~
          MYSQL_DEFAULT_AUTH
client.c:797:10: note: each undeclared identifier is reported only once for each function it appears in
client.c: In function ‘set_secure_auth’:
client.c:1185:38: error: ‘MYSQL_SECURE_AUTH’ undeclared (first use in this function); did you mean ‘MYSQL_DEFAULT_AUTH’?
   return _mysql_client_options(self, MYSQL_SECURE_AUTH, value);
                                      ^~~~~~~~~~~~~~~~~
                                      MYSQL_DEFAULT_AUTH
client.c:1186:1: warning: control reaches end of non-void function [-Wreturn-type]
 }
 ^
make: *** [Makefile:238: client.o] Error 1

make failed, exit code 2

Gem files will remain installed in /home/x-mwojciechow4/.rvm/gems/ruby-2.2.9/gems/mysql2-0.3.21 for inspection.
Results logged to /home/x-mwojciechow4/.rvm/gems/ruby-2.2.9/extensions/x86_64-linux/2.2.0/mysql2-0.3.21/gem_make.out

我注意到的第一个错误是“检查rb_thread_blocking_region（）... no“ - 否则我没有通过搜索搜索来找到任何有用的内容。

对我来说，保持相同的MySQL2版本很重要，因为这是一台测试服务器，因此我希望它尽可能接近生产服务器。

系统： RHEL 8.1 Ruby 2.2.9p480 铁轨4.2.7.1 MySQL 8.0.29 MySQL社区服务器-GPL

Answer 1

版本0.3.21中的MySQL2 GEM是 >使用MySQL 8.0。

因此，除非有任何实际问题，否则您应该更新宝石版本（无论是在测试和生产时）。 MySQL2 0.4.10（0.4.x的最后一个版本）应与您的导轨版本兼容，并支持MySQL 8.0。如果您还可以将Rails更新为至少4.2.11.3（您应该使用4.2.7.1版以来有很多安全修复程序），也可以使用MySQL2 0.5.x.。

无论如何，您提到的所有Ruby软件版本（即Ruby本身，Rails和MySQL2）都过时了，并且不再收到各自分支机构的任何更新。您应该投资将所有这些更新为新的支持版本。