Redmine

To compile the MySQL bindings (i.e. the mysql2 gem), you need to install a C compiler (which you likely already have as you use RVM) as well as the MySQL client developer files.

On Ubuntu, you can install these with:

# Install the compiler suite
apt install build-essential

# Install the MySQL developer files to compile software against it
apt install libmysqlclient-dev 

Thanks for your reply, but both packages are already installed

In that case, please follow the advice from the error message:

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

  /home/ubuntu/.rvm/gems/ruby-3.1.0/extensions/x86_64-linux/3.1.0/mysql2-0.5.6/mkmf.log

Please check that file. It likely contains (among other rather verbose information) details about which library specifically could not be located / used and where it was searched for.

Thanks ! I did but I have to say that it is not clear to me ...

Here we go :

have_func: checking for rb_absint_size()... -------------------- yes

LD_LIBRARY_PATH=.:/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib "gcc -o conftest -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0/x86_64-linux -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0/ruby/backward -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0 -I.    -O3 -fno-fast-math -ggdb3 -Wall -Wextra -Wdeprecated-declarations -Wduplicated-cond -Wimplicit-function-declaration -Wimplicit-int -Wmisleading-indentation -Wpointer-arith -Wwrite-strings -Wimplicit-fallthrough=0 -Wmissing-noreturn -Wno-cast-function-type -Wno-constant-logical-operand -Wno-long-long -Wno-missing-field-initializers -Wno-overlength-strings -Wno-packed-bitfield-compat -Wno-parentheses-equality -Wno-self-assign -Wno-tautological-compare -Wno-unused-parameter -Wno-unused-value -Wsuggest-attribute=format -Wsuggest-attribute=noreturn -Wunused-variable -Wundef  -fPIC conftest.c  -L. -L/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -Wl,-rpath,/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -L. -fstack-protector-strong -rdynamic -Wl,-export-dynamic -Wl,--no-as-needed     -Wl,-rpath,/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -L/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -lruby  -lm  -lc" 
checked program was:
/* begin */
1: #include "ruby.h" 
2: 
3: int main(int argc, char **argv)
4: {
5:   return !!argv[argc];
6: }
/* end */

LD_LIBRARY_PATH=.:/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib "gcc -o conftest -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0/x86_64-linux -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0/ruby/backward -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0 -I.    -O3 -fno-fast-math -ggdb3 -Wall -Wextra -Wdeprecated-declarations -Wduplicated-cond -Wimplicit-function-declaration -Wimplicit-int -Wmisleading-indentation -Wpointer-arith -Wwrite-strings -Wimplicit-fallthrough=0 -Wmissing-noreturn -Wno-cast-function-type -Wno-constant-logical-operand -Wno-long-long -Wno-missing-field-initializers -Wno-overlength-strings -Wno-packed-bitfield-compat -Wno-parentheses-equality -Wno-self-assign -Wno-tautological-compare -Wno-unused-parameter -Wno-unused-value -Wsuggest-attribute=format -Wsuggest-attribute=noreturn -Wunused-variable -Wundef  -fPIC conftest.c  -L. -L/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -Wl,-rpath,/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -L. -fstack-protector-strong -rdynamic -Wl,-export-dynamic -Wl,--no-as-needed     -Wl,-rpath,/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -L/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -lruby  -lm  -lc" 
checked program was:
/* begin */
 1: #include "ruby.h" 
 2: 
 3: /*top*/
 4: extern int t(void);
 5: int main(int argc, char **argv)
 6: {
 7:   if (argc > 1000000) {
 8:     int (* volatile tp)(void)=(int (*)(void))&t;
 9:     printf("%d", (*tp)());
10:   }
11: 
12:   return !!argv[argc];
13: }
14: int t(void) { void ((*volatile p)()); p = (void ((*)()))rb_absint_size; return !p; }
/* end */

--------------------

have_func: checking for rb_absint_singlebit_p()... -------------------- yes

