Mysql2 module issue after upgrading from Najdorf to Oparin

[rabah-beldi]

Hello,

I have the following error when loading Mysql module after upgrading.

Oct 6 11:40:22 XXXX automation[2685]: ERROR – automation: Q-task_id([r9361_service_template_provision_task_9939]) LoadError: libruby.so.2.7: cannot open shared object file: No such file or directory - /usr/local/lib64/gems/ruby/mysql2-0.5.4/mysql2/mysql2.so
Oct 6 11:40:22 XXX automation[2685]: ERROR – automation: Q-task_id([r9361_service_template_provision_task_9939]) internal:/usr/share/rubygems/rubygems/core_ext/kernel_require.rb:85:in require'#012<internal:/usr/share/rubygems/rubygems/core_ext/kernel_require.rb>:85:in require'#12/usr/local/share/gems/gems/mysql2-0.5.4/lib/mysql2.rb:36:in <top (required)>'#012<internal:/usr/share/rubygems/rubygems/core_ext/kernel_require.rb>:160:in require'#12internal:/usr/share/rubygems/rubygems/core_ext/kernel_require.rb:160:in rescue in require'#012<internal:/usr/share/rubygems/rubygems/core_ext/kernel_require.rb>:149:in require'
Oct 6 11:40:22 XXX automation[2685]: ERROR – automation: Method STDERR: internal:/usr/share/rubygems/rubygems/core_ext/kernel_require.rb:85:in require': libruby.so.2.7: cannot open shared object file: No such file or directory - /usr/local/lib64/gems/ruby/mysql2-0.5.4/mysql2/mysql2.so (LoadError) Oct 6 11:40:22 XXXX automation[2685]: ERROR – automation: Method STDERR: from <internal:/usr/share/rubygems/rubygems/core_ext/kernel_require.rb>:85:in require'
Oct 6 11:40:22 XXXX automation[2685]: ERROR – automation: Method STDERR: from /usr/local/share/gems/gems/mysql2-0.5.4/lib/mysql2.rb:36:in <top (required)>' Oct 6 11:40:22 XXXX automation[2685]: ERROR – automation: Method STDERR: from <internal:/usr/share/rubygems/rubygems/core_ext/kernel_require.rb>:160:in require'
Oct 6 11:40:22 XXXX automation[2685]: ERROR – automation: Method STDERR: from internal:/usr/share/rubygems/rubygems/core_ext/kernel_require.rb:160:in rescue in require' Oct 6 11:40:22 XXXX automation[2685]: ERROR – automation: Method STDERR: from <internal:/usr/share/rubygems/rubygems/core_ext/kernel_require.rb>:149:in require'
Oct 6 11:40:22 XXXX automation[2685]: ERROR – automation: Method STDERR: from /Custom/Integration/Centreon/Methods/CreateCentreonUser:7:in <main>' Oct 6 11:40:22 XXXX automation[2685]: ERROR – automation: Method STDERR: <internal:/usr/share/rubygems/rubygems/core_ext/kernel_require.rb>:85:in require': cannot load such file – mysql2 (LoadError)
Oct 6 11:40:22 XXXX automation[2685]: ERROR – automation: Method STDERR: from internal:/usr/share/rubygems/rubygems/core_ext/kernel_require.rb:85:in `require'

Here's the upgrade procedure for my case:

1. diactiver les repo epel

2. dnf update

3. systemctl stop evmserverd

4. systemctl status evmserverd

5. dnf install https://rpm.manageiq.org/release/15-oparin/el8/noarch/manageiq-release-15.0-1.el8.noarch.rpm

6. pg_dumpall -c --if-exists | gzip > vmdb.pg.gz; ls -l vmdb.pg.gz

7. systemctl stop postgresql

8. rm -rf $APPLIANCE_PG_DATA

9. dnf module list |egrep 'ruby|postgresql'

10. dnf -y module reset postgresql && dnf -y module enable postgresql:13

11. dnf -y module reset ruby && dnf -y module enable ruby:3.0

12. dnf install centos-release-stream

13. dnf swap centos-{linux,stream}-repos

14. dnf distro-sync

15. dnf autoremove

16. appliance_console_cli --internal --standalone --password XXXXX

17. gunzip < ./vmdb.pg.gz | psql postgres

18. rake db:migrate && rake evm:automate:reset ;date

19. systemctl start evmserverd

the file existe mysql2.so:
ll /usr/local/lib64/gems/ruby/mysql2-0.5.4/mysql2/mysql2.so
-rwxr-xr-x. 1 root root 378800 Nov 17 2022 /usr/local/lib64/gems/ruby/mysql2-0.5.4/mysql2/mysql2.so

Mysql2 version:
gem list | grep mysql
mysql2 (0.5.4)

Has anyone encountered the same issue?
Could you help me resolve this problem?
Thank you in advance.

[rabah-beldi]

Hello,

I solved the problem by uninstalling and reinstalling the mysql2 gem.