thr3ads.net - Rails - Rails (and MySQL) on Linux

If this information is useful, please help other people find it:
Share via:

Onno van der Straaten

2007-Nov-12 14:06 UTC

Rails (and MySQL) on Linux - gem install mysql

Hi,
I could use some suggestions on how to get Rails running properly on a
Linux vserver running SuSE Linux Enterprise Server 10.

The application is not working as expected, on certain requests the
server dies. In the log file I see MySQL connection problems. I don''t
have the MySQL gem installed so this is probably to be expected.

Assuming I really need this MySQL gem, the question is now how this
can be installed?

gem install mysql is not working:
user@epf:~> sudo gem install mysql
root''s password:
Bulk updating Gem source index for: http://gems.rubyforge.org
Select which gem to install for your platform (x86_64-linux)
 1. mysql 2.7.3 (mswin32)
 2. mysql 2.7.1 (mswin32)
 3. mysql 2.7 (ruby)
 4. mysql 2.6 (ruby)
 5. Skip this gem
 6. Cancel installation> 3Building native extensions.  This could take a while...
ERROR:  While executing gem ... (Gem::Installer::ExtensionBuildError)
    ERROR: Failed to build gem native extension.

ruby extconf.rb install mysql
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lm... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lz... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lsocket... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lnsl... yes
checking for mysql_query() in -lmysqlclient... no
*** 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=/usr/bin/ruby
        --with-mysql-config
        --without-mysql-config
        --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-mysqlclientlib
        --without-mysqlclientlib
        --with-mlib
        --without-mlib
        --with-mysqlclientlib
        --without-mysqlclientlib
        --with-zlib
        --without-zlib
        --with-mysqlclientlib
        --without-mysqlclientlib
        --with-socketlib
        --without-socketlib
        --with-mysqlclientlib
        --without-mysqlclientlib
        --with-nsllib
        --without-nsllib
        --with-mysqlclientlib
        --without-mysqlclientlib

In the readme of the gem some suggestions are offered for installing
this. These also don''t work, for instance:
ruby extconf.rb
ruby extconf.rb --with-mysql-dir=/usr/bin
ruby extconf.rb --without-mysqlclientlib

env LD_RUN_PATH=/usr/lib64/
ruby extconf.rb

Thanks and Regards,
Onno


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Lutz Horn

2007-Nov-12 14:14 UTC

head link

Re: Rails (and MySQL) on Linux - gem install mysql

Hi,

Do you have the MySQL development library installed?

2007/11/12, Onno van der Straaten
<onno-EOCVfBHj35CeRQHaTntOIqxOck334EZe@public.gmane.org>:> Building native extensions.  This could take a while...
> ERROR:  While executing gem ... (Gem::Installer::ExtensionBuildError)
>     ERROR: Failed to build gem native extension.
>
> ruby extconf.rb install mysql
> checking for mysql_query() in -lmysqlclient... no
> checking for main() in -lm... yes
> checking for mysql_query() in -lmysqlclient... no
> checking for main() in -lz... yes
> checking for mysql_query() in -lmysqlclient... no
> checking for main() in -lsocket... no
> checking for mysql_query() in -lmysqlclient... no
> checking for main() in -lnsl... yes
> checking for mysql_query() in -lmysqlclient... no
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Frederick Cheung

2007-Nov-12 14:29 UTC

head link

Re: Rails (and MySQL) on Linux - gem install mysql

On 12 Nov 2007, at 14:06, Onno van der Straaten wrote:
>
> Hi,
> I could use some suggestions on how to get Rails running properly on a
> Linux vserver running SuSE Linux Enterprise Server 10.
>
> The application is not working as expected, on certain requests the
> server dies. In the log file I see MySQL connection problems. I
don''t
> have the MySQL gem installed so this is probably to be expected.
>
> Assuming I really need this MySQL gem, the question is now how this
> can be installed?
>
> gem install mysql is not working:
> user@epf:~> sudo gem install mysql
Off the top of my head,

sudo gem install mysql -- --with-mysql-dir=/usr/local/mysql

should work assuming /usr/local/mysql has an include folder with the  
headers and a lib folder with the libraries.

Fred

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Onno van der Straaten

2007-Nov-12 14:43 UTC

head link

Re: Rails (and MySQL) on Linux - gem install mysql

I''m not sure, because when I do this:
rpm -ivh mysql-devel-5.0.26-14.x86_64.rpm
it reports and error:
error: Failed dependencies:
        mysql-shared = 5.0.26 is needed by mysql-
devel-5.0.26-14.x86_64

I searched for ''libmysqlclient.so'' on rpm.pbone.net and
foundtwo rpm''s
SuSE 10.X 	ftp.suse.com/pub/update/10.2/rpm/x86_64/mysql-
devel-5.0.26-14.x86_64.rpm
SuSE 10.X 	ftp.suse.com/pub/update/10.1/rpm/x86_64/mysql-
devel-5.0.26-12.13.x86_64.rpm

So I tried the one with the highest version number.