LD_LIBRARY_PATH=.:/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib "gcc -o conftest -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0/x86_64-linux -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0/ruby/backward -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0 -I.    -O3 -fno-fast-math -ggdb3 -Wall -Wextra -Wdeprecated-declarations -Wduplicated-cond -Wimplicit-function-declaration -Wimplicit-int -Wmisleading-indentation -Wpointer-arith -Wwrite-strings -Wimplicit-fallthrough=0 -Wmissing-noreturn -Wno-cast-function-type -Wno-constant-logical-operand -Wno-long-long -Wno-missing-field-initializers -Wno-overlength-strings -Wno-packed-bitfield-compat -Wno-parentheses-equality -Wno-self-assign -Wno-tautological-compare -Wno-unused-parameter -Wno-unused-value -Wsuggest-attribute=format -Wsuggest-attribute=noreturn -Wunused-variable -Wundef  -fPIC conftest.c  -L. -L/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -Wl,-rpath,/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -L. -fstack-protector-strong -rdynamic -Wl,-export-dynamic -Wl,--no-as-needed     -Wl,-rpath,/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -L/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -lruby  -lm  -lc" 
checked program was:
/* begin */
 1: #include "ruby.h" 
 2: 
 3: /*top*/
 4: extern int t(void);
 5: int main(int argc, char **argv)
 6: {
 7:   if (argc > 1000000) {
 8:     int (* volatile tp)(void)=(int (*)(void))&t;
 9:     printf("%d", (*tp)());
10:   }
11: 
12:   return !!argv[argc];
13: }
14: int t(void) { void ((*volatile p)()); p = (void ((*)()))rb_absint_singlebit_p; return !p; }
/* end */

--------------------

have_func: checking for rb_gc_mark_movable()... -------------------- yes

LD_LIBRARY_PATH=.:/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib "gcc -o conftest -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0/x86_64-linux -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0/ruby/backward -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0 -I.    -O3 -fno-fast-math -ggdb3 -Wall -Wextra -Wdeprecated-declarations -Wduplicated-cond -Wimplicit-function-declaration -Wimplicit-int -Wmisleading-indentation -Wpointer-arith -Wwrite-strings -Wimplicit-fallthrough=0 -Wmissing-noreturn -Wno-cast-function-type -Wno-constant-logical-operand -Wno-long-long -Wno-missing-field-initializers -Wno-overlength-strings -Wno-packed-bitfield-compat -Wno-parentheses-equality -Wno-self-assign -Wno-tautological-compare -Wno-unused-parameter -Wno-unused-value -Wsuggest-attribute=format -Wsuggest-attribute=noreturn -Wunused-variable -Wundef  -fPIC conftest.c  -L. -L/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -Wl,-rpath,/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -L. -fstack-protector-strong -rdynamic -Wl,-export-dynamic -Wl,--no-as-needed     -Wl,-rpath,/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -L/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -lruby  -lm  -lc" 
checked program was:
/* begin */
 1: #include "ruby.h" 
 2: 
 3: /*top*/
 4: extern int t(void);
 5: int main(int argc, char **argv)
 6: {
 7:   if (argc > 1000000) {
 8:     int (* volatile tp)(void)=(int (*)(void))&t;
 9:     printf("%d", (*tp)());
10:   }
11: 
12:   return !!argv[argc];
13: }
14: int t(void) { void ((*volatile p)()); p = (void ((*)()))rb_gc_mark_movable; return !p; }
/* end */

--------------------

have_func: checking for rb_wait_for_single_fd()... -------------------- yes

LD_LIBRARY_PATH=.:/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib "gcc -o conftest -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0/x86_64-linux -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0/ruby/backward -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0 -I.    -O3 -fno-fast-math -ggdb3 -Wall -Wextra -Wdeprecated-declarations -Wduplicated-cond -Wimplicit-function-declaration -Wimplicit-int -Wmisleading-indentation -Wpointer-arith -Wwrite-strings -Wimplicit-fallthrough=0 -Wmissing-noreturn -Wno-cast-function-type -Wno-constant-logical-operand -Wno-long-long -Wno-missing-field-initializers -Wno-overlength-strings -Wno-packed-bitfield-compat -Wno-parentheses-equality -Wno-self-assign -Wno-tautological-compare -Wno-unused-parameter -Wno-unused-value -Wsuggest-attribute=format -Wsuggest-attribute=noreturn -Wunused-variable -Wundef  -fPIC conftest.c  -L. -L/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -Wl,-rpath,/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -L. -fstack-protector-strong -rdynamic -Wl,-export-dynamic -Wl,--no-as-needed     -Wl,-rpath,/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -L/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -lruby  -lm  -lc" 
conftest.c: In function ‘t’:
conftest.c:14:57: error: ‘rb_wait_for_single_fd’ undeclared (first use in this function)
   14 | int t(void) { void ((*volatile p)()); p = (void ((*)()))rb_wait_for_single_fd; return !p; }
      |                                                         ^~~~~~~~~~~~~~~~~~~~~
