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.
Chris G. (Guest)
on 2009-03-24 03: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
lasitha (Guest)
on 2009-03-24 18:24
(Received via mailing list)
On Tue, Mar 24, 2009 at 6:36 AM, Chris G. <removed_email_address@domain.invalid>
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.
Chris G. (Guest)
on 2009-03-25 01: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!
Chris G. (Guest)
on 2009-03-25 03: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.