But I think I have it installed because when I do a global find on
''libmysqlclient'' there are some hits:
epf:/home/user/migration/soft # find / -name ''libmysqlclient*''
/usr/lib64/mysql/libmysqlclient_r.so.15.0.0
/usr/lib64/mysql/libmysqlclient_r.so.15
/usr/lib64/mysql/libmysqlclient.so.15
/usr/lib64/mysql/libmysqlclient.so.15.0.0
/usr/lib64/libmysqlclient_r.so.15.0.0
/usr/lib64/libmysqlclient_r.so.15
/usr/lib64/libmysqlclient.so.15
/usr/lib64/libmysqlclient.so.15.0.0

Thanks and Regards,
Onno



On Nov 12, 3:14 pm, "Lutz Horn"
<lutz.georg.h...-gM/Ye1E23mwN+BqQ9rBEUg@public.gmane.org>
wrote:> Hi,
>
> Do you have the MySQL development library installed?
>
> 2007/11/12, Onno van der Straaten
<o...-EOCVfBHj35CeRQHaTntOIqxOck334EZe@public.gmane.org>:
>
> > Building native extensions.  This could take a while...
> > ERROR:  While executing gem ... (Gem::Installer::ExtensionBuildError)
> >     ERROR: Failed to build gem native extension.
>
> > ruby extconf.rb install mysql
> > checking for mysql_query() in -lmysqlclient... no
> > checking for main() in -lm... yes
> > checking for mysql_query() in -lmysqlclient... no
> > checking for main() in -lz... yes
> > checking for mysql_query() in -lmysqlclient... no
> > checking for main() in -lsocket... no
> > checking for mysql_query() in -lmysqlclient... no
> > checking for main() in -lnsl... yes
> > checking for mysql_query() in -lmysqlclient... no

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Onno van der Straaten

2007-Nov-12 14:47 UTC

head link

Re: Rails (and MySQL) on Linux - gem install mysql

I''m not sure where my mysql dir is, the mysql exe is in /usr/bin and
it fails when I provide that directory:
epf:/home/user/migration/soft # sudo gem install mysql -- --with-mysql-
dir=/usr/bin
Select which gem to install for your platform (x86_64-linux)
 1. mysql 2.7.3 (mswin32)
 2. mysql 2.7.1 (mswin32)
 3. mysql 2.7 (ruby)
 4. mysql 2.6 (ruby)
 5. Skip this gem
 6. Cancel installation> 3Building native extensions.  This could take a while...
ERROR:  While executing gem ... (Gem::Installer::ExtensionBuildError)
    ERROR: Failed to build gem native extension.

ruby extconf.rb install mysql -- --with-mysql-dir=/usr/bin
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lm... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lz... yes
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lsocket... no
checking for mysql_query() in -lmysqlclient... no
checking for main() in -lnsl... yes
checking for mysql_query() in -lmysqlclient... no
*** 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=/usr/bin/ruby
        --with-mysql-config
        --without-mysql-config
        --with-mysql-dir
        --with-mysql-include
        --without-mysql-include=${mysql-dir}/include
        --with-mysql-lib
        --without-mysql-lib=${mysql-dir}/lib
        --with-mysqlclientlib
        --without-mysqlclientlib
        --with-mlib
        --without-mlib
        --with-mysqlclientlib
        --without-mysqlclientlib
        --with-zlib
        --without-zlib
        --with-mysqlclientlib
        --without-mysqlclientlib
        --with-socketlib
        --without-socketlib
        --with-mysqlclientlib
        --without-mysqlclientlib
        --with-nsllib
        --without-nsllib
        --with-mysqlclientlib
        --without-mysqlclientlib


Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/
mysql-2.7 for inspection.
Results logged to /usr/lib/ruby/gems/1.8/gems/mysql-2.7/gem_make.out
epf:/home/user/migration/soft #


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Jo Potts

2008-Dec-03 17:15 UTC

head link

Re: Rails (and MySQL) on Linux - gem install mysql

Instructions to fix this are here:

http://articles.slicehost.com/2008/7/8/ubuntu-hardy-installing-mysql-with-rails-and-php-options
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Rick

2008-Dec-03 17:44 UTC

head link

Re: Rails (and MySQL) on Linux - gem install mysql

On unix systems you can typically do "which mysql_config" and
you''ll
find that the libraries are "$(which mysql_config)/../lib".

Then you can use Fred''s tip and:

gem install mysql -- --with-mysql-config=$(which mysql_config)

Rick

On Dec 3, 8:15 am, Jo Potts
<rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
wrote:> Instructions to fix this are here:
>
> http://articles.slicehost.com/2008/7/8/ubuntu-hardy-installing-mysql-...
> --
> Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Tushar Gandhi

2010-Jun-08 10:29 UTC

head link

Re: Rails (and MySQL) on Linux - gem install mysql

Hi,
I am also getting same error. I tried all options but still error is 
there.
Can anyone point me to correct answer?
I don''t why the rails have this much of trouble.

Thanks,
Tushar
-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Rails - Nov 2007 - Rails (and MySQL) on Linux - gem install mysql

Rails (and MySQL) on Linux - gem install mysql

Re: Rails (and MySQL) on Linux - gem install mysql

Re: Rails (and MySQL) on Linux - gem install mysql

Re: Rails (and MySQL) on Linux - gem install mysql

Re: Rails (and MySQL) on Linux - gem install mysql

Re: Rails (and MySQL) on Linux - gem install mysql

Re: Rails (and MySQL) on Linux - gem install mysql

Re: Rails (and MySQL) on Linux - gem install mysql