Forum: Ruby Script throws error whenever I require mysql gem

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
607d3eb2d8ae3d07c5075e4f56c479c2?d=identicon&s=25 Chris Gallagher (gala)
on 2009-03-24 02:09
Hi all,

Ive been working on a small script and Im about to place some
functionality into it which allows it to write to my database by making
use of activerecord. I'm hitting a brick wall at the moment so I've come
to you for your expertise :)

The script runs perfectly fine until i...

require 'mysql'

..even though I havent actually asked the script to do anything more
than connect to mysql. if i comment out the configure block the error
still occurs.

I thought mysql was the issue so i completely reinstalled it from source
and the same error still occurs.

heres the error im seeing on Mac OS X Tiger:

/usr/local/lib/ruby/site_ruby/1.8/i686-darwin8.9.1/mysql.bundle: Failed
to lookup Init function
/usr/local/lib/ruby/site_ruby/1.8/i686-darwin8.9.1/mysql.bundle
(LoadError)
        from
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
`require'
        from
/usr/local/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:153:in
`require'
        from
/usr/local/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:521:in
`new_constants_in'
        from
/usr/local/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:153:in
`require'
        from bot.rb:6
/usr/local/lib/ruby/site_ruby/1.8/i686-darwin8.9.1/mysql.bundle: Failed
to lookup Init function
/usr/local/lib/ruby/site_ruby/1.8/i686-darwin8.9.1/mysql.bundle
(LoadError)
        from
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
`require'
        from
/usr/local/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:153:in
`require'
        from
/usr/local/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:521:in
`new_constants_in'
        from
/usr/local/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:153:in
`require'
        from bot.rb:6
/usr/local/lib/ruby/site_ruby/1.8/i686-darwin8.9.1/mysql.bundle: Failed
to lookup Init function
/usr/local/lib/ruby/site_ruby/1.8/i686-darwin8.9.1/mysql.bundle
(LoadError)
        from
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
`require'
        from
/usr/local/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:153:in
`require'
        from
/usr/local/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:521:in
`new_constants_in'
        from
/usr/local/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:153:in
`require'
        from bot.rb:6
cgallagher:~/work/tuneme/bot chrisgallagher$



The script for anyone interested is simply as follows:

require 'rubygems'
require 'sinatra'
require 'scrobbler'
require 'twibot'
require 'activerecord'
require 'mysql'

#startup tasks
configure do
  #connect to database
 ActiveRecord::Base.establish_connection({
        :adapter  => "mysql",
        :database => "tuneme",
        :socket   => "/tmp/mysql.socket",
        :username => "root",
        :password => ""
  })
end

class Link < ActiveRecord::Base
end


reply do |message, params|


  #create entry test
 # link = Link.create(:LinkValue => '123xyz')


  #check last.fm for a recomendation
  message_content = message.text
  artist_name = message_content.gsub("@tuneme ", "")
  p artist_name
  artist = Scrobbler::Artist.new(artist_name)
  #artist.similar.each { |a| puts "(#{a.match}%) #{a.name}" }
  similar_artist = artist.similar.first.name
  message = "@" + message.user.screen_name + " #{similar_artist} and
others... "
  post_tweet message
end




I'm completely at a loss here... any ideas?

Cheers
Chris
E16e84e861c1815ce11ba7bd851c857d?d=identicon&s=25 lasitha (Guest)
on 2009-03-24 17:24
(Received via mailing list)
On Tue, Mar 24, 2009 at 6:36 AM, Chris Gallagher <cgallagher@gmail.com>
wrote:
> [...]
>
> The script runs perfectly fine until i...
>
> require 'mysql'
>
> [...]
>
> /usr/local/lib/ruby/site_ruby/1.8/i686-darwin8.9.1/mysql.bundle: Failed
> to lookup Init function

The following post is probably still relevant:
http://rubyurl.com/B4Kl

cheers,
lasitha.
607d3eb2d8ae3d07c5075e4f56c479c2?d=identicon&s=25 Chris Gallagher (gala)
on 2009-03-25 00:45
Hi,

Just ran through all of those steps and still no luck. the exact same
error is being thrown. Cant seem to get through this error at all!
607d3eb2d8ae3d07c5075e4f56c479c2?d=identicon&s=25 Chris Gallagher (gala)
on 2009-03-25 02:30
OK, I've now done a complete uninstall and reinstalled with macports
instead. Now I'm seeing the following error:

LoadError: Failed to lookup Init function
/usr/local/lib/ruby/site_ruby/1.8/i686-darwin8.9.1/mysql.bundle
This topic is locked and can not be replied to.