Redmine

Hello,
After running "sudo bundle install" under Install gem Packages.

I get this error:
An error occurred while installing mysql2 (0.5.6), and Bundler cannot continue.

Is there something I could do to avoid this error?

Thank you

Thank you for your feedback.
This article does not include instructions for using MySQL.
You may need to install more packages and set up MySQL server.
I don't know how to do for MySQL, sorry.
RedmineInstall may help you.

That is what I was confused about. I started a VM from scratch and was using that article as a step-by-step guide, and for some reason, it gave me that error. I thought maybe I missed a step, so I started with a new VM, which still gave me that error. I felt that it didn't need MySQL but instead used PostgreSQL. I must be making some errors somewhere and will figure it out.
Thank you for your time and the article.

I apologize for misreading your initial message.
It's possible that there might be an error or something unclear in the instructions I provided.
I want to review the article.
Could you please paste the entire error message here that appears when "An error occurred while installing mysql2 (0.5.6), and Bundler cannot continue." occurs?

No problem. Here is what I have:

tester@server:/var/lib/redmine$ sudo bundle install
Don't run Bundler as root. Installing your bundle as root will break this application for all non-root users on this machine.
Fetching gem metadata from https://rubygems.org/.........
Resolving dependencies...
Fetching rake 13.2.1
Installing rake 13.2.1
Fetching base64 0.2.0
Fetching benchmark 0.4.0
Fetching bigdecimal 3.1.8
Fetching concurrent-ruby 1.3.4
Installing base64 0.2.0
Fetching connection_pool 2.4.1
Installing benchmark 0.4.0
Fetching drb 2.2.1
Installing bigdecimal 3.1.8 with native extensions
Installing concurrent-ruby 1.3.4
Installing connection_pool 2.4.1
Fetching logger 1.6.2
Installing drb 2.2.1
Installing logger 1.6.2
Fetching minitest 5.25.4
Fetching securerandom 0.4.0
Installing securerandom 0.4.0
Installing minitest 5.25.4
Fetching builder 3.3.0
Installing builder 3.3.0
Fetching erubi 1.13.0
Fetching racc 1.8.1
Fetching crass 1.0.6
Installing erubi 1.13.0
Fetching rack 3.1.8
Installing racc 1.8.1 with native extensions
Installing crass 1.0.6
Fetching useragent 0.16.11
Installing rack 3.1.8
Installing useragent 0.16.11
Fetching nio4r 2.7.4
Fetching websocket-extensions 0.1.5
Installing nio4r 2.7.4 with native extensions
Installing websocket-extensions 0.1.5
Fetching zeitwerk 2.7.1
Installing zeitwerk 2.7.1
Fetching timeout 0.4.2
Installing timeout 0.4.2
Fetching marcel 1.0.4
Installing marcel 1.0.4
Fetching mini_mime 1.1.5
Installing mini_mime 1.1.5
Fetching date 3.4.1
Installing date 3.4.1 with native extensions
Fetching stringio 3.1.2
Installing stringio 3.1.2 with native extensions
Fetching io-console 0.8.0
Installing io-console 0.8.0 with native extensions
Fetching thor 1.3.2
Installing thor 1.3.2
Fetching public_suffix 6.0.1
Installing public_suffix 6.0.1
Fetching chunky_png 1.4.0
Installing chunky_png 1.4.0
Fetching commonmarker 0.23.11
Installing commonmarker 0.23.11 with native extensions
Fetching csv 3.2.9
Fetching htmlentities 4.3.4
Installing csv 3.2.9
Fetching mini_magick 5.0.1
Installing htmlentities 4.3.4
Fetching mysql2 0.5.6
Installing mini_magick 5.0.1
Fetching net-ldap 0.17.1
Installing mysql2 0.5.6 with native extensions
Installing net-ldap 0.17.1
Fetching pg 1.5.9
Installing pg 1.5.9 with native extensions
Fetching rbpdf-font 1.19.1
Fetching rotp 6.3.0
Fetching rouge 4.5.1
Installing rotp 6.3.0
Fetching rqrcode_core 1.2.0
Installing rqrcode_core 1.2.0
Installing rouge 4.5.1
Fetching rubyzip 2.3.2
Installing rbpdf-font 1.19.1
Installing rubyzip 2.3.2
Fetching i18n 1.14.6
Installing i18n 1.14.6
Fetching tzinfo 2.0.6
Installing tzinfo 2.0.6
Fetching rack-session 2.0.0
Installing rack-session 2.0.0
Fetching rack-test 2.1.0
Installing rack-test 2.1.0
Fetching rackup 2.2.1
Installing rackup 2.2.1
Fetching websocket-driver 0.7.6
Installing websocket-driver 0.7.6 with native extensions
Fetching net-protocol 0.2.2
Installing net-protocol 0.2.2
Fetching nokogiri 1.16.8 (x86_64-linux)
Fetching addressable 2.8.7
Installing addressable 2.8.7
Fetching psych 5.2.1
Installing psych 5.2.1 with native extensions
Fetching reline 0.5.12
Installing reline 0.5.12
Installing nokogiri 1.16.8 (x86_64-linux)
Fetching rqrcode 2.2.0
Installing rqrcode 2.2.0
Fetching activesupport 7.2.2.1
Installing activesupport 7.2.2.1
Fetching net-imap 0.4.18
Fetching css_parser 1.19.1
Installing net-imap 0.4.18
Fetching rbpdf 1.21.3
Installing css_parser 1.19.1
Fetching globalid 1.2.1
Installing globalid 1.2.1
Installing rbpdf 1.21.3
Fetching activemodel 7.2.2.1
Fetching rails-dom-testing 2.2.0
Fetching loofah 2.23.1
Installing activemodel 7.2.2.1
Fetching html-pipeline 2.13.2
Installing rails-dom-testing 2.2.0
Fetching sanitize 6.1.3
Installing loofah 2.23.1
Fetching rdoc 6.8.1
Installing html-pipeline 2.13.2
Fetching roadie 5.2.1
Installing sanitize 6.1.3
Fetching mail 2.8.1
Installing roadie 5.2.1
Installing rdoc 6.8.1
Installing mail 2.8.1
Fetching activejob 7.2.2.1
Installing activejob 7.2.2.1
Fetching activerecord 7.2.2.1
Fetching rails-html-sanitizer 1.6.1
Installing rails-html-sanitizer 1.6.1
Fetching deckar01-task_list 2.3.2
Installing deckar01-task_list 2.3.2
Installing activerecord 7.2.2.1
Fetching actionview 7.2.2.1
Installing actionview 7.2.2.1
Fetching irb 1.14.1
Installing irb 1.14.1
Fetching actionpack 7.2.2.1
Fetching with_advisory_lock 5.1.0
Installing actionpack 7.2.2.1
Installing with_advisory_lock 5.1.0
Fetching actioncable 7.2.2.1
Fetching activestorage 7.2.2.1
Fetching actionmailer 7.2.2.1
Fetching railties 7.2.2.1
Installing actioncable 7.2.2.1
Installing actionmailer 7.2.2.1
Installing activestorage 7.2.2.1
Installing railties 7.2.2.1
Fetching actionmailbox 7.2.2.1
Fetching actiontext 7.2.2.1
Installing actionmailbox 7.2.2.1
Installing actiontext 7.2.2.1
Fetching actionpack-xml_parser 2.0.1
Fetching propshaft 1.1.0
Fetching rails 7.2.2.1
Fetching roadie-rails 3.2.0
Installing actionpack-xml_parser 2.0.1
Installing propshaft 1.1.0
Installing rails 7.2.2.1
Installing roadie-rails 3.2.0
Gem::Ext::BuildError: ERROR: Failed to build gem native extension.

    current directory: /usr/local/lib/ruby/gems/3.3.0/gems/mysql2-0.5.6/ext/mysql2