conftest.c:14:57: note: each undeclared identifier is reported only once for each function it appears in
At top level:
cc1: note: unrecognized command-line option ‘-Wno-self-assign’ may have been intended to silence earlier diagnostics
cc1: note: unrecognized command-line option ‘-Wno-parentheses-equality’ may have been intended to silence earlier diagnostics
cc1: note: unrecognized command-line option ‘-Wno-constant-logical-operand’ may have been intended to silence earlier diagnostics
checked program was:
/* begin */
 1: #include "ruby.h" 
 2: 
 3: /*top*/
 4: extern int t(void);
 5: int main(int argc, char **argv)
 6: {
 7:   if (argc > 1000000) {
 8:     int (* volatile tp)(void)=(int (*)(void))&t;
 9:     printf("%d", (*tp)());
10:   }
11: 
12:   return !!argv[argc];
13: }
14: int t(void) { void ((*volatile p)()); p = (void ((*)()))rb_wait_for_single_fd; return !p; }
/* end */

LD_LIBRARY_PATH=.:/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib "gcc -o conftest -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0/x86_64-linux -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0/ruby/backward -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0 -I.    -O3 -fno-fast-math -ggdb3 -Wall -Wextra -Wdeprecated-declarations -Wduplicated-cond -Wimplicit-function-declaration -Wimplicit-int -Wmisleading-indentation -Wpointer-arith -Wwrite-strings -Wimplicit-fallthrough=0 -Wmissing-noreturn -Wno-cast-function-type -Wno-constant-logical-operand -Wno-long-long -Wno-missing-field-initializers -Wno-overlength-strings -Wno-packed-bitfield-compat -Wno-parentheses-equality -Wno-self-assign -Wno-tautological-compare -Wno-unused-parameter -Wno-unused-value -Wsuggest-attribute=format -Wsuggest-attribute=noreturn -Wunused-variable -Wundef  -fPIC conftest.c  -L. -L/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -Wl,-rpath,/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -L. -fstack-protector-strong -rdynamic -Wl,-export-dynamic -Wl,--no-as-needed     -Wl,-rpath,/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -L/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -lruby  -lm  -lc" 
checked program was:
/* begin */
 1: #include "ruby.h" 
 2: 
 3: /*top*/
 4: extern int t(void);
 5: int main(int argc, char **argv)
 6: {
 7:   if (argc > 1000000) {
 8:     int (* volatile tp)(void)=(int (*)(void))&t;
 9:     printf("%d", (*tp)());
10:   }
11: 
12:   return !!argv[argc];
13: }
14: extern void rb_wait_for_single_fd();
15: int t(void) { rb_wait_for_single_fd(); return 0; }
/* end */

--------------------

have_func: checking for rb_enc_interned_str() in ruby.h... -------------------- yes

LD_LIBRARY_PATH=.:/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib "gcc -o conftest -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0/x86_64-linux -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0/ruby/backward -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0 -I.    -O3 -fno-fast-math -ggdb3 -Wall -Wextra -Wdeprecated-declarations -Wduplicated-cond -Wimplicit-function-declaration -Wimplicit-int -Wmisleading-indentation -Wpointer-arith -Wwrite-strings -Wimplicit-fallthrough=0 -Wmissing-noreturn -Wno-cast-function-type -Wno-constant-logical-operand -Wno-long-long -Wno-missing-field-initializers -Wno-overlength-strings -Wno-packed-bitfield-compat -Wno-parentheses-equality -Wno-self-assign -Wno-tautological-compare -Wno-unused-parameter -Wno-unused-value -Wsuggest-attribute=format -Wsuggest-attribute=noreturn -Wunused-variable -Wundef  -fPIC conftest.c  -L. -L/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -Wl,-rpath,/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -L. -fstack-protector-strong -rdynamic -Wl,-export-dynamic -Wl,--no-as-needed     -Wl,-rpath,/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -L/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -lruby  -lm  -lc" 
conftest.c: In function ‘t’:
conftest.c:16:57: error: ‘rb_enc_interned_str’ undeclared (first use in this function); did you mean ‘rb_interned_str’?
   16 | int t(void) { void ((*volatile p)()); p = (void ((*)()))rb_enc_interned_str; return !p; }
      |                                                         ^~~~~~~~~~~~~~~~~~~
      |                                                         rb_interned_str
