Sequel problem: no such file to load -- mysql (LoadError)

exile · September 22, 2007, 1:07pm

Hi, i tried to learn about sequel (and Ruby) and got this problem

/usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:21:in
require__': no such file to load -- mysql (LoadError) from /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:21:inrequire’
from
/usr/lib/ruby/gems/1.8/gems/sequel-0.2.0.2/lib/sequel/mysql.rb:5
from
/usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in require__' from /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:inrequire’
from /home/ruby/abc.rb:2

Anyone could point me in the right direction? Couldt google anything.

–
Br
Vento

exile · September 22, 2007, 1:18pm

Quoth Michael Andreasen:
…

Anyone could point me in the right direction? Couldt google anything.

Br
Vento

Why, was google broken?

exile · September 22, 2007, 1:30pm

Konrad M. wrote:

Why, was google broken?

Could be Either way i couldt find anything. So im still looking for
help on this one.

I admit im new to Ruby and maybe im googling the error msg incorrectly.
in any case any small point in the right direction would be appriciated.

–
thanks
Vento

exile · September 22, 2007, 1:44pm

Could be Either way i couldt find anything. So im still looking for
help on this one.

I admit im new to Ruby and maybe im googling the error msg incorrectly.
in any case any small point in the right direction would be
appriciated.

Do you have a MySQL gem installed?

exile · September 22, 2007, 1:46pm

On Sep 22, 2007, at 07:07 , Michael Andreasen wrote:

Hi, i tried to learn about sequel (and Ruby) and got this problem

/usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:21:in
require__': no such file to load -- mysql (LoadError) from /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:21:inrequire’
from
/usr/lib/ruby/gems/1.8/gems/sequel-0.2.0.2/lib/sequel/mysql.rb:5

Anyone could point me in the right direction? Couldt google anything.

Michael,

The first and third of those lines are stating that the ‘mysql’
library is missing.
Make sure that you have the ruby-mysql library installed, latest
version is 2.7 I believe.
“sudo gem install mysql”

~Wayne

s///g
Wayne E. Seguin
Sr. Systems Architect & Systems Administrator

exile · September 22, 2007, 3:46pm

On 9/22/07, Wayne E. Seguin [email protected] wrote:

The first and third of those lines are stating that the ‘mysql’
library is missing.
Make sure that you have the ruby-mysql library installed, latest
version is 2.7 I believe.
“sudo gem install mysql”

~Wayne

Also–after you have installed your necessary libraries–remember that
your mysql server needs to be running. I’ve, myself, tried to
troubleshoot DB library things into the ground when the server just
didn’t start. It seems simple and stupid, but it happens to the best.

Todd

exile · September 22, 2007, 2:16pm

thanks for your guidence which lead me to the soloution, but not the
problem.

gem install mysql

produces the following output:

make install
/bin/install -c -m 0755 mysql.so
/usr/lib/ruby/gems/1.8/gems/mysql-2.7/lib
Successfully installed mysql-2.7

however

ls -alh /usr/lib/ruby/gems/1.8/gems/mysql-2.7/lib

showed this path to be empty. i copyied mysql.so like this

cp /usr/lib/ruby/gems/1.8/gems/mysql-2.7/mysql.so
/usr/lib/ruby/gems/1.8/gems/mysql-2.7/lib/

and viola, it works!

exile · September 22, 2007, 4:31pm

Michael, if you need more help with sequel we have our own group:

http://groups.google.com/group/sequel-talk

sharon

exile · September 22, 2007, 9:32pm

On Sep 22, 2007, at 8:45 AM, Todd B. wrote:

Also–after you have installed your necessary libraries–remember that
your mysql server needs to be running. I’ve, myself, tried to
troubleshoot DB library things into the ground when the server just
didn’t start. It seems simple and stupid, but it happens to the best.

Todd

Yes! This is a common problem for all of us. It doesn’t happen often,
so we don’t see it or expect it. But, when the mysql server
application is stopped, you will get failure.

exile · September 23, 2007, 3:29pm

On Sep 22, 2007, at 08:16 , Mike Andersen wrote:

however

ls -alh /usr/lib/ruby/gems/1.8/gems/mysql-2.7/lib

showed this path to be empty. i copyied mysql.so like this

cp /usr/lib/ruby/gems/1.8/gems/mysql-2.7/mysql.so
/usr/lib/ruby/gems/1.8/gems/mysql-2.7/lib/

and viola, it works!

Strange… The only thing I can think of that I do different
sometimes is on OS X I’ll specify the mysql directory:

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

And DO checkout the sequel-talk group, they are super helpful and nice.

~Wayne

s///g
Wayne E. Seguin
Sr. Systems Architect & Systems Administrator