I've been able to use gem mysql2 and an older version of ruby without any problem. Updating both programs I've not been able to get them to work even though I have gone through everything I could find on the internet. With all the posts that mysql2 doesn't work is there another gem other than mysql2 that works? Is there something obvious that i am missing? Thanks Tom Reilly C:\Ruby32-x64\bin>gem install mysql2 Using rubygems directory: C:/Users/w3gat/.gem/ruby/3.2.0 Temporarily enhancing PATH for MSYS/MINGW... Installing required msys2 packages: mingw-w64-ucrt-x86_64-libmariadbclient error: failed to init transaction (unable to lock database) error: could not lock database: Permission denied pacman failed with the following output: Building native extensions. This could take a while... ERROR: Error installing mysql2: ERROR: Failed to build gem native extension. current directory: C:/Users/w3gat/.gem/ruby/3.2.0/gems/mysql2-0.5.5/ext/mysql2 C:/Ruby32-x64/bin/ruby.exe -I C:/Ruby32-x64/lib/ruby/3.2.0 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 *** 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 --without-opt-include=${opt-dir}/include --with-opt-lib --without-opt-lib=${opt-dir}/lib --with-make-prog --without-make-prog --srcdir=. --curdir --ruby=C:/Ruby32-x64/bin/$(RUBY_BASE_NAME) --with-openssl-dir --without-openssl-dir --with-mysql-dir --without-mysql-dir --with-mysql-include --without-mysql-include=${mysql-dir}/include --with-mysql-lib --without-mysql-lib=${mysql-dir}/lib --with-mysql-config --without-mysql-config --with-mysqlclient-dir --without-mysqlclient-dir --with-mysqlclient-include --without-mysqlclient-include=${mysqlclient-dir}/include --with-mysqlclient-lib --without-mysqlclient-lib=${mysqlclient-dir}/lib --with-mysqlclientlib --without-mysqlclientlib C:/Ruby32-x64/lib/ruby/3.2.0/mkmf.rb:1083:in `block in find_library': undefined method `split' for nil:NilClass (NoMethodError) paths = paths.flat_map {|path| path.split(File::PATH_SEPARATOR)} ^^^^^^ from C:/Ruby32-x64/lib/ruby/3.2.0/mkmf.rb:1083:in `each' from C:/Ruby32-x64/lib/ruby/3.2.0/mkmf.rb:1083:in `flat_map' from C:/Ruby32-x64/lib/ruby/3.2.0/mkmf.rb:1083:in `find_library' from extconf.rb:131:in `<main>' To see why this extension failed to compile, please check the mkmf.log which can be found here: C:/Users/w3gat/.gem/ruby/3.2.0/extensions/x64-mingw-ucrt/3.2.0/mysql2-0.5.5/mkmf.log extconf failed, exit code 1 Gem files will remain installed in C:/Users/w3gat/.gem/ruby/3.2.0/gems/mysql2-0.5.5 for inspection. Results logged to C:/Users/w3gat/.gem/ruby/3.2.0/extensions/x64-mingw-ucrt/3.2.0/mysql2-0.5.5/gem_make.out C:\Ruby32-x64\bin>cd \ruby32* ______________________________________________ ruby-talk mailing list -- ruby-talk(a)ml.ruby-lang.org To unsubscribe send an email to ruby-talk-leave(a)ml.ruby-lang.org ruby-talk info -- https://ml.ruby-lang.org/mailman3/postorius/lists/ruby-talk.ml.ruby-lang.or…