/usr/local/bin/ruby extconf.rb
checking for rb_absint_size()... yes
checking for rb_absint_singlebit_p()... yes
checking for rb_gc_mark_movable()... yes
checking for rb_wait_for_single_fd()... yes
checking for rb_enc_interned_str() in ruby.h... yes
checking for -lmysqlclient... no
-----
mysql client is missing. You may need to 'sudo apt-get install libmariadb-dev', 'sudo apt-get install libmysqlclient-dev' or 'sudo yum
install mysql-devel', and try again.
-----
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of necessary
libraries and/or headers.  Check the mkmf.log file for more details.  You may
need configuration options.

Provided configuration options:
        --with-opt-dir
        --without-opt-dir
        --with-opt-include=${opt-dir}/include
        --without-opt-include
        --with-opt-lib=${opt-dir}/lib
        --without-opt-lib
        --with-make-prog
        --without-make-prog
        --srcdir=.
        --curdir
        --ruby=/usr/local/bin/$(RUBY_BASE_NAME)
        --with-openssl-dir
        --without-openssl-dir
        --with-mysql-dir
        --without-mysql-dir
        --with-mysql-include=${mysql-dir}/include
        --without-mysql-include
        --with-mysql-lib=${mysql-dir}/lib
        --without-mysql-lib
        --with-mysql-config
        --without-mysql-config
        --with-mysql-dir
        --without-mysql-dir
        --with-mysql-include
        --without-mysql-include
        --with-mysql-lib
        --without-mysql-lib
        --with-mysqlclient-dir
        --without-mysqlclient-dir
        --with-mysqlclient-include=${mysqlclient-dir}/include
        --without-mysqlclient-include
        --with-mysqlclient-lib=${mysqlclient-dir}/lib
        --without-mysqlclient-lib
        --with-mysqlclientlib
        --without-mysqlclientlib