conftest.c:16:57: note: each undeclared identifier is reported only once for each function it appears in
At top level:
cc1: note: unrecognized command-line option ‘-Wno-self-assign’ may have been intended to silence earlier diagnostics
cc1: note: unrecognized command-line option ‘-Wno-parentheses-equality’ may have been intended to silence earlier diagnostics
cc1: note: unrecognized command-line option ‘-Wno-constant-logical-operand’ may have been intended to silence earlier diagnostics
checked program was:
/* begin */
 1: #include "ruby.h" 
 2: 
 3: #include <ruby.h>
 4: 
 5: /*top*/
 6: extern int t(void);
 7: int main(int argc, char **argv)
 8: {
 9:   if (argc > 1000000) {
10:     int (* volatile tp)(void)=(int (*)(void))&t;
11:     printf("%d", (*tp)());
12:   }
13: 
14:   return !!argv[argc];
15: }
16: int t(void) { void ((*volatile p)()); p = (void ((*)()))rb_enc_interned_str; return !p; }
/* end */

LD_LIBRARY_PATH=.:/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib "gcc -o conftest -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0/x86_64-linux -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0/ruby/backward -I/home/ubuntu/.rvm/rubies/ruby-3.1.0/include/ruby-3.1.0 -I.    -O3 -fno-fast-math -ggdb3 -Wall -Wextra -Wdeprecated-declarations -Wduplicated-cond -Wimplicit-function-declaration -Wimplicit-int -Wmisleading-indentation -Wpointer-arith -Wwrite-strings -Wimplicit-fallthrough=0 -Wmissing-noreturn -Wno-cast-function-type -Wno-constant-logical-operand -Wno-long-long -Wno-missing-field-initializers -Wno-overlength-strings -Wno-packed-bitfield-compat -Wno-parentheses-equality -Wno-self-assign -Wno-tautological-compare -Wno-unused-parameter -Wno-unused-value -Wsuggest-attribute=format -Wsuggest-attribute=noreturn -Wunused-variable -Wundef  -fPIC conftest.c  -L. -L/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -Wl,-rpath,/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -L. -fstack-protector-strong -rdynamic -Wl,-export-dynamic -Wl,--no-as-needed     -Wl,-rpath,/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -L/home/ubuntu/.rvm/rubies/ruby-3.1.0/lib -lruby  -lm  -lc" 
checked program was:
/* begin */
 1: #include "ruby.h" 
 2: 
 3: #include <ruby.h>
 4: 
 5: /*top*/
 6: extern int t(void);
 7: int main(int argc, char **argv)
 8: {
 9:   if (argc > 1000000) {
10:     int (* volatile tp)(void)=(int (*)(void))&t;
11:     printf("%d", (*tp)());
12:   }
13: 
14:   return !!argv[argc];
15: }
16: extern void rb_enc_interned_str();
17: int t(void) { rb_enc_interned_str(); return 0; }
/* end */

--------------------

Any idea ? I'm getting crazy with that ! ;-))

Thnaks for your support

Hello Simo, It looks like you need an experienced Linux admin to fix the errors you are facing with the manual setup on Ubuntu.

I suggest using any readymade redmine docker container image for quick and easy setup.

-- David https://redminepro.com/

Thanks for the suggestion David. I did handle this by changing the value in the gemfile from :

gem "mysql2", "~> 0.5.0", :platforms => [:mri, :mingw, :x64_mingw]

to

gem "mysql2", "0.5.4", :platforms => [:mri, :mingw, :x64_mingw]

Thanks for the update and for opening an accompanying issue with the the mysql2 project.

(Still, as a small addition: you should update your Ruby version. If you want/need to stick to Ruby 3.1.x, you should update to Ruby 3.1.6 because your current Ruby version 3.1.0 contains several functional bugs and security issues which were fixed in the meantime.)

holger mareck Just : thanks for the advice ! I'll do that soon !