To see why this extension failed to compile, please check the mkmf.log which can be found here:

  /usr/local/lib/ruby/gems/3.3.0/extensions/x86_64-linux/3.3.0-static/mysql2-0.5.6/mkmf.log

extconf failed, exit code 1

Gem files will remain installed in /usr/local/lib/ruby/gems/3.3.0/gems/mysql2-0.5.6 for inspection.
Results logged to /usr/local/lib/ruby/gems/3.3.0/extensions/x86_64-linux/3.3.0-static/mysql2-0.5.6/gem_make.out

  /usr/local/lib/ruby/3.3.0/rubygems/ext/builder.rb:125:in `run'
  /usr/local/lib/ruby/3.3.0/rubygems/ext/ext_conf_builder.rb:28:in `build'
  /usr/local/lib/ruby/3.3.0/rubygems/ext/builder.rb:193:in `build_extension'
  /usr/local/lib/ruby/3.3.0/rubygems/ext/builder.rb:227:in `block in build_extensions'
  /usr/local/lib/ruby/3.3.0/rubygems/ext/builder.rb:224:in `each'
  /usr/local/lib/ruby/3.3.0/rubygems/ext/builder.rb:224:in `build_extensions'
  /usr/local/lib/ruby/3.3.0/rubygems/installer.rb:844:in `build_extensions'
  /usr/local/lib/ruby/3.3.0/bundler/rubygems_gem_installer.rb:109:in `build_extensions'
  /usr/local/lib/ruby/3.3.0/bundler/rubygems_gem_installer.rb:28:in `install'
  /usr/local/lib/ruby/3.3.0/bundler/source/rubygems.rb:205:in `install'
  /usr/local/lib/ruby/3.3.0/bundler/installer/gem_installer.rb:55:in `install'
  /usr/local/lib/ruby/3.3.0/bundler/installer/gem_installer.rb:17:in `install_from_spec'
  /usr/local/lib/ruby/3.3.0/bundler/installer/parallel_installer.rb:133:in `do_install'
  /usr/local/lib/ruby/3.3.0/bundler/installer/parallel_installer.rb:124:in `block in worker_pool'
  /usr/local/lib/ruby/3.3.0/bundler/worker.rb:62:in `apply_func'
  /usr/local/lib/ruby/3.3.0/bundler/worker.rb:57:in `block in process_queue'
  <internal:kernel>:187:in `loop'
  /usr/local/lib/ruby/3.3.0/bundler/worker.rb:54:in `process_queue'
  /usr/local/lib/ruby/3.3.0/bundler/worker.rb:90:in `block (2 levels) in create_threads'

An error occurred while installing mysql2 (0.5.6), and Bundler cannot continue.

In Gemfile:
  mysql2

Thank you for sending the error log. I've reviewed it.
Please check adapter in config/database.yml.
When I configured adapter: mysql2, I encountered a same error in my environment.
Please configure adapter: postgresql.
For more details, please refer to the "Database Connection Settings" section in the article.

mysql client is missing. You may need to 'sudo apt-get install libmariadb-dev', 'sudo apt-get install libmysqlclient-dev' or 'sudo yum
install mysql-devel', and try again.

Thank you for looking into it. Yep, that was the issue. I tend to cp the example file and edit that. I did edit the section you pointed out but missed another part because I ran into the same issue. So I deleted that file, created a blank one, and entered the info you gave in your article, which worked.
Another issue I ran into was that passenger-6.0.23 is now passenger-6.0.24, but that was an obvious fix.

Thank you for the article and the great work. Having this and keeping a solid procedure to replicate saves me so much time.

Thank you for your response. I'm glad the issue has been resolved.
In my article,

※ A configuration example is provided in config/database.yml.example for reference

I may not have provided sufficient explanation. I plan to add a note such as:
'Please note that the database.yml.example file provides a configuration example for MySQL. Since this article uses PostgreSQL, be sure to adjust accordingly when referencing it.'

Thank you for your valuable feedback.